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-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 page

This 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.