Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Running the replication task from SAP S4 to Azure Managed Instance. While table selection, I have used the "include" option . It will show like below
'R4S-ADDITIONAL-TABLES.%'
So whenever I add a new table under "'R4S-ADDITIONAL-TABLES", it should automatically add in the replicate server as well. But the replication task is throwing me the following errors.
Stream component 'st_0_transaction_sorter' terminated Stream component failed at subtask 0, component st_0_transaction_sorter Error executing data handler Missing transaction id for operation DDL_NONE (26)
Cannot refresh source table (41) metadata Failed on getting table definition for table 'R4S-ADDITIONAL-TABLES.T002' SAP table 'R4S-ADDITIONAL-TABLES'.'T002' not found
Request your help here.
Thanks.
since i do not see what component got the error:
but i normally see this error on SOURCE_CAPTURE and SOURCE_UNLOAD
so best to enable TRACE on SOURCE_CAPTURE and SOURCE_UNLOAD ,, reprod the issue, review the logs.
- this could be some privileges for some views missing.
Check endpoint user privileges if it has a grant of "select any table", so that if new table is added it has all privileges for it.
Hi Steve, thank you for the update. i have included the snapshot where exactly i am facing the issue. Hope that helps more.
Hi Alex, thank you for the reply. You mean to say from the source system (SAP) ? If your mentioning about the user priviliges from source system. Yes, user have the grant priviliges .