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 knutst@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