Author Topic: ARSLOAD Failing without any error message  (Read 5038 times)

Gobi21

  • Guest
ARSLOAD Failing without any error message
« on: June 20, 2013, 07:50:41 AM »
Hi,

I am passing the below arsload command in my script

/opt/ondemand/bin/arsload -f -n -v -u < > -p <> -g <> -a <> /sbcimp/dyn/data/RAR/OD_App1/arsload_GI/ATFBTXS1_GI/GZZAF0001.AZZAF0001.201306171606374490

Below is the error message i can see:
Loaded 0 rows into the database
arsload: 06/18/13 12:46:07 Loading failed
arsload: Processing failed for file >/sbcimp/dyn/data/RAR/OD_App1/arsload_GI/ATFBTXS1_GI/GZZAF0001.AZZAF0001.201306171606374490<
arsload: Processing has stopped.  The remaining files will NOT be processed.
 ***** Result of Load Command execution: >1024< ***
LOAD FAILURE: The IND file >/sbcimp/dyn/data/RAR/OD_App1/arsload_GI/ATFBTXS1_GI/GZZAF0001.AZZAF0001.201306171606374490.IND< failed during load

I am not seeing any specific error message stating the reason for this failure. How i can get more logs with respect to this arsload command. I am clueless here.. I have checked the system log and it showed the same error message as above.

I have modifed a field with different length and arsload did throw the error message for the wrong format.

Your help is very much appreciated. Thanks.

jeffs42885

  • Guest
Re: ARSLOAD Failing without any error message
« Reply #1 on: June 20, 2013, 12:17:11 PM »
What is the type of file that you are trying to load??

Gobi21

  • Guest
Re: ARSLOAD Failing without any error message
« Reply #2 on: June 21, 2013, 12:14:53 AM »
we receive XML file from application team and convert them to IND File for providing Input for ARSLOAD.

rick

  • Guest
Re: ARSLOAD Failing without any error message
« Reply #3 on: June 21, 2013, 01:30:59 AM »
Could you check if .ind file is properly generated?

Gobi21

  • Guest
Re: ARSLOAD Failing without any error message
« Reply #4 on: June 21, 2013, 05:04:17 AM »
Hi,

Yes. I am able to see two records in IND File.

XCOMINDX Ended successfully, 2 documents processed in 1 set
-rw-r--r--   1 odappmgr a19133      2553 Jun 18 12:31 /sbcimp/dyn/data/RAR/OD_App1/arsload_GI/ATFBTXS1_GI/GZZAF0001.AZZAF0001.201306171606374490.IND

Any idea on why we arsload is not throwing any specific error messages?

rick

  • Guest
Re: ARSLOAD Failing without any error message
« Reply #5 on: June 25, 2013, 12:15:49 AM »
File names are case sensitive in unix, if file name is GZZAF0001.AZZAF0001.20130617160637449, Index file name should be  GZZAF0001.AZZAF0001.20130617160637449.ind and the output file name given in field GROUP_FILENAME in index file.

Gobi21

  • Guest
Re: ARSLOAD Failing without any error message
« Reply #6 on: June 26, 2013, 02:31:48 AM »
Hi Rick.

Thanks for your inputs. I have setup the same application and Group in a different instance(CMOD 8.4) and i was able to load the file into CMOD sucessfully.

Earlier i was using CMOD 7.1. I am not sure its an issue with Old CMOD version.