RSV-DR-0002 error in Cognos ReportNet

[donb410]

I have been struggling with this error for more than a week and needs some ideas.

When I try to run an actual report in ReportNet, I get the following error
RSV-DR-0002
Unable to execute this request.

Details:

QE-DEF-0285 Logon Failure.

QE-DEF-0285 Logon Failure.

QE-DEF-0325 The cause of the logon failure is:

QE-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
asdf_rep

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

then a Trace back follows.

I have Cognos installed on two Sun Servers with WebLogic.
Oracle is the database. When I connect either Cognos ReportNet to a database on another server, it connects fine and runs the reports. But when I try to run the reports from the oracle on the same computer, I get the above error.
At the customer site, all three (ReportNet, WebLogic, and Oracle) are running and working (although a little slow) on the same Sun Server.

It appears to be a data access problem, as I can get to and start executing the reports. They fail shortly after. Any help would be greatly appreciated!

 

[donb410]

The solution in my case was to change the LD_LIBRARY_PATH to point to $ORACLE_HOME/lib32 since the Oracle installation was 64 bits on the server that was not working, but only 32 bits on the server that was working. Further, to tell if you have a 64 bit installation or not go to $ORACLE_HOME, if there is a lib32 directory, you have a 64 bit installation.

This error is caused by a lack of communication to the Oracle Database.

There are multiple causes for this error. Use the following list to help resolve your problem.

1. When you set up the datasource in Framework Manager, for the Specify the Oracle connection string - New Data Source wizard step, be sure to check both the userID and password checkboxes.
2. Check the startup script startWebLogic.sh. If it contains a definition for LD_LIBRARY_PATH, this definition will take precedence over the user environment variable settings. Be sure that your definition for LD_LIBRARY_PATH includes the Oracle path. (In my case, I define LD_LIBRARY_PATH in my .profile file (since we do UNIX installs).
3. The local Oracle client install must be 8.1.7 or higher. If there are multiple instances of Oracle client on the machine, then Framework manager might not be talking to the right instance. Using Oracle's Home Selector, ensure that you are using the right instance. Reboot your computer for any changes to take effect.
4. The Oracle bin folder must be in the PATH variable. Put the crn/bin directory in the LD_LIBRARY_PATH. Restart Cognos ReportNet for the change to take effect. For example - LD_LIBRARY_PATH=/usr/cognos/crn/bin
I did not do this, I left it as documented in the ReportNet installation under UNIX (but this might work for you).
5. The oci.dll (this is an Oracle dll) must be in the Oracle bin directory. (local - where I had Framework Manager installed - FM only installs on PC). If you change clients, reboot your computer.

6. Ensure that the Oracle Client is 32-bit, not 64-bit. This was my problem some computers were installed with 32 bit and some with 64. I put the solution at the top so you would not have to read all the way to the end for it.



Thanks,
Don
(Perpetual Innovations, LLC)

http://www.perpetualinnovations.com

 

[the6campbells]

CRN has a layer that provides the query engine capability and within that provides gateways to interface to a specific data provider API. The error message is indicating that the share library failed to load. This means that either the actual library name is missing or more likely the required ORACLE libraries could not be located. The usual source is not having the appropriate SHLIB/LD_LIBRARY etc. pat set to point to the vendor libraries or you only have 64-bit clients installed and the 32-bit libraries cannot be found. Tools like Truss etc. allow you to watch a process running and you can see the calls being made by the dynamic loader etc. to locate files.