New Jobs Do Not Get Listed In The Showjobs Page
New Jobs Do Not Get Listed In The Showjobs Page
Titleimage
Posted by Patrick Hamou on 2017:09:19 16:15:21
APPLIES TO: Oracle Reports Developer
Oracle Reports Developer - Version 11.1.1.2.0 and later
Information in this document applies to any platform.
SYMPTOMS: old jobs, report
ACTUAL BEHAVIOR
---------------
When accessing
http://host:port/reports/rwservlet/showjobs?server=RptSvr_host_asinst_1
Only old jobs are shown, from days ago but not the recent launched ones
EXPECTED BEHAVIOR
-----------------------
See jobs from today.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Ran any report, verify it runs correctly
2. Access http://host:port/reports/rwservlet/showjobs?server=RptSvr_host_asinst_1
CAUSE: Standalone Reports server configuration
This Standalone Reports server has been configured to use "Job Status Repository DB" and "Job Repository DB and the table
RW_SERVER_JOB_QUEUE is not being updated.
SOLUTION: Job Status Repository, ORACLE_INSTANCE
1.- If you do not really need to record the jobs on the database then you could
disable the "Job Status Repository DB" and "Job Repository DB"
a) Make sure that the standalone reports server is down, before you proceed with any change.
b) Backup the correspondent rwserver.conf then take away the sections "Job Status Repository DB" and "Job Repository DB" using the EM Console
c) Move/delete the current $ORACLE_INSTANCE/reports/server/rptsvr_host_asinst_1.dat, to force the creation of a new one when the reports server gets re-started
d) Start the reports server
OR
2.- If you need the jobs in the database then
a) Make sure that the connection information provided in the Job Status Repository is correct (use sql*plus from the midtier to verify connection and credentials)
b) Make sure that the user specified in the connection information does have the needed tables Note:858200.1
c) verify there are no space limits on the database for the chosen user, check database logs for possible error with this user
d) Re-start the standalone reports server and make sure that the rwserver process gets created on the databsae side Note:1306209.1
Posted by Patrick Hamou on 2017:09:19 16:15:21