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

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 there might exist 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

SAP HANA Smart Data Integration

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