0425-462 A TRIGGER WAS SPECIFIED, BUT INPUT FILE ALREADY INDEXE

[zancanaro]

Hi
I obtain a 0425-462 msg after the following unload - reload on two differents APP on the same server AIX & instance
The genuine APP "TATA" is first copied by OD administrator as "TOTO" new APP.
The OnDemand level is 7.1.2.3 (ooooops late I know, the last support provided for 2010, september,30th)
AIX is at a 5.3.3 level
DB2_UDB for OD at 8.01

1  I used  /usr/lpp/ars/bin/arsdoc get -F toto.parmf -h ARCHIVE  -uadmin -pxxx -v
    where toto.parmf contains one line only : [-a] [-c] [-N][-d /home] [-f "TATA"] [-G TATA] [-i "WHERE NOCR='802' and NOCNT='00257948740' and CLICA='00956308'"] [-o TATAOK].   I obtained TATAOK.10.TATA.TATA.out

2 I used to load back in the new TOTO :/usr/lpp/ars/bin/arsload -u admin -ptoto -I ARCHIVE  -g TOTO -f  -n  TATAOK.10.TATA.TATA.out.

And then the fatal 0425-462 err msg.
----------------------------
arsload: Processing file >TATAOK.10.TATA.TATA.out<
arsload: 08/31/10 10:59:17 -- Indexing started, 24784 bytes to process
0425-415 cc=yes
0425-415 CONVERT=YES
0425-415 cctype=a
0425-415 cpgid=1147
0425-415 trigger1=*,*,X'D6D5C4C5D4C1D5C4'
0425-415 field1=0,8,8,(trigger=1,base=trigger)
0425-415 field2=0,16,8,(trigger=1,base=trigger)
0425-415 index1=X'e3e8c6d4d3',field1
0425-415 index2=X'e2e3c6d4d3',field2
0425-415 formdef=F1DEDE01
0425-415 restype=fdef,ovly,pseg
0425-415 imageout=asis
0425-415 inputdd=/home/TATAOK.10.TATA.TATA.out
0425-415 outputdd=./TATAOK.10.TATA.TATA.out.out
0425-415 indexdd=./TATAOK.10.TATA.TATA.out.ind
0425-415 resobjdd=./TATAOK.10.TATA.TATA.out.res
0425-462 A TRIGGER PARAMETER WAS SPECIFIED, BUT THE INPUT FILE IS ALREADY INDEXED.
0425-441 ACIF AT PQ95325 HAS COMPLETED ABNORMALLY WITH RETURN CODE 16.
arsload: 08/31/10 10:59:17 Indexing failed
arsload: Processing failed for file >TATAOK.10.TATA.TATA.out<
arsload: Processing has stopped.  The remaining files will NOT be processed.
/home
-------------------------------------
The two APP & APP GR are for AFP / ACIF , not generic index.
An idea ?
Greatfull thanks.

[Justin Derrick]

From the Messages and Codes Manual:

APK462S
A TRIGGER PARAMETER WAS SPECIFIED, BUT THE INPUT FILE IS ALREADY INDEXED.
Explanation:
The parameter file included a TRIGGERn parameter, but the input file contains indexing structured fields. ACIF cannot index a file that is already indexed.

User Response:
If you want to create an index object file for the input file, remove all TRIGGERn parameters from the ACIF parameter file and resubmit the job.


It sounds like you loaded this document with ACIF, and it created index fields that made it through to the output file.

But the bigger question is...  Why aren't you letting arsdoc create the Generic Index file for you, and loading that?

-JD.

[zancanaro]

Hi justin ! Thanks a lot for your advice !
Why I don't use generic unload & load ? 'cause when used I obtain a Forms problem like that :

Here are my in & out files :
HDG_UAF.24.TFACL.TFACL.ind                          >> index generic
HDG_UAF.24.TFACL.TFACL.out                          >>  data
HDG_UAF.24.TFACL.TFACL.res                           >>  resources
HDG_UAF_RELOAD_RTTFAAIA_IndexGenerik.sh      >> shell below
HDG_UAF_RELOAD_RTTFAAIA_IndexGenerik.sh.log  >> resulted log of this shelled arsload

