OnDemand Users Group

Archive => Other => Topic started by: Gobi21 on June 20, 2013, 02:50:41 PM

Title: ARSLOAD Failing without any error message
Post by: Gobi21 on June 20, 2013, 02:50:41 PM
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.
Title: Re: ARSLOAD Failing without any error message
Post by: jeffs42885 on June 20, 2013, 07:17:11 PM
What is the type of file that you are trying to load??
Title: Re: ARSLOAD Failing without any error message
Post by: Gobi21 on June 21, 2013, 07:14:53 AM
we receive XML file from application team and convert them to IND File for providing Input for ARSLOAD.
Title: Re: ARSLOAD Failing without any error message
Post by: rick on June 21, 2013, 08:30:59 AM
Could you check if .ind file is properly generated?
Title: Re: ARSLOAD Failing without any error message
Post by: Gobi21 on June 21, 2013, 12:04:17 PM
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?
Title: Re: ARSLOAD Failing without any error message
Post by: rick on June 25, 2013, 07: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.
Title: Re: ARSLOAD Failing without any error message
Post by: Gobi21 on June 26, 2013, 09: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.