SLT not working

[Former Member]

SLT Replication is not working in our SLT Development system

We have re-configured SLT as the source system(NON-SAP SQL Server) has been moved from one server to another server.

As part of re-configuring we did the following things

1) Stop Master job
2) Delete triggers
3) Delete logging tables
4) Delete SLT configuration via LTR
5) Re-create the configuration via LTR.

After this we see the replication is in error status.

We see errors such as below

------------------------------------------------------------------
List of Error / Warnings on Tables
Error Table XXXXX not found in the control table DMC_MT_TABLES
Error Trigger XXXXX is not active (trigger status is 0-)
Error Trigger XXXXX does not exist in the source system
Error Migration object =Z__061;Defined? = No, Generated? = No (X
= Yes, blank = No)
Error System status indicates issues with the replication process
for table XXXXX
Error System status indicates issues with the load process for
table XXXXX
Error No access plan found for table
----------------------------------------------------------------------

The above errors repeat for all tables. I have attached snapshot for
your reference.

Source System: SQL Server (Non SAP)
SLT Server  Release - Netweaver 7.4 with DMIS 2011_1_731 SP 007.
HANA  :  (Revision 85).

I have already logged a call and wanted to post here also for any advise anyone might have.

Regards
Kalyan

[Saritha_K]

Hi,

Can you please refer to note 1905420 for following the clean up of SLT configuration?

Regards,

Saritha K

[Former Member]

Thanks Saritha.

Except deleting the replication user, i have done every thing. Do you think its because of this we are missing entries in table DMC_MT_TABLES. Can you let me know your thoughts

Regards

Kalyan

[Saritha_K]

Hi Kalyana,

Your problem seems to be caused due to some inconsistency that has arised due to incomplete clean up.

I have recreated configurations many a times and have not come across like this. since its your dev system probably you can give it a try as per the note.

Parallely can you check tcodes ST22 and SM21 in your SLT system to see if there any errors being reported?

Regards,

Saritha K

[tobias_koebler]

Have you implemented all correction notes? Check if you have sufficent auth for non-SAP source connection user.

Best, Tobias

[Former Member]

Thanks Tobias.

We had issues earlier and we implemented some notes suggested by SAP as part of resolving issues back then. Also i checked the authorization on the non-sap source and the user has the required access. There are 3 DB's in the same host and all 3 use the same DB user.  The 2 DB's which are functioning are quality and production SLT systems.

Regards

Kalyan