sap errors and solutions

Just another SAP blog

Delete entries in Data Provisioning

How to Delete Entries in Data Provisioning from HANA Studio.

Symptom: I have deleted entries in our LT server from LTR t-code to create new one due to some issues. Now when I check Data Provisioning from HANA Studio I still see OLD entry. Now the question is How to delete it.

 

Solution:

Follow below steps:

 

Delete SLT user from HANA Studio. This will delete SLT user and SLT schema with all tables.

Go to SQL Query mode and execute below command.

DELETE FROM “SYS_REPL”.”RS_REPLICATION_COMPONENTS”;

This will delete every configuration in Data Provisioning.

 

If you want to delete table entry from Data Provisioning in HANA Studio use below command:

DELETE FROM <SLT-SCHEMA>.RS_STATUS WHERE TABLENAME = ‘<TABLE NAME>’

 

Note: This should perform in Training system only. Performing DEV, QTY and PRD servers is not recommended.  Please contact SAP before you perform.

 

 

Updated: August 16, 2016 — 3:15 pm

Leave a Reply

Your email address will not be published. Required fields are marked *

sap errors and solutions © 2016 Frontier Theme
Copy Protected by Chetan's WP-Copyprotect.