SAP Knowledge Base Article - Preview

2222811 - DSIs in state Awaiting Upgr after being upgraded to 15.7.1 SP300 - SAP RS 15.7.1

Symptom

  • Applied 15.7.1 SP300 to Rep Server 15.7.1 SPxxx 
  • Used repserver binary upgrade method by running 'repserver -upgr' command; no issues.
  • All connections have been upgraded except four alternate connections to IQ database.
  • admin version,'connection' shows that the default connection to IQ database has been upgraded, but the 4 alternate connections of this default connection are set to be waiting for upgrade.

1> admin version, 'connection'
2> go
Dbid         Name                                       Controller RS                     Status
----------- ------------------------------------ ------------------------------ ------------------------------------------------------------------------------------------------------
768          IQSERVER.IQDB                        RS1                                  Database has been upgraded.
1> admin who_is_down
2> go
Spid Name            State                   Info
---- --------------- -------------------- ------------------------------------------------------------
DSI EXEC              Awaiting Upgr      769(1) IQSERVER.IQ_CON01
DSI                       Awaiting Upgr      769 IQSERVER.IQ_CON01
DSI EXEC              Awaiting Upgr       770(1) IQSERVER.IQ_CON02
DSI                      Awaiting Upgr       770 IQSERVER.IQ_CON02
DSI EXEC             Awaiting Upgr       772(1) IQSERVER.IQ_CON03
DSI                      Awaiting Upgr      772 IQSERVER.IQ_CON03
DSI EXEC             Awaiting Upgr       771(1) IQSERVER.IQ_CON04
DSI                      Awaiting Upgr       771 IQSERVER.IQ_CON04

sysadmin upgrade ,'database' command didn't upgrade those alternate connections
1> sysadmin upgrade, 'database', 'IQSERVER','IQ_CON01'
2> go
1> resume connection to IQSERVER.IQ_CON01
2> go
Connection to 'IQSERVER.IQ_CON01' is resumed.
1> admin who_is_down
2> go
Spid Name            State                   Info
---- --------------- -------------------- ------------------------------------------------------------
DSI EXEC             Awaiting Upgr       769(1) IQSERVER.IQ_CON01
DSI                      Awaiting Upgr      769 IQSERVER.IQ_CON01
DSI EXEC             Awaiting Upgr       770(1) IQSERVER.IQ_CON02
DSI                      Awaiting Upgr       770 IQSERVER.IQ_CON02
DSI EXEC             Awaiting Upgr       772(1) IQSERVER.IQ_CON03
DSI                     Awaiting Upgr       772 IQSERVER.IQ_CON03
DSI EXEC             Awaiting Upgr       771(1) IQSERVER.IQ_CON04
DSI                     Awaiting Upgr       771 IQSERVER.IQ_CON04


Read more...

Environment

  • SAP Replication Server (RS) 15.7.1 SPxxx
  • SAP Replication Server (RS) 15.7.1 SP300

Product

SAP Replication Server 15.7

Keywords

CR790325, 790325 , 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.