My Oracle Support Banner

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

Last updated on AUGUST 02, 2019

Applies to:

Oracle Reports Developer - Version 9.0.4.0 and later
Information in this document applies to any platform.



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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
 About the architecture
Solution
 How to break the XML output?
 Status code meaning
 Additional statusformat=xml usage
  Conclusion
References

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