Symptom
- sybdbfm status reports:
node 1: server Server1, site SiteA.
db host status: OK.
db status DB INDOUBT hadr status PRIMARY.
node 2: server Server2, site SiteB.
db host status: OK.
db status DB INDOUBT hadr status STANDBY.
replication status: UNKNOWN. - dev_sybdbfm.log shows:
DB_STATUS=DB_ERROR
DB_DIAGNOSTICS=SAPSA user 'sa' failed to interact with the database (delete/insert). -
dev_sapdbctrl shows:
[PID 25870] ERROR AT sybServer.cpp:getDatabaseStatus:31945 TIME: 2020 Apr 23 15:07:55 DESCRIPTION: SAPSA user 'sa' is missing 'replication_role' in at least one replicated database LAST OS-ERROR: (0): Success
[PID 25870] ERROR AT sybOpenClient.cpp:executeQuery:2171 TIME: 2020 Apr 23 15:07:55 DESCRIPTION: Server message: Number 10353, Severity 14, State 4, Line 13, Server SID --- Message string: You must have any of the following role(s) to execute this command/procedure: 'replication_role'. Please contact a user with the appropriate role for help. LAST OS-ERROR: (0): Success
Read more...
Environment
- SAP Replication Server (SRS) 16.0
- SAP Adaptive Server Enterprise (ASE) 16.0 with Always-on Option (HADR)
Product
Keywords
RepServer, RS, FM, DB_CONNECT/SYB/SADB_USER, CHADR , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Problem
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.