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.
SAP Knowledge Base Article - Preview