HDG_UAF.24.TFACL.TFACL.ind ----------------------------------------
COMMENT: OnDemand Generic Index File Format
COMMENT: This file has been generated by the arsdoc command
COMMENT: September 10, 2010  14:41:34
COMMENT:
CODEPAGE:923
COMMENT:
IGNORE_PREPROCESSING:1
COMMENT:
GROUP_FIELD_NAME:tyfml
GROUP_FIELD_VALUE:N047    
GROUP_FIELD_NAME:stfml
GROUP_FIELD_VALUE:xxxxxx  
GROUP_FIELD_NAME:daedt
GROUP_FIELD_VALUE:20100204
GROUP_FIELD_NAME:nocr
GROUP_FIELD_VALUE:712
GROUP_FIELD_NAME:nocnt
GROUP_FIELD_VALUE:66825860  
GROUP_FIELD_NAME:clica
GROUP_FIELD_VALUE:404174741    
GROUP_FIELD_NAME:cdciv
GROUP_FIELD_VALUE:M  
GROUP_FIELD_NAME:prenom
GROUP_FIELD_VALUE:XXXXXXX                        
GROUP_FIELD_NAME:nom
GROUP_FIELD_VALUE:XXXX                           
GROUP_FIELD_NAME:cdpdt
GROUP_FIELD_VALUE:HGUOC2
GROUP_FIELD_NAME:ssuniope
GROUP_FIELD_VALUE:7010-01-06-14.48.47.400000
GROUP_FIELD_NAME:nrdmd
GROUP_FIELD_VALUE:004452
GROUP_FIELD_NAME:fvalidation
GROUP_FIELD_VALUE:S
GROUP_OFFSET:0
GROUP_LENGTH:20606
-------------------------------------------------------------------

HDG_UAF_RELOAD_RTTFAAIA_IndexGenerik.sh ---------------------------
 /usr/lpp/ars/bin/arsload -I archtest -uuser -ppwd  -g RTTFAAIA -n HDG_UAF.24.TFACL.TFACL.ind  >> $0.log
-------------------------------------------------------------------

