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
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.
SAP Knowledge Base Article - Preview