SAP Knowledge Base Article - Preview

2494610 - Error: Failed to validate the remote log file(s) is/are readable for MS SQL Server Log reader adapter - HANA Smart Data Integration

Symptom

  • Could not execute 'call afs_base."REMOTE::REMOTE2.START_REPLICATION"'. 
  • Console output show 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 1.0, platform edition

Keywords

HAN-DP-SDI, EIM, DPAgent, Log Reader, Data Provisioning, MSSQL, LogReaderAdapter , 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.