dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

Hi,

The problem (I think) is that the hibernate_sequence value is the same
as the organisationunitid values you already have in your table.

Please run the following and send us the result:

SELECT MAX(organisationunitid) FROM organisationunit;
SELECT nextval('hibernate_sequence');

Knut

On 12/2/11, Ifeanyi Okoye <897677@xxxxxxxxxxxxxxxxxx> wrote:
> Hello Knut,
> This error was encountered working off the Ubuntu server.
> Is there anyway we can fix this from there?
> Thanks
>
>
> Warm Regards,
>
> Ifeanyi
>
>
>
> ________________________________
>  From: Knut Staring <knutst@xxxxxxxxx>
> To: ifeanyiokoye@xxxxxxxxx
> Sent: Thursday, December 1, 2011 3:33 PM
> Subject: Re: [Bug 897677] Re: Some functions not working in DHIS 2 after
> database restore
>
> Hi Ife,
>
> I think this is related to importing to the database directly (not through
> the webinterface).
>
> You can hopefullyl resolve it by increasing the value of
> hibernate_sequence, which you can find under Schema-public-Sequences in
> pgadmin
>
> Knut
>
> On Thu, Dec 1, 2011 at 3:01 PM, Ifeanyi Okoye
> <897677@xxxxxxxxxxxxxxxxxx>wrote:
>
>> Just encountered this error now.
>>
>> ** Attachment added: "Error addOrganisationUnit.action.htm"
>>
>> https://bugs.launchpad.net/dhis2/+bug/897677/+attachment/2614704/+files/Error%20addOrganisationUnit.action.htm
>>
>> --
>> You received this bug notification because you are a member of DHIS 2
>> India Developers, which is subscribed to DHIS.
>> https://bugs.launchpad.net/bugs/897677
>>
>> Title:
>>  Some functions not working in DHIS 2 after database restore
>>
>> Status in DHIS 2 - District Health Information Software:
>>  New
>>
>> Bug description:
>>  I run a DHIS 2.0 (version 2.5) live instance using PostgreSQL 9.1 on my
>> Windows 7 computer. I used pg_dump to create a database backup in plain
>> format for a restore to PostgreSQL 8.4 running on an Ubuntu 10.04 i386
>> server. The restore was successful but there were some errors.
>>  After logging in, we found that there were problems with the following
>> functions:
>>
>>  1. Some of the settings did not import with the database restore
>>  2. Opening system general settings throws an exception
>>  3. Adding users also throws an exception
>>  4. Trying to edit a dataset throws exceptions as well.
>>
>>  I have attached some error logs and screenshots for you to see
>>
>> To manage notifications about this bug go to:
>> https://bugs.launchpad.net/dhis2/+bug/897677/+subscriptions
>>
>
>
> --
> Knut Staring
> Informatics, U. of Oslo
> http://hisp.uio.no
> +4791880522
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/897677
>
> Title:
>   Some functions not working in DHIS 2 after database restore
>
> Status in DHIS 2 - District Health Information Software:
>   New
>
> Bug description:
>   I run a DHIS 2.0 (version 2.5) live instance using PostgreSQL 9.1 on my
> Windows 7 computer. I used pg_dump to create a database backup in plain
> format for a restore to PostgreSQL 8.4 running on an Ubuntu 10.04 i386
> server. The restore was successful but there were some errors.
>   After logging in, we found that there were problems with the following
> functions:
>
>   1. Some of the settings did not import with the database restore
>   2. Opening system general settings throws an exception
>   3. Adding users also throws an exception
>   4. Trying to edit a dataset throws exceptions as well.
>
>   I have attached some error logs and screenshots for you to see
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/897677/+subscriptions
>
> --
> You received this bug notification because you are a member of DHIS 2
> India Developers, which is subscribed to DHIS.
> https://bugs.launchpad.net/bugs/897677
>
> Title:
>   Some functions not working in DHIS 2 after database restore
>
> Status in DHIS 2 - District Health Information Software:
>   New
>
> Bug description:
>   I run a DHIS 2.0 (version 2.5) live instance using PostgreSQL 9.1 on my
> Windows 7 computer. I used pg_dump to create a database backup in plain
> format for a restore to PostgreSQL 8.4 running on an Ubuntu 10.04 i386
> server. The restore was successful but there were some errors.
>   After logging in, we found that there were problems with the following
> functions:
>
>   1. Some of the settings did not import with the database restore
>   2. Opening system general settings throws an exception
>   3. Adding users also throws an exception
>   4. Trying to edit a dataset throws exceptions as well.
>
>   I have attached some error logs and screenshots for you to see
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/897677/+subscriptions
>


-- 
Knut Staring
Informatics, U. of Oslo
http://hisp.uio.no
+4791880522