I just logged into your server, it's really strange, since it works properly on my laptop and dhis2 play server. Can you delete all dhis folder in your tomcat/webapp folder, try to download latest war file and run it again.
On Tue, Apr 25, 2017 at 11:35 PM, Muhammad Bilal Siddqui < m.bilalsidd...@micromerger.com> wrote: > Hi > > Thanks for providing blank DB. After importing this my application started > but again in organisation unit I am not able to add organisation it shows > same error. ERROR: null value in column "organisationunitid" violates > not-null constraint > > > On Tue, Apr 25, 2017 at 8:17 PM, Em Le Hong <em.hispviet...@gmail.com> > wrote: > >> Hi, >> >> I just created 1 blank instance on my laptop, I give you the backup of >> its. You can try to restore it with any testing instance that running DHIS2 >> 2.26. (Remember that when you restore this database, it will completely >> cover your old database, so make sure that you have a backup of your >> database, otherwise you can't recover it). >> >> I created 1 orgUnit in this database called Global, you can change it >> later. It's working fine on my laptop, hope you can run it. >> >> [image: Inline image 1] >> >> On Tue, Apr 25, 2017 at 10:02 PM, Muhammad Bilal Siddqui < >> m.bilalsidd...@micromerger.com> wrote: >> >>> Yes. >>> >>> I am using dhis.conf file. >>> >>> I have to change because i am using 2 instance of DHIS one with name >>> dhis and other with lhs so i had to change 2nd one to LHS_HOME. >>> >>> Although i have facing same error on both when creating orgUnit >>> >>> On Tue, Apr 25, 2017 at 7:58 PM, Em Le Hong <em.hispviet...@gmail.com> >>> wrote: >>> >>>> you can change the war file name, but the variable name should be >>>> DHIS2_HOME and make sure that you use dhis.conf file (not the >>>> hibernate.properties file). >>>> >>>> On Tue, Apr 25, 2017 at 9:55 PM, Muhammad Bilal Siddqui < >>>> m.bilalsidd...@micromerger.com> wrote: >>>> >>>>> I am using war file. >>>>> >>>>> its name lhs.war >>>>> and using LHS_HOME varible instead of DHIS2_HOME >>>>> >>>>> On Tue, Apr 25, 2017 at 7:45 PM, Em Le Hong <em.hispviet...@gmail.com> >>>>> wrote: >>>>> >>>>>> How did you run it? Did you download the war file from dhis2.org and >>>>>> run it with tomcat server or you just download the dhis2 live package? >>>>>> >>>>>> On Tue, Apr 25, 2017 at 9:37 PM, Muhammad Bilal Siddqui < >>>>>> m.bilalsidd...@micromerger.com> wrote: >>>>>> >>>>>>> Hi. >>>>>>> >>>>>>> I tried as you suggested I check some tables in DB created. But >>>>>>> application failed to start. >>>>>>> >>>>>>> I attached log files. It shows error about DB. >>>>>>> >>>>>>> On Tue, Apr 25, 2017 at 3:01 PM, Muhammad Bilal Siddqui < >>>>>>> m.bilalsidd...@micromerger.com> wrote: >>>>>>> >>>>>>>> Ok. Thank you. I will try that. >>>>>>>> >>>>>>>> Get Outlook for iOS <https://aka.ms/o0ukef> >>>>>>>> ------------------------------ >>>>>>>> *From:* Em Le Hong <em.hispviet...@gmail.com> >>>>>>>> *Sent:* Tuesday, April 25, 2017 2:59:44 PM >>>>>>>> >>>>>>>> *To:* Muhammad Bilal Siddqui >>>>>>>> *Subject:* Re: [Dhis2-users] Data Store Issue in DHIS2 [2.26] >>>>>>>> >>>>>>>> in postgresSQL, create a database, then run it with your instance, >>>>>>>> it will automatically generate all tables for you. >>>>>>>> >>>>>>>> On Tue, Apr 25, 2017 at 4:56 PM, Muhammad Bilal Siddqui < >>>>>>>> m.bilalsidd...@micromerger.com> wrote: >>>>>>>> >>>>>>>>> Can you tell me how to create db? >>>>>>>>> Just i stop server and make db. And start server again. All table >>>>>>>>> in db should generate automatically? Or i need to create all tables? >>>>>>>>> >>>>>>>>> Get Outlook for iOS <https://aka.ms/o0ukef> >>>>>>>>> ------------------------------ >>>>>>>>> *From:* Em Le Hong <em.hispviet...@gmail.com> >>>>>>>>> *Sent:* Tuesday, April 25, 2017 2:47:42 PM >>>>>>>>> *To:* Muhammad Bilal Siddqui >>>>>>>>> >>>>>>>>> *Subject:* Re: [Dhis2-users] Data Store Issue in DHIS2 [2.26] >>>>>>>>> >>>>>>>>> Hi, >>>>>>>>> >>>>>>>>> I guess you download a copy database from dhis2.org site and >>>>>>>>> modified something, there's some wrong with database. The orgUnit >>>>>>>>> from demo >>>>>>>>> server has 2 attributes: HR identifier and NGO ID, I removed it from >>>>>>>>> your >>>>>>>>> server, but it still doesn't work. >>>>>>>>> >>>>>>>>> My suggestion is that you need to create a blank database on 2.26 >>>>>>>>> and import all metadata (orgUnit...) into the new server. >>>>>>>>> >>>>>>>>> Hope this work for you. >>>>>>>>> >>>>>>>>> Sincerely, >>>>>>>>> >>>>>>>>> On Tue, Apr 25, 2017 at 4:12 PM, Muhammad Bilal Siddqui < >>>>>>>>> m.bilalsidd...@micromerger.com> wrote: >>>>>>>>> >>>>>>>>>> Hi >>>>>>>>>> http://45.33.45.176:8080/lhs/ >>>>>>>>>> >>>>>>>>>> user admin >>>>>>>>>> pass district >>>>>>>>>> >>>>>>>>>> you can check with this account >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On Tue, Apr 25, 2017 at 1:51 PM, Em Le Hong < >>>>>>>>>> em.hispviet...@gmail.com> wrote: >>>>>>>>>> >>>>>>>>>>> Hi, >>>>>>>>>>> >>>>>>>>>>> If your server is online, is it possible to give me one account, >>>>>>>>>>> I will login and check for you. >>>>>>>>>>> >>>>>>>>>>> On Tue, Apr 25, 2017 at 3:38 PM, Muhammad Bilal Siddqui < >>>>>>>>>>> m.bilalsidd...@micromerger.com> wrote: >>>>>>>>>>> >>>>>>>>>>>> Actually there are some OrgUnits. I select 1 as parent but it >>>>>>>>>>>> still showing that error. >>>>>>>>>>>> >>>>>>>>>>>> Get Outlook for iOS <https://aka.ms/o0ukef> >>>>>>>>>>>> ------------------------------ >>>>>>>>>>>> *From:* Em Le Hong <em.hispviet...@gmail.com> >>>>>>>>>>>> *Sent:* Tuesday, April 25, 2017 1:30:41 PM >>>>>>>>>>>> *To:* Muhammad Bilal Siddqui >>>>>>>>>>>> *Cc:* Knut Staring; DHIS 2 Users list >>>>>>>>>>>> *Subject:* Re: [Dhis2-users] Data Store Issue in DHIS2 [2.26] >>>>>>>>>>>> >>>>>>>>>>>> I guess you are missing parent orgUnit, you need to create it >>>>>>>>>>>> as root orgUnit if there's no orgUnit exist in your database. >>>>>>>>>>>> >>>>>>>>>>>> On Tue, Apr 25, 2017 at 3:10 PM, Muhammad Bilal Siddqui < >>>>>>>>>>>> m.bilalsidd...@micromerger.com> wrote: >>>>>>>>>>>> >>>>>>>>>>>>> Thanks for response. I check console it show me following >>>>>>>>>>>>> error >>>>>>>>>>>>>> >>>>>>>>>>>>>> null value in column "organisationunitid" violates not-null >>>>>>>>>>>>>> constraint >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> console screenshot attached >>>>>>>>>>>>> >>>>>>>>>>>>> On Tue, Apr 25, 2017 at 11:26 AM, Knut Staring < >>>>>>>>>>>>> knu...@gmail.com> wrote: >>>>>>>>>>>>> >>>>>>>>>>>>>> Please look for error messages in your browser console and >>>>>>>>>>>>>> your Tomcat log. >>>>>>>>>>>>>> >>>>>>>>>>>>>> Regards, >>>>>>>>>>>>>> Knut >>>>>>>>>>>>>> >>>>>>>>>>>>>> On Apr 25, 2017 6:13 AM, "Muhammad Bilal Siddqui" < >>>>>>>>>>>>>> m.bilalsidd...@micromerger.com> wrote: >>>>>>>>>>>>>> >>>>>>>>>>>>>>> HI, >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> I have set up DHIS2 on my server successfully all is working >>>>>>>>>>>>>>> fine with demo DB then I connect different empty db and also >>>>>>>>>>>>>>> try in demo db >>>>>>>>>>>>>>> but i am not able to add Organisation unit. it gives me >>>>>>>>>>>>>>> following error. >>>>>>>>>>>>>>> *failed_to_save_organisation_unit* >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> Any thoughts what went wrong. Am using chrome browser >>>>>>>>>>>>>>> DHIS2 Version 2.26 >>>>>>>>>>>>>>> PostgresSQL Version 9.4.10 >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> -- >>>>>>>>>>>>>>> -- >>>>>>>>>>>>>>> Regards >>>>>>>>>>>>>>> *Muhammad Bilal Siddiqui* >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> *MicroMerger (Pvt.) Ltd.* >>>>>>>>>>>>>>> Office No-104 Cubator 1ne >>>>>>>>>>>>>>> CIIT, Park Road, Chak Shehzad >>>>>>>>>>>>>>> Islamabad. >>>>>>>>>>>>>>> Pakistan 44000 >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> *C* : +923325694928 *P* : +92518444777 >>>>>>>>>>>>>>> *E* : m.bilalsidd...@micromerger.com *W* : >>>>>>>>>>>>>>> www.micromerger.com >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> *This e-mail and any files transmitted with it are >>>>>>>>>>>>>>> confidential to the intended recipient and may be privileged. >>>>>>>>>>>>>>> If you are >>>>>>>>>>>>>>> not the intended recipient, please immediately notify the >>>>>>>>>>>>>>> sender. Whilst we >>>>>>>>>>>>>>> have used Anti-Virus software to alert us to the presence of >>>>>>>>>>>>>>> computer >>>>>>>>>>>>>>> viruses, we cannot guarantee that this email and any files >>>>>>>>>>>>>>> transmitted with >>>>>>>>>>>>>>> it are free from them. *N : Think before print do you >>>>>>>>>>>>>>> really need this on paper. thanks >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> _______________________________________________ >>>>>>>>>>>>>>> Mailing list: https://launchpad.net/~dhis2-users >>>>>>>>>>>>>>> Post to : dhis2-users@lists.launchpad.net >>>>>>>>>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users >>>>>>>>>>>>>>> More help : https://help.launchpad.net/ListHelp >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> -- >>>>>>>>>>>>> -- >>>>>>>>>>>>> Regards >>>>>>>>>>>>> *Muhammad Bilal Siddiqui* >>>>>>>>>>>>> >>>>>>>>>>>>> *MicroMerger (Pvt.) Ltd.* >>>>>>>>>>>>> Office No-104 Cubator 1ne >>>>>>>>>>>>> CIIT, Park Road, Chak Shehzad >>>>>>>>>>>>> Islamabad. >>>>>>>>>>>>> Pakistan 44000 >>>>>>>>>>>>> >>>>>>>>>>>>> *C* : +923325694928 *P* : +92518444777 >>>>>>>>>>>>> *E* : m.bilalsidd...@micromerger.com *W* : >>>>>>>>>>>>> www.micromerger.com >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> *This e-mail and any files transmitted with it are >>>>>>>>>>>>> confidential to the intended recipient and may be privileged. If >>>>>>>>>>>>> you are >>>>>>>>>>>>> not the intended recipient, please immediately notify the sender. >>>>>>>>>>>>> Whilst we >>>>>>>>>>>>> have used Anti-Virus software to alert us to the presence of >>>>>>>>>>>>> computer >>>>>>>>>>>>> viruses, we cannot guarantee that this email and any files >>>>>>>>>>>>> transmitted with >>>>>>>>>>>>> it are free from them. *N : Think before print do you really >>>>>>>>>>>>> need this on paper. thanks >>>>>>>>>>>>> >>>>>>>>>>>>> _______________________________________________ >>>>>>>>>>>>> Mailing list: https://launchpad.net/~dhis2-users >>>>>>>>>>>>> Post to : dhis2-users@lists.launchpad.net >>>>>>>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users >>>>>>>>>>>>> More help : https://help.launchpad.net/ListHelp >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> -- >>>>>>>>>>>> *Em Le Hong* >>>>>>>>>>>> DHIS2 Implementation| *HISP Vietnam* >>>>>>>>>>>> em.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.com >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> -- >>>>>>>>>>> *Em Le Hong* >>>>>>>>>>> DHIS2 Implementation| *HISP Vietnam* >>>>>>>>>>> em.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.com >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> -- >>>>>>>>>> Regards >>>>>>>>>> *Muhammad Bilal Siddiqui* >>>>>>>>>> >>>>>>>>>> *MicroMerger (Pvt.) Ltd.* >>>>>>>>>> Office No-104 Cubator 1ne >>>>>>>>>> CIIT, Park Road, Chak Shehzad >>>>>>>>>> Islamabad. >>>>>>>>>> Pakistan 44000 >>>>>>>>>> >>>>>>>>>> *C* : +923325694928 *P* : +92518444777 >>>>>>>>>> *E* : m.bilalsidd...@micromerger.com *W* : www.micromerger.com >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> *This e-mail and any files transmitted with it are confidential >>>>>>>>>> to the intended recipient and may be privileged. If you are not the >>>>>>>>>> intended recipient, please immediately notify the sender. Whilst we >>>>>>>>>> have >>>>>>>>>> used Anti-Virus software to alert us to the presence of computer >>>>>>>>>> viruses, >>>>>>>>>> we cannot guarantee that this email and any files transmitted with >>>>>>>>>> it are >>>>>>>>>> free from them. *N : Think before print do you really need this >>>>>>>>>> on paper. thanks >>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> *Em Le Hong* >>>>>>>>> DHIS2 Implementation| *HISP Vietnam* >>>>>>>>> em.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.com >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> *Em Le Hong* >>>>>>>> DHIS2 Implementation| *HISP Vietnam* >>>>>>>> em.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.com >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> -- >>>>>>> Regards >>>>>>> *Muhammad Bilal Siddiqui* >>>>>>> >>>>>>> *MicroMerger (Pvt.) Ltd.* >>>>>>> Office No-104 Cubator 1ne >>>>>>> CIIT, Park Road, Chak Shehzad >>>>>>> Islamabad. >>>>>>> Pakistan 44000 >>>>>>> >>>>>>> *C* : +923325694928 *P* : +92518444777 >>>>>>> *E* : m.bilalsidd...@micromerger.com *W* : www.micromerger.com >>>>>>> >>>>>>> >>>>>>> *This e-mail and any files transmitted with it are confidential to >>>>>>> the intended recipient and may be privileged. If you are not the >>>>>>> intended >>>>>>> recipient, please immediately notify the sender. Whilst we have used >>>>>>> Anti-Virus software to alert us to the presence of computer viruses, we >>>>>>> cannot guarantee that this email and any files transmitted with it are >>>>>>> free >>>>>>> from them.*N : Think before print do you really need this on paper. >>>>>>> thanks >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> *Em Le Hong* >>>>>> DHIS2 Implementation| *HISP Vietnam* >>>>>> em.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.com >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> -- >>>>> Regards >>>>> *Muhammad Bilal Siddiqui* >>>>> >>>>> *MicroMerger (Pvt.) Ltd.* >>>>> Office No-104 Cubator 1ne >>>>> CIIT, Park Road, Chak Shehzad >>>>> Islamabad. >>>>> Pakistan 44000 >>>>> >>>>> *C* : +923325694928 *P* : +92518444777 >>>>> *E* : m.bilalsidd...@micromerger.com *W* : www.micromerger.com >>>>> >>>>> >>>>> *This e-mail and any files transmitted with it are confidential to the >>>>> intended recipient and may be privileged. If you are not the intended >>>>> recipient, please immediately notify the sender. Whilst we have used >>>>> Anti-Virus software to alert us to the presence of computer viruses, we >>>>> cannot guarantee that this email and any files transmitted with it are >>>>> free >>>>> from them.*N : Think before print do you really need this on paper. >>>>> thanks >>>>> >>>> >>>> >>>> >>>> -- >>>> *Em Le Hong* >>>> DHIS2 Implementation| *HISP Vietnam * >>>> em.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.com >>>> >>>> >>>> >>>> >>>> >>>> >>> >>> >>> -- >>> -- >>> Regards >>> *Muhammad Bilal Siddiqui* >>> >>> *MicroMerger (Pvt.) Ltd.* >>> Office No-104 Cubator 1ne >>> CIIT, Park Road, Chak Shehzad >>> Islamabad. >>> Pakistan 44000 >>> >>> *C* : +923325694928 *P* : +92518444777 >>> *E* : m.bilalsidd...@micromerger.com *W* : www.micromerger.com >>> >>> >>> *This e-mail and any files transmitted with it are confidential to the >>> intended recipient and may be privileged. If you are not the intended >>> recipient, please immediately notify the sender. Whilst we have used >>> Anti-Virus software to alert us to the presence of computer viruses, we >>> cannot guarantee that this email and any files transmitted with it are free >>> from them.*N : Think before print do you really need this on paper. >>> thanks >>> >> >> >> >> -- >> *Em Le Hong* >> DHIS2 Implementation| *HISP Vietnam * >> em.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.com >> >> >> >> >> >> > > > -- > -- > Regards > *Muhammad Bilal Siddiqui* > > *MicroMerger (Pvt.) Ltd.* > Office No-104 Cubator 1ne > CIIT, Park Road, Chak Shehzad > Islamabad. > Pakistan 44000 > > *C* : +923325694928 *P* : +92518444777 > *E* : m.bilalsidd...@micromerger.com *W* : www.micromerger.com > > > *This e-mail and any files transmitted with it are confidential to the > intended recipient and may be privileged. If you are not the intended > recipient, please immediately notify the sender. Whilst we have used > Anti-Virus software to alert us to the presence of computer viruses, we > cannot guarantee that this email and any files transmitted with it are free > from them.*N : Think before print do you really need this on paper. thanks > -- *Em Le Hong* DHIS2 Implementation| *HISP Vietnam * em.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.com
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp