SAP Knowledge Base Article - Preview

2980492 - Replication of a user procedure that creates logins in master database - SAP ASE 16.0 with HADR / SRS 16.0

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

SAP Adaptive Server Enterprise 16.0 ; SAP Replication Server 16.0

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.