SAP Knowledge Base Article - Preview

3253625 - Route upgrade failing due to error 11069 'unique key violation' - SRS

Symptom

  • In some circumstances, route upgrade might fail due to below errors after upgrading replication server from 16.0 SP03 to 16.0 SP04:

    sysadmin upgrade,"route", <target repserver>

    2022/09/24 13:26:41. Starting Routing thread for 'servername'.
    E. 2022/09/24 13:26:41. ERROR #11069 ROUTING( ) - generic/sts/stscol.c(2501)
            unique key violation.
    I. 2022/09/24 13:26:41. Route upgrade/upgrade recovery fails due to error. The upgrade procedure is not completed. This routing thread will in turn exit.
    I. 2022/09/24 13:26:41. Routing thread for 'servername ' exiting normally.

  • in the table rs_routeversions, a strange entry(line in bold) is inserted:
     dest_rsid   source_rsid dest_rssd_id route_version min_path_version marker_serial_no status      proposed_version
     ----------- ----------- ------------ ------------- ---------------- ---------------- ----------- ----------------
    others ommitted...
    others ommitted... 
               0           0            0             0                0                1           0                0
  • from SRS log, there's the record while tracing on:
    insert rs_routeversions (dest_rsid,source_rsid,dest_rssd_id,route_version,min_path_version,marker_serial_no,status,proposed_version ) values  (0,0,0,0,0,1,0,0 )


Read more...

Environment

  • SAP Replication Server (SAP SRS) 16.0 SP04
  • SAP Replication Server (SAP SRS) 16.0 SP03

Product

SAP Replication Server 16.0

Keywords

route upgrade, sysadmin upgrade, rs_routeversions, upgrade, 822801, CR 822801, CR#822801, unique key violation , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Known Error

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.