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.