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());

}
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);
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 .