cancel
Showing results for 
Search instead for 
Did you mean: 

RESTORE Table replication in SAP HANA Via SLT

KamalMehta
Advisor
Advisor
0 Kudos

Hi Experts,

Please suggest how we can restore Replication of a Table if the same has been deleted from Tables RS_STATUS with in the same schema.

Thanks

Accepted Solutions (0)

Answers (2)

Answers (2)

srinivasan_vinayagam
Active Contributor
0 Kudos

Hi Rocky,

Run the below command from SQLEditor:

insert into <schema>."RS_ORDER" values(<your_table>, null, 'C');

Or re-load the table  as per below thread.

http://scn.sap.com/thread/2146829

Regards,

V Srinivasan

nilesh_khorgade
Explorer
0 Kudos

Hello Rockey,

If the status is deleted from RS_STATUS, but table is intact with its triggers and logging tables in source you can use below command to get the previous status of the table. Though you will loose history of table

Ex: if previous status was set as replicate in progress then command would be as below

insert into "schemaname"."RS_STATUS" values('source sid','source host name','tablename','R','',0,'','P','')

Regards,

Nilesh

KamalMehta
Advisor
Advisor
0 Kudos

Hi Nilesh,

Kindly note that i am not able to find the this table (Table to be replicated) into required schema in HANA studio.

although this was available earlier but some how the status changed to error in data provisioning and was not able to find this table in that schema. I deleted the entries from Table RS_STATUS Table so as to make it work again but no success.

I also tried using the above command mentioned by you to create entry in RS_ORDERS Table so as to start replication but again no success.

Thanks

nilesh_khorgade
Explorer
0 Kudos

Hi,

In that case I would suggest to replicate the same table again.

Regards,

Nilesh

Saritha_K
Contributor
0 Kudos

Hi Rocky,

Can u pls try below steps once and let us know if it worked or not-

login to slt-

tcode- LTRC

tab- table overview-

stop replication (if you still see the table in there)

tab -processing steps

Under delete objects tab

do a reset all objects and settings for the respective table.

[from hana], delete the table object (if you still see it in schema)

start replication from slt or hana.

hope this helps!

Regards,

Saritha

KamalMehta
Advisor
Advisor
0 Kudos

Tried Replicating again with both Load and Replicate Option but no success.

Thanks

KamalMehta
Advisor
Advisor
0 Kudos

Hi Saritha,

Please note :

1. The Table doesn't exist in HANA Schema.

2. It's not appearing in LTRC - Table Overview.

3.  Delete option in the Processing tab in lTRC will be effective only when this table appears in Table Overview in LTRC. Although i have tested it out as well no success.

4. This Table is appearing in data provisioning in 'Load' or 'Replicate' Option both but when i am executing nothing is coming up for this Table in HANA.

Also note that in LTRC --> Expert Functions --> Display Table I am able to see this Table but its not appearing in LTRC --> Table Overview.

Thanks

Saritha_K
Contributor
0 Kudos

Hi Rocky,

What is your DMIS version? Have you applied all correction notes ?

Regards,

Saritha K

Former Member
0 Kudos

Hi Rocky,

Can you please check the Trigger & Logging table status of this table from source system?

Trigger status from IUUC_Remote & Logging table status from SE16.

If the triggers & logging tables exist for this particular table then remove it from IUUC_Remote in source.Then simply add this table via LTRC.

Regards,

Joydeep.