dhis2-users team mailing list archive

[Em Le Hong <em.hispvietnam@xxxxxxxxx>]

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.bilalsiddqui@xxxxxxxxxxxxxxx> 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.hispvietnam@xxxxxxxxx>
> 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.bilalsiddqui@xxxxxxxxxxxxxxx> 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.hispvietnam@xxxxxxxxx>
>>> 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.bilalsiddqui@xxxxxxxxxxxxxxx> 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.hispvietnam@xxxxxxxxx>
>>>>> 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.bilalsiddqui@xxxxxxxxxxxxxxx> 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.bilalsiddqui@xxxxxxxxxxxxxxx> wrote:
>>>>>>>
>>>>>>>> Ok. Thank you. I will try that.
>>>>>>>>
>>>>>>>> Get Outlook for iOS <https://aka.ms/o0ukef>
>>>>>>>> ------------------------------
>>>>>>>> *From:* Em Le Hong <em.hispvietnam@xxxxxxxxx>
>>>>>>>> *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.bilalsiddqui@xxxxxxxxxxxxxxx> 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.hispvietnam@xxxxxxxxx>
>>>>>>>>> *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.bilalsiddqui@xxxxxxxxxxxxxxx> 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.hispvietnam@xxxxxxxxx> 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.bilalsiddqui@xxxxxxxxxxxxxxx> 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.hispvietnam@xxxxxxxxx>
>>>>>>>>>>>> *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.bilalsiddqui@xxxxxxxxxxxxxxx> 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 <
>>>>>>>>>>>>> knutst@xxxxxxxxx> 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.bilalsiddqui@xxxxxxxxxxxxxxx> 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.bilalsiddqui@xxxxxxxxxxxxxxx  *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@xxxxxxxxxxxxxxxxxxx
>>>>>>>>>>>>>>> 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.bilalsiddqui@xxxxxxxxxxxxxxx  *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@xxxxxxxxxxxxxxxxxxx
>>>>>>>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>>>>>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> --
>>>>>>>>>>>> *Em Le Hong*
>>>>>>>>>>>> DHIS2 Implementation| *HISP Vietnam*
>>>>>>>>>>>> em.hispvietnam@xxxxxxxxx | *Skype:* em.hispvietnam@xxxxxxxxx
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> --
>>>>>>>>>>> *Em Le Hong*
>>>>>>>>>>> DHIS2 Implementation| *HISP Vietnam*
>>>>>>>>>>> em.hispvietnam@xxxxxxxxx | *Skype:* em.hispvietnam@xxxxxxxxx
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> --
>>>>>>>>>> --
>>>>>>>>>> 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.bilalsiddqui@xxxxxxxxxxxxxxx  *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.hispvietnam@xxxxxxxxx | *Skype:* em.hispvietnam@xxxxxxxxx
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> *Em Le Hong*
>>>>>>>> DHIS2 Implementation| *HISP Vietnam*
>>>>>>>> em.hispvietnam@xxxxxxxxx | *Skype:* em.hispvietnam@xxxxxxxxx
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> --
>>>>>>> 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.bilalsiddqui@xxxxxxxxxxxxxxx  *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.hispvietnam@xxxxxxxxx | *Skype:* em.hispvietnam@xxxxxxxxx
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> --
>>>>> 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.bilalsiddqui@xxxxxxxxxxxxxxx  *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.hispvietnam@xxxxxxxxx | *Skype:* em.hispvietnam@xxxxxxxxx
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>> --
>>> 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.bilalsiddqui@xxxxxxxxxxxxxxx  *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.hispvietnam@xxxxxxxxx | *Skype:* em.hispvietnam@xxxxxxxxx
>>
>>
>>
>>
>>
>>
>
>
> --
> --
> 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.bilalsiddqui@xxxxxxxxxxxxxxx  *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.hispvietnam@xxxxxxxxx | *Skype:* em.hispvietnam@xxxxxxxxx