Dear Knut, I am also getting this problem.
I think its cause's the latest building code and the current database, which are being used, doesn't compatibility with each other. Any idea better than for this one ? On Tue, Sep 22, 2009 at 4:10 AM, Knut Staring <[email protected]> wrote: > Seems Hibernate cannot carry out necessary adjustments to the database > because of lacking keys? > > * INFO 21:07:29,974 Hibernate properties file found: > /usr/local/dhis/config/za/hibernate.properties > (DefaultHibernateConfigurationProvider.java [main]) > * ERROR 21:07:37,520 Unsuccessful: alter table categories_categoryoptions > add constraint fk_category_categoryoptionid foreign key (categoryoptionid) > references dataelementcategoryoption (SchemaUpdate.java [main]) > * ERROR 21:07:37,521 ERROR: insert or update on table > "categories_categoryoptions" violates foreign key constraint > "fk_category_categoryoptionid" > Detail: Key (categoryoptionid)=(1) is not present in table > "dataelementcategoryoption". (SchemaUpdate.java [main]) > * ERROR 21:07:37,548 Unsuccessful: alter table > categoryoptioncombos_categoryoptions add constraint > fk_categoryoptioncombo_categoryoptionid foreign key (categoryoptionid) > references dataelementcategoryoption (SchemaUpdate.java [main]) > * ERROR 21:07:37,548 ERROR: insert or update on table > "categoryoptioncombos_categoryoptions" violates foreign key constraint > "fk_categoryoptioncombo_categoryoptionid" > Detail: Key (categoryoptionid)=(1) is not present in table > "dataelementcategoryoption". (SchemaUpdate.java [main]) > * ERROR 21:07:37,552 Unsuccessful: alter table columnorder add constraint > fk_columnorder_categoryoptionid foreign key (categoryoptionid) references > dataelementcategoryoption (SchemaUpdate.java [main]) > * ERROR 21:07:37,552 ERROR: insert or update on table "columnorder" > violates foreign key constraint "fk_columnorder_categoryoptionid" > Detail: Key (categoryoptionid)=(2428) is not present in table > "dataelementcategoryoption". (SchemaUpdate.java [main]) > > -- > Cheers, > Knut Staring > > _______________________________________________ > Mailing list: > https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs> > Post to : [email protected] > Unsubscribe : > https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs> > More help : https://help.launchpad.net/ListHelp > > -- Hieu.HISPVietnam Good Health !
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
