Novell Home

My Favorites

Close

Please to see your favorites.

ZCM 11.2.1 migration from embedded Sybase to Oracle fails

This document (7010347) is provided subject to the disclaimer at the end of this document.

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 http://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 TID 7010757 "ZENworks Configuration Management 11.2.2 - update information and list of fixes" which can be found at http://www.novell.com/support/search.do?usemicrosite=true&searchString=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 http://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

Disclaimer

This Support Knowledgebase provides a valuable tool for NetIQ/Novell/SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.

  • Document ID:7010347
  • Creation Date:02-JUL-12
  • Modified Date:09-NOV-12
    • NovellZENworks Configuration Management

Did this document solve your problem? Provide Feedback