IBM Support

PH42679: LOADER JOB FAILS WITH HLOU5715E AND LOADER STC REPORTS A -20398 HLOSUSQA

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • On a IDAA 7.5.7 accelerator, when loader job is run on a table
    with
    many columns, the load job may fail with the following message:
    HLOU5715E 342 13:03:33.79 Unknown error during IDAA validation
    
    HLOU4014E 342 13:03:33.79 An error occured on accelerator
     ...
    HLOU4016W 342 13:03:33.79 Warning processing table:
    
    
    Loader STC report(s) the following message:
    SQL Error occurred.  Module:HLOSUSQA+00003C46
    
    DSNT408I SQLCODE = -20398, ERROR:  ERROR ENCOUNTERED DURING XML
    PARSING
          AT LOCATION 0 The initial character in the document was
          incorrecRC=000C,RSN=3063.
    DSNT418I SQLSTATE   = 2200M SQLSTATE RETURN CODE
    
    DSNT415I SQLERRP    = DSNNONPR SQL PROCEDURE DETECTING ERROR
    
    DSNT416I SQLERRD    = -490  0  0  -1  0  0 SQL DIAGNOSTIC
    INFORMATION
    
    DSNT416I SQLERRD    = X'FFFFFE16'  X'00000000'  X'00000000'
    
          X'FFFFFFFF'  X'00000000'  X'00000000' SQL DIAGNOSTIC
          INFORMATION
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All Users                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: Loader job fails with HLOU5715E and     *
    *                      loader stc reports a -20398 on HLOSUSQA *
    ****************************************************************
    Loader job fails with HLOU5715E and loader stc reports a
    -20398 on HLOSUSQA
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH42679

  • Reported component name

    IDAA LOADER ZOS

  • Reported component ID

    5639OLA00

  • Reported release

    210

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-12-09

  • Closed date

    2022-01-04

  • Last modified date

    2022-02-01

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Modules/Macros

  • HLO#A001 HLO#ACIR HLO#ACIW HLO#ACON HLO#ACRD HLO#ACUP HLO#ADIS
    HLO#ADSC HLO#AEXT HLO#AFMT HLO#AFRR HLO#ALLO HLO#AMIN HLO#ASYS
    HLO#AUMX HLO#AUTO HLO#BIND HLO#CARD HLO#CHKR HLO#CL   HLO#CL64
    HLO#CL7  HLO#CL8  HLO#CLLS HLO#CMTS HLO#CNTL HLO#CPM  HLO#CPNT
    HLO#CPOL HLO#DB2V HLO#DSAF HLO#DSPL HLO#DYNL HLO#ENCR HLO#ENQS
    HLO#ENVF HLO#EPRI HLO#ERSH HLO#ERSI HLO#FCPY HLO#ICAI HLO#ICAL
    HLO#ICCC HLO#ICCI HLO#IDCF HLO#IDSA HLO#IERR HLO#IHSA HLO#IKPL
    HLO#IKPN HLO#ILGP HLO#ILRA HLO#ILRS HLO#ILSA HLO#INIT HLO#IOPF
    HLO#IPIE HLO#IPPB HLO#IPPC HLO#IPPD HLO#IPPH HLO#IPPL HLO#IPPN
    HLO#IPPS HLO#IRPL HLO#ISNA HLO#JPRI HLO#LGAA HLO#LGAC HLO#LGAF
    HLO#LGAI HLO#LGAP HLO#LOGR HLO#LRD6 HLO#MAIN HLO#MDRV HLO#MLOG
    HLO#MMGR HLO#MPRI HLO#MREP HLO#MTIO HLO#NREC HLO#OPCL HLO#OPRI
    HLO#OS   HLO#PRF5 HLO#PRNG HLO#QSAM HLO#RANG HLO#RESM HLO#RH
    HLO#RH10 HLO#RM24 HLO#RPRP HLO#RUNT HLO#STAT HLO#SUBD HLO#SUBX
    HLO#SYSC HLO#TB   HLO#TB7  HLO#TB8  HLO#TP   HLO#TP10 HLO#TSS
    HLO#TSSA HLO#TUTL HLO#UPRI HLO#URDT HLO#UTLS HLO#UTOP HLO#VERS
    HLO#VSM  HLO#WRIT HLO#XMLI HLO#XMLJ HLO#XMLS HLO$ACCS HLO$ACES
    HLO$BDSN HLO$BJBC HLO$BMSG HLO$BUTJ HLO$CALL HLO$CTCM HLO$DCVT
    HLO$DS   HLO$DSN  HLO$ETRG HLO$EXCP HLO$OPVS HLO$OPVV HLO$PRFD
    HLO$PRFR HLO$RCTL HLO$URDT HLO$ZPAR HLO3MEPI HLO3MEPL HLOALLZT
    HLOAPOST HLOBLNKT HLOCAPST HLOCHART HLOCOMAT HLODOTT  HLODSNXT
    HLOEDIT  HLOFTRT  HLOHEXT  HLOIENQS HLOLGRD  HLOLVALT HLOMMGR
    HLOMSGEN HLONBLKT HLONNUMT HLOPARET HLOPERIT HLOPIPE  HLOPIPEA
    HLOPRPG  HLOPSTPR HLOREBD  HLOREEXP HLORERD  HLORPART HLORUSQA
    HLOS99   HLOSINIT HLOSPLCY HLOSUSQA HLOUCLBK HLOUHAL1 HLOUHLTP
    HLOUHMON HLOUMAIN HLOUSE35 HLOUTMGR HLOXAS31 HLOXAS64 HLOXASMS
    HLOXASPR HLOXDDM  HLOXEXPM HLOXPDS  HLOXUTLS HLOZPEXT HLOZSCHD
    HLOZSRB3
    

Fix information

  • Fixed component name

    IDAA LOADER ZOS

  • Fixed component ID

    5639OLA00

Applicable component levels

  • R210 PSY UI78794

       UP22/01/07 P F201

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"2.1.0"}]

Document Information

Modified date:
02 February 2022