Framework Manager 10.2 Client Installation Issues

[raja1718]

Hello Folks,

I am trying to install the Framework / Transformer Client on my machine, The installation is good but getting error when I am trying to connect with any data source.

Environment : Windows 7 (64 Bit)
Cognos 10.2 (64 Bit Enabled)
Oracle 11g. Driver for (64 Bit )

But I am getting the below error.

QE-DEF-0285 Logon failure.
QE-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
testDataSourceConnection

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

Guys any solutions let me know , Thanks in advance.

Raj

[SomeClown]

did you copy the Oracle odbc drivers into the p2pd\web-inf\lib on your servers?  Path on the servers includes the Oracle libraries?

cogudaor is the call out to Oracle drivers (uda is the data access section,   or means oracle)

[MMcBride]

Why IBM did this is completely beyond me...

However...

You need to load and configure the Database Client software on your client pc.
This is true for Framework Manager and Transformer.

I found this out when I moved to AIX and I use ODBC on AIX to connect to SQL Server
When I loaded Framework Manager on a Windows "build server" even though it was plugged into my AIX Cognos protal perfectly fine I could not pull in any data/tables etc until I had created a SQL Server ODBC connection with the EXACT same name as my AIX configuration

Once I did this Framework Manager works fine - and when you publish the model it uses the Data Source connection defined in Cognos Connections

[MFGF]

If you are using CQM, the FM application contains its own embedded CQM engine so that you can continue to develop and test metadata objects if you are disconnected from the Cognos server. All you need is access to the data source(s). The consequence of this, of course, is that you need to have the database client libraries installed on your local FM machine as well as on the Cognos server (or ODBC connections etc).

If you are using DQM, access is only via the Cognos server. This means you do not have to have any database client tools or definitions on your local FM machine. It also means you cannot test run queries or update data source query subjects with new columns etc if you are disconnected from the Cognos server.

Cheers!

MF.

[raja1718]

Folks,

Thanks all for your suggestions and help finally it worked.

I just installed Oracle 11G 32 Bit Driver.

I am not sure how its driving me nuts for a while & still after installation how it worked finally.

I believe it might need 32 Bit Oracle client not matter if the machine is 64 bit or what ever for Cognos 10.2.

Thanks again

Cheers,

Raj

[MFGF]

Folks,

Thanks all for your suggestions and help finally it worked.

I just installed Oracle 11G 32 Bit Driver.

I am not sure how its driving me nuts for a while & still after installation how it worked finally.

I believe it might need 32 Bit Oracle client not matter if the machine is 64 bit or what ever for Cognos 10.2.

Thanks again

Cheers,

Raj

Yes. If you are using CQM you can only connect via the 32 bit client libraries. If you are using DQM, access is via JDBC (via the Cognos server) and you do not need any client libraries on your FM machine.

Cheers!

MF.

[sir_jeroen]

For the Oracle Contentstore you can use the 64-bit ojdbc6.jar (I even believe there's no difference between the 32 and 64-bit version)

And now the fun part:
For e.g. Report Studio you need the 32-bit Oracle client but... for Metric Studio (64-bit) you need the 64-bit Oracle client.
If you need them both to be installed you have to make sure that first the 32-bit is installed and after that the 64-bit.
This will cause the 64-bit client to be the first oracle client in your %PATH% system variable and the 32-bit the second.
If the sequence is 32 and then 64 Metric Studio won't work :D