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.