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
