Environment
Novell ZENworks Configuration Management 11.3.1 System Update
Oracle database
Oracle database
Situation
Cannot upgrade to ZENworks 11.3.1
The upgrade fails on the pre-global actions
The following may be seen in the pre-global-actions.log:
Error executing v_11_3_1/oracle/ConstraintName_Fix.sql, will retry (1). Error: (com.novell.zenworks.datamodel.exceptions.InternalDataModelException: Error executing SQL: DECLARE
V_STG VARCHAR2(400);
Caused by: org.hibernate.QueryTimeoutException: ORA-20001: Stage 1 SYS_C0011450C00C00C00C00C00C00ORA-00972: identifier is too long
ORA-06512: at line 12
ORA-00972: identifier is too long
The upgrade fails on the pre-global actions
The following may be seen in the pre-global-actions.log:
Error executing v_11_3_1/oracle/ConstraintName_Fix.sql, will retry (1). Error: (com.novell.zenworks.datamodel.exceptions.InternalDataModelException: Error executing SQL: DECLARE
V_STG VARCHAR2(400);
Caused by: org.hibernate.QueryTimeoutException: ORA-20001: Stage 1 SYS_C0011450C00C00C00C00C00C00ORA-00972: identifier is too long
ORA-06512: at line 12
ORA-00972: identifier is too long
Resolution
A patch has been provided on a case by case basis. Please contact
Novell support if the issue is seen.