IZ61804: ERROR EXPORTING TADDM DATA TO TBSM: DB2 SQL ERROR -104, SQLSTATE: 42601, SQLERRMC: END-OF-STATEMENT

APAR status

• Closed as program error.

Error description

• PROBLEM DESCRIPTION
  During an import in TBSM an Exception Occurred The Error in
  TADDM was ERROR engine.TopologyManagerEngine -
  [TopologyManagerEngine.E.34] An error occurred while attempting
  to cleanup implicit relationship pointer. DB2 SQL ERROR -104,
  SQLSTATE: 42601, SQLERRMC: END-OF-STATEMENT
  
  PROBLEM SUMMARY
  The SQL Error -104, SQLSTATE: 42601, SQLERRMC: END-OF-STATEMENT
  occurred because the SQL create statement fails to include a
  closing bracket ")" due to a specific set of criteria.
  
  
  
  
  During a Delta Import the followiong error was discoverd in the
  TBSM
  logs.
  
  [2009/9/23-00:54:9.501]
  com.ibm.tbsm.cltools.taddm.ASITADDMConnection
  generateExplicitRelationship [11]  GTMCL5205E: Exception caught.
  java.rmi.ServerException: RemoteException occurred in server
  thread;
  nested exception is:
   java.rmi.RemoteException: [TopologyManagerFactory.E.3] An
  unexpected
  error occurred.; nested exception is:
   java.rmi.ServerException: RemoteException occurred in server
  thread;
  nested exception is:
   java.rmi.RemoteException.
  [2009/9/23-00:54:10.532]
  com.ibm.tbsm.cltools.taddm.ASITADDMConnection
  getConnection [11]  GTMCL5276I: Requesting a connection to the
  CMDB at
  148.173.251.159. SSL enabled: false.
  [2009/9/23-00:54:10.641]
  com.ibm.tbsm.cltools.taddm.ASITADDMConnection
  getConnection [11]  GTMCL5277I: Connection established with
  148.173.251.159.
  [2009/9/23-00:54:11.813]
  com.ibm.tbsm.cltools.taddm.ASITADDMConnection
  getConnection [11]  GTMCL5276I: Requesting a connection to the
  CMDB at
  148.173.251.159. SSL enabled: false.
  [2009/9/23-00:54:11.891]
  com.ibm.tbsm.cltools.taddm.ASITADDMConnection
  getConnection [11]  GTMCL5277I: Connection established with
  148.173.251.159.
  [2009/9/23-00:54:12.969]
  com.ibm.tbsm.cltools.taddm.ASITADDMConnection
  getConnection [11]  GTMCL5276I: Requesting a connection to the
  CMDB at
  148.173.251.159. SSL enabled: false.
  [2009/9/23-00:54:13.063]
  com.ibm.tbsm.cltools.taddm.ASITADDMConnection
  getConnection [11]  GTMCL5277I: Connection established with
  148.173.251.159.
  [2009/9/23-00:54:14.282]
  com.ibm.tbsm.cltools.taddm.ASITADDMConnection
  getConnection [11]  GTMCL5276I: Requesting a connection to the
  CMDB at
  148.173.251.159. SSL enabled: false.
  [2009/9/23-00:54:14.376]
  com.ibm.tbsm.cltools.taddm.ASITADDMConnection
  getConnection [11]  GTMCL5277I: Connection established with
  148.173.251.159.
  [2009/9/23-00:54:15.532]
  com.ibm.tbsm.cltools.taddm.ASITADDMMssId
  process711 [11]  GTMCL5205E: Exception caught. Relationship():
  Retry
  exceeded on getChangedClasses.
  
  
  At the same time on TADDM the following error was recorded.
  
  
  2009-09-23 00:54:14,469 TopologyManager [RMI TCP
  Connection(2124)-127.0.0.1]  ERROR engine.TopologyManagerEngine
  -
  [TopologyManagerEngine.E.34] An error occurred while attempting
  to clean
  up implicit relationship pointer.
  com.solarmetric.jdbc.ReportingSQLException: DB2 SQL error:
  SQLCODE:
  -104, SQLSTATE: 42601, SQLERRMC:
  END-OF-STATEMENT;1D39B142CD9E4E92D5B';)
  {stmnt 457710408 SELECT
  MSSOBJLINK_REL.MSS_X,MSSOBJLINK_REL.OBJ_X,MSSOBJLINK_REL.GUID_X,
  MSSOBJLI
  NK_REL.MSSSOURCETOKEN_X,MSSINFO.ACCESSSTRING_X,MSSINFO.GUID_X,MS
  S.MSSNAM
  E_X,MSS.PRODUCTNAME_X, MSS.PRODUCTVERSION_X , MSS.HOSTNAME_X,
  MSS.MANUFACTURERNAME_X, MSS.SUBCOMPONENTINSTANCENAME_X,
  MSS.SUBCOMPONENT_X FROM MSSOBJLINK_REL, MSS LEFT OUTER JOIN
  MSSINFO ON
  MSS.PK_X = MSSINFO.PK__PARENTMSSACCESSINFO_X WHERE
  MSSOBJLINK_REL.MSS_X=MSS.GUID_X AND MSSOBJLINK_REL.OBJ_X IN (
  'FA3B01C8B34831D39B142CD9E4E92D5B'} [code=-104, state=42601]
  

Local fix

• n/a
  

Problem summary

• During an import in TBSM an Exception Occurred The Error in
  TADDM was ERROR engine.TopologyManagerEngine -
  [TopologyManagerEngine.E.34] An
  error occurred while attempting to cleanup implicit relationship
  pointer. DB2 SQL
  ERROR -104, SQLSTATE: 42601, SQLERRMC: END-OF-STATEMENT
  

Problem conclusion

• The fix for this APAR is contained in the following
  maintenance packages:
  | Fix Pack | 7.1.2.0-TIV-ITADDM-FP0006
  

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 DEPENDENCY

• Fixed component ID

  5724N5500

Applicable component levels

• R712 PSY

     UP