SAP HANA Forum
While trying to configure an SDI Data Provisioning Adapter in SAP Hana Smart Data Integration 1.x
I am getting error which says:
"Cannot call addSubscription method because the adapter is in FIRST_ADD_SUBSCRIPTION_FAILED state"
You can either upgrade to Data Provisioning Agent 1.3.3. or higher to resolve this issue or if you are not able to update Data Provisioning Agent then you can also try to re-configuration by cleaning your environment
Please follow this below steps for cleaning your environment and reconfigure the replication:
1. First, drop the remote source you created from WebIDE UI or HANA Studio
2. If the target table in HANA Database was created by reptask, check and drop it manually if it exist
3. Stop the DPAgent
4. Go to folder <DPAgent installation root folder>/LogReader, delete the folder named as <"Instance Name"> configured in remote source
5. Please use database client application for accessing your source database (MSSQL server / Oracle server), and then execute the script
"<DPAgent installation root folder>/LogReader/scripts/mssql_logreader_cleanup.sql"
Or for Oracle:
"<DPAgent installation root folder>/LogReader/scripts/oracle_logreader_cleanup.sql"
in your source database.
Note: Logon the remote database using the user with which you configure the remote source.
6. Restart DPAgent
Sign up for STechies