COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: rashmi.cognos on 24 Mar 2015 01:01:20 AM

Title: cannot connect to audit DB in cognos configuration
Post by: rashmi.cognos on 24 Mar 2015 01:01:20 AM
Hi,

We have C8.4 installation on 2 servers, one is primary and other is secondary. We started getting error in secondary server when we test audit DB from cognos config. The eror is -

"IPFTEST-006, Logging failed to connect to database:jdbc:oracle:thin@imart:1526:cogprod"

Same audit DB is successfully tested from primary server - cognos configuration and from cognos portal. As per IBM documentation "http://www-01.ibm.com/support/docview.wss?uid=swg21371382", its a JAR file issue. But we have everything in place and the ojdbc14.jar file is same for both the servers. Also, content store is tested successfully from this secondary server. We have -

Cogos 8.4
windows server
Oracle 10.2g as CS and audit DBs.

Please help and suggest.
Title: Re: cannot connect to audit DB in cognos configuration
Post by: rkadwad on 04 Nov 2015 03:54:02 AM
Hi Rashmi,

Did you able to resolve the issue? I have the same problem with cognos 10. I have required JRE file copied to cognos location, But while testing audit DB getting this error: [Logging]
[ ERROR ] IPFTEST-006 Logging failed to connect to Database:jdbc:oracle:thin:@

If you already found solution please help
Title: Re: cannot connect to audit DB in cognos configuration
Post by: MFGF on 05 Nov 2015 03:55:52 AM
Quote from: rkadwad on 04 Nov 2015 03:54:02 AM
Hi Rashmi,

Did you able to resolve the issue? I have the same problem with cognos 10. I have required JRE file copied to cognos location, But while testing audit DB getting this error: [Logging]
[ ERROR ] IPFTEST-006 Logging failed to connect to Database:jdbc:oracle:thin:@

If you already found solution please help

Does this help?

http://www-01.ibm.com/support/docview.wss?uid=swg21371382
Title: Re: cannot connect to audit DB in cognos configuration
Post by: screwdrive on 23 Sep 2016 10:36:44 AM
Hi,

Does this solution work well with cognos analytics (11.0.3) as well? Audit Store and Content store are based on Oracle 12c DB.
Title: Re: cannot connect to audit DB in cognos configuration
Post by: screwdrive on 23 Sep 2016 01:36:21 PM
Yes it does. I copied the ojdbc7.jar to 'drivers' directory previously by mistake.