Sybase to Oracle migrating fails to port on large data tables.

  • 7003330
  • 21-May-2009
  • 06-Jul-2012

Environment

Novell ZENworks 10 Configuration Management with Support Pack 1 - 10.1 Database

Situation

ERROR: "FINER: JZ006: Caught IOException: java.io.IOException: JZ0C0: Connection is already closed.
[2009.05.05-10:32:19] SEVERE: An error has occurred while migrating the database."
The Closest Server Rules not migrating. 
If the migration detects that one of the closest server rules data columns has more than 50000 characters, then it will postpone the migration on those rows.

The ASA database service exits suddenly at about the time when the error gets reported.
 
Also, possible errors after sucessful migration due to large tables being truncated.  Examples, bundles with missing actions, Frequently Used shortcut missing.


Resolution

This is fixed in version 10.2.1 - see KB 7003766 "ZENworks 10 Configuration Management 10.2.1 - update information and list of fixes" which can be found at https://www.novell.com/support