SAP Knowledge Base Article - Preview

2494610 - [MssqlLogReaderAdapter] Error: "Failed to validate the remote log file(s) is/are readable." - SAP HANA Smart Data Integration

Symptom

  • Could not execute "call afs_base."REMOTE::REMOTE2.START_REPLICATION"'. 
  • Console output shows the error:
    • Adapter validation failed. Failed to validate the remote log file(s) is/areat SQLScript/Executor/Evaluator/SeEvaluatorImpl.cpp:764
    • SAP DBTech JDBC: [256]: sql processing error: "AFS_BASE"."REMOTE::REMOTE2.START_REPLICATION": line 42 col 4 (at pos 1803): [256] (range 3) sql processing error exception: sql processing error: QUEUE: REMOTE::REMOTE2.SUB_VT_"INFORMATION_SCHEMA"."TABLES": Failed to add subscription for remote subscription Error: exception 151050: CDC add subscription failed: Adapter validation failed. Failed to validate the remote log file(s) is/are readable.
  • Framework.trc log contains the error:
    • [ERROR] com.sap.hana.dp.mssqllogreaderadapter.MssqlLogReaderAdapter.cdcOpen[594] - Adapter validation failed.
      com.sap.hana.dp.cdcadaptercommons.validation.ValidationException: Failed to validate the remote log file(s) is/are readable.
      at com.sap.hana.dp.mssqllogreaderadapter.validation.RemoteLogFileReadableValidator.validate(RemoteLogFileReadableValidator.java:80)
  • When checking in sybfiltermgr.exe, it shows the following error:


Read more...

Environment

SAP HANA Smart Data Integration

Product

SAP HANA smart data integration 2.0

Keywords

SDI, DPAgent, Log Reader, Data Provisioning, MSSQL, MssqlLogReaderAdapter, sybfilter, sybfiltermgr.exe , 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.