10
« on: August 02, 2019, 01:38:46 PM »
Hi Srinivas,
I have a similar issue, I have a .txt file that I am trying to load. There are multiple customer record in that text file which I need to split per customer and load.
I have created an application with ACIF indexer and below index information (took few from your index information).
CC=YES
CCTYPE=A
CONVERT=NO
CPGID=500
MCF2REF=CPCS
TRC=NO
FORMFEED=YES
FILEFORMAT=STREAM,(NEWLINE=X'0A')
GROUPMAXPAGES=9999
TRIGGER1=*,1,X'F1',(TYPE=GROUP) /* '1' */
FIELD1=2,91,8,(TRIGGER=1,BASE=TRIGGER)
FIELD2=23,51,8,(TRIGGER=1,BASE=TRIGGER)
INDEX1=X'506F73746C6E675F44617465',FIELD1,(TYPE=GROUP,BREAK=YES) /* Posting_Date */
INDEX2=X'47726F75705F6F',FIELD2,(TYPE=GROUP,BREAK=NO) /* Group_No */
DCFPAGENAMES=NO
UNIQUEBNGS=YES
IMAGEOUT=ASIS
INDEXOBJ=ALL
INDEXSTARTBY=1
INSERTIMM=NO
RESTYPE=NONE
INPEXIT=/opt/IBM/ondemand/V9.5/exits/acif/asciinp
and I use below command on my server to load the file
/opt/IBM/ondemand/V9.5/bin/arsload -fv -u <username>-p <password> -c /arstmp -h <hostname> -g <AG_name> -a <app> /file_path/file.txt
I get below error
2019-08-02 16:27:40.682942: ARS4302I Indexing started, 13245 bytes to process
: APK415I CC=YES
: APK415I CCTYPE=A
: APK415I CONVERT=NO
: APK415I CPGID=500
: APK415I MCF2REF=CPCS
: APK415I TRC=NO
: APK415I FORMFEED=YES
: APK415I FILEFORMAT=STREAM,(NEWLINE=X'0A')
: APK415I GROUPMAXPAGES=9999
: APK415I TRIGGER1=*,1,X'F1',(TYPE=GROUP)
: APK415I FIELD1=2,91,8,(TRIGGER=1,BASE=TRIGGER)
: APK415I FIELD2=23,51,8,(TRIGGER=1,BASE=TRIGGER)
: APK415I INDEX1=X'506F73746C6E675F44617465',FIELD1,(TYPE=GROUP,BREAK=YES)
: APK415I INDEX2=X'47726F75705F6F',FIELD2,(TYPE=GROUP,BREAK=NO)
: APK415I DCFPAGENAMES=NO
: APK415I UNIQUEBNGS=YES
: APK415I IMAGEOUT=ASIS
: APK415I INDEXOBJ=ALL
: APK415I INDEXSTARTBY=1
: APK415I INSERTIMM=NO
: APK415I RESTYPE=NONE
: APK415I INPEXIT=/opt/IBM/ondemand/V9.5/exits/acif/asciinp
: APK415I INPUTDD=/file_path/file.text
: APK415I OUTPUTDD=/arstmp/file.txt.out
: APK415I INDEXDD=/arstmp/file.txt.ind
: APK415I RESOBJDD=/dev/null
: APK493S A VALUE OF YES FOR THE FORMFEED PARAMETER IS NOT ALLOWED WITH THE CONVERT=YES, CC=YES, OR TRC=YES PARAMETERS.
: APK441I ACIF AT IPTR923 HAS COMPLETED ABNORMALLY WITH RETURN CODE 16.
2019-08-02 16:27:40.707222: ARS4309E Indexing failed
2019-08-02 16:27:40.707350: ARS4318E Processing failed for file >/file_path/file.txt<
2019-08-02 16:27:40.726587: ARS4327E Processing has stopped. The remaining files will NOT be processed.
Please suggest if I am doing something incorrect or missing something.
Thanks ahead!!