OnDemand User Group
Support Forums => MP Server => Topic started by: Frederick Tybalt on September 23, 2013, 06:28:57 AM
-
Hello,
I am getting a strange error when loading a file MP (AIX) CMOD 8.5.0.6, DB2 9.07.0004
APK440I ACIF AT IM43P11 HAS COMPLETED NORMALLY WITH RETURN CODE 0.
arsload: 09/09/13 11:09:58 Indexing completed
arsload: 09/09/13 11:09:58 -- Loading started, 42082 bytes to process
OnDemand Load Id = >763-1-0-658FAA-15658-15948<
An error occurred. Contact your system administrator and/or consult the System Log. File=arsadmp.c, Line=1669
Failed while attempting to load the database
Loaded 0 rows into the database
arsload: 09/09/13 11:10:05 Loading failed
arsload: Processing failed for file >/XX/XX/XX/XX/XXXXXXXXXXXXXXX.ARD<
arsload: 09/09/13 11:10:05 -- Unloading started
OnDemand UnLoad Successful - LoadId(763-1-0-658FAA-15658-15948) Rows Deleted(0)
Verifying the system log, I get the below message in the message no 13
DB Error: [IBM][CLI Driver][DB2/AIX64] SQLSTATE 01517: A character that could not be converted was replaced with a substitute character. -- SQLSTATE=01517, SQLCODE=0, File=arsdoc.c, Line=4216
DB Error: Warning: Unexpected SQL_SUCCESS_WITH_INFO -- SQLSTATE=Not Defined, SQLCODE=1, File=arsdoc.c, Line=4216
The code page used is EBCDIC 500 and there are no strange characters in indexes. Any insights on this error would be helpful
-
Hmmm...do you have IgnoreWarnings=1 in the db2cli.ini?
Ed
-
Hi,
what is the codepage in the database? Might be you have charcters that are not defined in the database codepage
regards Egon
-
DB2 uses 819.
-
Did this ever get resolved?
If so what was the resolution?
Thanks ----
Ed
-
This has happened to me once before -- I ended up converting the database to unicode, and making the AG fields bigger. Thankfully, I noticed this during a major migration, so I was able to do this to the AG configuration while moving the database.
-JD.