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>
- On the Replication Server:
- 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.