SAP Knowledge Base Article - Preview

3230059 - replication task getting 686 - SQL error

Symptom

When running a replication task to add the first subscription for a DB@LTLAdapter remote source you recieve the following error:

InternalError: dberror($.hdb.Connection.executeProcedure): 686 - SQL error, server error code: 686. start task error: "<owner>"."<owner> ::<task name>": line 27 col 7 (at pos 1032): [140038] Error executing SQL command in task.;Error executing ALTER_REMOTE_SUBSCRIPTION_QUEUE with command: 'ALTER REMOTE SUBSCRIPTION "<owner>"."<subscription_name>" QUEUE'. ,exception71000256: QUEUE: <subscription_name> : Failed to add subscription for remote subscription <subscription_name> [id = 17236928] in remote source <remote source name>[id = 17236898]. Error: exception 151050: CDC add subscription failed: RS[<remote source name> ]: Failed to add the first subscription. Error: Failed to configure repagent for null with exception: Failed to download <owner>.SDI.at SQLScript/Executor/Evaluator/SeEvaluatorImpl.cpp:700


Read more...

Environment

  • SAP HANA Smart Data Integration version 2.05 and higher
  • SDI DB2 Mainframe ADAPTER 2.6 and higher
  • REP AGENT SDI DB2 MAIN ADAPTER 2.6.2 and higher

Keywords

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.