2974194 - Undocumented values for valid column in rs_oqid - SRS

• To verify the validity of a Replication connection, the column "valid" of the table "rs_oqid" is checked 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, valid, origin_lsite_id from rs_oqid where valid > 0

• Sometimes, 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

• 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

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