ORA-01000: maximum open cursors exceeded - Githubissues

wso2 / api-manager

All issues, tasks, improvements and new features of WSO2 API Manager

Apache License 2.0

34 stars 8 forks source link

ORA-01000: maximum open cursors exceeded #2372

Closed GihanAyesh closed 9 months ago

GihanAyesh commented 9 months ago

Description

When there is a fewer number of cursors allowed in the DB level, the ORA-01000: maximum open cursors exceeded issue occurs

Steps to Reproduce

Start APIM 3.1.0 server.
Created an API product with a large number of resources (more than 100).
Set the cursor limit to less than 100.
Go to the Devportal and subscribe to the API product and then list the application through the Devportal UI.
Then the following error can observe. [20xx-xx-2x 1x:xx:0x,xxx] [0xxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxxx7] ERROR {org.wso2.carbon.apimgt.impl.dao.ApiMgtDAO} - Failed to retrieve scopes of application_xxx_XXxxxxXxxXxXXXXxxxXxXxx java.sql.SQLException: ORA-01000: maximum open cursors exceeded

Affected Component

APIM

Version

3.1.0

Environment Details (with versions)

No response

Relevant Log Output

No response

Related Issues

No response

Suggested Labels

No response

GihanAyesh commented 9 months ago

Fix: https://github.com/wso2/carbon-apimgt/pull/10974