cancel
Showing results for 
Search instead for 
Did you mean: 

How can I re-load a table into HANA using SLT

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (4)

Answers (4)

Former Member
0 Kudos

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

rajarshi_muhuri
Active Participant
0 Kudos

as a corollary , How do I remove a table from the list of tables shown in the "data Provisioning" pane in the SQL studio ?

Former Member
0 Kudos

Hope, the problem is solved for these pool tables. If yes, could you please share the RCA, Sandeep.

Former Member
0 Kudos

Hi Tilak,

Actually I did not pursue it any further. It was in our lab environment. I haven't found any documentation regarding deleting and re-loading a table with SLT.

Thanks

Sandeep

Former Member
0 Kudos

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

lbreddemann
Active Contributor
0 Kudos

> 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