Author Topic: Report Failed - AN ACIF STORAGE REQUEST WAS UNSUCCESSFUL - REQUEST SIZE 314 GETM  (Read 3938 times)

Srinivas

  • Guest
Hello,

Report got failed since index failed. But i have done correct index and tried multilple times.

Same result we are getting.

: APK415I RESOBJDD=/dev/null
 : APK410S AN ACIF STORAGE REQUEST WAS UNSUCCESSFUL - REQUEST SIZE 314 GETMAIN RETURN CODE 255.
 : APK441I ACIF AT IPTR923 HAS COMPLETED ABNORMALLY WITH RETURN CODE 16.
1: ARS4309E Indexing failed


Env : Linux / CMOD 9.5 / Txt report ( Line Data) / ACIF indexer

Report size : 3.2GB and it's nearly 76Lacs pages.

And also im using exit parameter for page spilting and followed by trigger value. Below is the my index parameters

#######################

CC=YES
CCTYPE=Z
CONVERT=NO
CPGID=850
MCF2REF=CPCS
TRC=NO
FILEFORMAT=STREAM,(NEWLINE=X'0A')
TRIGGER1=*,15,X'5354414E44415244204348415254455245442042414E4B',(TYPE=GROUP)   /* ******* */
FIELD1=1,78,9,(TRIGGER=1,BASE=TRIGGER)
FIELD2=0,39,17,(TRIGGER=1,BASE=TRIGGER)
INDEX1=X'73746174656D656E7464617465',FIELD1,(TYPE=GROUP,BREAK=YES)             /* statementdate           */
INDEX2=X'6272616E63686E616D65',FIELD2,(TYPE=GROUP,BREAK=YES)                   /* branchname              */
DCFPAGENAMES=NO
UNIQUEBNGS=YES
IMAGEOUT=ASIS
INDEXOBJ=GROUP
INDEXSTARTBY=1
INSERTIMM=NO
RESTYPE=NONE
INPEXIT=/apps/ibm/ondemand/V9.5/exits/acif/asciinp

#################

Please assist urgently.... :)

Thanks
Srinivas :-\

jsquizz

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 522
    • View Profile
Are there any other messages in the system log associated with the log ID of the 88 record?
#CMOD #DB2 #AFP2PDF #TSM #AIX #RHEL #AWS #AZURE

Srinivas

  • Guest
Hi,

There is no other logs in system log folder. Every time getting below error msg.

##################
19-01-28 23:55:09.206227: ARS4302I Indexing started, 3358487365 bytes to process
                        : APK415I CC=NO
                        : APK415I CCTYPE=Z
                        : APK415I CONVERT=NO
                        : APK415I CPGID=850
                        : APK415I MCF2REF=CPCS
                        : APK415I TRC=NO
                        : APK415I FILEFORMAT=STREAM,(NEWLINE=X'0A')
                        : APK415I TRIGGER1=*,13,X'20205354414E44415244204348415254455245442042414E4B',(TYPE=GROUP)
                        : APK415I FIELD1=1,94,10,(TRIGGER=1,BASE=0)
                        : APK415I FIELD2=0,55,19,(TRIGGER=1,BASE=0)
                        : APK415I INDEX1=X'73746174656D656E7464617465',FIELD1,(TYPE=GROUP,BREAK=YES)
                        : APK415I INDEX2=X'6272616E63686E616D65',FIELD2,(TYPE=GROUP,BREAK=YES)
                        : APK415I DCFPAGENAMES=NO
                        : APK415I UNIQUEBNGS=YES
                        : APK415I IMAGEOUT=ASIS
                        : APK415I INDEXOBJ=ALL
                        : APK415I INDEXSTARTBY=1
                        : APK415I INSERTIMM=NO
                        : APK415I RESTYPE=NONE
                        : APK415I INPUTDD=/odshared/staging/ebbs/load/bdds/extract/ECARS.BDDS.BDBalanceListApp.BDBalanceListAppGrp.20181207_225541.Balance List_201806
                        : APK415I OUTPUTDD=/dev/null
                        : APK415I INDEXDD=/odshared/staging/ebbs/load/bdds/extract/ECARS.BDDS.BDBalanceListApp.BDBalanceListAppGrp.20181207_225541.Balance List_201806
                        : APK415I RESOBJDD=/dev/null
                        : APK410S AN ACIF STORAGE REQUEST WAS UNSUCCESSFUL - REQUEST SIZE 401 GETMAIN RETURN CODE 255.
                        : APK441I ACIF AT IPTR923 HAS COMPLETED ABNORMALLY WITH RETURN CODE 16.
