16.5 Troubleshooting Information

This section contains information on the various steps that you can take to rectify issues that occur.

16.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>