IT46497: ASSIGNING RESULTSET HAVING MORE THAN ONE ROW OF DB STATEMENT TO ROW VARIABLE CAN CAUSE ABEND

APAR status

• Closed as program error.

Error description

• If user assigns result of ESQL Database SELECT statement which
  returns more that one row to ROW ESQL variable , Integration
  Server abends.
  

Local fix

• Make sure DB statement does not return more than one row
  in
  resultset.
  

Problem summary

• ****************************************************************
  
  USERS AFFECTED:
  All users of IBM App Connect Enterprise v12 and v13 using ROW
  data type in ESQL.
  
  
  Platforms affected:
  AIX, ZOS, LinuxZ64, LinuxX64, LinuxPPCLE64, WinX64
  
  ****************************************************************
  
  PROBLEM DESCRIPTION:
  If user assigns result of ESQL Database SELECT statement
  which
  returns more that one row to ROW ESQL variable, the
  Integration
  Server abends with following
  stack:
  
  (0x90000002e16c038+0x00000060)
  _ZN14SqlWriteCursor25createAfterWithSameParserEv
  [/opt/IBM/ace-12.0.10.1/server/lib/libImbRdl.so]
  (0x90000002e205
  0f8+0x0000007c)
  _ZNK14SqlPathElement11createAfterER14SqlWriteCursorN21ImbMessage
  
  De
  [/opt/IBM/ace-12.0.10.1/server/lib/libImbRdl.so]
  (0x90000002e206
  6f8+0x00000298)
  _ZNK14SqlPathElement18navigateCursorNextER14SqlEvalEnvironR14Sql
  
  WriteCursorbPK27SqlDefaultsForMsgNodeCreateb
  [/opt/IBM/ace-12.0.10.1/server/lib/libImbRdl.so]
  (0x90000002e121
  d18+0x000007b8)
  _ZN13SqlEvalResult18assignToChildInnerER14SqlWriteCursorRK14SqlP
  
  athElementRibbRK10ImbWstring
  [/opt/IBM/ace-12.0.10.1/server/lib/libImbRdl.so]
  (0x90000002e121
  3f8+0x00000290)
  _ZN13SqlEvalResult13assignToChildER14SqlWriteCursorRK14SqlPathEl
  
  ementbbRK10ImbWstring
  [/opt/IBM/ace-12.0.10.1/server/lib/libImbRdl.so]
  (0x90000002e11f
  978+0x0000019c)
  _ZNK13SqlAssignment15assignToMessageER14SqlEvalEnviron
  [/opt/IBM/ace-12.0.10.1/server/lib/libImbRdl.so]
  

Problem conclusion

• Product no longer abends and logs error BIP4173E.
  
  ---------------------------------------------------------------
  The fix is targeted for delivery in the following PTFs:
  
  Version   Maintenance Level
  v12.0      12.0.12.15
  v13.0      13.0.4.0
  
  The latest available maintenance can be obtained from:
  http://www-01.ibm.com/support/docview.wss?rs=849&uid=swg27006041
  
  
  If the maintenance level is not yet available,information on
  its planned availability can be found on:
  http://www-1.ibm.com/support/docview.wss?rs=849&uid=swg27006308
  ---------------------------------------------------------------
  

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

  APP CONNECT ENT

• Fixed component ID

  5724J0560

Applicable component levels