Home » Developer & Programmer » Forms » Query in Oracle report
Query in Oracle report [message #186952] Thu, 10 August 2006 04:58 Go to next message
orafan2003
Messages: 122
Registered: February 2006
Senior Member
Hi,
I already posted the query in report section..but did not get any answer..if anyone can guide me here...i will be thankful/
I am using a distribution portlet in a portal and trying to enter report details like name of report,its location, parameters involved and when I view these applied changes, I am getting an error.
REP-56055: Exceed max connections allowed: 20" Oracle Reports Error
So to fix this I followed the following steps.
http://www.rittman.net/archives/000514.html
The problem is not fixed and all the different reports that use this distribution portlet are giving the same error. The problem is not with the distribution portlet. It is from the report side. Whe I try to open the report with its URL, it does not give me any error. Only when I put it in the distribution portlet, it gives the above error.
Any solution?
Re: Query in Oracle report [message #187097 is a reply to message #186952] Thu, 10 August 2006 21:15 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Which version of Reports , Application Server, Operating System are you using?

Have you rebooted the machine?

David
Re: Query in Oracle report [message #187139 is a reply to message #187097] Fri, 11 August 2006 01:56 Go to previous messageGo to next message
orafan2003
Messages: 122
Registered: February 2006
Senior Member
>>Which version of Reports , Application Server, Operating System are you using?
I am using Reports 10.1.2.02
Application server 10.1.2
OS Windows2000 Professional

Another problem is that everytime I open my report in the report builder, it gives me an error
REP-1247 -Report contains uncompiled PLSQL.
So I have to recompile the PLSQL everytime. Eventhough I save these changes, this error is coming up the next time.
Is there a solution for this?
Re: Query in Oracle report [message #187428 is a reply to message #187139] Mon, 14 August 2006 00:08 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Repeat: Have you rebooted the machine?

Are the DB and AS running under OS Windows2000 Professional?

David
Previous Topic: help
Next Topic: Query Problem
Goto Forum:
  


Current Time: Fri Sep 20 10:27:51 CDT 2024