Cannot Upgrade to ZENworks 11.3.1 Error in ConstraintName_Fix.sql

  • 7015748
  • 07-Oct-2014
  • 07-Oct-2014

Environment

Novell ZENworks Configuration Management 11.3.1 System Update
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

Resolution

A patch has been provided on a case by case basis. Please contact Novell support if the issue is seen.

Status

Reported to Engineering

Feedback service temporarily unavailable. For content questions or problems, please contact Support.