on 02-27-2012 5:09 PM
Hi,
I am using HANA Version: 1.0.24 and SLT SAPK-91705INDMIS.
I have replicated several tables without any problems in this environment. However, when I tried to replicate T009, T009B and T009C; two tables T009B and T009C show status of replication as "Error" in both LTR and Hana Studio. Table T009 is replicated correctly.
I noticed that the table structure for T009B and T009C is created in HANA but there is no Data. Not sure what happened during replication. It seems to have stopped in between due to some error and now I have Table structures but with no data. I have tried suspend / stop and replicate but it keeps shown status as 'Error'.
Tcode LTR on SLT system shows following warnings
"Trigger exists in Source System although it is internally set as initial" for both tables.
I just want to start again and redo the load/replication of these two tables. What is the process of doing so?
Thanks
Sandeep
Hi Sandeep,
I cannot comment on the officially supported way of deleting these triggers. Maybe the following will work,
Run the below command from SQLEditor:
insert into <schema>."RS_ORDER" values(<your_table>, null, 'C');
delete from <schema>."RS_STATUS" where TABLENAME=<your_table>
Although I think it should delete source triggers(but not sure). You do the cleanup from SLT (transaction IUUC_SYNC_MON)-->Expert Functions --> 'Delete DB triggers' , 'Delete Logging tables entries' and 'Delete Logging tables' for your table.
Also after doing this, you can check in source system (transaction IUUC_REMOTE) if triggers for your table are deleted.
Caution Again :-): I don't know if the above method is a documented and officially supported one.
Regards, Rahul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sandeep,
your problem seems similar to this one:
http://scn.sap.com/thread/3148283
But i'm not sure nor if this will fix your problem nor if this is an official solution.
Regards
Leo Capasso
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
as a corollary , How do I remove a table from the list of tables shown in the "data Provisioning" pane in the SQL studio ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hope, the problem is solved for these pool tables. If yes, could you please share the RCA, Sandeep.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rahul,
Thanks for your suggestion! I am hesitant to delete logging tables entries and looging table. I did try the insert in RS_ORDER but it did not help.
I think the problem may be because T009, T009B and T009C are Pool tables. All three of them use single set of Triggers.
Thanks
Sandeep
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> I think the problem may be because T009, T009B and T009C are Pool tables. All three of them use single set of Triggers.
Hello Sandeep,
one of the big advantages of the SLT solution is that it can deal with pool and cluster tables since the data access is done via the standard NetWeaver database library.
So, no, surely it is not a problem that these tables are pool tables.
regards,
Lars
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.