dhis2-users team mailing list archive

[Muhammad Bilal Siddqui <m.bilalsiddqui@xxxxxxxxxxxxxxx>]

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