Author Topic: ARSLOAD code page error on Windows  (Read 4180 times)

LWagner

  • Guest
ARSLOAD code page error on Windows
« on: December 28, 2011, 05:10:17 PM »
In omvs on z/OS 1.9, used this command:

"nohup /usr/lpp/ars/V8R4M0/bin/arsdoc get -h ARSDBASE -u CADMINOD -p V0T2R9Y3 -v -a -d /ars1 -g -o afp0500 -P -c -N -x "10927-95-0-402FAA-15094-15094" -G 'AFP0500' -i "WHERE LOAD_DATE > 0" 1>arsget.sys094 2>arsget.sys094 & "

This created what appear to be valid .IND, .OUT and .RES files. I used FTP to move them to a windows server, the .IND as Ascii, the other two as binary.  I then tried to then use them with ARSLOAD, and got errors mapping field names as follows.  I expect this a code page problem. The mis-translated filed names and proper value are at the bottom.

============================================
arsload: Processing file >afp0500.3.AFP0500.DEPOSIT-V01<
arsload: 12/28/11 15:38:20 -- Loading started, 7363386 bytes to process
Resource afp0500.3.AFP0500.DEPOSIT-V01.res matches the resource >4-116-0<
The field name ' ??|?+?+?(???' found in the index file does not match any expected fields.  The field will be ignored.
The field name '+ (?' found in the index file does not match any expected fields.  The field will be ignored.
The field name ' ??????' found in the index file does not match any expected fields.  The field will be ignored.
The field name '^' found in the index file does not match any expected fields.  The field will be ignored.
The field name ' (|?+????' found in the index file does not match any expected fields.  The field will be ignored.
The field name '&|???+?^? ??' found in the index file does not match any expected fields.  The field will be ignored.
The field name '??&|??^+ (?' found in the index file does not match any expected fields.  The field will be ignored.
The field name '<| ?^? ??' found in the index file does not match any expected fields.  The field will be ignored.
The field name '& ??^?+?' found in the index file does not match any expected fields.  The field will be ignored.Unable to open the file: /ars1/afp0500.3.AFP0500.DEPOSIT-V01.out
Loaded 0 rows into the database
arsload: 12/28/11 15:38:23 Loading failed
arsload: Processing failed for file >afp0500.3.AFP0500.DEPOSIT-V01<
arsload: Processing has stopped.  The remaining files will NOT be processed.
=========================================================

The field name ' ??|?+?+?(???' should be "ACCOUNT NUMBER"
The field name '+ (?' should be "NAME"
The field name ' ??????' should be "ADDRESS"
The field name '^' should be "_"
The field name ' (|?+????' should be "AMOUNT DUE"
The field name '&|???+?^? ??' should be "POSTING_DATE"
The field name '??&|??^+ (?' should be "REPORT_NAME"
The field name '<| ?^? ??' should be "LOAD_DATE"
The field name '& ??^?+?' should be "PAGE_CNT
-------------------------------------------------------
Sample from .IND file:
COMMENT: OnDemand Generic Index File Format
COMMENT: This file has been generated by the arsdoc command
COMMENT: December 27, 2011  23:00:41
COMMENT: CODEPAGE:1047
CODEPAGE:1047
COMMENT:
IGNORE_PREPROCESSING:1
COMMENT:
GROUP_FIELD_NAME:ACCOUNT NUMBER
GROUP_FIELD_VALUE:1012230201632500000901       
GROUP_FIELD_NAME:NAME
GROUP_FIELD_VALUE:ROSALINA OLIVA               
GROUP_FIELD_NAME:ADDRESS
GROUP_FIELD_VALUE:1632-1/2 COUNCIL ST           
GROUP_FIELD_NAME:_
GROUP_FIELD_VALUE:       
GROUP_FIELD_NAME:AMOUNT DUE
GROUP_FIELD_VALUE:205.00       
GROUP_FIELD_NAME:POSTING_DATE
GROUP_FIELD_VALUE:04/29/11
GROUP_FIELD_NAME:REPORT_NAME
GROUP_FIELD_VALUE:DEPOSIT-V01
GROUP_FIELD_NAME:LOAD_DATE
GROUP_FIELD_VALUE:04/29/2011 22:33:13
GROUP_FIELD_NAME:PAGE_CNT
GROUP_FIELD_VALUE:1
GROUP_OFFSET:0
GROUP_LENGTH:15140
GROUP_FILENAME:/ars1/afp0500.3.AFP0500.DEPOSIT-V01.out



Ed_Arnold

  • Hero Member
  • *****
  • Posts: 1203
    • View Profile
Re: ARSLOAD code page error on Windows
« Reply #1 on: December 29, 2011, 11:43:48 AM »
Try changing CODEPAGE from 1047 to 5346.

Ed
#zOS #ODF

LWagner

  • Guest
Re: ARSLOAD code page error on Windows
« Reply #2 on: December 29, 2011, 12:06:56 PM »
Edited .IND file.  Changed CODEPAGE per suggestion, and FILENAME from omvs directory to Windows folder

Perhaps too many documents to load.  For AFP, I may have to slice and dice the SQL to extract smaller numbers of bills to not exceed the processing maximum.  No additional error message seem available besides the one shown.
-----------------------
arsload: Processing file >afp0500.3.AFP0500.DEPOSIT-V01<
arsload: 12/29/11 10:58:27 -- Loading started, 7363386 bytes to process
Resource afp0500.3.AFP0500.DEPOSIT-V01.res matches the resource >4-116-0<
OnDemand Load Id = >10927-116-0-414FAA-15094-15094<
An unexpected error occurred.  Contact your System Administrator and/or consult the System Log.  File=arsadmp.c, Line=1032
Unable to store the object >414FAA1<.  Object size 19635
Loaded 486 rows into the database
arsload: 12/29/11 10:58:47 Loading failed
arsload: Processing failed for file >afp0500.3.AFP0500.DEPOSIT-V01<
arsload: 12/29/11 10:58:47 -- Unloading started
OnDemand UnLoad Successful - LoadId(10927-116-0-414FAA-15094-15094) Rows Deleted(486)
12/29/11 10:58:52 -- Unloading of data was successful
arsload: Processing has stopped.  The remaining files will NOT be processed.

Ed_Arnold

  • Hero Member
  • *****
  • Posts: 1203
    • View Profile
Re: ARSLOAD code page error on Windows
« Reply #3 on: December 29, 2011, 12:25:22 PM »
> consult the System Log

Nothing in there?

Seems like you should be able to load huge files, what I see doesn't look all that big.   ???
#zOS #ODF