SAP Knowledge Base Article - Preview

1923830 - Unable to authenticate Sybase IQ from SCC - JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reasons -- SAP IQ 16 (15)

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.