If you encounter a Java Heap Space exception during the database migration because of low memory:
Edit the ZENworks_installation_path\bin\novell-zenworks-configure.bat file on Windows or /opt/novell/zenworks/bin/novell-zenworks-configure on Linux to change the heap space value in the following line, depending upon the RAM of the device where the migration utility is running:
"%JAVA_HOME%\bin\java" -Djava.library.path=%ZENLIB% -cp "%MYCP%" %DEBUG_OPTS% %JAVA_OPTS% -Xmx128m com.novell.zenworks.configure.ConfigureLoader %CONFIG_OPTS%
The heap space value is represented in megabytes (MB) within -Xmx128m. By default, it is 128.
For example, if the RAM of the device is 512 MB, then the line in the novell-zenworks-configure.bat file can be updated as follows:
"%JAVA_HOME%\bin\java" -Djava.library.path=%ZENLIB% -cp "%MYCP%" %DEBUG_OPTS% %JAVA_OPTS% -Xmx512m com.novell.zenworks.configure.ConfigureLoader %CONFIG_OPTS%
IMPORTANT:The heap space value must be either equivalent to or less than the RAM of the device.
At the console prompt, run the ZENworks_installation_path\bin\novell-zenworks-configure.bat file on Windows or /opt/novell/zenworks/bin/novell-zenworks-configure on Linux.
Follow the prompts.
When you are prompted to enter the location of the file required for resuming the migration, enter the the complete path of DBMigration.xml. The file is located in the ZENworks_installtion_path\bin directory on Windows, and in the /opt/novell/zenworks/bin directory on Linux.
The XML file contains a list of tables and a flag indicating whether the table was successfully migrated or not. When the database migration resumes, only the tables with flag value set to False are migrated.
If the Oracle database crashes during the database migration:
At the console prompt, run the ZENworks_installation_path\bin\novell-zenworks-configure.bat file on Windows or /opt/novell/zenworks/bin/novell-zenworks-configure on Linux.
Follow the prompts.
When you are prompted to enter the location of the file required for resuming the migration, enter the the complete path of DBMigration.xml. The file is located in the ZENworks_installtion_path\bin directory on Windows, and in the /opt/novell/zenworks/bin directory on Linux.
The XML file contains a list of tables and a flag indicating whether the table was successfully migrated or not. When the database migration resumes, only the tables with flag value set to False are migrated.
IMPORTANT:Do not edit the contents of DBMigration.xml.
If the Oracle USERS tablespace does not have sufficient space to create and store the ZENworks database schema, the database migration fails with the following error messages while trying to create the tables:
SEVERE: Terminating the database migration... SEVERE: An error has occurred while migrating the database.
To resolve this issue, the Oracle database administrator must increase the size of the USERS tablespace. Ensure that the tablespace has a minimum of 100 MB to create ZENworks database schema without any data in it and an appropriate additional space depending upon the size of the database to be migrated.
If the NLS_CHARACTERSET parameter is not set to AL32UTF8 and the NLS_NCHAR_CHARACTERSET parameter is not set to AL16UTF16, the database migration fails with the following error messages:
Failed to run the sql script: localization-updater.sql,
message:Failed to execute the SQL command: insert into
zLocalizedMessage(messageid,lang,messagestr)
values('POLICYHANDLERS.EPE.INVALID_VALUE_FORMAT','fr','La stratégie {0} n''a
pas pu être appliquée du fait que la valeur de la variable "{1}" n''est pas
dans un format valide.'),
message:ORA-00600: internal error code, arguments: [ktfbbsearch-7], [8], [],
[], [], [], [], []
To resolve this issue, set the NLS_CHARACTERSET parameter to AL32UTF8 and the NLS_NCHAR_CHARACTERSET parameter to AL16UTF16. To ensure that the character set parameters are configured with the recommended values, run the following query at the database prompt:
select parameter, value from nls_database_parameters where parameter like '%CHARACTERSET%';
If you choose to migrate the database by using an existing user schema, the database migration utility creates the ZENworks database but it might fail to migrate the data.
To resolve this issue:
Make sure that the ZENworks tables, views, and user sequence are deleted from the newly created ZENworks database by the database administrator. Later on, clear the user_recyclebin database table.
Start the database migration again by using the same user schema.
To start the migration from an internal Sybase to the Oracle database, see Migrating the Data from the Internal Sybase Database to an Oracle Database. To start the migration from an external Sybase to the Oracle database, see Migrating the Data from the External Sybase Database to an Oracle Database.