Author Topic: ARS1143I Error Referencing field names with non standard characters  (Read 2305 times)

ajdmozart

  • Newbie
  • *
  • Posts: 5
    • View Profile
I'm trying to load up a report into CMOD.  I used the report wizard to generate my objects and index file  (index file below) :

CC=YES
CCTYPE=A
CONVERT=NO
CPGID=500
MCF2REF=CPCS
NEWPAGE=1
TRC=NO
FILEFORMAT=RECORD,133
TRIGGER1=*,1,X'F1',(TYPE=GROUP)  /* 1 */
FIELD1=1,12,8,(TRIGGER=1,BASE=0)
FIELD2=0,20,3,(TRIGGER=1,BASE=0)
FIELD3=0,26,7,(TRIGGER=1,BASE=0)
INDEX1=X'52756E44617465',FIELD1,(TYPE=GROUP,BREAK=YES)      /* RunDate   */
INDEX2=X'4167656E6379',FIELD2,(TYPE=GROUP,BREAK=NO)         /* Agency    */
INDEX3=X'5061796565436F6465',FIELD3,(TYPE=GROUP,BREAK=NO)   /* PayeeCode */
DCFPAGENAMES=NO
UNIQUEBNGS=YES
IMAGEOUT=ASIS
INDEXOBJ=GROUP
INDEXSTARTBY=1
INSERTIMM=NO
RESTYPE=NONE

I am having issues successfully loading the report into CMOD.

The report is a line report on the mainframe. We are loading it into the JES2 queue under a CLASS that the CMOD ARSLOAD program listens to. 

FIELD1 is the RUN DATE on the Report defined as DATE, INDEX and Segment in the AppGrp, Format %m/%d/%y
 RUN DATE: 06/23/17                           

FIELD2 is Agency derived of the 3 characters in the following report field on line 1 – defined as Filter, String
   1RUN SORT: PDRDP351002002PC00010  ................                                                                             

FIELD3 is Payee Code derived of the 7 characters in the following report field on line 1  – defined as Filter, String
   1RUN SORT: PDRDP351002002PC00010  ................         

I’ve also defined a field called Load Date in the Application with a default of ‘t’ to get the system load date.

This is a large report so I defined it as "Large Object"

When I try to load this report into CMOD, the ARSLOAD fails to load and gives me the following message :

2019-01-31 17:10:15.484592: ARS1143I The field name 'êÍ>à/ÈÁ' found in the index file does not match any expected fields.  The field will be ignored.                                                               
2019-01-31 17:10:15.484734: ARS1143I The field name ' ÅÁ>Ä`' found in the index  file does not match any expected fields.  The field will be ignored.                                                               
2019-01-31 17:10:15.484754: ARS1143I The field name '&/`ÁÁä?ÀÁ' found in the index  file does not match any expected fields.  The field will be ignored.                                                               

I would greatly appreciate anyone letting me know where I may be going wrong.


Greg Ira

  • Full Member
  • ***
  • Posts: 240
    • View Profile
Re: ARS1143I Error Referencing field names with non standard characters
« Reply #1 on: February 01, 2019, 10:02:27 AM »
Your hex values are off.  Not sure how they were created but they need to be corrected for z/OS
eg.  Your RunDate is X'52756E44617465'  which, in EBCIDC, is êÍ>à/ÈÁ.
       It should be X'D9A495C481A385'

When you use the graphical indexer wizard be sure your sample is in EBCIDC and your code page is set correctly.
« Last Edit: February 01, 2019, 10:06:44 AM by Greg Ira »

ajdmozart

  • Newbie
  • *
  • Posts: 5
    • View Profile
Re: ARS1143I Error Referencing field names with non standard characters
« Reply #2 on: February 01, 2019, 10:23:47 AM »
Thanks. I believe the code page is correctly set as 500 which is ANSI (EBCDIC). But you're right, I set it  to ASCII in the wizard to build the fields, and indexes. If I set CC Type = ANSI (ASCII), File format : Line, 133 and Code Page 850 in the wizard the sample appears in unreadable format and its impossible for me to identify the fields. So I built the triggers, fields and indexes in the ASCII version of the sample, then I changed the properties to the EBCDIC  parameters before saving.  Is there another way?
Thanks

Nolan

  • Full Member
  • ***
  • Posts: 152
    • View Profile
Re: ARS1143I Error Referencing field names with non standard characters
« Reply #3 on: February 01, 2019, 10:38:18 AM »
You need to download the data from Z/OS in binary format.  Then you can use the wizard to setup indexing.  The other way is not to use the wizard but do it manually which is what we do normally.  Don't use anything ANSI if it is for Z/OS EBCIDIC.
J.

#zOS #AIX #Windows #Multiplatforms
#DB2 #TSM #ODF #zODF #ODWEK
#CapacityPlanning #AFP #ReportDistribution
#Finance #ICN

ajdmozart

  • Newbie
  • *
  • Posts: 5
    • View Profile
Re: ARS1143I Error Referencing field names with non standard characters
« Reply #4 on: February 01, 2019, 12:01:52 PM »
Thank you