Skip to main content

Unable to successfully test the Content Store database (Oracle) from within Cognos Configuration


Technote (troubleshooting)


Problem

Administrator launches Cognos Configuration. Administrator opens the 'Data Access - Content Manager' section. Administrator right-clicks on the Content Store, and chooses 'test'. Administrator receives error message:

[Content Manager database connection]
1. [ ERROR ] The database connection failed.
2. [ ERROR ] Content Manager failed to start because it could not load driver "oracle.jdbc.driver.OracleDriver".



Cause

Cognos Configuration cannot read the required Oracle driver file. It requires ojdbc14.jar.

Resolving the problem

Do not use the Cognos Configuration tool for testing the JDBC connection to the Cognos Content Store.

Instead use the following method:

1) Open command prompt.

2) Navgiate to the directory where you extracted the CognosConfig.zip|.tar package

3) Ensure that the JDBC driver file has been copied to the <CognosConfig>/BI-Customization/JDBC folder; if not, copy it there now.

4) Run the following commands:
Windows:
set cp=.;"%CD%\lib\*";"%CD%\BI-Customization\JDBC\*"
java -classpath %cp% com.ibm.connections.metrics.cognos.install.CognosDBJDBCConnectionVerifer cognos.db.type cognos.db.host cognos.db.name cognos.db.user cognos.db.password

Linux, AIX:
export cp=".:`pwd`/lib/*:`pwd`/BI-Customization/JDBC/*"
java -classpath $cp com.ibm.connections.metrics.cognos.install.CognosDBJDBCConnectionVerifer cognos.db.type cognos.db.host cognos.db.name cognos.db.user cognos.db.password

where
cognos.db.type, cognos.db.host , cognos.db.name, cognos.db.user, cognos.db.password are the values specified in the cognos-setup.properties file



Rate this page:

(0 users)Average rating

Copyright and trademark information

IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.

Rate this page:


(0 users)Average rating

Add comments

Document information

IBM Connections

Install


Software version:
4.0


Operating system(s):
AIX, Linux, Linux zSeries, Windows


Reference #:
1609831


Modified date:
2012-08-31

Translate my page

Content navigation