Report Server issue in 10gAS

We were running 10gAS on test server initially and it needs to be migrated from test server to apps server. It (test) was configured with report server "rep_hostname".

Apps server already been installed with AS (same version), but it was running with different report server (rep_apps_oraclehome1).

We overwrote all the fmx,fmb and rdf in apps, with the same from test. But the report server was not running. No report is popping up.

Tried to start "sh rwserer.sh server=rep_hostname" , but that made no sense. Error "frm-41213- unable to connect to report server rep_hostname"

Then tried, this url.
http://vidyabala.blogspot.com/2006/10/configuring-oracle-10g-reports-in.html

added rep_hostname to opmn service. This new service was started up fine. But the report was not popping up. Error frm-41214- unable to run report.

I went to check the report job status on "http://sever-name:7778/reports/rwservlet?servername=rep_hostname". All jobs were in status unable to run.

Clicked on one un-run report and it shown " Terminated with error:
REP-271468672: Unable to create a temporary file." .

That's the hint!!!!

The temp folder location mentioned in $ORACLE_HOME/reports/conf/rep_hostname.conf file's "tempDir" value, was not actually exists.
Then I created a temp folder on that location with proper permissions.

That's the fix. The reports are now running fine.

No comments:

Post a Comment

Kindly make your valuable and progressive comments here.
Junks will be deleted without notice :-)

 SPACE MANAGEMENT :: 1. Table space usuage: ============== SELECT tablespaces.tablespace_name,          allocated.total_alloc allocated_mb, ...