IBM Support

Attempting to open a datasource in Cube Designer fails: invalidDriverLocation

Troubleshooting


Problem

Selecting a Dynamic Query Mode datasource in Cube Designer fails with... invalidDriverLocation

Cause

The jdbc driver files exist in the

install_location\webapps\p2pd\WEB-INF\lib

subdirectory of the Cognos Analytics server install.

Resolving The Problem

Remove the jdbc driver files from the

install_location\webapps\p2pd\WEB-INF\lib

subdirectory. They only need to exist in the install_location\drivers subdirectory.

[{"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Cube Designer v11x","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg22001693