Database migration fails from Sybase to Oracle

  • 7003134
  • 27-Apr-2009
  • 27-Apr-2012

Environment

Novell ZENworks 10 Configuration Management with Support Pack 1 - 10.1.3 Migration

Situation

Migration of Sybase to Oracle database fails if the ZAM Migration utility was used to migrate from ZAM 7.5 to ZCM 10.1.x.  The same failure will also happen if the ZAM Migration from ZAM 7.5 to ZCM 10.1.x was done, then 10.1.x was upgraded to 10.2. 
 
It gives the following error:
 
[2009.04.20-18:53:20] FINER: Number of rows in target DB:NC_CPUis:0
[2009.04.20-18:53:20] FINER: ORA-01438: value larger than specified precision allowed for this column

[2009.04.20-18:53:20] SEVERE: An error has occurred while migrating the database.
[2009.04.20-18:53:22] SEVERE: ORA-01438: value larger than specified precision allowed for this column

[2009.04.20-18:53:22] FINEST: Unexpected exception com.novell.zenworks.configure.ConfigureException: ORA-01438: value larger than specified precision allowed for this column

Resolution

This is fixed in version 10.2 - see KB 7003225 "ZENworks Configuration Management SP2 (10.2) - update information and list of fixes" which can be found at https://www.novell.com/support