If you are unable to create a new account, please email support@bspsoftware.com

 

Error QE-DEF-0285 The Logon Failed QE-DEF-0325 Failed because RQP-DEF-0068

Started by ilikebundy, 28 Jan 2015 06:33:50 PM

Previous topic - Next topic

ilikebundy

Hi ALL
I am in need of someones help to overcome this issue as all solutions I have found by a search has failed.

Background on problem:

Cognos 10.2.1 running on Linux RHCE 6.4
Informix content store
Informix 32 Client SDK
Application also running in a 2nd instance of Informix

Everything was running perfectly.
Hostname and ip was changed.

Sqlhosts file changed on both instances of the database and in Client SDK
All url's changed in cognos with the new hostname.

Cognos starts fine but the connection strings now give the following error:

QE-DEF-0285 The Logon Failed
QE-DEF-0325 Failed because for the following reason:

RQP-DEF-0068 Unable to connect to at least one database during the multi-database attach 1 database(s) in:
testDataSourceConnection

UDA-SQL-0432 Unable to locate the gateway libcogdaif

I have done an odbc connection through the client SDK and this is successful.

I am lost on what else to do.


Daljith

Considering client is working fine, did you try opening Cognos Configuration and checked if you are able to run the test for Content Manager successfully.  If not try re-entering the password again there and check if it is working fine.

MFGF

Quote from: ilikebundy on 28 Jan 2015 06:33:50 PM
Hi ALL
I am in need of someones help to overcome this issue as all solutions I have found by a search has failed.

Background on problem:

Cognos 10.2.1 running on Linux RHCE 6.4
Informix content store
Informix 32 Client SDK
Application also running in a 2nd instance of Informix

Everything was running perfectly.
Hostname and ip was changed.

Sqlhosts file changed on both instances of the database and in Client SDK
All url's changed in cognos with the new hostname.

Cognos starts fine but the connection strings now give the following error:

QE-DEF-0285 The Logon Failed
QE-DEF-0325 Failed because for the following reason:

RQP-DEF-0068 Unable to connect to at least one database during the multi-database attach 1 database(s) in:
testDataSourceConnection

UDA-SQL-0432 Unable to locate the gateway libcogdaif

I have done an odbc connection through the client SDK and this is successful.

I am lost on what else to do.

Hi,

I think the key clue here is the following part of the message:

UDA-SQL-0432 Unable to locate the gateway libcogudaif (I'm assuming it's libcogudaif not libcogdaif?)

From my rusty memory of Cognos on Unix, I think this is telling us that Cognos 10 is unable to locate the Informix client driver on the local Linux server. If I'm remembering correctly, Libcogudaif.so tries to load the Informix client driver but when it can't find it, the library fails to load successfully and you see this error. It's worth checking your LD_LIBRARY_PATH and PATH environment variables to make sure that the Informix 32-bit libraries are referenced properly.

MF.
Meep!

ilikebundy

Thank you for your suggestions.

The Content Store test - Test OK
Cognos starts fine.

Its just the strings that fail with the error above.
I am using "Informix Dynamic Server" for the connection.
Pathing appears to be ok.
Informix Client SDK is 32 bit.

(Weird how everything worked before ip/host change )

MFGF

Quote from: ilikebundy on 29 Jan 2015 04:22:32 PM
Thank you for your suggestions.

The Content Store test - Test OK
Cognos starts fine.

Its just the strings that fail with the error above.
I am using "Informix Dynamic Server" for the connection.
Pathing appears to be ok.
Informix Client SDK is 32 bit.

(Weird how everything worked before ip/host change )

Content store connectivity is managed entirely differently, so the fact that the content store tests and Cognos starts is unrelated. The issue is with Cognos not recognising the Informix client driver I think.

What happens if you set up an entirely new connection to your Informix database from within the Cognos Admin Console? Do you see the same error? I'm wondering if you have something in the existing connection string that has the old hostname hard-coded (ie it's looking for the informix client on the wrong server)?

MF.
Meep!