DHIS2: minmaxdataelement table not created

Ok did you also do eclipse:eclipse in dhis-2/ ?

=20
=20
=20
=20

=20
Thanks for the quick reply Lars.
Sorry for not letting you know but in fact the dhis-2/ has been built suc=

cessfully. Only dhis-2/dhis-web is not going through!

Will switch to PostgreeSQL and see what happens.

=20
Best=2C
Jeton
=20
Date: Tue=2C 14 Jun 2011 18:57:43 +0200
Subject: Re: DHIS2: minmaxdataelement table not created
From: larshelge@gmail.com

To: jeton_lesnadekon@hotmail.com=3B dhis2-devs@lists.launchpad.net
=20
=20
Hi Jeton=2C
interesting that you are setting this up in Kosovo.=20

I think what you have is two problems. Regarding the build problem you mu=

st first build dhis-2/ then dhis-2/dhis-web=2C see here for instructions: h=
ttp://dhis2.org/development

=20
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 ver=
sion. In case you haven't done too much with your database you can try chan=
ging to PostgreSQL which is more thoroughly tested in the community.

=20
Forwarding to list so other can help.
regards Lars
=20
=20
Hi Lars=2C

=20
=20
=20
This is Jeton Mehmeti emailing from Kosovo regarding an issue i'm
=20
running into when starting tomcat server.
=20
=20
=20
I have recently checked out the DHIS2 source code for the purpose and

=20
intention of implementing DHIS2 in Kosovo. No agreement has been made
=20
yet=2C but I'm in process of negotiation with them guys from Ministry of
=20
Health and they are eager to see the software and learn what they can

=20
benefit from it.
=20
=20
=20
Anyways=2C can you please help me fix the problem I'm running into. That
=20
is=2C when I run tomcat server minmaxdataelement table cannot be created.

=20
Please see log below:
=20
=20
=20
2011-06-14 11:28:17 Commons Daemon procrun stdout initialized* INFO
=20
11:29:24=2C729 System property dhis2.home not set
=20
(DefaultLocationManager.java [main])

=20
* INFO 11:29:24=2C729 Environment variable DHIS2_HOME points to C:\dhis
=20
(DefaultLocationManager.java [main])
=20
* ERROR 11:30:01=2C054 Unsuccessful: create table minmaxdataelement

=20
(minmaxdataelementid integer not null auto_increment=2C sourceid integer=

=2C

=20
dataelementid integer=2C categoryoptioncomboid integer=2C minvalue intege=

r

=20
not null=2C maxvalue integer not null=2C generated bit not null=2C primar=

y key

=20
(minmaxdataelementid)) (SchemaUpdate.java [main])
=20
* ERROR 11:30:01=2C055 You have an error in your SQL syntax=3B check the
=20
manual that corresponds to your MySQL server version for the right

=20
syntax to use near 'maxvalue integer not null=2C generated bit not null=

=2C

