SAP Knowledge Base Article - Preview

1940888 - ERROR #1028: The column prefix '.<table_name>.' does not match with a table name - SRS

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.