IBM Cognos Cube Designer failed to connect with data

Technote (troubleshooting)


Problem(Abstract)

When expanding Datasources, great_outdoors_warehouse is displayed with

little exclamation warning sign. Everytime metadata is refreshed it

returns an error message "jdbcDriverNotFound"

Symptom

Error displayed when opening the sample cube model in Cube Designer (model.fmd)
from the (..\webcontent\samples\models\great_outdoors_dynamiccube\sqlserver) folder.
When expanding Datasources, great_outdoors_warehouse is displayed with
little exclamation warning sign. Everytime metadata is refreshed it
returns an error message "jdbcDriverNotFound"


Environment

IBM Cognos 10.2 32-bit
Windows 2008 R2
Microsoft SQL Server 2008 R2

Resolving the problem

Follow the steps in the Cube Designer install guide.
Then make the following changes.
Firstly change your settings in the databaseDriverLocations.properties
file removing the sqljdbc_auth.dll and adding \\ to the path. Your
setting should be as follows:

databaseJNIPath=C:\\folder1\\folder2\\auth\\x86

Save the file.

1. Add sqljdbc4.jar and sqlauth.dll to ..\v5dataserver\lib and
..\webapps\p2pd\WEB_INF\lib on the BI Server
2. Restart the BI Server.
3. Test Cube Designer.

Rate this page:

(0 users)Average rating

Document information


More support for:

Cognos Business Intelligence
Cube Designer

Software version:

10.2

Operating system(s):

Windows

Reference #:

1618358

Modified date:

2012-11-23

Translate my page

Machine Translation

Content navigation