Hi All,
I am attempting to load a very large (1.2GB) line data file into OnDemand. I am getting the following error message in my 88 record:
arsload: 12/10/13 13:23:10 Indexing completed
arsload: 12/10/13 13:23:10 -- Loading started, 1174555350 bytes to process
OnDemand Load Id = >16227-7-0-221FAA-16044-16044<
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
The last row successfully loaded was 30000
Loaded 30000 rows into the database
arsload: 12/10/13 13:26:08 Loading failed
arsload: Processing failed for file >/od/REPORT.1386149548219.REPORT.REPORT_0.0.0.ARD<
arsload: 12/10/13 13:26:08 -- Unloading started
OnDemand UnLoad Successful - LoadId(16227-7-0-221FAA-16044-16044) Rows Deleted(30000)
I am also seeing this in the system log associated with the event id:
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
Nothing in the error reports, nothing in the console. File loads for about 8 hours and then fails. We loaded this same file
appx one month ago and it loaded 140k rows into the database and was around the same size. Ulimits are all set to unlimited.