IBM Support

IBM Case Foundation Case Analyzer Error while processing WIP cubes after installing IBM Case Foundation: "Error while processing WIP cubes:{0} java.lang.Exception: A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running."

Troubleshooting


Problem

IBM Case Analyzer Error while processing WIP cubes after installing IBM Case Foundation: "Error while processing WIP cubes:{0} java.lang.Exception: A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running."

Symptom

IBM Case Analyzer full stack error when processing cubes:

Error while processing WIP cubes: {0}

java.lang.Exception: A connection cannot be made to redirector. Ensure

that 'SQL Browser' service is running.

at Microsoft.AnalysisServices.XmlaClient.GetTcpClient(ConnectionInfo

connectionInfo)

at

Microsoft.AnalysisServices.XmlaClient.OpenTcpConnection(ConnectionInfo

connectionInfo)

at Microsoft.AnalysisServices.XmlaClient.Connect(ConnectionInfo

connectionInfo, Boolean beginSession)

at

Microsoft.AnalysisServices.XmlaClient.GetInstancePort(ConnectionInfo

connectionInfo)

at Microsoft.AnalysisServices.XmlaClient.GetTcpClient(ConnectionInfo

connectionInfo)

at

Microsoft.AnalysisServices.XmlaClient.OpenTcpConnection(ConnectionInfo

connectionInfo)

at Microsoft.AnalysisServices.XmlaClient.Connect(ConnectionInfo

connectionInfo, Boolean beginSession)

at Microsoft.AnalysisServices.Server.Connect(String

connectionString, String sessionId)

at Microsoft.AnalysisServices.Server.Connect(String

at pa.amo.ProcessAnalyzerAMO.connect()

at pa.amo.ProcessAnalyzerAMO.Main(String[] argv)

at

filenet.pa.main.DTSRunner.processWIP(Unknown Source)

at

filenet.pa.main.DTSRunner.access$800(Unknown Source)

at

filenet.pa.main.DTSRunner$WIPProcessor.run(Unknown Source)

at

Caused by:

java.lang.Exception: A connection cannot be made to

redirector. Ensure that 'SQL Browser' service is running.

at Microsoft.AnalysisServices.XmlaClient.GetTcpClient(ConnectionInfo

connectionInfo)

at

Microsoft.AnalysisServices.XmlaClient.OpenTcpConnection(ConnectionInfo

connectionInfo)

at Microsoft.AnalysisServices.XmlaClient.Connect(ConnectionInfo

connectionInfo, Boolean beginSession)

at

Microsoft.AnalysisServices.XmlaClient.GetInstancePort(ConnectionInfo

connectionInfo)

at Microsoft.AnalysisServices.XmlaClient.GetTcpClient(ConnectionInfo

connectionInfo)

at

Microsoft.AnalysisServices.XmlaClient.OpenTcpConnection(ConnectionInfo

connectionInfo)

at Microsoft.AnalysisServices.XmlaClient.Connect(ConnectionInfo

connectionInfo, Boolean beginSession)

at Microsoft.AnalysisServices.Server.Connect(String

connectionString, String sessionId)

at Microsoft.AnalysisServices.Server.Connect(String

at pa.amo.ProcessAnalyzerAMO.connect()

at pa.amo.ProcessAnalyzerAMO.Main(String[] argv)

at

filenet.pa.olap.PAAMO.checkResult(Unknown Source)

at

filenet.pa.olap.PAAMO.processWIPCubes(Unknown Source)

Cause

When the DBA created the OLAP database the Default Instance Name was used for the OLAP instance.
In this case the customer had entered the database server host name for the OLAP instance setting instead of using the Default Instance Name during the installation.

Resolving The Problem

The following steps were used to resolve the issue.

  1. Stop Case Analyzer.
  2. Locate analyzer.properties file (CA_install_path\IBM\FileNet\Case Analyzer Engine\jpa).
  3. Open the analyzer.properties file in a text editor.
  4. Locate the following entry: "analyzer.olap.instance="
  5. If OLAP database was created using the Default Instance Name leave the value blank, if it was given a name during creation enter the name.
  6. Restart Case Analyzer and process cubes.

[{"Product":{"code":"SSTHRT","label":"IBM Case Foundation"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Case Analyzer","Platform":[{"code":"PF033","label":"Windows"}],"Version":"5.0","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
17 June 2018

UID

swg21696626