Author Topic: Strange Error while loading a file  (Read 4782 times)

Frederick Tybalt

  • Full Member
  • ***
  • Posts: 124
    • View Profile
    • Personal Website
Strange Error while loading a file
« 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
 
rIcK
======------------------======
www.rick.co.in | www.tekbytz.com

Ed_Arnold

  • Hero Member
  • *****
  • Posts: 1199
    • View Profile
Re: Strange Error while loading a file
« Reply #1 on: September 23, 2013, 07:22:55 AM »
Hmmm...do you have IgnoreWarnings=1 in the db2cli.ini?

Ed
#zOS #ODF

ewirtz

  • Full Member
  • ***
  • Posts: 134
    • View Profile
Re: Strange Error while loading a file
« Reply #2 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

Frederick Tybalt

  • Full Member
  • ***
  • Posts: 124
    • View Profile
    • Personal Website
Re: Strange Error while loading a file
« Reply #3 on: September 24, 2013, 04:45:51 AM »
DB2 uses 819. 
rIcK
======------------------======
www.rick.co.in | www.tekbytz.com

Ed_Arnold

  • Hero Member
  • *****
  • Posts: 1199
    • View Profile
Re: Strange Error while loading a file
« Reply #4 on: November 03, 2015, 12:31:50 PM »
Did this ever get resolved?

If so what was the resolution?

Thanks ----

Ed
#zOS #ODF

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2228
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: Strange Error while loading a file
« Reply #5 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.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR