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
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.