We are using SDI MssqlECCAdapter to replicate ECC data from an MSSQL database to a HANA Cloud instance. Latest versions of SDI / DP agent, HANA Cloud db. I am trying to load a very large table, but once I kick off the process, if the performance is not acceptable, I can't seem to find a way to stop it short of restarting HANA.
For example, when I ran the process last night, based on the speed at which the first 4 partitions completed, I estimated that it would take 75 hours for the entire reptask to complete. I did not want this data load to run for that long as we are trying to do these data loads during quiet times in ECC.
I've tried redeploying the reptask from BAS, but that typically fails because the process is running. The stop task button in the SQL Console from which I start the stored procedure doesn't seem to actually stop the process in the HANA DB or on the DP Agent. I tried killing the task ID using the CANCEL TASK statement, but it kept saying that the task ID didn't exist.
Is there way to stop the initial load of a reptask once it starts?
Thanks in advance
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.