Databases :: ORA-01000 - Maximum Open Cursors Exceeded
Jun 28, 2010
I have some problem according to nettiers generator..
i am using nettiers 2.3.0 to generate library for oracle datasource 10g.
here is the error when i am using the library..
ORA-01000: maximum open cursors exceeded
ORA-06512: at "EPROC.ADM_MENU_GETPAGED", line 40
ORA-06512: at line 1
Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OracleClient.OracleException: ORA-01000: maximum open cursors exceeded
ORA-06512: at "USERXXX.ADM_MENU_GETPAGED", line 40
ORA-06512: at line 1
I'm trying to fix an issue with an application I'm supporting (I didn't write the code). The code takes an SSRS report and renders it in pdf format. Users are sporadically getting the error indicated in the title. There is no rhyme or reason to when the error is generated (a particular report will run one time and throw the error the next). The code is below.
Public Sub OpenReport() Dim MyParms As New Generic.List(Of ReportParameter) Dim mimeType As String = Nothing Dim encoding As String = Nothing Dim extension As String = Nothing Dim deviceInfo As String = Nothing Dim streamids() As String = Nothing Dim warnings As Microsoft.Reporting.WebForms.Warning() = Nothing Dim bytes() As Byte Dim format As String = "PDF" ''#to open the report in pdf; report viewer invisible Try If dropReports.SelectedItem.Value = "1" Then If Session("IsBDAP") = True Then MyParms.Add(New ReportParameter("SCAId", dropSCA.SelectedItem.Value, False)) Else MyParms.Add(New ReportParameter("SCAId", Server.UrlEncode(Session("SCAId")), False)) End If MyParms.Add(New ReportParameter("ProviderId", dropProvider.SelectedItem.Value, False)) If dropVisit.Visible = True Then MyParms.Add(New ReportParameter("VisitId", dropVisit.SelectedItem.Value, False)) End If MyParms.Add(New ReportParameter("FY", dropContractFY.SelectedItem.Value, False)) ReportViewer1.ProcessingMode = ProcessingMode.Remote ReportViewer1.ServerReport.ReportServerUrl = New Uri(System.Configuration.ConfigurationManager.AppSettings("ReportServerURI")) ReportViewer1.ServerReport.ReportPath = Session("ReportsFolder") & "MReport" ReportViewer1.ServerReport.ReportServerCredentials = New MyReportServerCredentials() ReportViewer1.ServerReport.SetParameters(MyParms) ''#Code to convert the report to pdf deviceInfo = "<DeviceInfo>" + "<SimplePageHeaders>True</SimplePageHeaders>" + "</DeviceInfo>" bytes = ReportViewer1.ServerReport.Render(format, deviceInfo, mimeType, encoding, extension, streamids, warnings) Dim size As Integer = bytes.Length ReportViewer1.ServerReport.Refresh() Response.Buffer = True Response.Clear() Response.ContentType = mimeType Response.AddHeader("content-disposition", "attachment; filename=MReport." + extension) Response.BinaryWrite(bytes) ElseIf dropReports.SelectedItem.Value = "2" Then If Session("IsBDAP") = True Then MyParms.Add(New ReportParameter("SCAId", dropSCA.SelectedItem.Value, False)) Else MyParms.Add(New ReportParameter("SCAId", Server.UrlEncode(Session("SCAId")), False)) End If MyParms.Add(New ReportParameter("ProviderId", dropProvider.SelectedItem.Value, False)) If dropVisit.Visible = True Then MyParms.Add(New ReportParameter("FollowUpVisitId", dropVisit.SelectedItem.Value, False)) End If MyParms.Add(New ReportParameter("FY", dropContractFY.SelectedItem.Value, False)) ReportViewer1.ProcessingMode = ProcessingMode.Remote ReportViewer1.ServerReport.ReportServerUrl = New Uri(System.Configuration.ConfigurationManager.AppSettings("ReportServerURI")) ReportViewer1.ServerReport.ReportPath = Session("ReportsFolder") & "FReport" ReportViewer1.ServerReport.ReportServerCredentials = New MyReportServerCredentials() ReportViewer1.ServerReport.SetParameters(MyParms) ''#Code to convert the report to pdf deviceInfo = "<DeviceInfo>" + "<SimplePageHeaders>True</SimplePageHeaders>" + "</DeviceInfo>" bytes = ReportViewer1.ServerReport.Render(format, deviceInfo, mimeType, encoding, extension, streamids, warnings) ReportViewer1.ServerReport.Refresh() Response.Buffer = True Response.Clear() Response.ContentType = mimeType Response.AddHeader("content-disposition", "attachment; filename=FReport." + extension) Response.BinaryWrite(bytes)
I read that the default length limit is 4MB. None of the reports by themselves are even over 350K. I'm wondering if this could be caused by a caching issue. I'm not an expert, so I need some guidance as to how best to solve the problem. I also want to understand why the issue is happening. note that only 2 reports are shown in the snippet - there are about 30+ reports in the full sub. edit - I tried the proposed solution, but it didn't help (I also tried the Fiddler route, but did not see anything glaring). I thought it might be best to clarify. The reports will run fine for a while, but the execution time gradually gets slower and slower until the application eventually displays the error.
I have written an asp upload script. It works ok for small files but anything over say 4 meg and it struggles. I keep getting the following error coming up:Maximum request length exceeded. Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details: System.Web.HttpException: Maximum request length exceeded.So the above error comes up or it times out. Is there a way to modify the code so that it won't do this? I have included the code that I have written.
When uploading a file over 4mb I receive error: maximum request length exceeded. This is fine - I don't want users to upload files any larger. But, anyone know how to handle the error in a clean way? It appears I can't avoid it with an IF statement or Try/Catch block.
one of our programmers is having an issue with a asp.net app. i had him rebuild and recompile the app to the network share on the staging server and received the same error. i even deleted the files in this folder
(C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files). to make sure that the server was not the issue i installed it on another server and received the same error. i found a article on msdn that states that its a source code issue. Compiler Error Message: BC30041: Maximum number of errors has been exceeded. Source Error:
Then I found this solution online to handle the error if someone tries to upload file bigger than 10 MB
[Code]....
This works great on my local machine but when I try to run it from Production server , It still shows me the "Internet Expolrer cannot display webpage". I just want to display a nice message to user when He tries to upload file larger than 10 MB.
If I upload a file that is larger than the configs max request length I get a "Server Response Error: Unknown Server Error" alert popup. It asks if I want to see the response page and if I click "OK" an application error window pops up saying "Maximum request length exceeded." I found this already. [URL] I was unsuccessful at getting that to work.
I also found another SO question (I can't seem to find it now) that was similar. The difference was that the OP had asked how to redirect to an error page. I don't want to do that. The answer was to use a custom error redirect that gets setup in the web.config.
I simply want to absorb the error and do nothing, I'm using the OnClientUploadError event to handle the error via js. Basically, I just don't want this stupid popup message.
One odd thing is that I don't see the error when running the app locally, but I do see the error when I've got the app deployed out to our server. Note I should have mentioned that I know about the config value to set the max request length. Setting it to be very large won't work for this instance. Update So, I'm wondering if this could be something with the IIS settings of our server. It's odd that it doesn't happen locally. what I should be looking for? Most of what I find on the net suggests modifying the machine.config. However, as I said before, I don't simply want to up the allowed size. I am handling the error fine via js, I don't want this alert to show up under any circumstances. Update Well, it sounds like the IIS default limit is 30MB.
I am using DotNetNuke and I have posted this in their forum. But it is more appropriate here. I am trying to upload a 13 MB video file to my site ( a .flv file) using the file manager function under the host login. I understand that .NET limits the upload size to 4 MB for security reasons. In accordance with other posts here I added this code to my web.config file to allow bigger upload.
I added it in the system.web section. Now, I still get this error:
"An error has occurred.DotNetNuke.Services.Exceptions.PageLoadException: Maximum request length exceeded. ---> System.Web.HttpException: Maximum request length exceeded. at System.Web.HttpRequest.GetEntireRawContent() at System.Web.HttpRequest.GetMultipartContent() at System.Web.HttpRequest.FillInFormCollection() at System.Web.HttpRequest.get_Form() at System.Web.HttpRequest.get_HasForm() at System.Web.UI.Page.GetCollectionBasedOnMethod(Boolean dontReturnNull) at System.Web.UI.Page.DeterminePostBackMode() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint,
Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace.
When the user tries to upload a file with a size more than 4 MB, the AsyncFileUpload control gives a Confirmation alert (with "OK"/"Cancel" button) with the following message "Server Response error: Maximum Request Lengh Exceeded". But when the User clicks the "OK" button a new window popups and shows the server error and on clicking the cancel button the AsyncFileUpload background color turns red. Here I am not sure why the control is showing a Confirmation alert instead of a simple alert message. Is it possible to change the Confirmation alert with the simple alert message? Basically I don't want the popup window to show the server error as it is happening currently. Also, is there a better way to handle the file size error and show apporiate error message to the users?
I have developed an application using Winforms that connects to the Database using WCF services. All the services are working fine except those that return huge amount of data from the database. I did increase the size of the maxReceivedMessageSize and maxBufferPoolSize to 9223372036854775807 in the Config file of the client which I believe is the largest but I still get the error message "The maximum message size quota for incoming messages (65536) has been exceeded". I am using visual studio 2010 with VB.Net programming language on the client side and C sharp on the server.
I also goggled but the nearest solution I got was to increase the maxReceivedMessageSize which I did but in vain. Below is the detail of the error: "The server did not provide a meaningful reply; this might be caused by a contract mismatch, a premature session shutdown or an internal server error.
I get the following error from a 550 line sql statement with multiple temp tables:
"The maximum number of tables in a query (260) was exceeded."
Are there any tricks for getting rid of this error? The long query is required for this program. Will I need to build a new table before the query runs?
I am trying to Upload data from Excel file. Transfer data from Excel file to XML file and passed it to Store procedure. And insert the record into database.I also set the timeout for command to zero. when i upload 1 to 500 rows its working fine and when I upload the 10000 rows than its takes time but upload all the users successfully at localhost. But when I upload the code to remote srever,than its only upload upto 300 or 400 rows.After uploading these users it will gives the error of Request Time Out . Even more if I tried to upload 50000 rows its give me the error of 'Maximum Length Exceeded'. Can anyone tell me what the maximum size of Excel sheet to upload the users. How I can get rid of the Request Time Out Issue. How I can Increase the server response time.
I encounter "maximum length exceeded" error when I try to upload a document which is 9MB in size. I know that the issue will be solved if httpRuntime maxRequestLength and requestLengthDiskThreshold in web.config are increased but what I am looking for is how I can nicely handle the error and show the message to the user. I did try to use Application_Error event in global ascx but the event is not fired. The reason might be from Server.Transfer from DNN PageBase class's OnError method.
We have the data in excel file and want to upload the same into Oracle table.To achieve this we are using following query insert into [ODBC:Driver={Microsoft ODBC for oracle};connectionstring].tablename (select * from sheet$ ) This is working fine for less records but when the record count increases following is the error faced. Error : System Resource Exceeded
We tried the following: 1. We tried to remove connection pooling for oracle. 2. We tried to remove connection pooling for excel. 3. We also verified that only one connection for each (oracle and excel) is open.
Our assumptions: 1. Either the server setting is the issue 2. Jet oledb Driver is the issue.
Is it possible to have a stored procedure return multiple ref cursors to a .Net application? I tried this, but it didn't work.
<code> While odr.Read() dtUserData.Load(odr, LoadOption.OverwriteChanges) End While odr.NextResult() While odr.Read() dtUserRoles.Load(odr, LoadOption.OverwriteChanges) End While </code>
environment: W7 Ultimate 64, VS2008, Mysql 5.1.45, Connector .Net 6.2.2
.aspx environment: a DropDownList (DDL) triggers a DetailsView (DV). All functions (select, edit, new ...etc) work fine.
Now, in the same .aspx page I use Event "SQLDSDVKlient_Inserted" to get the Last inserted record ID using "ExecuteScalar" method! This to fill the DV with the just created record using "New" (see code below).
on "cnn.Open()" I get below error msg; Event code 3005!
Some additional info:
a) keep in mind this all happens in the same .aspx page b) In the MySQL wizard (5.1.45) I clicked the "allow remote connections". c) the ConnectionString is copied out of web.config (remind you: all 'normal' DV functions work fine.I.e. I certainly can connect to my MySQL DB.) d) When using, in ConnectionString, the parameters "Allow User Variables=True;old guids = true" I get, on statement "cnn = New Data.SqlClient.SqlConnection(connString)" a msg: Keyword not supported"; so I removed it. e) without above connectionstring parm I get on statement "cnn.Open()" below error msg: where I need help!
Questions:
1) why does the system suddenly bring the remote connection into play?; I'm always on the same machine, same .aspx page! 2) what is the role of the "mysql connector.net" (6.2.2) in this scenario ?
I have attached two databases (from an ASP.NET application to SQL Express). They have attached fine and are working alright but what disturbs me is when I go and check it from SQL management studio, I could see those databases at attached in SQLExpress but I couldn't open it out them there. I need to update them with many records and I want to open them. Any clue what I am missing? I could have sent you the screen shot but I dont know how to attach an image in this thread.
Our heavily-used VS2005 application uses CR (10.2) for an MSWord-formatted stream to a webservice, and for printing from a CRViewer. We continue to get "Failed to open report" or "The maximum report processing jobs limit configured by your system administrator has been reached". Once the error starts, the only remedy is recycling the application pool, disconnecting current users.
I have used the proper ReportDocument Close() and Dispose(), and even GC.Collect(), in Page_Unload. I upped the Print Job Limit from 75 to 300. After recycling I delete temp files.
1) Is there any way to monitor the use of the CR resources, to see when they increase and get close to the limit?
2) Is there any way to free them without having to disconnect users?
I suspect users are simply closing their browser after printing from an open CR Viewer. It would still go through Page_Unload, right? So maybe I would benefit from closing and disposing the CR Viewer in Page_Unload as well as the click that returns them to the application.
I had assumed that to permit users to page through the report, the CR Viewer had to have ViewState enabled, and remain open through Page_Unload.
I have created web application and wrote single connection string in a class file hosted at live server.
I'm getting error sometime "Connection pool size exceeded".
My other applications are hosted on same server [server1] and all application hit same server [server2] having database. Is it mean, my every application using same connnection pool because of same IIS or same memory and encountered error said "Connection pool size exceeded".
How can I get rid of this problem ? (I have already tried manipulation of pool size)
