Thanks for the quick reply Lars.
Sorry for not letting you know but in fact the dhis-2/ has been built successfully. Only dhis-2/dhis-web is not going through!
Will switch to PostgreeSQL and see what happens.
Best,
Jeton
Thanks for the quick reply Lars.
Sorry for not letting you know but in fact the dhis-2/ has been built successfully. Only dhis-2/dhis-web is not going through!
Will switch to PostgreeSQL and see what happens.
Best,
Jeton
Ok did you also do eclipse:eclipse in dhis-2/ ?
On Jun 14, 2011 8:15 PM, “Jeton Mehmeti” jeton_lesnadekon@hotmail.com wrote:
Thanks for the quick reply Lars.
Sorry for not letting you know but in fact the dhis-2/ has been built successfully. Only dhis-2/dhis-web is not going through!
Will switch to PostgreeSQL and see what happens.
Best,
JetonDate: Tue, 14 Jun 2011 18:57:43 +0200
Subject: Re: DHIS2: minmaxdataelement table not created
From: larshelge@gmail.com
To: jeton_lesnadekon@hotmail.com; dhis2-devs@lists.launchpad.net
Hi Jeton,
interesting that you are setting this up in Kosovo.
I think what you have is two problems. Regarding the build problem you must first build dhis-2/ then dhis-2/dhis-web, see here for instructions: http://dhis2.org/development
Regarding the database problem I am not really sure. There might be some issues when upgrading from a legacy database in MySQL to a newer DHIS 2 version. In case you haven’t done too much with your database you can try changing to PostgreSQL which is more thoroughly tested in the community.
Forwarding to list so other can help.
regards Lars2011/6/14 Jeton Mehmeti jeton_lesnadekon@hotmail.com
Hi Lars,
This is Jeton Mehmeti emailing from Kosovo regarding an issue i’m
running into when starting tomcat server.
I have recently checked out the DHIS2 source code for the purpose and
intention of implementing DHIS2 in Kosovo. No agreement has been made
yet, but I’m in process of negotiation with them guys from Ministry of
Health and they are eager to see the software and learn what they can
benefit from it.
Anyways, can you please help me fix the problem I’m running into. That
is, when I run tomcat server minmaxdataelement table cannot be created.
Please see log below:
2011-06-14 11:28:17 Commons Daemon procrun stdout initialized* INFO
11:29:24,729 System property dhis2.home not set
(DefaultLocationManager.java [main])
- INFO 11:29:24,729 Environment variable DHIS2_HOME points to C:\dhis
(DefaultLocationManager.java [main])
- ERROR 11:30:01,054 Unsuccessful: create table minmaxdataelement
(minmaxdataelementid integer not null auto_increment, sourceid integer,
dataelementid integer, categoryoptioncomboid integer, minvalue integer
not null, maxvalue integer not null, generated bit not null, primary key
(minmaxdataelementid)) (SchemaUpdate.java [main])
- ERROR 11:30:01,055 You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'maxvalue integer not null, generated bit not null,
primary key (minmaxdataelemen’ at line 1 (SchemaUpdate.java [main])
- ERROR 11:30:01,058 Unsuccessful: alter table minmaxdataelement add
index fk_minmaxdataelement_dataelementid (dataelementid), add constraint
fk_minmaxdataelement_dataelementid foreign key (dataelementid)
references dataelement (dataelementid) (SchemaUpdate.java [main])
- ERROR 11:30:01,059 Table ‘dhis.minmaxdataelement’ doesn’t exist
(SchemaUpdate.java [main])
- ERROR 11:30:01,063 Unsuccessful: alter table minmaxdataelement add
index fk_minmaxdataelement_categoryoptioncomboid
(categoryoptioncomboid), add constraint
fk_minmaxdataelement_categoryoptioncomboid foreign key
(categoryoptioncomboid) references categoryoptioncombo
(categoryoptioncomboid) (SchemaUpdate.java [main])
- ERROR 11:30:01,063 Table ‘dhis.minmaxdataelement’ doesn’t exist
(SchemaUpdate.java [main])
- ERROR 11:30:01,067 Unsuccessful: alter table minmaxdataelement add
index fk_minmaxdataelement_sourceid (sourceid), add constraint
fk_minmaxdataelement_sourceid foreign key (sourceid) references source
(sourceid) (SchemaUpdate.java [main])
- ERROR 11:30:01,076 Table ‘dhis.minmaxdataelement’ doesn’t exist
(SchemaUpdate.java [main])
- ERROR 11:30:01,080 Unsuccessful: create index index_minmaxdataelement
on minmaxdataelement (sourceid, dataelementid, categoryoptioncomboid)
(SchemaUpdate.java [main])
- ERROR 11:30:01,080 Table ‘dhis.minmaxdataelement’ doesn’t exist
(SchemaUpdate.java [main])
- INFO 11:30:46,738 Executing startup routine [1 of 10, runlevel 1]:
TableAlteror (DefaultStartupRoutineExecutor.java [main])
Also, when I run mvn eclipse:eclipse in /dhis-2/dhis-web Built fails
for the following reasons:
[INFO] BUILD FAILURE
[INFO]
[INFO] Total time: 14.002s
[INFO] Finished at: Tue Jun 14 12:11:57 CEST 2011
[INFO] Final Memory: 9M/21M
[INFO]
[ERROR] Failed to execute goal on project dhis-web-commons: Could not
resolve de
pendencies for project org.hisp.dhis:dhis-web-commons:jar:2.3-SNAPSHOT:
The foll
owing artifacts could not be resolved: org.hisp.dhis:dhis-
api:jar:2.3-SNAPSHOT,
org.hisp.dhis:dhis-service-i18n:jar:2.3-SNAPSHOT, org.hisp.dhis:dhis-
service-cor
e:jar:2.3-SNAPSHOT, org.hisp.dhis:dhis-service-
administration:jar:2.3-SNAPSHOT,
org.hisp.dhis:dhis-service-options:jar:2.3-SNAPSHOT, org.hisp.dhis:dhis-
service-
reporting:jar:2.3-SNAPSHOT, org.hisp.dhis:dhis-support-
test:jar:2.3-SNAPSHOT, or
g.hisp.dhis:dhis-support-system:jar:2.3-SNAPSHOT: Could not find
artifact org.hi
sp.dhis:dhis-api:jar:2.3-SNAPSHOT in amplecode_maven2_repo
.org/maven2) → [Help 1]
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the
-e swit
ch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions,
please rea
d the following articles:
[ERROR] [Help 1]
http://cwiki.apache.org/confluence/display/MAVEN/DependencyReso
lutionException
[ERROR]
[ERROR] After correcting the problems, you can resume the build with the
command
[ERROR] mvn -rf :dhis-web-commons
C:\dhis\dhis-2\dhis-web>
Sorry to overload you with so much error text. I hope you can find some
time to respond.
Thank in advance.
Jeton
–
This message was sent from Launchpad by
Jeton Mehmeti (https://launchpad.net/~jeton-lesnadekon)
using the “Contact this user” link on your profile page
(https://launchpad.net/~larshelge).
For more information see
Yes, I did do mvn eclipse:eclipse in dhis-2/ and it's fine.
Hi,
Den 14. juni 2011 kl. 19.29 skrev Jeton Mehmeti:
Yes, I did do mvn eclipse:eclipse in dhis-2/ and it’s fine.
I guess you have to do mvn install in dhis-2 for the jars to be available when building dhis-web, as it is a separate project.
Jo
Thanks Jo. It’s built now.
Jeton
Subject: Re: [Dhis2-devs] DHIS2: minmaxdataelement table not created
From: storset@gmail.com
Date: Tue, 14 Jun 2011 20:26:29 +0200
CC: larshelge@gmail.com; dhis2-devs@lists.launchpad.net
To: jeton_lesnadekon@hotmail.com
Hi,
Den 14. juni 2011 kl. 19.29 skrev Jeton Mehmeti:
Yes, I did do mvn eclipse:eclipse in dhis-2/ and it’s fine.
I guess you have to do mvn install in dhis-2 for the jars to be available when building dhis-web, as it is a separate project.
Jo
Good morning Lars,
I am wanting to make standard report thru ireport but cannot fetch data from sql query.
The information on table reports show no table name report to include in the ireport sql query as is shown on DHIS2 user manual. (Attached: report table)
An example of report query is given on the user manual (attached) and I can see the query is build based on the table name, which the current version of DHIS 2.3 is not showing, therefore not able to fetch data from a particular report table without the correct table name.
Appreciate your help.
Thanks,
Jeton
---------- Forwarded message ----------
From: “Jeton Mehmeti” jeton_lesnadekon@hotmail.com
Date: Jun 27, 2011 2:54 AM
Subject: Standard report
Hi Jeton,
after version 2.2 the report tables are not written as a physical database table anymore. It is rather generated as a custom JR data source within DHIS 2. This implies that you can continue to develop iReport designs as before but only utilize the fields and functions provided by the report table (no sql). To get started please generate the report table and click “Download as JRXML” and use this file as a template/starting point for your design. The reason for this move was that the shared database table approach did not work well in high concurrency environments.
regards,
Lars
On Mon, Jun 27, 2011 at 1:53 AM, Jeton Mehmeti jeton_lesnadekon@hotmail.com wrote:
Good morning Lars,
I am wanting to make standard report thru ireport but cannot fetch data from sql query.
The information on table reports show no table name report to include in the ireport sql query as is shown on DHIS2 user manual. (Attached: report table)
An example of report query is given on the user manual (attached) and I can see the query is build based on the table name, which the current version of DHIS 2.3 is not showing, therefore not able to fetch data from a particular report table without the correct table name.
Appreciate your help.
Thanks,
Jeton
Hi everyone,
A problem I have previewing the design of reports in iReport.
Compilation takes place with no errors, but previewing the report returns a message “The document has no pages”.
Anyone has ran into this before?
Thanks,
Jeton Mehmeti
Kosovo
Hi Jeton,
are you previewing inside iReport or by uploading the report design to DHIS 2 by creating a standard report? The latter method would be the way to do it.
Lars
On Fri, Jul 1, 2011 at 11:21 AM, Jeton Mehmeti jeton_lesnadekon@hotmail.com wrote:
Hi everyone,
A problem I have previewing the design of reports in iReport.
Compilation takes place with no errors, but previewing the report returns a message “The document has no pages”.
Anyone has ran into this before?
Thanks,
Jeton Mehmeti
Kosovo
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Either way a blank page is shown!
Okay can you check the tomcat log and post potential exceptions?
Log attached.
Sorry couldn’t read much from the log.
On Fri, Jul 1, 2011 at 12:01 PM, Jeton Mehmeti jeton_lesnadekon@hotmail.com wrote:
Log attached.
Date: Fri, 1 Jul 2011 11:46:29 +0200
Subject: Re: [Dhis2-devs] Designing reports in iReport
From: larshelge@gmail.comTo: jeton_lesnadekon@hotmail.com
CC: dhis2-devs@lists.launchpad.net
Okay can you check the tomcat log and post potential exceptions?
Resolved.Key was in the iReport itself. In the 'report inspector' under 'properties' changed the value of 'when no data'.This implies that when there is no data iReport by default returns a blank page unless you change the value of 'when no data'.Jeton
Date: Fri, 1 Jul 2011 07:18:29 -0700
From: jlungo@yahoo.com
Subject: Re: [Dhis2-devs] Designing reports in iReport
To: jeton_lesnadekon@hotmail.com
this implies your query can not retrieve data.
but if you have downloaded your xml file from the dhis's report table it doesnot matter. when you upload your xml file back to dhis, it will work fine
Lungo
--- On Fri, 7/1/11, Jeton Mehmeti <jeton_lesnadekon@hotmail.com> wrote: