ARSLOAD AFP load error

[ibmarthin]

I have offloaded AFP documents from OnDemand 8.4.1 running on zOS. Using the ARSDOC get
That makes 3 files:
arsdoc_get.12366.NAFSAG.NAFSAPP.ind
arsdoc_get.12366.NAFSAG.NAFSAPP.out
arsdoc_get.12366.NAFSAG.NAFSAPP.res

I have transfered the .out and .res binary, and .ind as ASCII to the Windows server.
But when running ARSLOAD it gives this error:
Invalid structured field header in the file D:\OnDemand_data\input\arsdoc_get.12366.NAFSAG.NAFSAPP.ind
I have tried to transfer .ind binary, but that did not change anything.

D:\OnDemand_data>rem "C:\Program Files\ibm\OnDemand for Windows\bin\ARSLOAD.EXE" -v -h atp-20tapp003 -g NAFSAG -a NAFSAPP "D:\OnDemand_data\input\arsdoc_get.out.2"

D:\OnDemand_data>"C:\Program Files\ibm\OnDemand for Windows\bin\ARSLOAD.EXE" -u nimda -nv -1  D:\OnDemand_data\input\arsload.log -2 8  -h atp-20tapp003 -g NAFSAG -a NAFSAPP "D:\OnDemand_data\input\arsdoc_get.12366.NAFSAG.NAFSAPP"
arsload: Processing file >D:\OnDemand_data\input\arsdoc_get.12366.NAFSAG.NAFSAPP<
arsload: Load Version <8.5.0.0> Operating System <Windows 64> <6.1.7601 Service Pack 1>
arsload: Server Version <8.5.0.0> Operating System <Windows 64> <6.1.7601 Service Pack 1> Database <DB2> <09.07.0006>
arsload: 09/04/12 14:10:52 -- Loading started, 6706 bytes to process
Resource D:\OnDemand_data\input\arsdoc_get.12366.NAFSAG.NAFSAPP.res matches the resource >2-1-0<
Invalid structured field header in the file D:\OnDemand_data\input\arsdoc_get.12366.NAFSAG.NAFSAPP.ind
Loaded 0 rows into the database
arsload: 09/04/12 14:10:53 Loading failed
arsload: Processing failed for file >D:\OnDemand_data\input\arsdoc_get.12366.NAFSAG.NAFSAPP<
arsload: Processing has stopped.  The remaining files will NOT be processed.

[Alessandro Perucchi]

Hello 2ma2,

I would suggest first to have cmod 8.5.0.5, since a lot of codepage correction were made into cmod v8.5.0.X.

Then, in the .ind you have a CODEPAGE:1047, which is some EBCDIC codepages.
Meaning that you should try to load the .ind in its original form, in EBCDIC and not in ASCII.
If you want to have it in ASCII (for example codepage 923 (iso8859-15) or for Windows 1252 (which I don't remember yet the internal codepage value), or 1208 for UTF-8)
Then please change the value of CODEPAGE:1047 with the codepage of the new codepage you used as the target conversion from EBCDIC->ASCII.
Then it should work.

Sincerely yours,
Alessandro

[ibmarthin]

After upgrading to 8.5.0.5 - and correcting the problem with: ARS_ORIGINAL_CODEPAGE I get exatly the same error with the 1047 codepage..

[Alessandro Perucchi]

Hello 2m2,

in which format are the .ind files? They are in ASCII or in EBCDIC?

If the index is in ASCII, then what codepage are you using? ISO8859-15? UTF-8? WIN1252? what else??? Because you will need to change the line:   CODEPAGE: accordingly.
(for Info:   ISO8859-15 = 923, UTF-8=1208, WIN1252=5348, ...) this link is your friend http://www-01.ibm.com/software/globalization/ccsid/ccsid_registered.html

If your index is EBCDIC, then I heard that z/OS has some ressources so maybe the files were not completely transfered... or something similar...

I mean the error you get with arsload has nothing to do with ARS_ORIGINAL_CODEPAGE.
When you are trying to load a document, that's irrelevant.

Sincerely yours,
Alessandro

[Ed_Arnold]

2ma2 - have you tried loading directly from z/OS -> Windows server?  Do you have 8.5 available on z/OS?

Ed

[Nils Engerby]

Joining the party late... 
The error message in the first post indicates that the AG is defined with ACIF indexing so the load program expects an index file in AFP format.
The index file produced by arsdoc get is in the Generic indexer format so you must use the -X G flag in your arsload command.

[ibmarthin]

Hi there

I have been away for a while But thanks to all for the interest in my problem.

@Alessandro. I have tried the various codepages, both after binary and ASCII transfer. But the same error appears.

@Ed_Arnold. No I am only able to offload files on zOS and transfer the "ARSDOC GET" files to Windows. And I have no OD 8.5 available on zOS - yet.

@Nils_Engerby. Yes, you're right, I also found that in the manual. Infortunatelt same message appears:

"C:\Program Files\ibm\OnDemand for Windows\bin\ARSLOAD.EXE" -1 "D:\OnDemand_data\output\arsload_trace.txt" -2 8 -f  -I atp-20tapp003 -g NAFSAG -a NAFSAPP  "D:\OnDemand_data\arsdoc_get.12366.NAFSAG.NAFSAPP" -c "C:\Program Files\ibm\OnDemand for Windows\bin32" -X G

- I have attached ARSLOAD_TRACE.txt file.

Regards
Ib Marthin.

[Nils Engerby]

Your trace shows that the load program still expects an ACIF index file. See if it makes a difference if you put the load file name after all other options:

"C:\Program Files\ibm\OnDemand for Windows\bin\ARSLOAD.EXE" -f  -I atp-20tapp003 -g NAFSAG -a NAFSAPP -X G "D:\OnDemand_data\arsdoc_get.12366.NAFSAG.NAFSAPP"

You could also temporarily change the indexer setting in NAFSAPP to Generic, but remember to backup any ACIF parameters in the app and restore the original indexer settings after you are done loading.

//Nils

[ibmarthin]

Putting the . IND file name last in the command,  was, perhaps, a little step forward.
Now ARSLOAD recognize it but conclude that it has an invalid format.
And a result the ARSTFMT stops.

I have not, yet, changed the index setting in AP..


D:\OnDemand_data>Echo start ARSLOAD ....
start ARSLOAD ....


D:\OnDemand_data>"C:\Program Files\ibm\OnDemand for Windows\bin\ARSLOAD.EXE" -1 "D:\OnDemand_data\output\arsload_trace.txt" -2 8 -f  -I atp-20tapp003 -g NAFSAG -a NAFSAPP  -X G  "D:\OnDemand_data\arsdoc_get.9946.NAFSAG.NAFSAPP"
arsload: Processing file >D:\OnDemand_data\arsdoc_get.9946.NAFSAG.NAFSAPP<
arsload: Load Version <8.5.0.5> Operating System <Windows 64> <6.1.7601 Service Pack 1>
arsload: Server Version <8.5.0.5> Operating System <Windows 64> <6.1.7601 Service Pack 1> Database <DB2> <09.07.0006>
arsload: 10/05/12 12:13:53 -- Loading started, 6550 bytes to process
Resource D:\OnDemand_data\arsdoc_get.9946.NAFSAG.NAFSAPP.res matches the resource >5-1-0<
Invalid generic index file format: >?|((?+?
arsload: 10/05/12 12:13:53 Loading failed[/font]
arsload: Processing failed for file >D:\OnDemand_data\arsdoc_get.9946.NAFSAG.NAFSAPP<
arsload: Processing has stopped.  The remaining files will NOT be processed.

Formater trace....

D:\OnDemand_data>"C:\Program Files\ibm\OnDemand for Windows\bin\ARStfmt.EXE"   -i D:\OnDemand_data\output\arsload_trace.txt -o "D:\OnDemand_data\output\arsload_format_trace.txt"
fatal error 'Invalid character (Unicode: 0x16)' at line: 1135

[Nils Engerby]

Did you, by any chance, forget to transfer the index file in ASCII format this time?

//Nils

[ibmarthin]

Yes - I actually tried both ASCII and EBCDIC. But - same result.

[Alessandro Perucchi]

Have you open a PMR?
Because that should not be a problem...

Sincerely yours,
Alessandro

[LWagner]

On your ARSLOAD command, add parameter  -X G, to force an indexing override to use the generic indexer.

[LWagner]

I see you already found -X G.

I have successfully extracted AFP from Z/OS and uploaded to AIX CMOD 8.5.
I performed both the extract and the load on the indexing server, a Windows box.
Then no issue of how to FTP the files.
 
My ARSLOAD bat command file:

PATH=$PATH;C:\Program files\IBM\OnDemand for Windows\bin
arsload -h <ip address of server> -nfv -u system-id -p is-password -a FINAL-V01 -g AFP0501 AFP0501A.4.AFP0501.FINAL-V01 >> AFParsload3-log.txt