IV83741: INTERACTION DETAIL TOPOLOGY HAS ERROR KD4UI0003E

IBM Tivoli Composite Application Manager for SOA 7.2 Interim Fix 12 README 7.2.0.1-TIV-ITCAMSOA-IF0012

APAR status

• Closed as program error.

Error description

• Problem Description :
  
  If the user in the Operation Flow view selects a node to View
  Interaction Detail, the Interaction Detail view shows an error
  (KD4UI0003E) instead of an interaction topology. The TEPS eWAS
  SystemOut.log shows the following exceptions.
  
  [3/28/16 11:02:43:182 EDT] 0000982c SDMSUIAccessI E
  com.ibm.management.soa.dms.query.impl.SDMSUIAccessImpl
  getOperationDetailsForGUID An error was encountered while
  creating the graph.
  
  com.ibm.management.soa.dms.exceptions.DMSDataFormatException:
  com.ibm.management.soa.dms.exceptions.DMSDataFormatException
  KD4DM0023E The SDMS command failed due to errors accessing the
  SDMS database.: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL
  Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null,
  DRIVER=3.64.96
      at
  com.ibm.management.soa.dms.access.dao.BaseInstanceView.setOperat
  ionsInstanceFocaleNodeToGraph(BaseInstanceView.java:3326)
      at
  com.ibm.management.soa.dms.access.dao.BaseInstanceView.findInsta
  nceRelationships(BaseInstanceView.java:309)
      at
  com.ibm.management.soa.dms.access.factory.impl.PersistenceFactor
  yImpl.findInstanceRelationships(PersistenceFactoryImpl.java:366)
      at
  com.ibm.management.soa.dms.query.impl.SDMSUIAccessImpl.getOperat
  ionDetailsForGUID(SDMSUIAccessImpl.java:1246)
      at
  com.ibm.management.soa.dms.ejb.access.AccessManagerBean.getOpera
  tionDetailsForGUID(AccessManagerBean.java:589)
      at
  com.ibm.management.soa.dms.ejb.access.EJSLocalStatelessAccessMan
  ager_c8a58271.getOperationDetailsForGUID(Unknown Source)
      at
  com.ibm.management.soa.dms.ejb.facade.SDMSFacadeBean.invokeAcces
  sBeanMethods(SDMSFacadeBean.java:586)
      at
  com.ibm.management.soa.dms.ejb.facade.SDMSFacadeBean.invokeQuery
  (SDMSFacadeBean.java:225)
      at
  com.ibm.management.soa.dms.ejb.facade.EJSRemoteStatelessSDMSFaca
  de_7c3bc5ed.invokeQuery(Unknown Source)
      ....
  
  caused by
  
  com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error:
  SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=3.64.96
      ....
      at
  com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(W
  SJdbcPreparedStatement.java:712)
      at
  com.ibm.management.soa.dms.access.dao.JDBCHelper.executeQuery(JD
  BCHelper.java:283)
      at
  com.ibm.management.soa.dms.access.dao.StandardBPDDescription.get
  BPDDescriptionByProcessApplicationVersion(StandardBPDDescription
  .java:561)
      at
  com.ibm.management.soa.dms.access.dao.BaseInstanceView.setOperat
  ionsInstanceFocaleNodeToGraph(BaseInstanceView.java:3307)
      at
  com.ibm.management.soa.dms.access.dao.BaseInstanceView.findInsta
  nceRelationships(BaseInstanceView.java:309)
      at
  com.ibm.management.soa.dms.access.factory.impl.PersistenceFactor
  yImpl.findInstanceRelationships(PersistenceFactoryImpl.java:366)
      at
  com.ibm.management.soa.dms.query.impl.SDMSUIAccessImpl.getOperat
  ionDetailsForGUID(SDMSUIAccessImpl.java:1246)
      at
  com.ibm.management.soa.dms.ejb.access.AccessManagerBean.getOpera
  tionDetailsForGUID(AccessManagerBean.java:589)
      at
  com.ibm.management.soa.dms.ejb.access.EJSLocalStatelessAccessMan
  ager_c8a58271.getOperationDetailsForGUID(Unknown Source)
      at
  com.ibm.management.soa.dms.ejb.facade.SDMSFacadeBean.invokeAcces
  sBeanMethods(SDMSFacadeBean.java:586)
      at
  com.ibm.management.soa.dms.ejb.facade.SDMSFacadeBean.invokeQuery
  (SDMSFacadeBean.java:225)
      at
  com.ibm.management.soa.dms.ejb.facade.EJSRemoteStatelessSDMSFaca
  de_7c3bc5ed.invokeQuery(Unknown Source
  
  Approver :
    L3 - BG
    L2 - IS
  
  LOCAL FIX:
  none
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ITCAM for SOA Interaction Detail topology    *
  * users on all platforms.                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * If a service port namespace is longer than 64 characters the *
  * BPM code attempts to insert the full length string into a    *
  * smaller buffer and this throws an exception.                 *
  *                                                              *
  * The fix limits the length of a namespace query that was      *
  * causing database errors and preventing users from viewing    *
  * certain interaction detail topologies.                       *
  ****************************************************************
  * RECOMMENDATION: Apply fix when it is available.              *
  ****************************************************************
  

Problem conclusion

• Apply the IFix when it is available.
  
  The fix for this APAR is contained in the following maintenance
  packages:
  | interim fix | 7.2.0.1-TIV-ITCAMSOA-IF0010
  

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

  ITCAM FOR SOA-D

• Fixed component ID

  5724SOA00

Applicable component levels