SAP Knowledge Base Article - Preview

2638606 - Real time replication issue with SDI DB2LogReaderAdapter : T2LUW exception: SQL30081N A communication error has been detected

Symptom

  • Realtime replication fails with:

Failed to resume CAPTURE on Remote Source RS_DB2_PE: Code: 256, Message: dberror($.hdb.Connection.executeUpdate): 256 - SQL error, server error code: 256. sql processing error: RESUME CAPTURE: XX_XXX_XX: Failed to execute resume capture on remote source XX_XXX_XX exception 151061: CDC resume remote source failed: Adapter validation failed. Failed to establish JDBC connection. Error: [jcc][XXXX][XXXXX][X.XX.XX] T2LUW exception: SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "XX.XXX.XX.XXX". Communication function detecting the error: "connect". Protocol specific error code(s): "111", "*", "*". SQLSTATE=08001
ERRORCODE=-30081, SQLSTATE=08001

  • In framework.trc:

2018-04-26 15:52:38,813 [ERROR] DB2LogReaderAdapter | DB2LogReaderAdapter.cdcOpen - Adapter validation failed.
com.sap.hana.dp.cdcadaptercommons.validation.ValidationException: Failed to establish JDBC connection. Error: [jcc][XXXX][XXXXX][X.XX.XX] T2LUW exception: SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "XX.XXX.XX.XXX". Communication function detecting the error: "connect". Protocol specific error code(s): "111", "*", "*". SQLSTATE=08001
ERRORCODE=-30081, SQLSTATE=08001
at com.sap.hana.dp.cdcadaptercommons.validation.AbstractDBAccessValidator.validate(AbstractDBAccessValidator.java:45)
at com.sap.hana.dp.cdcadaptercommons.validation.AdapterPropertiesValidator.validate(AdapterPropertiesValidator.java:126

  • Initial Load works. 
  • You can create virtual table and do queries.
  • This is brand new install.

 


Read more...

Environment

  • SAP HANA Smart Data Integration
  • DB2LogReaderAdapter
  • DP Agent installed on Suse OS

Product

SAP HANA smart data integration all versions

Keywords

SDI , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.