OnDemand User Group

Support Forums => Other => Topic started by: Gobi21 on September 14, 2014, 09:04:21 PM

Title: Unable to load the big files.File=arsadmp.c
Post by: Gobi21 on September 14, 2014, 09:04:21 PM

Hi All,

My Ondemand load processing is failing to load. here is the error message. It is looking like the issue is happenning only for big files. we are using version 8.4.1.

Strange that it is not able to write anything in system log too.

arsload: 09/12/14 15:30:10 -- Loading started, 159359663 bytes to process
OnDemand Load Id = >xxx-xx-xxxx-xx<
An error occurred.  Contact your system administrator and/or consult the System Log.  File=arsadmp.c, Line=1574
Failed while attempting to load the database
Loaded 0 rows into the database
arsload: 09/12/14 15:30:10 Loading failed
arsload: Processing failed for file >xxx.20140912_1530<
arsload: 09/12/14 15:30:10 -- Unloading started
OnDemand UnLoad Successful - LoadId(xxx-xx-xxxx-xx) Rows Deleted(0)

09/12/14 15:30:11 -- Unloading of data was successful
An error occurred.  Contact your system administrator and/or consult the System Log.  File=arsadmin.c, Line=2293

arsload: Unable to log load information
arsload: Processing has stopped.  The remaining files will NOT be processed.

Can someone adjust to clue to resolve this issue.?. On the same day, i could see some small loads with less than 100 records went sucess.

Title: Re: Unable to load the big files.File=arsadmp.c
Post by: rick on September 15, 2014, 12:57:29 AM

could be the index has a non supportable database chars. Did you try with other large samples?

Title: Re: Unable to load the big files.File=arsadmp.c
Post by: Ed_Arnold on September 15, 2014, 07:07:10 AM

What's the operating system for the server?  AIX?  Windows?  z/OS?  Something else?

Ed

Title: Re: Unable to load the big files.File=arsadmp.c
Post by: Gobi21 on September 17, 2014, 09:39:58 PM

Yes.. I tried with large feeds. It is uncommon. some of the files are loading fine and some of the files are throwing this error.

This is Linux x86_64.

Thanks for having a look on this.

Title: Re: Unable to load the big files.File=arsadmp.c
Post by: Justin Derrick on September 18, 2014, 03:51:38 AM

You can check the DB2 Diag log for more information about the failure.  You should find it inside your database instance owner directory (usually archive or odadmin) under sqllib/db2dump.  You'll want to review those logs around the time of the failure to get a better understanding of why the databased choked on the load.

-JD.

Title: Re: Unable to load the big files.File=arsadmp.c
Post by: Gobi21 on September 18, 2014, 04:02:57 AM

Thanks JD.

we are using Oracle. Anywhere i can find out the related logs?.


-Gobi

Title: Re: Unable to load the big files.File=arsadmp.c
Post by: jeffs42885 on September 18, 2014, 05:58:40 AM

Have your Oracle DBA's look at the transaction logs. We came across this incident a few weeks ago when trying to load large files. CMOD should be able to handle a 159MB file, but in our case these files had 200-300k rows and the transaction logs were filling extremely fast, causing all kinds of issues with CMOD and P8. This is why I don't like Oracle and prefer DB2/CMOD.

Title: Re: Unable to load the big files.File=arsadmp.c
Post by: Gobi21 on November 05, 2014, 01:15:10 AM

Thanks everyone for your suggestions.

We had space issue in TableSpace DB which was found from the DB Activity log. Once the space was increased. we are fine now.