Last row successful error when loading a file using ARSLOAD

Technote (troubleshooting)


Problem(Abstract)


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;

ARSLOAD Command:
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

and

Windows event:
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.

UNIX Servers
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.

Windows Server
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
(http://support.microsoft.com/kb/256986/EN-US/ )

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.


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Content Manager OnDemand for Multiplatforms

Software version:

8.5.0.1, 8.5.0.2, 8.5.0.3, 8.5.0.4, 8.5.0.5, 8.5.0.6

Operating system(s):

AIX, UNIX, Windows

Reference #:

1616768

Modified date:

2013-02-06

Translate my page

Machine Translation

Content navigation