Author Topic: cannot connect to audit DB in cognos configuration  (Read 5007 times)

Offline rashmi.cognos

  • Full Member
  • ***
  • Join Date: Dec 2014
  • Posts: 8
  • Forum Citizenship: +0/-0
cannot connect to audit DB in cognos configuration
« 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.

Offline rkadwad

  • Full Member
  • ***
  • Join Date: Apr 2007
  • Posts: 5
  • Forum Citizenship: +0/-0
Re: cannot connect to audit DB in cognos configuration
« Reply #1 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

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,273
  • Forum Citizenship: +620/-10
  • Cognos Software Muppet
Re: cannot connect to audit DB in cognos configuration
« Reply #2 on: 05 Nov 2015 03:55:52 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
Meep!

Offline screwdrive

  • Full Member
  • ***
  • Join Date: Dec 2008
  • Posts: 11
  • Forum Citizenship: +0/-0
  • It feels good to be lost in the right direction!
Re: cannot connect to audit DB in cognos configuration
« Reply #3 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.

Offline screwdrive

  • Full Member
  • ***
  • Join Date: Dec 2008
  • Posts: 11
  • Forum Citizenship: +0/-0
  • It feels good to be lost in the right direction!
Re: cannot connect to audit DB in cognos configuration
« Reply #4 on: 23 Sep 2016 01:36:21 pm »
Yes it does. I copied the ojdbc7.jar to 'drivers' directory previously by mistake.

 


       
Twittear