ZCM 11.2.1 migration from embedded Sybase to Oracle fails

  • 7010347
  • 02-Jul-2012
  • 09-Nov-2012

Environment

Novell ZENworks Configuration Management 11.2.1 Database

Situation

Attempting to migrate from an Internal Sybase Database to an External Oracle Database, following instructions in the online documentation https://www.novell.com/documentation/zenworks11/zen11_system_admin/?page=/documentation/zenworks11/zen11_system_admin/data/b83m504.html

ERROR:
/opt/novell/zenworks/share/datamodel/oracle/nc_component_indexes.sql,
 message:Failed to execute the SQL command: --BREAK,
 message:Invalid SQL type: sqlKind = 0

Migration fails

Resolution

This is fixed in version 11.2.2 - see KB 7010757 "ZENworks Configuration Management 11.2.2 - update information and list of fixes" which can be found at https://support.microfocus.com/kb/doc.php?id=7010757

Workaround: if it is not possible to upgrade to ZCM 11.2.2 at this time, in the interim, Novell has made a Patch available for testing, in the form of a Field Test File (FTF): it can be obtained at https://download.novell.com/Download?buildid=7O060czFFhE~ as "ZCM 11.2.1 - fix to allow migration from embedded Sybase to Oracle - see TID 7010347". This Patch should only be applied if the symptoms above are being experienced, and are causing problems.

This Patch has had limited testing, and should not be used in a production system without first being checked in a test environment. Some Patches have specific requirements for deployment, it is very important to follow any instructions in the readme at the download site. Please report any problems encountered when using this Patch, by using the feedback link on this TID.

Cause

Incorrect SQL syntax in /opt/novell/zenworks/share/datamodel/oracle/nc_component_indexes.sql file, found too late in the test cycle to be incorporated into ZCM 11.2.1