Vista combinada Visión Plana Vista de árbol
Discusiones [ Anterior | Siguiente ]
toggle
Srinivas KK
6.1.0 to 6.1.2 GA3 upgrade fails on VerfiyLayout
17 de enero de 2014 17:01
Respuesta

Srinivas KK

Ranking: Junior Member

Mensajes: 33

Fecha de incorporación: 3 de diciembre de 2011

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 KK
RE: 6.1.0 to 6.1.2 GA3 upgrade fails on VerfiyLayout
17 de enero de 2014 14:19
Respuesta

Srinivas KK

Ranking: Junior Member

Mensajes: 33

Fecha de incorporación: 3 de diciembre de 2011

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 KK
RE: 6.1.0 to 6.1.2 GA3 upgrade fails on VerfiyLayout
19 de enero de 2014 7:00
Respuesta

Srinivas KK

Ranking: Junior Member

Mensajes: 33

Fecha de incorporación: 3 de diciembre de 2011

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 .