COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Administration and Security => Topic started by: nagoole on 27 Jul 2021 12:13:08 AM

Title: Cognos JDBC connection Failed
Post by: nagoole on 27 Jul 2021 12:13:08 AM
Hi all,

I tried to connect oracle DB version 19c JDBC connection but getting failed with below error. While creating the data source connection.

XQE-GEN-0002 An unexpected exception occurred: Server is sending a non-null replay context but our replayModes=[]

Please confirm which JDBC driver need to place and supported to connect 19c version.

Currently we are using OJDBC7 version.



Title: Re: Cognos JDBC connection Failed
Post by: MFGF on 02 Aug 2021 07:09:22 AM
Quote from: nagoole on 27 Jul 2021 12:13:08 AM
Hi all,

I tried to connect oracle DB version 19c JDBC connection but getting failed with below error. While creating the data source connection.

XQE-GEN-0002 An unexpected exception occurred: Server is sending a non-null replay context but our replayModes=[]

Please confirm which JDBC driver need to place and supported to connect 19c version.

Currently we are using OJDBC7 version.

Hi,

You haven't stated what version of Cognos you are using, but assuming you're on 11.x, you need the ojdbc8 driver - CA 11.x runs on JRE8. You can grab the ojdbc8 download for Oracle 19c from here:

https://www.oracle.com/database/technologies/appdev/jdbc-ucp-19c-downloads.html

Cheers!

MF.