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 "SBP"
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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.