SAP Knowledge Base Article - Preview

2974194 - Undocumented values for column rs_oqid.valid -SRS

Symptom

  • To verify the validity of a Replication connection, we could have to check the value of column "valid" of the table "rs_oqid" in the RSSD database of the replication server.
  • The following query is used to detect connection with problem :

select origin_site_id, q_number, q_type, alid, origin_lsite_id from rs_oqid where valid > 0

  • Sometime, rows are returned with undocumented values for the columns valid and q_type. Below is an example :


origin_site_id   q_number     q_type                valid      origin_lsite_id
-------------------------------------------------------------------------------
          104              104               7      1597322589                    104
          104                 0               3      1597322589                    104
          104              103               2      1597322589                    104
          108              108               7      1597322594                    108
          118              118               7      1597322590                      11

  • There is no information in documentation about such value for column valid and q_type:

Replication Server Reference Manual > SAP Replication Server System Tables > rs_oqid


Read more...

Environment

  • SAP Replication Server (SRS) 16.0
  • SAP Replication Server (SRS) 15.7.1
  • SAP Adaptive Server Enterprise (ASE) 16.0 SP03 with Always-on Option (HADR)
  • SAP Adaptive Server Enterprise (ASE) 16.0 SP03 with High Availability Disaster Recovery (HADR) for Business Suite

Product

SAP Replication Server 15.7 ; SAP Replication Server 16.0

Keywords

rs_oqid, valid, loss, rs_oqid.valid, unknown value , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-REP-SAP , Replication with SAP Suite / SAP BW , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.