You can either use rwservlet/showjobs or Enterprise Manager Fusion Middleware Control (EM FMW Control) to view reports jobs which were either run successfully or failed. In rare occurrences, when trying to view the Reports Jobs in EM for a reports server, the following error may show up:
To fix this error, you will need to do the following:
- Shut down WLS_REPORTS
- Go to %ORACLE_INSTANCE%\reports\server
- Backup the file ‘name_of_reports_server_used.dat’
- Rename the file which you created a backup
- Start up WLS_REPORTS
You should now be able to view reports jobs in EM.
There is also a second similar error known as well:
“Failed to get requested metrics from the EM Agent.
Error connecting to report_server:OHS_port return status = -1”
To fix this error, you will need to do one of the following:
- Make an edit to the targets.xml file for the EM Agent:
- Go to %ORACLE_INSTANCE%\EMAGENT\%AGENT_NAME%\sysman\emd
- Open targets.xml in WordPad or a text editor other than Notepad
- Update HTTPPort to the OHS port you are using and update Servlet to the listen address you use for reports
- Save and close the file
- Reboot EMAGENT from OPMN
- Add ‘listen 8888’ to httpd.conf and restart OHS from OPMN
You should now be able to view reports jobs in EM.
NOTE: Applying the modification for the first error will lose any report server history and all scheduled jobs on the current 11g reports server. If there is a list of scheduled jobs, you would need to reschedule them after applying the above steps.
Reference: Oracle Support note 387541.1
