PI32848: SETTLEMENT ENGINE - SQLCODE -407 ON ICRE LOAD

APAR status

• Closed as program error.

Error description

• As soon as an ICRE file is created, the ICRE Load event is
  triggered.
  During this process, we get the following messages in our log.
  
  IZRIL100K: *** ICRE load started
  
  IZRDB998I: Database Accessor Exception. AccumulatorAccessor
  Assignment
  of a NULL value to a NOT NULL column "TBSPACEID=35, TABLEID=14,
  COLNO=4" is not allowed.. SQLCODE=-407, SQLSTATE=23502,
  DRIVER=3.63.75
  
  IZRDB999I: Database Accessor Exception. SQL: INSERT INTO
  IZR_ACCUM_OUTBOUND(BANK_ID,BDAY_ID,OUT_PRES_ID,PRESENTMENT_ID,AC
  CUM_ID,
  ITEM_COUNT,TOTAL_AMT,APPLICATION_NAME) VALUES (?,?,?,?,?,?,?,?)
  
  IZRMDB06S: Database exception encountered while sending a reply
  message
  Assignment of a NULL value to a NOT NULL column "TBSPACEID=35,
  TABLEID=14, COLNO=4" is not allowed.. SQLCODE=-407,
  SQLSTATE=23502,
  DRIVER=3.63.75
  

Local fix

Problem summary

• -
  

Problem conclusion

• Given a fix for null checking ACCUM_ID during ICRE Load.
  

Temporary fix

Comments

APAR Information

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

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

Fix information

• Fixed component name

  V2 PRESENT & SE

• Fixed component ID

  5799PST00

Applicable component levels

• R231 PSN

     UP