SAP Knowledge Base Article - Preview

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

Symptom

  • 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) 


Read more...

Environment

SAP Replication Server Real Time Loading (RTL) 16.0

Keywords

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

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.