PI57766: DNIE4497E AND FIN MESSAGE BACKED OUT WHEN FIELD 32A IS EMPTY ANDMWH IS ENABLED

3.0.0-FTM-SWS-MP-fp0003

APAR status

• Closed as program error.

Error description

• If message warehouse is enabled, and a SWIFT ISN is processed in
  DNF_ILC_FIN, where the amount field is empty or contains invalid
  characters, the message is backed out to DNF_ERROR and the
  following event is issued:
  DNIE4497E 2016-02-12 07:22:15 <OUName> DNF_ILC_FIN Exception
  without valid message ID; exception data: message catalog=
  'BIPmsgs', error number='2595', parameters='((-1)(S22018)(',
  component='DNF_ILC_FIN_4480.ComIbmDnfIlcFin0.ComIbmDnfIlcFin.
  DnfIlcFinErrorReply.PrepMwhInsert'.
  
  The Broker Joblog shows the following:
  +BIP2232E HVBCBRK EXEC_HVBCBRK_FT_WBIFN_FNFIN 40 ERROR DETECTED
  WHILST
  230
   HANDLING A PREVIOUS ERROR IN NODE
  'DNF_ILC_FIN_4480.ComIbmDnfIlcFin0.
  C
   omIbmDnfIlcFin.DnfIlcFinErrorReply.PrepMwhInsert'. :
  ImbDataFlowNode
  (9
  
  34)
  
  +BIP2230E BRKName EGName ERROR DETECTED WHILST PROCESSING A
  MESSAGE IN NODE 'DNF_ILC_FIN_4480.ComIbmDnfIlcFin0.
  ComIbmDDnfIlcFin.DnfIlcFinErrorReply.PrepMwhUpdate'. :
  ImbComputeNode
  +BIP2488E BRKName EGName (.ComIbmDnfIlcFinErrorReply_
  PrepMwhUpdate.main, 12.3) ERROR DETECTED WHILST
  EXECUTING THE SQL STATEMENT 'DnfIlcFinErrorReply_
  CreateMwhRequest(rInputRoot, rOutputRoot, rEnvironment,
  rOutputLocalEnvironment, TRUE, bDoMsgWh);'. :
  ImbRdlStatementGroup
  +BIP2934E BRKName EGName ERROR DETECTED WHILST EXECUTING THE
  FUNCTION OR PROCEDURE 'DnfIlcFinErrorReply_CreateMwhRequest'. :
  ImbRdlRoutine
  +BIP2488E BRKName EGName (.DnfIlcFinErrorReply_CreateMwhRequest,
  110.6) ERROR DETECTED WHILST EXECUTING THE SQL STATEMENT
  'DnfFinUtil_ExtractField32(chFinMessage, xFinMessage, chDate,
  chCurrency, chAmount, chOption);'. : ImbRdlStatementGroup
  +BIP2934E BRKName EGName ERROR DETECTED WHILST EXECUTING THE
  FUNCTION OR PROCEDURE 'DnfFinUtil_ExtractField32'. :
  ImbRdlRoutine
  +BIP2488E BRKName EGName (ComIbmDnfFin.DnfFinUtil_extractField32
  , 44.5) ERROR DETECTED WHILST EXECUTING THE  SQL STATEMENT
  'DECLARE iValueDateYear INTEGER CAST(chValueDateYear AS INTEGER)
  ;'. : ImbRdlStatementGroup
  +BIP2521E BRKName EGName (ComIbmDnfFin.DnfFinUtil_ExtractField32
  , 44.35) : ERROR CASTING THE VALUE ''' TO 'INTEGER'. :
  ImbRdlTypeCast
  +BIP2595E BRKName EGname ERROR CASTING CHARACTER STRING '' TO AN
  INTEGER. STATE = '-1' 'S22018' '0' ''. : ImbUtility
  

Local fix

• N/A
  

Problem summary

• Formerly, when message warehouse was enabled, and when a SWIFT
  ISN was processed in DNF_ILC_FIN, where the amount field was
  empty or contained invalid characters, the message was backed
  out to DNF_ERROR and the event DNIE4497E was issued.
  

Problem conclusion

• Now, a Message Warehouse entry is written.
  

Temporary fix

Comments

APAR Information

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

  PI57654

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

Fix information

• Fixed component name

  FTM SWIFT SVCS

• Fixed component ID

  5725X9230

Applicable component levels

• R300 PSY

     UP