HP Vertica Datasource

[MFGF]

malcolm.cantor wrote:

Hi

I wonder if you can help me please.

I have connected Cognos 10.2 to a HP vetica Datasource via the JDBC connection. The connection succeeds in Cognos admin as a dynamic connection and I am able to do the same using Framework Manager where the connection succeeds .

When I try to use the datasource in Framework manager it shows the connections as one of the selectable data sources but when I choose it the error comes up BMT-MD-5079 Failed to execute metadata request. Please check if the JDBC driver exists.

I am puzzled I have looked at the Environment variables to make sure its pointing to the correct place etc all seems fine.

This error occurs if I try to use it as a DQM source, if I uncheck DQM then I get this error
QE-DEF-0285 The logon failed.
QE-DEF-0325 The logon failed for the following reason:
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
Vertica

UDA-SQL-0432 Unable to locate the gateway "cogudajdbc".

I didn't get chance to reply to the message before he posted again:

Hi

Sorted the issue it was missing the jdbc jar file in the Web inf directory on the dispatcher.

Sorry to have troubled you

Regards

Malcolm

Glad you sorted it, Malcolm! I'm posting this up so that others with a similar issue can see the solution.

Cheers!

MF.

[satyajit.igate@gmail.com]

MF,
I am having same issue. I created a JDBC datasource using DB2 database. I am able to connect from Cognos connection>Administration. My BI server is installed in AIX server(not in windows). I have installed FM in my local system. I can view the datasource I created but when I tried to use that it throws the error below:
FYI- I have copied the "db2jcc4.jar" file in FM location: C:\Program Files (x86)\ibm\cognos\c10\webapps\p2pd\WEB-INF\lib
-----------------------------
QE-DEF-0285 The logon failed.
QE-DEF-0325 The logon failed for the following reason:
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
Satyajit

UDA-SQL-0432 Unable to locate the gateway "cogudajdbc".
------------------------------------
Any help would be appreciated.

[the6campbells]

In order to use Dynamic query and JDBC drivers your FM model must be set to Dynamic and not compatibility mode.

This is different from the inability of the JRE being able to load the JDBC driver for a specific vendor.