19-01-28 23:55:38.605605: ARS4309E Indexing failed
19-01-28 23:55:38.605666: ARS4318E Processing failed for file >ECARS.BDDS.BDBalanceListApp.BDBalanceListAppGrp.20181207_225541.Balance List_20180628_4.ARD.Failed<

################

Ed_Arnold

  • Hero Member
  • *****
  • Posts: 1147
    • View Profile
>  3358487365 bytes to process

3,358,487,365 bytes or over 3 gigabytes.

I'd consider trying to break up that input file.

Ed
#zOS #ODF

Srinivas

  • Guest
Hi,

we are successfully loaded 14GB file to same application group and index parameters. Only problem with few files.
 
Yes, i have done split ( using python script & spilted by byte to byte )and tried to load. still reports getting failed.

But index is correct.
############
2019-01-30 15:04:48.328929: ARS4302I Indexing started, 6337 bytes to process
                          : APK415I CC=NO
                          : APK415I CCTYPE=Z
                          : APK415I CONVERT=NO
                          : APK415I CPGID=850
                          : APK415I MCF2REF=CPCS
                          : APK415I TRC=NO
                          : APK415I FILEFORMAT=STREAM,(NEWLINE=X'0A')
                          : APK415I TRIGGER1=*,13,X'20205354414E44415244204348415254455245442042414E4B',(TYPE=GROUP)
                          : APK415I FIELD1=1,94,10,(TRIGGER=1,BASE=0)
                          : APK415I FIELD2=0,55,19,(TRIGGER=1,BASE=0)
                          : APK415I INDEX1=X'73746174656D656E7464617465',FIELD1,(TYPE=GROUP,BREAK=YES)
                          : APK415I INDEX2=X'6272616E63686E616D65',FIELD2,(TYPE=GROUP,BREAK=YES)
                          : APK415I DCFPAGENAMES=NO
                          : APK415I UNIQUEBNGS=YES
                          : APK415I IMAGEOUT=ASIS
                          : APK415I INDEXOBJ=ALL
                          : APK415I INDEXSTARTBY=1
                          : APK415I INSERTIMM=NO
                          : APK415I RESTYPE=NONE
                          : APK415I INPUTDD=/odshared/staging/ebbs/load/bdds/extract/backup/1.txt
                          : APK415I OUTPUTDD=/dev/null
                          : APK415I INDEXDD=/odshared/staging/ebbs/load/bdds/extract/backup/1.txt.ind
                          : APK415I RESOBJDD=/dev/null
                          : APK448S INDEXING WAS REQUESTED, BUT NO GROUP 'TRIGGERn' NOR ANY 'FIELD' BASED ON IT WAS SATISFIED WITHIN THE PAGE RANGE SPECIFIED BY THE INDEXSTARTBY PARAMETER.
                          : APK441I ACIF AT IPTR923 HAS COMPLETED ABNORMALLY WITH RETURN CODE 16.
2019-01-30 15:04:48.351881: ARS4309E Indexing failed
2019-01-30 15:04:48.351919: ARS4318E Processing failed for file >1.txt<
2019-01-30 15:04:49.820115: ARS4327E Processing has stopped.  The remaining files will NOT be processed.
######################

jsquizz

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 522
    • View Profile
That to me sounds like its an indexing error, and it cannot find the trigger.

I understand where you are coming from, with the large file erroring out. Usually when I would load a very large file - lets say for example around 4GB..Using 2 triggers, maybe a floating trigger, indexing every line- that's when it would fail. Usually, in that case it would give no error and simply run out of resources or something like that.
#CMOD #DB2 #AFP2PDF #TSM #AIX #RHEL #AWS #AZURE

fnb4321

  • Jr. Member
  • **
  • Posts: 59
    • View Profile