=20
primary key (minmaxdataelemen' at line 1 (SchemaUpdate.java [main])
=20
* ERROR 11:30:01=2C058 Unsuccessful: alter table minmaxdataelement add

=20
index fk_minmaxdataelement_dataelementid (dataelementid)=2C add constrain=

t

···

On Jun 14=2C 2011 8:15 PM=2C "Jeton Mehmeti" <jeton_lesnadekon@hotmail.com>= wrote:

2011/6/14 Jeton Mehmeti <jeton_lesnadekon@hotmail.com>
=20
fk_minmaxdataelement_dataelementid foreign key (dataelementid)
=20
references dataelement (dataelementid) (SchemaUpdate.java [main])

=20
* ERROR 11:30:01=2C059 Table 'dhis.minmaxdataelement' doesn't exist
=20
(SchemaUpdate.java [main])
=20
* ERROR 11:30:01=2C063 Unsuccessful: alter table minmaxdataelement add

=20
index fk_minmaxdataelement_categoryoptioncomboid
=20
(categoryoptioncomboid)=2C add constraint
=20
fk_minmaxdataelement_categoryoptioncomboid foreign key
=20
(categoryoptioncomboid) references categoryoptioncombo

=20
(categoryoptioncomboid) (SchemaUpdate.java [main])
=20
* ERROR 11:30:01=2C063 Table 'dhis.minmaxdataelement' doesn't exist
=20
(SchemaUpdate.java [main])
=20
* ERROR 11:30:01=2C067 Unsuccessful: alter table minmaxdataelement add

=20
index fk_minmaxdataelement_sourceid (sourceid)=2C add constraint
=20
fk_minmaxdataelement_sourceid foreign key (sourceid) references source
=20
(sourceid) (SchemaUpdate.java [main])

=20
* ERROR 11:30:01=2C076 Table 'dhis.minmaxdataelement' doesn't exist
=20
(SchemaUpdate.java [main])
=20
* ERROR 11:30:01=2C080 Unsuccessful: create index index_minmaxdataelement

=20
on minmaxdataelement (sourceid=2C dataelementid=2C categoryoptioncomboid)
=20
(SchemaUpdate.java [main])
=20
* ERROR 11:30:01=2C080 Table 'dhis.minmaxdataelement' doesn't exist

=20
(SchemaUpdate.java [main])
=20
* INFO 11:30:46=2C738 Executing startup routine [1 of 10=2C runlevel 1]:
=20
TableAlteror (DefaultStartupRoutineExecutor.java [main])
=20
=20

=20
Also=2C when I run mvn eclipse:eclipse in /dhis-2/dhis-web Built fails
=20
for the following reasons:
=20
=20
=20
[INFO] BUILD FAILURE
=20
[INFO]
=20

------------------------------------------------------------------------
=20
[INFO] Total time: 14.002s
=20
[INFO] Finished at: Tue Jun 14 12:11:57 CEST 2011
=20
[INFO] Final Memory: 9M/21M

=20
[INFO]
=20
------------------------------------------------------------------------
=20
[ERROR] Failed to execute goal on project dhis-web-commons: Could not
=20
resolve de

=20
pendencies for project org.hisp.dhis:dhis-web-commons:jar:2.3-SNAPSHOT:
=20
The foll
=20
owing artifacts could not be resolved: org.hisp.dhis:dhis-
=20
api:jar:2.3-SNAPSHOT=2C

=20
org.hisp.dhis:dhis-service-i18n:jar:2.3-SNAPSHOT=2C org.hisp.dhis:dhis-
=20
service-cor
=20
e:jar:2.3-SNAPSHOT=2C org.hisp.dhis:dhis-service-
=20
administration:jar:2.3-SNAPSHOT=2C

=20
org.hisp.dhis:dhis-service-options:jar:2.3-SNAPSHOT=2C org.hisp.dhis:dhis=

-

=20
service-
=20
reporting:jar:2.3-SNAPSHOT=2C org.hisp.dhis:dhis-support-
=20
test:jar:2.3-SNAPSHOT=2C or

=20
g.hisp.dhis:dhis-support-system:jar:2.3-SNAPSHOT: Could not find
=20
artifact org.hi
=20
sp.dhis:dhis-api:jar:2.3-SNAPSHOT in amplecode_maven2_repo
=20
(http://www.amplecode

=20
.org/maven2) -> [Help 1]
=20
[ERROR]
=20
[ERROR] To see the full stack trace of the errors=2C re-run Maven with th=

e

=20
-e swit
=20
ch.
=20
[ERROR] Re-run Maven using the -X switch to enable full debug logging.

=20
[ERROR]
=20
[ERROR] For more information about the errors and possible solutions=2C
=20
please rea
=20
d the following articles:
=20
[ERROR] [Help 1]
=20

http://cwiki.apache.org/confluence/display/MAVEN/DependencyReso
=20
lutionException
=20
[ERROR]
=20
[ERROR] After correcting the problems=2C you can resume the build with th=

e

=20
command
=20
=20
=20
[ERROR] mvn <goals> -rf :dhis-web-commons
=20
C:\dhis\dhis-2\dhis-web>
=20
=20
=20
Sorry to overload you with so much error text. I hope you can find some

=20
time to respond.
=20
=20
=20
Thank in advance.
=20
=20
=20
Jeton
=20
--
=20
This message was sent from Launchpad by
=20
Jeton Mehmeti (https://launchpad.net/~jeton-lesnadekon)

=20
using the "Contact this user" link on your profile page
=20
(https://launchpad.net/~larshelge).
=20
For more information see

=20
https://help.launchpad.net/YourAccount/ContactingPeople
=20
=20
=20
                =20

                 =

--_0b92da8c-5291-4dd6-bea5-f54e30f3681c_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<style><!--
.hmmessage P
{
margin:0px=3B
padding:0px
}
body.hmmessage
{
font-size: 10pt=3B
font-family:Tahoma
}
--></style>
</head>
<body class=3D'hmmessage'>
Yes=2C I did do mvn eclipse:eclipse in dhis-2/ and it's fine.<br><br><hr id=
=3D"stopSpelling">Date: Tue=2C 14 Jun 2011 19:22:52 +0200<br>Subject: RE: D=
HIS2: minmaxdataelement table not created<br>From: larshelge@gmail.com<br>T=
o: jeton_lesnadekon@hotmail.com<br>CC: dhis2-devs@lists.launchpad.net<br><b=

Ok did you also do eclipse:eclipse in dhis-2/&nbsp=3B ?<BR>

<div class=3D"ecxgmail_quote">On Jun 14=2C 2011 8:15 PM=2C "Jeton Mehmeti" =
&lt=3B<a href=3D"mailto:jeton_lesnadekon@hotmail.com">jeton_lesnadekon@hotm=
ail.com</a>&gt=3B wrote:<br>&gt=3B <br>&gt=3B <br>&gt=3B <br>&gt=3B <br>
&gt=3B <br>&gt=3B Thanks for the quick reply Lars.<br>&gt=3B 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!<br>&gt=3B Will switch to PostgreeSQL =
and see what happens.<br>
&gt=3B <br>&gt=3B Best=2C<br>&gt=3B Jeton<br>&gt=3B <br>&gt=3B Date: Tue=2C=
14 Jun 2011 18:57:43 +0200<br>&gt=3B Subject: Re: DHIS2: minmaxdataelement=
table not created<br>&gt=3B From: <a href=3D"mailto:larshelge@gmail.com">l=
arshelge@gmail.com</a><br>
&gt=3B To: <a href=3D"mailto:jeton_lesnadekon@hotmail.com">jeton_lesnadekon=
@hotmail.com</a>=3B <a href=3D"mailto:dhis2-devs@lists.launchpad.net">dhis2=
-devs@lists.launchpad.net</a><br>&gt=3B <br>&gt=3B <br>&gt=3B Hi Jeton=2C<b=

&gt=3B interesting that you are setting this up in Kosovo. <br>

&gt=3B I think what you have is two problems. Regarding the build problem y=
ou must first build dhis-2/ then dhis-2/dhis-web=2C see here for instructio=
ns: <a href=3D"http://dhis2.org/development" target=3D"_blank">http://dhis2=
.org/development</a><br>
&gt=3B <br>&gt=3B Regarding the database problem I am not really sure. Ther=
e 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 c=
ommunity.<br>
&gt=3B <br>&gt=3B Forwarding to list so other can help.<br>&gt=3B regards L=
ars<br>&gt=3B <br>&gt=3B 2011/6/14 Jeton Mehmeti &lt=3B<a href=3D"mailto:je=
ton_lesnadekon@hotmail.com">jeton_lesnadekon@hotmail.com</a>&gt=3B<br>&gt=
=3B <br>&gt=3B Hi Lars=2C<br>
&gt=3B <br>&gt=3B <br>&gt=3B <br>&gt=3B This is Jeton Mehmeti emailing from=
Kosovo regarding an issue i'm<br>&gt=3B <br>&gt=3B running into when start=
ing tomcat server.<br>&gt=3B <br>&gt=3B <br>&gt=3B <br>&gt=3B I have recen=
tly checked out the DHIS2 source code for the purpose and<br>
&gt=3B <br>&gt=3B intention of implementing DHIS2 in Kosovo. No agreement h=
as been made<br>&gt=3B <br>&gt=3B yet=2C but I'm in process of negotiation =
with them guys from Ministry of<br>&gt=3B <br>&gt=3B Health and they are ea=
ger to see the software and learn what they can<br>
&gt=3B <br>&gt=3B benefit from it.<br>&gt=3B <br>&gt=3B <br>&gt=3B <br>&gt=
=3B Anyways=2C can you please help me fix the problem I'm running into. Tha=
t<br>&gt=3B <br>&gt=3B is=2C when I run tomcat server minmaxdataelement tab=
le cannot be created.<br>
&gt=3B <br>&gt=3B Please see log below:<br>&gt=3B <br>&gt=3B <br>&gt=3B <br=

&gt=3B 2011-06-14 11:28:17 Commons Daemon procrun stdout initialized* INFO=

<br>&gt=3B <br>&gt=3B 11:29:24=2C729 System property dhis2.home not set<br>=
&gt=3B <br>&gt=3B (DefaultLocationManager.java [main])<br>
&gt=3B <br>&gt=3B * INFO 11:29:24=2C729 Environment variable DHIS2_HOME po=
ints to C:\dhis<br>&gt=3B <br>&gt=3B (DefaultLocationManager.java [main])<b=

&gt=3B <br>&gt=3B * ERROR 11:30:01=2C054 Unsuccessful: create table minma=

xdataelement<br>
&gt=3B <br>&gt=3B (minmaxdataelementid integer not null auto_increment=2C s=
ourceid integer=2C<br>&gt=3B <br>&gt=3B dataelementid integer=2C categoryop=
tioncomboid integer=2C minvalue integer<br>&gt=3B <br>&gt=3B not null=2C ma=
xvalue integer not null=2C generated bit not null=2C primary key<br>
&gt=3B <br>&gt=3B (minmaxdataelementid)) (SchemaUpdate.java [main])<br>&gt=
=3B <br>&gt=3B * ERROR 11:30:01=2C055 You have an error in your SQL syntax=
=3B check the<br>&gt=3B <br>&gt=3B manual that corresponds to your MySQL se=
rver version for the right<br>
&gt=3B <br>&gt=3B syntax to use near 'maxvalue integer not null=2C generate=
d bit not null=2C<br>&gt=3B <br>&gt=3B primary key (minmaxdataelemen' at li=
ne 1 (SchemaUpdate.java [main])<br>&gt=3B <br>&gt=3B * ERROR 11:30:01=2C058=
Unsuccessful: alter table minmaxdataelement add<br>
&gt=3B <br>&gt=3B index fk_minmaxdataelement_dataelementid (dataelementid)=
=2C add constraint<br>&gt=3B <br>&gt=3B fk_minmaxdataelement_dataelementid =
foreign key (dataelementid)<br>&gt=3B <br>&gt=3B references dataelement (da=
taelementid) (SchemaUpdate.java [main])<br>
&gt=3B <br>&gt=3B * ERROR 11:30:01=2C059 Table 'dhis.minmaxdataelement' doe=
sn't exist<br>&gt=3B <br>&gt=3B (SchemaUpdate.java [main])<br>&gt=3B <br>&g=
t=3B * ERROR 11:30:01=2C063 Unsuccessful: alter table minmaxdataelement add=
<br>
&gt=3B <br>&gt=3B index fk_minmaxdataelement_categoryoptioncomboid<br>&gt=
=3B <br>&gt=3B (categoryoptioncomboid)=2C add constraint<br>&gt=3B <br>&gt=
=3B fk_minmaxdataelement_categoryoptioncomboid foreign key<br>&gt=3B <br>&g=
t=3B (categoryoptioncomboid) references categoryoptioncombo<br>
&gt=3B <br>&gt=3B (categoryoptioncomboid) (SchemaUpdate.java [main])<br>&gt=
=3B <br>&gt=3B * ERROR 11:30:01=2C063 Table 'dhis.minmaxdataelement' doesn'=
t exist<br>&gt=3B <br>&gt=3B (SchemaUpdate.java [main])<br>&gt=3B <br>&gt=
=3B * ERROR 11:30:01=2C067 Unsuccessful: alter table minmaxdataelement add<=

&gt=3B <br>&gt=3B index fk_minmaxdataelement_sourceid (sourceid)=2C add con=
straint<br>&gt=3B <br>&gt=3B fk_minmaxdataelement_sourceid foreign key (sou=
rceid) references source<br>&gt=3B <br>&gt=3B (sourceid) (SchemaUpdate.java=
[main])<br>
&gt=3B <br>&gt=3B * ERROR 11:30:01=2C076 Table 'dhis.minmaxdataelement' doe=
sn't exist<br>&gt=3B <br>&gt=3B (SchemaUpdate.java [main])<br>&gt=3B <br>&g=
t=3B * ERROR 11:30:01=2C080 Unsuccessful: create index index_minmaxdataelem=
ent<br>
&gt=3B <br>&gt=3B on minmaxdataelement (sourceid=2C dataelementid=2C catego=
ryoptioncomboid)<br>&gt=3B <br>&gt=3B (SchemaUpdate.java [main])<br>&gt=3B =
<br>&gt=3B * ERROR 11:30:01=2C080 Table 'dhis.minmaxdataelement' doesn't ex=
ist<br>
&gt=3B <br>&gt=3B (SchemaUpdate.java [main])<br>&gt=3B <br>&gt=3B * INFO 1=
1:30:46=2C738 Executing startup routine [1 of 10=2C runlevel 1]:<br>&gt=3B =
<br>&gt=3B TableAlteror (DefaultStartupRoutineExecutor.java [main])<br>&gt=
=3B <br>&gt=3B <br>
&gt=3B <br>&gt=3B Also=2C when I run mvn eclipse:eclipse in /dhis-2/dhis-w=
eb Built fails<br>&gt=3B <br>&gt=3B for the following reasons:<br>&gt=3B <=

&gt=3B <br>&gt=3B <br>&gt=3B [INFO] BUILD FAILURE<br>&gt=3B <br>&gt=3B [=

INFO]<br>&gt=3B <br>
&gt=3B --------------------------------------------------------------------=
----<br>&gt=3B <br>&gt=3B [INFO] Total time: 14.002s<br>&gt=3B <br>&gt=3B [=
INFO] Finished at: Tue Jun 14 12:11:57 CEST 2011<br>&gt=3B <br>&gt=3B [INFO=
] Final Memory: 9M/21M<br>
&gt=3B <br>&gt=3B [INFO]<br>&gt=3B <br>&gt=3B -----------------------------=
-------------------------------------------<br>&gt=3B <br>&gt=3B [ERROR] Fa=
iled to execute goal on project dhis-web-commons: Could not<br>&gt=3B <br>&=
gt=3B resolve de<br>
&gt=3B <br>&gt=3B pendencies for project org.hisp.dhis:dhis-web-commons:jar=
:2.3-SNAPSHOT:<br>&gt=3B <br>&gt=3B The foll<br>&gt=3B <br>&gt=3B owing art=
ifacts could not be resolved: org.hisp.dhis:dhis-<br>&gt=3B <br>&gt=3B api:=
jar:2.3-SNAPSHOT=2C<br>
&gt=3B <br>&gt=3B org.hisp.dhis:dhis-service-i18n:jar:2.3-SNAPSHOT=2C org.h=
isp.dhis:dhis-<br>&gt=3B <br>&gt=3B service-cor<br>&gt=3B <br>&gt=3B e:jar:=
2.3-SNAPSHOT=2C org.hisp.dhis:dhis-service-<br>&gt=3B <br>&gt=3B administra=
tion:jar:2.3-SNAPSHOT=2C<br>
&gt=3B <br>&gt=3B org.hisp.dhis:dhis-service-options:jar:2.3-SNAPSHOT=2C or=
g.hisp.dhis:dhis-<br>&gt=3B <br>&gt=3B service-<br>&gt=3B <br>&gt=3B report=
ing:jar:2.3-SNAPSHOT=2C org.hisp.dhis:dhis-support-<br>&gt=3B <br>&gt=3B te=
st:jar:2.3-SNAPSHOT=2C or<br>
&gt=3B <br>&gt=3B g.hisp.dhis:dhis-support-system:jar:2.3-SNAPSHOT: Could n=
ot find<br>&gt=3B <br>&gt=3B artifact org.hi<br>&gt=3B <br>&gt=3B sp.dhis:d=
his-api:jar:2.3-SNAPSHOT in amplecode_maven2_repo<br>&gt=3B <br>&gt=3B (<a =
href=3D"http://www.amplecode" target=3D"_blank">http://www.amplecode</a><br=

&gt=3B <br>&gt=3B .org/maven2) -&gt=3B [Help 1]<br>&gt=3B <br>&gt=3B [ERROR=
]<br>&gt=3B <br>&gt=3B [ERROR] To see the full stack trace of the errors=2C=
re-run Maven with the<br>&gt=3B <br>&gt=3B -e swit<br>&gt=3B <br>&gt=3B ch=
.<br>&gt=3B <br>&gt=3B [ERROR] Re-run Maven using the -X switch to enable f=
ull debug logging.<br>
&gt=3B <br>&gt=3B [ERROR]<br>&gt=3B <br>&gt=3B [ERROR] For more information=
about the errors and possible solutions=2C<br>&gt=3B <br>&gt=3B please rea=
<br>&gt=3B <br>&gt=3B d the following articles:<br>&gt=3B <br>&gt=3B [ERROR=
] [Help 1]<br>&gt=3B <br>
&gt=3B <a href=3D"http://cwiki.apache.org/confluence/display/MAVEN/Dependen=
cyReso" target=3D"_blank">http://cwiki.apache.org/confluence/display/MAVEN/=
DependencyReso</a><br>&gt=3B <br>&gt=3B lutionException<br>&gt=3B <br>&gt=
=3B [ERROR]<br>&gt=3B <br>&gt=3B [ERROR] After correcting the problems=2C y=
ou can resume the build with the<br>
&gt=3B <br>&gt=3B command<br>&gt=3B <br>&gt=3B <br>&gt=3B <br>&gt=3B [ERROR=
] mvn &lt=3Bgoals&gt=3B -rf :dhis-web-commons<br>&gt=3B <br>&gt=3B C:\dhi=
s\dhis-2\dhis-web&gt=3B<br>&gt=3B <br>&gt=3B <br>&gt=3B <br>&gt=3B Sorry to=
overload you with so much error text. I hope you can find some<br>
&gt=3B <br>&gt=3B time to respond.<br>&gt=3B <br>&gt=3B <br>&gt=3B <br>&gt=
=3B Thank in advance.<br>&gt=3B <br>&gt=3B <br>&gt=3B <br>&gt=3B Jeton<br>&=
gt=3B <br>&gt=3B --<br>&gt=3B <br>&gt=3B This message was sent from Launchp=
ad by<br>&gt=3B <br>&gt=3B Jeton Mehmeti (<a href=3D"https://launchpad.net/=
~jeton-lesnadekon" target=3D"_blank">https://launchpad.net/~jeton-lesnadeko=
n</a>)<br>
&gt=3B <br>&gt=3B using the "Contact this user" link on your profile page<b=

&gt=3B <br>&gt=3B (<a href=3D"https://launchpad.net/~larshelge" target=3D=

"_blank">https://launchpad.net/~larshelge</a>).<br>&gt=3B <br>&gt=3B For mo=
re information see<br>
&gt=3B <br>&gt=3B <a href=3D"https://help.launchpad.net/YourAccount/Contact=
ingPeople" target=3D"_blank">https://help.launchpad.net/YourAccount/Contact=
ingPeople</a><br>&gt=3B <br>&gt=3B <br>&gt=3B <br>&gt=3B <br></=

                </body>

</html>=

--_0b92da8c-5291-4dd6-bea5-f54e30f3681c_--