The below problem resolved itself when I switched to the db I need to use. k
On Mon, Sep 21, 2009 at 11:10 PM, Knut Staring <knu...@gmail.com> 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 > -- Cheers, Knut Staring
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