Did you try changing the INDEXSTARTBY parameter to 99 instead of 1 ?

Srinivas

  • Guest
Hi,

@jsquizz,

Any suggestions?

@fnb4321

Yes tried, same result
######
2019-01-31 19:59:45.322645: ARS4302I Indexing started, 3358487365 bytes to process
                          : APK415I CC=NO
                          : APK415I CCTYPE=Z
                          : APK415I CONVERT=NO
                          : APK415I CPGID=850
                          : APK415I MCF2REF=CPCS
                          : APK415I TRC=NO
                          : APK415I FILEFORMAT=STREAM,(NEWLINE=X'0A')
                          : APK415I TRIGGER1=*,13,X'20205354414E44415244204348415254455245442042414E4B',(TYPE=GROUP)
                          : APK415I FIELD1=1,94,10,(TRIGGER=1,BASE=0)
                          : APK415I FIELD2=0,55,19,(TRIGGER=1,BASE=0)
                          : APK415I INDEX1=X'73746174656D656E7464617465',FIELD1,(TYPE=GROUP,BREAK=YES)
                          : APK415I INDEX2=X'6272616E63686E616D65',FIELD2,(TYPE=GROUP,BREAK=YES)
                          : APK415I DCFPAGENAMES=NO
                          : APK415I UNIQUEBNGS=YES
                          : APK415I IMAGEOUT=ASIS
                          : APK415I INDEXOBJ=ALL
                          : APK415I INDEXSTARTBY=99
                          : APK415I INSERTIMM=NO
                          : APK415I RESTYPE=NONE
                          : APK415I INPUTDD=/odshared/staging/ebbs/load/bdds/extract/ECARS.BDDS.BDBalanceListApp.BDBalanceListAppGrp.20181207_225541.Balance List_20180628_4.ARD.Failed
                          : APK415I OUTPUTDD=/dev/null
                          : APK415I INDEXDD=/odshared/staging/ebbs/load/bdds/extract/ECARS.BDDS.BDBalanceListApp.BDBalanceListAppGrp.20181207_225541.Balance List_20180628_4.ARD.Failed.ind
                          : APK415I RESOBJDD=/dev/null
                          : APK410S AN ACIF STORAGE REQUEST WAS UNSUCCESSFUL - REQUEST SIZE 401 GETMAIN RETURN CODE 255.
                          : APK441I ACIF AT IPTR923 HAS COMPLETED ABNORMALLY WITH RETURN CODE 16.
2019-01-31 20:00:14.998424: ARS4309E Indexing failed



Alessandro Perucchi

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 1001
    • View Profile
I don't know what to say, except is there a "buggy" character in your list that creates a problem in your user exit that you have developed?
Or something like memory leak? That would maybe explain why the storage request for 401 bytes was not possible, because the leak took the whole memory allocated.

Well this is only an idea...
Alessandro Perucchi

#Install #Migrations #Conversion #Educate #Repair #Upgrade #Migrate #Enhance #Optimize #AIX #Linux #Multiplatforms #DB2 #Windows #Oracle #TSM #Tivoli #Performance #Audits #Customizing #Availability #HA #DR #JavaApi #ContentNavigator #ICN #WEBi #ODWEK #Services #PDF #AFP #XML

Srinivas

  • Guest
Hello,

This is my latest update. Here im using " New ACIF parameter: FORMFEED=YES | NO "

Can you please have a look index values. ( is there any cause of report loading failed after index success)..

