maximum open cursors exceeded with dotConnect for Oracle

maximum open cursors exceeded with dotConnect for Oracle

Postby 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

Postby xcbroker » Thu 08 Sep 2011 17:30

Any suggestion please?
xcbroker
 
Posts: 21
Joined: Tue 07 Apr 2009 21:25

Postby 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.
Shalex
Devart Team
 
Posts: 7475
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle