Oracle BI Publisher Blog

Ah, finally, I have worked a character from Sponge Bob into a blog post. I get ribbed a little at work because rather than reveal my magnificent profile picture on our employee directory I have posted a picture of the sponge.
When we first moved to California in 1999, we were avid Sponge Bob fans - as the kids have grown up we only look out for the old episodes where the writing was awesome and Sponge Bob's voice was not so danged annoying - any episode with Mr Lawrence listed as a writer and you'll find us immersed in Bikini Bottom, hangin out with the 'yellow one' and Patrick. The 'hash slinging slasher' was a ghost story character used by Squidward to try and scare 'Bob' into shutting up. If I have completely lost you, apologies, just look out for older episodes on Nickelodeon.

The post title is referring to a problem that has been cropping up recently - not earth shattering, an easy fix, if you know what to do - so Im sharing.

Those of you on 10.1.3.4 standalone or using as part of BIEE might see an error similar to this:

[121508_062307356][][STATEMENT] BI Publisher can not read or
 write the repository: C:BIPHome3/XMLP

On first glance you think, hey that looks OK but look a little, there is a 'slash' missing in that path. Thankfully the boys and gals at HQ have found out what the problem was and there is a fix on the way.

In the mean time, you just need to either update the reports repository path through the user interface Admin > System Maintenance > Report Repository. Once you add the slash back in you'll need t osave and then bounce the server. Alternatively, you can update the config file directly. You'll find the 'xmlp-server-config.xml' file under the J2EE_HOME\home\applications\xmlpserver\xmlpserver\WEB-INF.

<?xml version="1.0" encoding="UTF-8"?>

<xmlpConfig xmlns="http://xmlns.oracle.com/oxp/xmlp">

  <resource>

    <file path="d:\BI\OracleBI\xmlp\XMLP"/>

  </resource>

</xmlpConfig>

Then bounce the server to pick up the change and you're done!