The user receives errors similar to the errors below, when performing an ARSLOAD in IBM Content Manager onDemand (CMOD) 8.5.x. The line and row number will depend on the file being loaded;
An error occurred. Contact your system administrator and/or consult the
System Log. File=arsadmp.c, Line=1608
Failed while attempting to load the database
The last row successfully loaded was 117461
Loaded 117461 rows into the database
DB Error: [IBM][CLI Driver][DB2/NT64] SQLSTATE 01517: A character that
could not be converted was replaced with a substitute character. --
SQLSTATE=01517, SQLCODE=0, File=arsdoc.c, Line=1608
Resolving the problem
This issue could be related to an incorrect ARS_ORIGINAL_CODEPAGE setting. Check that the value is correct using the method below.
Run arsdb -u without ARS_ORIGINAL_CODEPAGE in the ars.cfg for information on the proper setting for ARS_ORIGINAL_CODEPAGE.
An example of running the arsdb -u -I <OD_INSTANCE> command without RS_ORIGINAL_CODEPAGE in the ars.cfg is:
arsdb: Unable to initialize environment. The return code is -1. If this is a new (created in 8.5) instance, then define ARS_ORIGINAL_CODEPAGE=819 in ars.cfg. Otherwise, if this is an existing instance (created prior to 8.5), then define ARS_ORIGINAL_CODEPAGE=923 in ars.cfg. Once set, ARS_ORIGINAL_CODEPAGE must never change.
Edit the ars.cfg file and add the ARS_ORIGINAL_CODEPAGE parameter set to the appropriate value determined by the arsdb command.
Run arsdb.exe -u -I <OD_INSTANCE> for information on the proper setting for ARS_ORIGINAL_CODEPAGE.
An example of running the arsdb.exe -I <OD_INSTANCE> -u command, where OD_INSTANCE is the OnDemand Instance name, without ARS_ORIGINAL_CODEPAGE set is:
arsdb: Unable to initialize environment. The return code is -1. If this is a new (created in 8.5) instance, then define ARS_ORIGINAL_CODEPAGE with a value of 1208 in the registry.
Otherwise, if this is an existing instance (created prior to 8.5), then define ARS_ORIGINAL_CODEPAGE with a value of 5348 in the registry. The registry setting should be placed in the following section HKEY_LOCAL_MACHINE\SOFTWARE\IBM\OnDemand for Windows\@SRV@_<OD_INSTANCE>)\CFG. Once set, ARS_ORIGINAL_CODEPAGE must never change.
IMPORTANT: Before you modify the registry, back it up and make sure that you understand how to restore the registry if a problem occurs. For information on how to back up, restore, and edit the registry, read the following article in the Microsoft® Knowledge Base: 256986 Description of the Microsoft Windows Registry
Use the regedit.exe command to update the Windows Registry Key specified in the output of the arsdb command and add the ARS_ORIGINAL_CODEPAGE string value set to the appropriate value determined by the arsdb command.