Tuesday, November 24, 2009

Common Header and Footer with Sub Template – Part 3

You have followed my last few posts but somehow it’s not working… Yep, that can be possible and probably the following two settings would be the cause for why it’s not working. Take a look and try that out! 

Set Proxy Server for HTTP Option

If the BI Publisher is running inside the firewall then you need to set your Proxy server to your JVM for the HTTP option to work. Here is an example of how to set that for your deployment with OC4J server.

Edit OC4J Startup File

1. Open the <Oracle_Home>\oc4j\bin\oc4j.cmd file.

2. Locate the following lines starting with ‘set JVMARGS…’:

set JVMARGS=-Djava.library.path=C:\oracle\bi\server\Bin;C:\oracle\bi\web\bin-DSAROOTDIR=C:\oracle\bi

-DSADATADIR=C:\oracle\bidata -XX:MaxPermSize=128m -Xmx512m %OC4J_JVM_ARGS%

3. Insert the following string after the 'set JVMARGS=' part of the line:

-Dhttp.proxyHost=<proxy.mycompany.com> -Dhttp.proxyPort=80

4. For example, after inserting the above string, the new 'set JVMARGS=' line should look like the following:

set JVMARGS=-Dhttp.proxyHost=<proxy.mycompany.com> -Dhttp.proxyPort=80

-Djava.library.path=C:\oracle\bi\server\Bin;C:\oracle\bi\web\bin -DSAROOTDIR=C:\oracle\bi

-DSADATADIR=C:\oracle\bidata -XX:MaxPermSize=128m -Xmx512m %OC4J_JVM_ARGS%

Restart the server

After editing the command line file you need to restart the OC4J server to apply the proxy server setting.

Enable External References for File Option

When you import the sub-template you need to set ‘Disable external reference’ option to be ‘False’ to allow the main RTF template to be able to reference the Sub-Template file.

1. Open the report and go to Configure page.

2. Change the ‘Disable external reference’ value to ‘False’.


Hope now all of your reports are working fine with your Sub-Template!

No comments:

Post a Comment