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
maximum open cursors exceeded with dotConnect for Oracle
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.
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.