An Oracle blog about BI Publisher

  • September 30, 2008

Got a Upgrade Issue?

Over the past week I have received a few mails concerning a problem in some upgrades. They all seem to be related to a full BIEE upgrade rather than a BIP upgrade. the dev team are still investigating as it seems to be hard to reproduce, but just in case you are out there suffering ... we have a solution.

If you have specifically chosen to upgrade in the installer process and find that you can not get into the BI Publisher server interface after upgrading to Trying either from the More Products > BI Publisher link in BIEE or going directly to the BIP server you get a user security error. You will hopefully have hit an issue that was found today. The fix is simple enough, it looks as thou the /Admin/Security/security.xml file contains some incorrect entries. The sample file we saw today had the following:


<allow path="/Business Intelligence" />

<allow path="/Executive" />

<allow path="/Financials" />

<allow path="/HR Manager" />

<allow path="/Marketing" />

<allow path="/Sales Manager" />

<allow path="/Supply Chain Management" />

<allow path="/Training" />

<allow path="D:/OracleBI/xmlp/XMLP/Reports/Business Intelligence" />

<allow path="D:/OracleBI/xmlp/XMLP/Reports/Executive" />

<allow path="D:/OracleBI/xmlp/XMLP/Reports/Financials" />

<allow path="D:/OracleBI/xmlp/XMLP/Reports/HR Manager" />

<allow path="D:/OracleBI/xmlp/XMLP/Reports/Marketing" />

<allow path="D:/OracleBI/xmlp/XMLP/Reports/Sales Manager" />

<allow path="D:/OracleBI/xmlp/XMLP/Reports/Supply Chain Management" />

<allow path="D:/OracleBI/xmlp/XMLP/Reports/Training" />


The entries in red are incorrect. Just simply remove them from the file, save it and bounce the server and all should be well. Investigations are ongoing to check why they entries were in there and as soon as I have some confirmation I will let you know.

If you have hit this issue, can you share the OS and platforms you upgraded on. The install.log file located at $BIHome/BIServer/log would be very useful along with the steps you took during the install, if you can remember.

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.