HDG_UAF_RELOAD_RTTFAAIA_IndexGenerik.sh.log-----------------------
arsload: Processing file >HDG_UAF.2.TFAAIA-a.TFAAIA-a.ind<
arsload: 09/10/10 15:45:46 -- Indexing started, 1012 bytes to process
0425-415 cc=yes
0425-415 CONVERT=YES
0425-415 cctype=a
0425-415 cpgid=1147
0425-415 trigger1=*,*,X'D6D5C4C5D4C1D5C4'
0425-415 field1=0,8,8,(trigger=1,base=trigger)
0425-415 field2=0,16,8,(trigger=1,base=trigger)
0425-415 field3=0,24,8,(trigger=1,base=trigger)
0425-415 field4=0,32,3,(trigger=1,base=trigger)
0425-415 field5=0,35,11,(trigger=1,base=trigger)
0425-415 field6=0,46,14,(trigger=1,base=trigger)
0425-415 field7=0,60,4,(trigger=1,base=trigger)
0425-415 field8=0,64,32,(trigger=1,base=trigger)
0425-415 field9=0,96,32,(trigger=1,base=trigger)
0425-415 field10=0,128,6,(trigger=1,base=trigger)
0425-415 field11=0,134,26,(trigger=1,base=trigger)
0425-415 field12=0,160,6,(trigger=1,base=trigger)
0425-415 index1=X'e3e8c6d4d3',field1
0425-415 index2=X'e2e3c6d4d3',field2
0425-415 index3=X'c4c1c5c4e3',field3
0425-415 index4=X'd5d6c3d9',field4
0425-415 index5=X'd5d6c3d5e3',field5
0425-415 index6=X'c3d3c9c3c1',field6
0425-415 index7=X'c3c4c3c9e5',field7
0425-415 index8=X'd7d9c5d5d6d4',field8
0425-415 index9=X'd5d6d4',field9
0425-415 index10=X'c3c4d7c4e3',field10
0425-415 index11=X'e2e2e4d5c9d6d7c5',field11
0425-415 index12=X'd5d9c4d4c4',field12
0425-415 formdef=F1PDKUAF
0425-415 restype=fdef,ovly,pseg
0425-415 imageout=asis
0425-415 inputdd=/home/pprsy26/HDG_UAF.2.TFAAIA-a.TFAAIA-a.ind
0425-415 outputdd=./HDG_UAF.2.TFAAIA-a.TFAAIA-a.ind.out
0425-415 indexdd=./HDG_UAF.2.TFAAIA-a.TFAAIA-a.ind.ind
0425-415 resobjdd=./HDG_UAF.2.TFAAIA-a.TFAAIA-a.ind.res
0425-420 AN ERROR OCCURRED WHILE ATTEMPTING TO OPEN F1PDKUAF RETURN CODE 28.
0425-412 MODULE APKSRIAX HAS RETURNED WITH RETURN CODE 255.
0425-532 A FORM DEFINITION WITH A MEMBER NAME (F1PDKUAF) WAS NOT FOUND OR WAS INVALID - RETURN CODE 28.
0425-441 ACIF AT PQ88992 HAS COMPLETED ABNORMALLY WITH RETURN CODE 16.
arsload: 09/10/10 15:45:46 Indexing failed
arsload: Processing failed for file >HDG_UAF.2.TFAAIA-a.TFAAIA-a.ind<
arsload: Unloading of data was NOT performed
arsload: Processing has stopped.  The remaining files will NOT be processed.
arsload: Processing file >HDG_UAF.2.TFAAIA.TFAAIA.ind<
arsload: 09/10/10 15:45:46 -- Indexing started, 1008 bytes to process
0425-415 cc=yes
0425-415 CONVERT=YES
0425-415 cctype=a
0425-415 cpgid=1147
0425-415 trigger1=*,*,X'D6D5C4C5D4C1D5C4'
0425-415 field1=0,8,8,(trigger=1,base=trigger)
0425-415 field2=0,16,8,(trigger=1,base=trigger)
0425-415 field3=0,24,8,(trigger=1,base=trigger)
0425-415 field4=0,32,3,(trigger=1,base=trigger)
0425-415 field5=0,35,11,(trigger=1,base=trigger)
0425-415 field6=0,46,14,(trigger=1,base=trigger)
0425-415 field7=0,60,4,(trigger=1,base=trigger)
0425-415 field8=0,64,32,(trigger=1,base=trigger)
0425-415 field9=0,96,32,(trigger=1,base=trigger)
0425-415 field10=0,128,6,(trigger=1,base=trigger)
0425-415 field11=0,134,26,(trigger=1,base=trigger)
0425-415 field12=0,160,6,(trigger=1,base=trigger)
0425-415 index1=X'e3e8c6d4d3',field1
0425-415 index2=X'e2e3c6d4d3',field2
0425-415 index3=X'c4c1c5c4e3',field3
0425-415 index4=X'd5d6c3d9',field4
0425-415 index5=X'd5d6c3d5e3',field5
0425-415 index6=X'c3d3c9c3c1',field6
0425-415 index7=X'c3c4c3c9e5',field7
0425-415 index8=X'd7d9c5d5d6d4',field8
0425-415 index9=X'd5d6d4',field9
0425-415 index10=X'c3c4d7c4e3',field10
0425-415 index11=X'e2e2e4d5c9d6d7c5',field11
0425-415 index12=X'd5d9c4d4c4',field12
0425-415 formdef=F1PDKUAF
0425-415 restype=fdef,ovly,pseg
0425-415 imageout=asis
0425-415 inputdd=/home/pprsy26/HDG_UAF.2.TFAAIA.TFAAIA.ind
0425-415 outputdd=./HDG_UAF.2.TFAAIA.TFAAIA.ind.out
0425-415 indexdd=./HDG_UAF.2.TFAAIA.TFAAIA.ind.ind
0425-415 resobjdd=./HDG_UAF.2.TFAAIA.TFAAIA.ind.res
0425-420 AN ERROR OCCURRED WHILE ATTEMPTING TO OPEN F1PDKUAF RETURN CODE 28.
0425-412 MODULE APKSRIAX HAS RETURNED WITH RETURN CODE 255.
0425-532 A FORM DEFINITION WITH A MEMBER NAME (F1PDKUAF) WAS NOT FOUND OR WAS INVALID - RETURN CODE 28.
0425-441 ACIF AT PQ88992 HAS COMPLETED ABNORMALLY WITH RETURN CODE 16.
arsload: 09/10/10 15:45:46 Indexing failed
arsload: Processing failed for file >HDG_UAF.2.TFAAIA.TFAAIA.ind<
arsload: Unloading of data was NOT performed
arsload: Processing has stopped.  The remaining files will NOT be processed.
arsload: Processing file >HDG_UAF.24.TFACL.TFACL.ind<
arsload: 09/10/10 15:45:47 -- Indexing started, 1813 bytes to process
0425-415 cc=yes
0425-415 CONVERT=YES
0425-415 cctype=a
0425-415 cpgid=1147
0425-415 trigger1=*,*,X'D6D5C4C5D4C1D5C4'
0425-415 field1=0,8,8,(trigger=1,base=trigger)
0425-415 field2=0,16,8,(trigger=1,base=trigger)
0425-415 field3=0,24,8,(trigger=1,base=trigger)
0425-415 field4=0,32,3,(trigger=1,base=trigger)
0425-415 field5=0,35,11,(trigger=1,base=trigger)
0425-415 field6=0,46,14,(trigger=1,base=trigger)
0425-415 field7=0,60,4,(trigger=1,base=trigger)
0425-415 field8=0,64,32,(trigger=1,base=trigger)
0425-415 field9=0,96,32,(trigger=1,base=trigger)
0425-415 field10=0,128,6,(trigger=1,base=trigger)
0425-415 field11=0,134,26,(trigger=1,base=trigger)
0425-415 field12=0,160,6,(trigger=1,base=trigger)
0425-415 index1=X'e3e8c6d4d3',field1
0425-415 index2=X'e2e3c6d4d3',field2
0425-415 index3=X'c4c1c5c4e3',field3
0425-415 index4=X'd5d6c3d9',field4
0425-415 index5=X'd5d6c3d5e3',field5
0425-415 index6=X'c3d3c9c3c1',field6
0425-415 index7=X'c3c4c3c9e5',field7
0425-415 index8=X'd7d9c5d5d6d4',field8
0425-415 index9=X'd5d6d4',field9
0425-415 index10=X'c3c4d7c4e3',field10
0425-415 index11=X'e2e2e4d5c9d6d7c5',field11
0425-415 index12=X'd5d9c4d4c4',field12
0425-415 formdef=F1PDKUAF
0425-415 restype=fdef,ovly,pseg
0425-415 imageout=asis
0425-415 inputdd=/home/pprsy26/HDG_UAF.24.TFACL.TFACL.ind
0425-415 outputdd=./HDG_UAF.24.TFACL.TFACL.ind.out
0425-415 indexdd=./HDG_UAF.24.TFACL.TFACL.ind.ind
0425-415 resobjdd=./HDG_UAF.24.TFACL.TFACL.ind.res
0425-420 AN ERROR OCCURRED WHILE ATTEMPTING TO OPEN F1PDKUAF RETURN CODE 28.
0425-412 MODULE APKSRIAX HAS RETURNED WITH RETURN CODE 255.
0425-532 A FORM DEFINITION WITH A MEMBER NAME (F1PDKUAF) WAS NOT FOUND OR WAS INVALID - RETURN CODE 28.
0425-441 ACIF AT PQ88992 HAS COMPLETED ABNORMALLY WITH RETURN CODE 16.
arsload: 09/10/10 15:45:47 Indexing failed
arsload: Processing failed for file >HDG_UAF.24.TFACL.TFACL.ind<
arsload: Unloading of data was NOT performed
arsload: Processing has stopped.  The remaining files will NOT be processed.
-------------------------------------------------------------------

