Symptom
- A legacy application system uses a custom stored procedure for login creation.
- When it creates a new login in the primary ASE, the new login is not replicating to the companion ASE.
- The DSI thread for the master database in the companion ASE is shut down with the following error in the SRS log:
ERROR #1028 DSI EXEC(103(1) ASE_HAC.master) - neric/dsi/dsiqmint.c(5197)
Message from server: Message: 571, State 2, Severity 16 -- 'Invalid user specified, password left unchanged.'.
THREAD FATAL ERROR #5049 DSI EXEC(103(1) ASE_HAC.master) - neric/dsi/dsiqmint.c(5210)
The DSI thread for database 'ASE_HAC.master' is being shutdown. DSI received data server error #571 which is mapped to STOP_REPLICATION. See logged data server errors for more information. The data server error was caused by output command #0 mapped from input command #0 of the failed transaction.
This is the failing transaction in the outbound queue:
begin transaction
select set_enc_password(0xc007e80385750bc3cd822a0bf5369f0dce74d9d733bcd0433f6e196c747682b47467f5d55668d081209a, 'newlogin')
I. 2020/10/14 08:26:55. execute rs_update_lastcommit @origin = 104, @origin_qid = 0x00000000057732f60000fe2500080000fe2500000000ac54007e93a10000000000000001, @secondary_qid = 0x000000000000000000000000000000000000000000000000000000000000000000000000, @origin_time = '20201014 07:40:51:096', @conn_id = 0
if @@error <> 0 rollback transaction
commit transaction:
- If the new login is added using sp_addlogin, it is successfully replicated to the companion ASE. However, this legacy application system cannot be changed to use the sp_addlogin system procedure.
- Is there any way to trigger replication of the custom stored procedure that creates new logins in the master database?
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0
- SAP Replication Server (SRS) 16.0
- High Availability Disaster Recovery (HADR)
Product
Keywords
syslogins, sp_password, "database replication definition", DDL, DML, INSERT, UPDATE, DELETE, "SELECT INTO" , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To
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