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
[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