OnDemand User Group

Support Forums => MP Server => Topic started by: Frederick Tybalt on September 23, 2013, 06:28:57 AM

Title: Strange Error while loading a file
Post 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
 

Title: Re: Strange Error while loading a file
Post by: Ed_Arnold on September 23, 2013, 07:22:55 AM

Hmmm...do you have IgnoreWarnings=1 in the db2cli.ini?

Ed

Title: Re: Strange Error while loading a file
Post by: ewirtz on September 24, 2013, 03:20:07 AM

Hi,

what is the codepage in the database? Might be you have charcters that are not defined in the database codepage

regards Egon

Title: Re: Strange Error while loading a file
Post by: Frederick Tybalt on September 24, 2013, 04:45:51 AM

DB2 uses 819. 

Title: Re: Strange Error while loading a file
Post by: Ed_Arnold on November 03, 2015, 12:31:50 PM

Did this ever get resolved?

If so what was the resolution?

Thanks ----

Ed

Title: Re: Strange Error while loading a file
Post by: Justin Derrick on November 03, 2015, 01:31:18 PM

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.