COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: hrk551 on 24 Feb 2011 08:28:57 AM

Title: Tables not loading in AUDIT
Post by: hrk551 on 24 Feb 2011 08:28:57 AM
 Hi all,

I know there are several threads on this  kind of subject but unfortunatly I could not find the onw whaich fits for my situation. Hope some one can help me.
I am able the retrieve data for user session, logon etc. But there is no datafor reports viewed or packages used. In the cognos administration I have set logging level to basic for my dispatchers. Here I see one when this is set to Basic then "ACQUIRED" is "NO" so I did a reset to parent values for logging which brings logging level to Request and Acuired to "YES", but there is no data in view reports. Can someone help me.

Thanx
Title: Re: Tables not loading in AUDIT
Post by: AussiePete2011 on 27 Feb 2011 11:20:47 PM
Hi there,

To be able to answer this question you'll need to provide more information
1.  The version of Cognos being used - see the cmplst.txt file for information on the version and build found under the ../<cognos install dir>
2.  The database vendor, version and build
The Audit database uses the jdbc driver so the question in step 2 needs to be answered to provide an answer for which jdbc driver is required.
See 
http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.inst_cr_winux.8.4.1.doc/inst_cr_winux_id18117SetUptheDatabaseClientforaLoggingD.html

Once the above is defined, then you also need to confirm if you are using a supported version against the database.
You can check this by locating the Cognos Supported environments page
E.g. 8.4.1 - https://www-304.ibm.com/support/docview.wss?uid=swg27017522

Hope this helps
Cheers
Peter B