SAP Knowledge Base Article - Preview

2722613 - Error: "Failed to clean up the environment" for replication through HanaAdapter - SAP HANA Smart Data Integration

Symptom

framework.trc shows error(s) similar to:

  • [ERROR] TransSystemObjectManager | TransSystemObjectManager.assertDeinitializable  - De-initialization is not allowed due to existing system table(s)["<Schema>"."<System object prefix>SHADOW_<Source schema>_<Source table name>"] which might not be cleaned up successfully.
  • [ERROR] TransSystemObjectManager | TransSystemObjectManager.assertDeinitializable  - Please confirm all the subscriptions have been reset/dropped already then manually drop those system table(s) with CASCADE option in source system. Otherwise you may have configured a duplicate [System Object Prefix] remote source parameter which has conflicts with existing active system objects, please alter this parameter and try again.
  • [ERROR] HanaAdapterDelegate | StatefulAdapterCDC$CDCOpened.addSubscription  - [<Remote source>] Failed to add the first subscription.
    • at com.sap.hana.dp.adapter.sdk.AdapterException: Failed to clean up the environment. Context: java.sql.SQLException: Clean up the environment prohibited!
    • at com.sap.hana.dp.hanaadapter.trans.TransSystemObjectManager.assertDeinitializable(TransSystemObjectManager.java:1329)

Error upon executing a replication task or flowgraph that uses a real time subscription:

  • InternalError: dberror($.hdb.Connection.executeProcedure): 686 - SQL error, server error code: 686. start task error: "<Schema>"."<Rep task>.START_REPLICATION": line 27 col 7 (at pos 1029):
  • [140038] Error executing SQL command in task.;Error executing ALTER_REMOTE_SUBSCRIPTION_QUEUE with command: 'ALTER REMOTE SUBSCRIPTION "<SCHEMA>"."<Remote subscription name>" QUEUE'. ,exception
  • exception 71000256: QUEUE: <Remote subscription name>: Failed to add subscription for remote subscription <Remote subscription name>[id = #] in remote source <Remote source name>[id = #].
  • Error: exception 151050: CDC add subscription failed: RS[<Remote source name>]: Failed to add the first subscription. Error: java.sql.SQLException: Clean up the environment prohibited! Please check dpagent framework.trc for the at SQLScript/Executor/Evaluator/SeEvaluatorImpl.cpp:768


Read more...

Environment

SAP HANA Smart Data Integration

Product

SAP HANA smart data integration all versions

Keywords

SDI, HanaAdapter, OracleLogReaderAdapter, OracleECCAdapter, MssqlLogReaderAdapter, MssqlECCAdapter , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , How To

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.