Thursday, August 9, 2012

Cache Hit Statistics


Cache hits statistics can be found in the NQServer.log at the under given path;

D:\OracleBI\server\Log\NQServer.log  

[58001] Query Cache Statistics -- Hits:200(68%), Qualified Misses:27(9%), Unqualified Misses:67(23%).

Cheers and Long Live Pakistan ;)

Wednesday, August 1, 2012

OBIEE Printing to PDF Error


Error Detail;

A fatal error occurred while processing the request. The server responded with: Error while executing PDFRpcCall.processMessage java.io.IOException: Access is denied at java.io.WinNTFileSystem.createFileExclusively(Native Method) at java.io.File.checkAndCreate(File.java:1704) at java.io.File.createTempFile(File.java:1793) at com.siebel.analytics.web.javahostrpccalls.xmlp.XmlpAbstractRpcCall.processMessageInternal(XmlpAbstractRpcCall.java:34) at com.siebel.analytics.javahost.AbstractRpcCall.processMessage(AbstractRpcCall.java:94) at com.siebel.analytics.javahost.MessageProcessorImpl.processMessage(MessageProcessorImpl.java:175) at com.siebel.analytics.javahost.Listener$Job.run(Listener.java:223) at com.siebel.analytics.javahost.standalone.SAJobManagerImpl.threadMain(SAJobManagerImpl.java:205) at com.siebel.analytics.javahost.standalone.SAJobManagerImpl$1.run(SAJobManagerImpl.java:153) at java.lang.Thread.run(Thread.java:619) .


This happens due to rights issue on C:\WINDOWS\TEMP folder. Set the full rights for EVERYONE on this folder and the issue will be no more.


Cheers and long live Pakistan ;)