Embedded Database Maintenance
311
n
ov
do
cx (e
n)
16
Ap
ril 20
10
Troubleshooting the Database Migration Failure Issue
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%';
Troubleshooting the Database Migration by Using An Existing User Schema
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:
1
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.
2
Start the database migration again by using the same user schema. For more information, see
“Migrating the Data from the Sybase SQL Anywhere Database to an Oracle Database” on
page 307
.
34.6.5 Reverting to the Sybase Database
If you want to return to using the Sybase database:
1
On the device where you run the migration utility, rename the following files:
zdm.xml.bak
to
zdm.xml
dmaccounts.properties.bak
to
dmaccounts.properties
dmmappings.properties.bak
to
dmmappings.properties
The files are located in the
ZENworks_installation_path
\conf\datamodel
directory on
Windows and in the
/etc/opt/novell/zenworks/datamodel
directory on Linux.
2
Restart all the ZENworks Services:
On Windows:
Do the following:
1. From the Windows desktop
Start
menu, click
Settings
>
Control Panel
.
