Symptom
- SCC will not authenticate IQ Database in the Perspective Resources Window.
- There are no issues logging into IQ with the same login/password with Interactive SQL (DBISQL)
- The following Error is returned in the SCC console, and the SCC Logs (agent.log, gateway.log, IQMAP.log):
Security error for '<IQ Server>' (SCC login DBA) JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reasons()"
The following IQ Messages may also be seen in the console window:
I. 09/18 15:58:25. TCP/IP: Received connection request from <IP Address>.
...
I. 09/18 15:58:26. TDS 1: login: user 'DBA', database '', application 'SCC_IQ-130918-15:58:25 404', host '<Hostname>', host_pid '2557', charset ''
I. 09/18 15:58:26. Connection ID 1: "DBA" connected to database "<Database Name>" over TCPIP
I. 09/18 15:58:26. Connection ID 1: AppInfo is HOST=<Hostname>;PID=2557;EXE=SCC_IQ-130918-15:58:25 404
I. 09/18 15:58:26. Connection ID 1: Server character set conversion will occur database character set is "CESU-8" using client character set "UTF-8"
I. 09/18 15:58:26. TDS 1: request complete
I. 09/18 15:58:26. Connection ID 1: connection "DBA" terminated abnormally
I. 09/18 15:58:26. Connection ID 1: Disconnected TCPIP client's AppInfo is HOST=<Hostname>;PID=2557;EXE=SCC_IQ-130918-15:58:25 404
I. 09/18 15:58:26. Connection ID 1: "DBA" disconnected from database "<Database Name>"
I. 09/18 15:58:26. Connection ID 1: Client disconnected
Read more...
Environment
SAP Sybase IQ 14
SAP Sybase IQ 16
SAP Sybase Control Center 3.2.x
Product
SAP IQ 16.0 ; SAP Sybase IQ 15.4
Keywords
SCC,3.2.7 , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed
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