OBIEE DiagCap.vbs

Interesting if you want have to do in-depth error research:

cscript diagcap.vbs -d temp

Found in {OracleBI}\server\Bin, it collects al the interesting logs  and configurations into 1 directory.

Till Next Time

OBIEE backslash in dashboard page name

We had this strange error the other night, a report with a report prompt placed on a dashboard came back with the logon screen every time the prompt was used more than once.
After some hours of hard core hacking we found that is was caused by a backslash “\” in the dashboard page title “revenue \ week”. Seems that under certain conditions this screws up the internal search for an open db connection. It seems to be occurring only with the combination report prompt and “\” in the dashboard title and certain connection pool configurations.
The solution: don’t use backslashes in your dashboard page title when using a report with a report prompt.
It’s a good thing to implement as standard policy to, the backslash is often an escape character within OBI EE.

Till Next Time

OBIEE Ago and and error ORA-00942: table or view does not exist

George did a good one:

http://translate.google.com/translate?u=http://bidwcz.blogspot.com/&sl=cs&tl=en&hl=en&ie=UTF-8

On how to use PERF_PREFER_INTERVAL_STITCH_JOIN here!

Till Next Time

OBIEE error saving security account

My colleague Rene Kuipers encountered this error while trying to copy reports using the catalog manager over a network share.

This was caused by the fact that the catalog manager didn't have full control over the catalog folder (read,write,create and delete).
Till Next Time