Details
-
Bug
-
Resolution: Done
-
Major
-
xCM 6.0
-
None
Description
60 r25860
Sql Server 2008
Files: db storage
Bigtexts: filesystem storage
ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - Unsuccessful: alter table jahia_sites_grps add constraint FK7B24559790F996AC foreign key (grpid_sites_grps) references jahia_grps (key_jahia_grps)
ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - Column 'jahia_grps.key_jahia_grps' is not the same length or scale as referencing column 'jahia_sites_grps.grpid_sites_grps' in foreign key 'FK7B24559790F996AC'. Columns participating in a foreign key relationship must be defined with the same length and scale.
ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - Unsuccessful: alter table jahia_sites_users add constraint FKEA2BF1BF6CF683C0 foreign key (userid_sites_users) references jahia_users (key_jahia_users)
ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - Column 'jahia_users.key_jahia_users' is not the same length or scale as referencing column 'jahia_sites_users.userid_sites_users' in foreign key 'FKEA2BF1BF6CF683C0'. Columns participating in a foreign key relationship must be defined with the same length and scale.
TestRail: Results
Attachments
Issue Links
- relates to
-
-
- Closed
-
Activity
Damien Saulnier
added a comment - Same with Oracle:
ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - Unsuccessful: alter table jahia_sites_grps add constraint FK7B24559790F996AC foreign key (grpid_sites_grps) references jahia_grps (key_jahia_grps)
ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - ORA-02275: une telle contrainte rÚfÚrentielle existe dÚjÓ dans la table
ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - Unsuccessful: alter table jahia_sites_users add constraint FKEA2BF1BF6CF683C0 foreign key (userid_sites_users) references jahia_users (key_jahia_users)
ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - ORA-02275: une telle contrainte rÚfÚrentielle existe dÚjÓ dans la table
Damien Saulnier
added a comment - Same with Oracle:
ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - Unsuccessful: alter table jahia_sites_grps add constraint FK7B24559790F996AC foreign key (grpid_sites_grps) references jahia_grps (key_jahia_grps)
ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - ORA-02275: une telle contrainte rÚfÚrentielle existe dÚjÓ dans la table
ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - Unsuccessful: alter table jahia_sites_users add constraint FKEA2BF1BF6CF683C0 foreign key (userid_sites_users) references jahia_users (key_jahia_users)
ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] - ORA-02275: une telle contrainte rÚfÚrentielle existe dÚjÓ dans la table 
Resolution: added <column/> element for <many-to-one/> mapping in order to specify column length explicitly. Otherwise the SchemaExportTask assumes the length of 255 chars (a bug in SchemaExportTask?)
Commit: 26243