dhis2-devs team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

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