The problem comes when I use generic facility to unload & load, I obtain within "0425-420" error for Formdef F1PDKUAF.
This formdef is OK in my genuine/source (i.e. Production) instance and ALSO (at the same "level" ) in the test instance where reload is executing.  That's single reason for not use "generic" load & unload.

Edited by Moderator to obfuscate potentially sensitive customer data.
 

[Justin Derrick]

It sounds like Application where this data is coming from wasn't defined to store the resources with something like:
   restype=fdef

In the NEW Application definition, you should probably specify the directory where the resource can be found:
   USERLIB=</path/to/afp/resources>

(Where /path/to/afp/resources is the DIRECTORY where those resources can be found.)

That might fix your loading problem.

-JD.

[Alessandro Perucchi]

Hello,

I was following this thread, and saw that when you use Generic index when reloading document, you need/must use the "-X G" option in order to force the generic index with arsload, even if you have ACIF Indexer.

In your case:

/usr/lpp/ars/bin/arsload -I archtest -uuser -ppwd  -X G -g RTTFAAIA -n HDG_UAF.24.TFACL.TFACL.ind  >> $0.log

The second error in this ARSLOAD command is that you must NOT add the ".ind" suffix when you use Generic Index... otherwise it doesn't work.

So you need to test like that:

/usr/lpp/ars/bin/arsload -I archtest -uuser -ppwd  -X G -g RTTFAAIA -n HDG_UAF.24.TFACL.TFACL.ind  >> $0.log

And finally, I personnaly will always add the following options ->  -v  (verbose)   -f  (force unload in case of error during load)
So the final command I'd recommand for your case would be:

/usr/lpp/ars/bin/arsload -I archtest -uuser -ppwd  -X G -g RTTFAAIA -nvf HDG_UAF.24.TFACL.TFACL  >> $0.log

Cheers,
Alessandro

[zancanaro]

Hi Allessandro,
Thanks a lot for your answer.
It's exactly the problem ; Arsload can never index two times.
Merci encore.