maximum open cursors exceeded with dotConnect for Oracle

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
xcbroker
Posts: 21
Joined: Tue 07 Apr 2009 21:25
Contact:

maximum open cursors exceeded with dotConnect for Oracle

Post by xcbroker » Tue 06 Sep 2011 20:00

Hi

We are using dotConnect version 5.35.79 in our custom Web Parts to connect to Oracle database. The web parts are used in SharePoint site and on this particular SharePoint webpart page, we have about 16 webparts on it. The web parts are querying oracle views and all the views are returning multiple rows of data. As soon as the page loads, it throws the following error:

An error occured while connecting to database: Error = ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
ORA-00604: error occurred at recursive SQL level 1
ORA-01000: maximum open cursors exceeded
ORA-01000: maximum open cursors exceeded
ORA-02063: preceding 5 lines from FRED
ORA-02063: preceding 6 lines from GUPS_EDW_LINK.WORLD; Command Type = Text; Command= select * from VW_FRED_SURFACES_DATA where GENERAL_PERMIT_APP_ID = :permit;

In the connection string, when we add the attribute DIRECT=TRUE in the connection string, page loads fine but since we need to support RAC, this won't work for us.

When we add the attribute POOLING=OFF in the connection string, page loads fine but Pooling=off is not recommended.

Increased the MAXPOOLSIZE to 500, but it still didn’t work.

If the number of webparts using the views are limited to 12 (using stored procedure in the other 4 webparts) page loads the data without any error.

Thanks,
Sean

xcbroker
Posts: 21
Joined: Tue 07 Apr 2009 21:25
Contact:

Post by xcbroker » Thu 08 Sep 2011 17:30

Any suggestion please?

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 09 Sep 2011 17:27

1. How are you retrieving data from your database? Maybe, you are not closing readers, etc. If possible, try to localize the issue and send us a small test project with the corresponding DDL/DML script to reproduce the problem in our environment.

2. Does the problem persist with the latest (6.50.214) build of dotConnect for Oracle? If you do not have access to the registered version, trial can be downloaded from http://www.devart.com/dotconnect/oracle/download.html. Also try the "Validate Connection=true;" connection string parameter with the new version.

3. Try another version of Oracle client.

Post Reply