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 , Problem

About this page

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

Search for additional results

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