Oracle Reports 6i; Strange Errors
Posted on 2005-04-07
We are currently using Oracle Reports 6i for our reporting, and are experiencing errors when requests for generation of on-the-fly reports are made via our application. Reports which are not generated on-the-fly, and utilize the Oracle Queue, are being generated correctly.
I have searched the web for a resolution to this problem, to no avail. Suggestions usually revolved around restarting the Oracle Reports server, recompiling the reports, recompiling the PL/SQL, or refreshing the browser, etc. None of these resolutions worked.
The first error received in our browser was the following: "Error: The requested URL was not found, or cannot be served at this time. Oracle Reports Server CGI - The Reports Server Engine terminated abnormally." I went home last night when none of the suggestions which were implemented worked.
When I came in this morning, a more detailed error message was displayed: "Error: The requested URL was not found, or cannot be served at this time. Oracle Reports Server CGI - Report Job has terminated with error. Reports Server Replies: REP-0736: There exist uncompiled program unit(s). REP-1247: Report contains uncompiled PL/SQL."
Any assistance in solving this problem will be very much appreciated!