Foros de discusión
6.1.0 to 6.1.2 GA3 upgrade fails on VerfiyLayout
Srinivas Konakanchi, modificado hace 10 años.
6.1.0 to 6.1.2 GA3 upgrade fails on VerfiyLayout
Junior Member Mensajes: 33 Fecha de incorporación: 4/12/11 Mensajes recientes
I am trying to upgrade CE , able to resolve most of the db upgrade issues . since db user doesn't have all required roles to modify tables ( which is expected , dba team doesn't let application to modify the schema ).
So finally here this update stmt is failing , since this column is not unique - sourceprototypelayoutuuid. .
SQL: update Layout set uuid_ = sourcePrototypeLayoutUuid where sourcePrototypeLayoutUuid IS NOT NULL and uuid_ != sourcePrototypeLayoutUuid
SQL state: 23000
Vendor: oracle
Vendor error code: 1
Vendor error message: ORA-00001: unique constraint (<schema>.IX_CED31606) violated
How do i correct this table or should i skip running this update ? Please help us.
protected void verifyUuid() throws Exception {
verifyUuid("AssetEntry");
verifyUuid("JournalArticle");
StringBundler sb = new StringBundler(3);
sb.append("update Layout set uuid_ = sourcePrototypeLayoutUuid where ");
sb.append("sourcePrototypeLayoutUuid != '' and ");
sb.append("uuid_ != sourcePrototypeLayoutUuid");
runSQL(sb.toString());
}
So finally here this update stmt is failing , since this column is not unique - sourceprototypelayoutuuid. .
SQL: update Layout set uuid_ = sourcePrototypeLayoutUuid where sourcePrototypeLayoutUuid IS NOT NULL and uuid_ != sourcePrototypeLayoutUuid
SQL state: 23000
Vendor: oracle
Vendor error code: 1
Vendor error message: ORA-00001: unique constraint (<schema>.IX_CED31606) violated
How do i correct this table or should i skip running this update ? Please help us.
protected void verifyUuid() throws Exception {
verifyUuid("AssetEntry");
verifyUuid("JournalArticle");
StringBundler sb = new StringBundler(3);
sb.append("update Layout set uuid_ = sourcePrototypeLayoutUuid where ");
sb.append("sourcePrototypeLayoutUuid != '' and ");
sb.append("uuid_ != sourcePrototypeLayoutUuid");
runSQL(sb.toString());
}
Srinivas Konakanchi, modificado hace 10 años.
RE: 6.1.0 to 6.1.2 GA3 upgrade fails on VerfiyLayout
Junior Member Mensajes: 33 Fecha de incorporación: 4/12/11 Mensajes recientes
Even if i drop old index and create new index , i will run into the same issue
.
create unique index IX_E118C537 on Layout (uuid_, groupId, privateLayout);
.
create unique index IX_E118C537 on Layout (uuid_, groupId, privateLayout);
Srinivas Konakanchi, modificado hace 10 años.
RE: 6.1.0 to 6.1.2 GA3 upgrade fails on VerfiyLayout
Junior Member Mensajes: 33 Fecha de incorporación: 4/12/11 Mensajes recientes
sb.append("update Layout set uuid_ = sourcePrototypeLayoutUuid where ");
sb.append("sourcePrototypeLayoutUuid != '' and ");
sb.append("uuid_ != sourcePrototypeLayoutUuid");
wht's the purpose of the sql , why we r trying to set unique field with non-unique field value ?
child menu items will have same sourcePrototypeLayoutUuid value , so above sql is failing.
MenuItem1-> ChildMenuItem2 , ChildMenuItem3 ..etc , Here child menu items have same value for sourcePrototypeLayoutUuid .
sb.append("sourcePrototypeLayoutUuid != '' and ");
sb.append("uuid_ != sourcePrototypeLayoutUuid");
wht's the purpose of the sql , why we r trying to set unique field with non-unique field value ?
child menu items will have same sourcePrototypeLayoutUuid value , so above sql is failing.
MenuItem1-> ChildMenuItem2 , ChildMenuItem3 ..etc , Here child menu items have same value for sourcePrototypeLayoutUuid .