SAP Knowledge Base Article - Preview

3454727 - The column prefix 's' does not match when executing rs_stat_populate -SRS

Symptom

When trying to Build the Sybase Replication Server with the new version of SP04 PL05. It is giving the following error when executing the , Procedure 'rs_stat_populate_sqt'. 

The procedure rs_stat_populate_sqt is part of the script in $SYBASE/$SYBASE_REP/scripts/rs_install_statreport_v1510_ase.sql

...creating table: rs_statreport
...creating procedure: rs_stat_populate_netspd
...creating procedure: rs_stat_populate_rat
...creating procedure: rs_stat_populate_sqmw
...creating procedure: rs_stat_populate_sqt
Msg 107, Level 15, State 1:
Server 'XXXXXX_XXXXXX_XXXX_XXXXX', Procedure 'rs_stat_populate_sqt', Line 281:
The column prefix 'c' 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.


Read more...

Environment

SAP Replication Server (SRS) 16.0

Keywords

rs_install_statreport_v1510_ase.sql rs_stat_populate_sqt Msg 107 column prefix match table name or alias name  , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Problem

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.