2722613 - com.sap.hana.dp.adapter.sdk.AdapterException: Failed to clean up the environment. Context: java.sql.SQLException: Clean up the environment prohibited! Please check dpagent framework.trc for the recovery steps

framework.trc shows error similar to:

[ERROR] TransSystemObjectManager | TransSystemObjectManager.assertDeinitializable  - De-initialization is not allowed due to existing system table(s)["<schema>"."HADP_SHADOW_<schema>_<table_name>"] which might not be cleaned up successfully.
2018-11-20 12:03:24,371 [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 configure duplicate [System Object Prefix] remote source parameter which has conflicts with existing active system objects, please alter this parameter and try again.
2018-11-20 12:03:24,372 [ERROR] HanaAdapterDelegate | StatefulAdapterCDC$CDCOpened.addSubscription  - [<remote_source>] Failed to add the first subscription.

....

com.sap.hana.dp.adapter.sdk.AdapterException: Failed to clean up the environment. Context: java.sql.SQLException: Clean up the environment prohibited! Please check dpagent framework.trc for the recovery steps.
                                 at com.sap.hana.dp.hanaadapter.trans.TransSystemObjectManager.assertDeinitializable(TransSystemObjectManager.java:1329)

SAP HANA Smart Data Integration

SDI, HanaAdapter, , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem