Problems starting latest build

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

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


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


Hieu.HISPVietnam
Good Health !