Skip to Content
0

Not Able to delete Triggered and Logging Table in SLT (MSSQL --> SLT-ODP --> BW)

Oct 25, 2017 at 11:58 AM

175

avatar image
Former Member
Hello All,

In our project we are using SLT-ODP to extracts data from MSSQL. We have replicated some table in LTRC. Now because some reason we are tried to delete Triggered and Logging table from IUUC_REMOTE - Export function but it's showing "schema name is not provided" when we delete triggered. For Logging table deletion it's showing deleted successfully but when we check in MSSQL server both Triggered and Logging table is there.

Is there anything we need to do in order to delete Triggered and Logging Table in SLT?

Thanks and Regards,

Girish R Lakhani

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Yogesh Patel
Oct 27, 2017 at 01:22 AM
0

Hello Girish,

Please look in to SAP note : 1620618 - Delete Trigger

Thank you

Yogesh

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks Yogesh.

We have already tried this note but not worked.

We have followed following steps:

1. We have run IUUC_DELETE_TRIGGERS_REMOTE program to delete trigger.

But when I executed this program we are getting following error.

We are tried to put schema name with table name but then also we are getting same error.

Thanks,

Girish

7bhbq.png (14.7 kB)
lj3fz.jpeg (5.6 kB)
0

Hi Girish,

On same SAP note its explaining to remove at DB level. Did you try that process?

Thank you

Yogesh

0