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.
Subscribe to:
Post Comments (Atom)
SPACE MANAGEMENT :: 1. Table space usuage: ============== SELECT tablespaces.tablespace_name, allocated.total_alloc allocated_mb, ...
-
On a new VIS R12.1 installation, the OHS (oracle http server) failed to start and give status 204. Upon querying the status of opmn manage...
-
Recently, I got a complaint from my AS10g users, that they are facing frequent disconnection with the server. May be due to network distrupt...
-
A nice story about RMAN. The story begins, when one of my associate DBAs did an RMAN restoration & recovery 2 days back...
No comments:
Post a Comment
Kindly make your valuable and progressive comments here.
Junks will be deleted without notice :-)