Oracle Reports 6i; Strange Errors

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!

Thanks much.
ElectrokardiogramAsked:
Who is Participating?
 
PAQ_ManConnect With a Mentor Commented:
Question Closed, 500 points refunded.
PAQ_Man
Community Support Moderator
0
 
ElectrokardiogramAuthor Commented:
Elaboration of the term "on-the-fly" report: the report uses cgi60, not the Oracle Queue.
0
 
dnarramoreCommented:
Can you compile the report?  Perhaps there's a little compilation error, like the name of a field changed or something like that, maybe.

I'm assuming you know how to compile a report.
0
 
ElectrokardiogramAuthor Commented:
Thanks for your reply, "dnarramore". Please reread my original post - I already tried recompilation.

It turns out that there appear to be some bugs in Oracle Reports 6i, and this is probably one of the reasons some of the other groups at work have upgraded to Oracle Reports 10g.

One bug is the fact that Oracle Reports 6i will indicate a successful compile sometimes when the compile really was not successful. Essentially, the successful compile message will be displayed, but checking the Program Units section of a report to make sure no units have an asterisk by them will verify whether the compile was truly successful. A colleague of mine pointed this out - this is not a very intuitive feature of the product.

Another bug is the fact that, when calling stored procedures that have optional parameters from a unit within Program Units, the optional parameters apparently need to be specified within the call - as soon as I supplied these parameters, which were coded as being optional in the associated packages, the report successfully compiled with no asterisks. This is also a very annoying feature of which I was not aware - Oracle Reports should adhere to PL/SQL rules when calling PL/SQL!

This question is now closed.
0
 
helpneedCommented:
hi

check the following

Open up a seeded reports and see the before report trigger. I remember SRW.INIT and something else that must exist.

Check the way you transfer it.. Make sure it is binary transfer and also do you have any attached library plls

You can also try converting your report by using the Report Compiler , this should be installed with the standard installation of Oracle Reports 6i

try to gtant execute on the package to public and see

regards
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.