How to Know the Status of a Report Executed Via Rwservlet URL (Doc ID 412053.1)

Last updated on OCTOBER 17, 2023

Applies to:

Goal

How to get a specific job status when calling the report from other programs (i.e. java programs)? When running a report from a browser or from command line (rwclient) it is very simple to know the status of the job, as it will be display to the browser or on the same screen you use to run the report. This note offers an option to get the specific job status among other useful information.

About the architecture

Report Server works on a 3-tier architecture and  Oracle HTTP Server log (access_log) will not give the information about a specific job finished status, it will just indicate the "GET request" succeeded or failed.

You will find a similar entry like this one when calling the report on the Oracle HTTP Server log (access_log):

XXX.X.XX.XXX - - [22/Jan/2007:14:34:36 -0500] "GET /reports/rwservlet?server=reportservername
&report=test.rdf&destype=file&desformat=html&desname=d:\\temp\\test.html&userid=<user>/<password>@dbalias& HTTP/1.1" 200 778

Note that the "200" code (HTTP-200) at the end of this line does not indicate how the test.rdf report was run, if it was finished or not; it just indicated Oracle HTTP Server (OHS) "GET request" successfully got a response.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.