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.