SAP Knowledge Base Article - Preview

2988882 - Stored procedure replication fails with ERROR #1028, Message: 107- SAP SRS

Symptom

  • 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..."


Read more...

Environment

  • SAP Replication Server (SRS) 16.0
  • SAP Replication Server (SRS) 15.7.1

Product

SAP Replication Server 15.7 ; SAP Replication Server 16.0

Keywords

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-RTL , Rep Server Real-Time Loading Edition (RTLE) , BC-SYB-REP-RSO , Rep Server Options (RSO) , BC-SYB-REP-ME , Replication Server Messaging Edition (RSME) , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.