3464010 - How to update Maintenance User password for RTL replication to IQ - SAP SRS

• Updated the password for the Maintenance User associated to DSI connection to connect to IQ using RTL.
• The password of maintenance user for the connection IQ (using RTL) is updated with command:

• • On the Replication Server:
          alter connection to IQ_conn.IQ_db set password to <newpassword>
  • On the IQ Server:
          alter user IQ_maint identified by <newpassword>
    
    
• After stop/start the DSI connection to IQ, the folling error message are printed in 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 error 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