15.5 Troubleshooting Information

15.5.1 Resolving Reports-Portal Integration Error When Attempting Create Resource

In Oracle Portal, when configuring Oracle Reports Security settings for Reports Definition File Access, you may encounter an error when editing a report definition file, when you click Run or Run as Portlet.

500 Internal Server Error
Unexpected Error. Please contact Administrator

This error occurs when all of the following conditions are true:

• Running in an Interop deployment (which allows for a mixed 9.0.2/9.0.4 environment), with 9.0.4 MT (mid-tier), 9.0.4 IM (Identity Management), and 9.0.2 MR (metadata repository) configured to run together.

• Running Oracle Reports within Oracle Portal, using the SSOCONN parameter.

• The connection resource specified in the SSOCONN parameter has not been created in the Oracle Internet Directory server.

To implement the workaround, perform the following steps:

1. In the 9.0.4 IM ORACLE_HOME, open the following file in a text editor:

   ORACLE_HOME/Apache/Apache/conf/mod_osso.conf 
   

2. Add the following flag:

   OssoRedirectByForm on
   

   For example:

   <IfModule mod_osso.c> 
   OssoIpCheck off 
   OssoIdleTimeout off 
   OssoConfigFile 
   /private1/iasinst/install_set1/904infra/Apache/Apache/conf/osso/osso.conf 
   OssoRedirectByForm on 
   </IfModule>