29.7 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 the issue of database migration failure:

  • Set the NLS_CHARACTERSET parameter to AL32UTF8 and the NLS_NCHAR_CHARACTERSET parameter to AL16UTF16..

  • 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%';