dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

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