[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Oracle Reports 6i; Strange Errors

Posted on 2005-04-07
6
Medium Priority
?
4,799 Views
Last Modified: 2012-08-13
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.
0
Comment
Question by:Electrokardiogram
5 Comments
 

Author Comment

by:Electrokardiogram
ID: 13728567
Elaboration of the term "on-the-fly" report: the report uses cgi60, not the Oracle Queue.
0
 
LVL 3

Expert Comment

by:dnarramore
ID: 13730469
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
 

Author Comment

by:Electrokardiogram
ID: 13731926
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
 
LVL 5

Expert Comment

by:helpneed
ID: 13733483
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
 

Accepted Solution

by:
PAQ_Man earned 0 total points
ID: 13872376
Question Closed, 500 points refunded.
PAQ_Man
Community Support Moderator
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question