2019-02-06 17:50:49.389552: ARS4302I Indexing started, 3358487365 bytes to process
                          : APK415I CC=NO
                          : APK415I CCTYPE=Z
                          : APK415I CONVERT=NO
                          : APK415I CPGID=850
                          : APK415I MCF2REF=CF
                          : APK415I TRC=NO
                          : APK415I FILEFORMAT=STREAM,(NEWLINE=X'0A')
                          : APK415I TRIGGER1=*,14,X'205354414E44415244204348415254455245442042414E4B2E',(TYPE=GROUP)
                          : APK415I FIELD1=1,94,8,(TRIGGER=1,BASE=0)
                          : APK415I FIELD2=0,54,20,(TRIGGER=1,BASE=0)
                          : APK415I INDEX1=X'73746174656D656E7464617465',FIELD1,(TYPE=GROUP,BREAK=YES)
                          : APK415I INDEX2=X'6272616E63686E616D65',FIELD2,(TYPE=GROUP,BREAK=YES)
                          : APK415I DCFPAGENAMES=NO
                          : APK415I UNIQUEBNGS=YES
                          : APK415I IMAGEOUT=ASIS
                          : APK415I INDEXOBJ=ALL
                          : APK415I INDEXSTARTBY=0
                          : APK415I INSERTIMM=NO
                          : APK415I RESTYPE=NONE
                          : APK415I FORMFEED=YES
                          : APK415I INPUTDD=/odshared/staging/ebbs/load/bdds/extract/ECARS.BDDS.BDBalanceListApp.BDBalanceListAppGrp.20181207_225541.Balance List_20180628_4.ARD.Failed
                          : APK415I OUTPUTDD=/dev/null
                          : APK415I INDEXDD=/odshared/staging/ebbs/load/bdds/extract/ECARS.BDDS.BDBalanceListApp.BDBalanceListAppGrp.20181207_225541.Balance List_20180628_4.ARD.Failed.ind
                          : APK415I RESOBJDD=/dev/null
                          : APK440I ACIF AT IPTR923 HAS COMPLETED NORMALLY WITH RETURN CODE 0.
2019-02-06 17:54:18.556847: ARS4308I Indexing completed
2019-02-06 17:54:18.556984: ARS4312I Loading started, 3358487365 bytes to process
2019-02-06 17:54:18.666910: ARS1146I Loaded 0 rows into the database
2019-02-06 17:54:18.666966: ARS4311E Loading failed
2019-02-06 17:54:18.672553: ARS4318E Processing failed for file >ECARS.BDDS.BDBalanceListApp


#######################

Thanks !

Srinivas

Ed_Arnold

  • Hero Member
  • *****
  • Posts: 1147
    • View Profile
On z/OS we can run ACIF "standalone" separate from a load.

//* RUN APK, CREATING OUTPUT AND A RESOURCE LIBRARY           *

Can you do that to separate the indexing from the loading?

Ed
#zOS #ODF

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2145
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Yeah, I took a look at the indexing parameters, and I don't see anything obvious.  I was checking out the RESOBJDD parameter, because I know you can't read from /dev/null. 

It sounds like the problem is inside the index file.  You'd need to share that with us to take a look inside it, but it will likely contain confidential data.

-JD.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

Srinivas

  • Guest
Hello,

IBM PMR team, provided below link.

https://www.ibm.com/support/knowledgecenter/en/SSQHWE_9.5.0/com.ibm.ondemand.messages.doc/dodk0410.htm

I don't understand what they are suggesting !.

Thanks!
SR

Srinivas

  • Guest
Hello Folks,

latest update on issue.

Finally loaded reports after splitted into pages ( using python script & splitted by byte to byte ).

And index parametrs updated like below.

#########
CC=YES
CCTYPE=Z
CONVERT=NO
CPGID=850
MCF2REF=CPCS
TRC=NO
FILEFORMAT=STREAM,(NEWLINE=X'0A')
TRIGGER1=*,13,X'2020205354414E44415244204348415254455245442042414E4B',(TYPE=GROUP)   /*   ******** */
FIELD1=0,85,9,(TRIGGER=1,BASE=TRIGGER)
FIELD2=0,39,27,(TRIGGER=1,BASE=TRIGGER)
INDEX1=X'73746174656D656E7464617465',FIELD1,(TYPE=GROUP,BREAK=YES)                   /* statementdate              */
INDEX2=X'6272616E63686E616D65',FIELD2,(TYPE=GROUP,BREAK=YES)                         /* branchname                 */
DCFPAGENAMES=NO
UNIQUEBNGS=YES
IMAGEOUT=ASIS
INDEXOBJ=ALL
INDEXSTARTBY=1
INSERTIMM=NO
RESTYPE=NONE
INPEXIT=/apps/ibm/ondemand/V9.5/exits/acif/asciinp

#################



Thanks!
SR

ODSA

  • Jr. Member
  • **
  • Posts: 13
    • View Profile
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!!