Symptom
- There is table level replication with replication definitions and subscriptions in the system.
- Replication Server was upgraded from 12.6 to 15.6 previously and then again was upgraded from 15.6 to 15.7.1. After the second upgrade, the DSI EXEC process went down with ERROR #1028.
ERROR #1028 DSI EXEC(116(1) PDS.RDB)
Message from server: Message: 107, State 2, 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. - Tried to resume with skip transaction a few times. The skipped transactions were missing table owner names in their SQL statements. The table names are prefixed with '<30 spaces>.'
- For example, a skipped update SQL command may look like "update .ABCTable set col1=xxx, col2=xxxx where col3=xxx".
Read more...
Environment
- SAP Replication Server (SRS) 12.6
- SAP Replication Server (SRS) 15.6
- SAP Replication Server (SRS) 15.7.1
Product
SAP Replication Server all versions
Keywords
CR637731, 637731 , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Bug Filed
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.
SAP Knowledge Base Article - Preview