dhis2-devs team mailing list archive

[Hieu Dang Duy <hieu.hispvietnam@xxxxxxxxx>]

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 <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
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Hieu.HISPVietnam
Good Health !