Symptom
- In 3rd Node HADR system, sap_enable_replication may fail with "SQL ERROR -- Message: 'Database xxx.xxx is not known as a primary database for this site.". Same error is also displayed in RMA log.
[INFO ] [Thread - 4:37902][RMA] - [CreateSubscription ] - Task Create Subscription - Action - Verifying if the subscription 'xxx_sub' for database replication definition 'xxx_repdef' exists.
[INFO ] [Thread - 4:37902][RMA] - [CreateSubscription ] - Executing 'check subscription "xxx_sub" for database replication definition "xxx_repdef" with primary at xxx.SID with replicate at SID_Site1.SID' in the Replication Server at xxx:xxx.
[TRACE] [Thread - 4:37902][RMA] - [CreateSubscription ] - Result from command:SQL ERROR -- Message: 'Database xxx.SID is not known as a primary database for this site.' SQLState: 'null' Remote Code: '15400' Cause: ''. - In the repserver Log:
ERROR #28186 dSUB( ) - eneric/sub/sub_gen.c(2217)
Error applying command at the primary Replication Server for subscription <SID_Site1_SID_sub> for database replication definition <SID_Site1_SID_repdef> with replicate at <SID_Site3.SID>
ERROR #1028 dSUB( ) - eneric/sub/sub_gen.c(2217)
Message from server: Message: 15094, State 0, Severity 12 -- 'SID_Site3.SID is not defined to the Replication Server.'.
ERROR #1028 DSI EXEC(113(3) SID_Site3.SID) - /generic/useful/cm.c(5369)
Message from server: Message: 3959, State 1, Severity 16 -- 'New transaction cannot be started as Adaptive Server is in 'Inactive' HADR state. The command could not be completed.'
ERROR #1028 DSI EXEC(113(3) SID_Site3.SID) - /generic/useful/cm.c(5369)
Message from server: Message: 4002, State 1, Severity 14 -- 'Login failed.
ERROR #1027 DSI EXEC(113(3) SID_Site3.SID) - /generic/useful/cm.c(5369)
Open Client Client-Library error: Error: 67175468, Severity 4 -- 'ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.'.
ERROR #13045 DSI EXEC(113(3) SID_Site3.SID) - /generic/useful/cm.c(5373)
Failed to connect to server 'SID_Site3' as user 'SID_maint'. See CT-Lib and/or server error messages for more information.
The DSI thread for database 'SID_Site3.SID' is shutdown.
ERROR #1028 DSI EXEC(112(2) SID_Site3.master) - /generic/useful/cm.c(5369)
Message from server: Message: 3959, State 1, Severity 16 -- 'New transaction cannot be started as Adaptive Server is in 'Inactive' HADR state. The command could not be completed.
ERROR #1028 DSI EXEC(112(2) SID_Site3.master) - /generic/useful/cm.c(5369)
Message from server: Message: 4002, State 1, Severity 14 -- 'Login failed.
ERROR #1027 DSI EXEC(112(2) SID_Site3.master) - /generic/useful/cm.c(5369)
Open Client Client-Library error: Error: 67175468, Severity 4 -- 'ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.'
ERROR #13045 DSI EXEC(112(2) SID_Site3.master) - /generic/useful/cm.c(5373)
Failed to connect to server 'SID_Site3' as user 'SID_maint'. See CT-Lib and/or server error messages for more information.
The DSI thread for database 'SID_Site3.master' is shutdown.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 with Always-on Option (HADR)
- SAP Adaptive Server Enterprise (ASE) 16.0 with High Availability Disaster Recovery (HADR) for Business Suite
Product
SAP Replication Server 16.0
Keywords
CR822871, CR#822871, 822871, sap_enable_replication, HADR with 3rd node, SQL ERROR , 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