3464010 - Problem after updating the password of the Maintenance User for RTL replication to IQ - SAP SRS

• Error messages are being reported in RS and IQ error logs after updating the password of the Maintenance User associated with a DSI connection for connecting to IQ using RTL.
• The password of the Maintenance User for the connection to IQ (using RTL) is updated in two different places using commands:

• 1. On the Replication Server:
           alter connection to IQ_conn.IQ_db set password to <newpassword>
  2. On the IQ Server:
           alter user IQ_maint identified by <newpassword>
     
     
• After stopping and starting the DSI connection to IQ, the following error messages are printed in the Replication Server errorlog:

                   I. 2024/04/18 08:39:18. Retry of a grouped transaction of 3 individual transactions has failed in database 'IQ_conn.IQ_db'. It will be broken into smaller groups and retried.
                       E. 2024/04/18 08:39:18. ERROR #1028 DSI EXEC(103(1) IQ_conn.IQ_db) - neric/dsi/dsiqmint.c(5055)
                               Message from server: Message: -1003002, State 0, Severity 14 -- 'SQL Anywhere Error -1003002: CtLibrary Error: 44, Severity: 0, Origin: 1, Layer: 4
                       Error Message: ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.
                       OS Error: 0,.

• At the same time, the following errors start to be printed in the IQ errorlog :

                       I. 04/18 04:08:40. 0000002823  I. 04/18 04:08:40. Exception Thrown from hqmlib/hqm_con.cxx:199, Err# 1, tid 23 origtid 23
                       I. 04/18 04:08:40. 0000002823    O/S Err#: 0, ErrID: 8192 (hqm_exception); SQLCode: -1003002, SQLState: 'QHA02', Severity: 14
                       I. 04/18 04:08:40. 0000002823 [20174]: CtLibrary Error: 44, Severity: 0, Origin: 1, Layer: 4
                       Error Message: ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.
                       OS Error: 0, OS Message: ---. 
                       -- (hqmlib/hqm_con.cxx 199) 

SAP Replication Server Real Time Loading (RTL) 16.0

maint_user, maintenance user, RTL, alter connection, alter user IQ_maint identified by <newpassword>, -1003002, 44, connect to the server failed,ErrID: 8192, hqm_exception , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Problem