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.