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
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.