SAP Knowledge Base Article - Preview

3012042 - Password change causes DSI Down in MSA due error 4002 - SRS

Symptom

DSI for master database was down due to changing login password. There is error 4002 in the log:

=====

E. 2021/01/12 04:47:30. ERROR #1028 DSI EXEC(103(1) server02.master) - /generic/useful/cm.c(5376)
 Message from server: Message: 4002, State 1, Severity 14 -- 'Login failed.
'.
E. 2021/01/12 04:47:30. ERROR #1027 DSI EXEC(103(1) server02.master) - /generic/useful/cm.c(5376)
 Open Client Client-Library error: Error: 67175468, Severity 4 -- 'ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.'.
E. 2021/01/12 04:47:30. ERROR #13045 DSI EXEC(103(1) server02.master) - /generic/useful/cm.c(5380)
 Failed to connect to server 'server02' as user 'login01'. See CT-Lib and/or server error messages for more information.
I. 2021/01/12 04:47:30. The DSI thread for database 'server02.master' is shutdown.
....
....
I. 2021/01/12 04:47:55. The DSI thread for database 'server02.master' is started.
I. 2021/01/12 04:47:55. begin transaction 
I. 2021/01/12 04:47:55. exec sp_password_rep @caller_password=NULL , @new_password=70xc007a8f06807cce550e9b9589185d2bca28948feaf33b19de3a680344e2401dc27464f68a6aa8184bcdd, @loginame=NULL , @immediate=0
I. 2021/01/12 04:47:55. execute rs_update_lastcommit @origin = 102, @origin_qid = 0x0000000000019b96000016b50004000016b400040000acae004ef5f00000000000000001, @secondary_qid = 0x000000000000000000000000000000000000000000000000000000000000000000000000, @origin_time = '20210112 04:47:29:226', @conn_id = 0
I. 2021/01/12 04:47:55. if @@error <> 0 rollback transaction
I. 2021/01/12 04:47:55.  commit transaction

=====

** disclaimer: the original 'password' from customer's system was deleted and add a fake password - this is test data **


Read more...

Environment

  • MSA
  • Replication Server 16.0 SP03 PL08
  • Adaptive Server Enterprise 16.0 SP03 PL08

Product

SAP Replication Server 16.0

Keywords

login failed error 4002 sp_password MSA master database chnage password DSI down , 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.