Hi Thuy, Worked perfectly.
Thank you. Busoye On 25 April 2013 00:23, Thuy Nguyen <[email protected]> wrote: > Hi Busoye > You can change the current value of hibernate sequence by open your > postgresql database> there you expand the Schemas > > expand the Sequences> right click on Hibernate_sequence and select > Properties. the Current Value is in the Definition tab. > Change this number to the highest id from your indicator table or highest > in all the id value you have in the database to prevent this error happen > again in future. > > Thuy > > > On Thu, Apr 25, 2013 at 3:38 AM, Busoye Anifalaje <[email protected]> wrote: > >> Hi all, >> >> I imported 190 new indicators through a csv import into Postgres. >> IndicatorID as the primary key was set incrementally to continue from the >> last highest number (i.e. 33466, 33467, 33468 ... 33673). The imported >> indicators work perfectly. >> >> Now the problem: I tried to create a new indicator through the front end >> in DHIS2.11 (Build Revision: 10492) but keep getting an error that >> identifies a primary key conflict with the indicatorid. I also found that >> with every retry, the system tries to use the next incremental indicatorid >> (e.g. trial 1: indicatorid 33467 already exists; trial 2: 33468 already >> exists). I manually entered the indicator directly into the postgres table >> without any problem. Again, the indicator works fine. Any ideas on how to >> solve this problem without having to update all the imported indicators >> with new indicator ids? >> >> Further details of the error are attached in the attached screenshots >> (for some reason my tomcat log is not capturing the error - also attached). >> >> >> Thanks. >> >> Busoye >> >> DHIS Version: 2.11 >> Build Revision: 10492 >> OS: Windows XP >> OS Version: 5.1 >> >> >> >> >> >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-users >> Post to : [email protected] >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> >> >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
