2575890 - Oracle connection in "Awaiting Upgr" status after attempting upgrade - SRS

Symptom

After attempting to upgrade an Oracle user database connection during the upgrade of an SAP Replication Server (SRS), the error log shows:

ERROR #18076 USER(sa) - ric/useful/results.c(656)
        Unable to execute query 'select count(*) from user_tables where table_name = upper('rs_dbversion')' against server 'DCO'.
ERROR #1028 USER(sa) - ric/useful/results.c(656)
        Message from server: Message: 1445, State 0, Severity 16 -- 'ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table
'.
ERROR #18095 USER(sa) - eric/servmain/upgr.c(3389)
        Database 'DCO.DB' is not accessible.

Environment

SAP Replication Server (SRS) 15.7.1 and higher

Product

SAP Replication Server 15.7 ; SAP Replication Server 16.0

Keywords

"Awaiting Upgr", RepServer, upgrade, Oracle, DCO, connection , 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.