- Stored procedure fails to replicate with error like below:
ERROR #1028 DSI EXEC(104(1) <DS>.<DB>) - dsiqmint.c(4445)
Message from server: Message: 107, State 1, Severity 15 -- 'The column prefix '<table_name>' does not match with a table name or alias name used in the query. Either the table is not specified in the FROM clause or it has a correlation name which must be used instead.
THREAD FATAL ERROR #5089 DSI EXEC(104(1) <DS>.<DB>) - dsiqmint.c(4470)
The DSI thread for database '<DS>.<DB>' is being shutdown. DSI received data server error #107 which is mapped to STOP_REPLICATION. See logged data server errors for more information. The error was caused by line #2 of stored procedure '<sp_name>' on the data server mapped from input command #1 (or a command before it) of the failed transaction.
The DSI thread for database '<DS>.<DB>' is shutdown.
- If the stored procedure on replicated site is run manually, it works fine without error.
- The stored procedure code contains some query like "insert into...select *from..."
- SAP Replication Server (SRS) 16.0
- SAP Replication Server (SRS) 15.7.1
RepServer, RS, ERROR #1028, Message: 107 , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-REP-HET , Replication Server Heterogeneous Edition (RSHE) , BC-SYB-REP-ME , Replication Server Messaging Edition (RSME) , BC-SYB-REP-RSO , Rep Server Options (RSO) , BC-SYB-REP-RTL , Rep Server Real-Time Loading Edition (RTLE) , How To
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.