IBM Support

i2 Analyze SQL Server Connector Creator query fails with runtimeException

Troubleshooting


Problem

In i2 Analyze, after connecting to a SQL Server data source using Connector Creator, the query execution fails with   "java.lang.RuntimeException: There was an error while making the HTTP request please check the logs for more information."

Cause

This error on query:


 java.lang.RuntimeException: There was an error while making the HTTP request please check the logs for more information. 

usually indicates that there is some configuration problem that is preventing the query from executing.

Resolving The Problem

Check your data source configuration.

  • Examine your JDBC driver settings in server.datasources.xml  for any typos in <library>  and <dataSource>  settings.
  • When connecting to SQL Server, ensure that the SQL Server Browser service is running.

[{"Product":{"code":"SSXVTH","label":"i2 Analyze"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF033","label":"Windows"}],"Version":"4.1.1;4.1.2;4.1.3;4.1.4;4.1.5;4.1.6","Edition":"","Line of Business":{"code":"LOB24","label":"Security Software"}}]

Document Information

Modified date:
16 June 2018

UID

swg22013426