topic Re: Runtime Errors 'DBSQL_NO_MORE' in DevOps and System Administration Forum

Runtime Errors 'DBSQL_NO_MORE'

inventrax — Wed, 12 Apr 2023 07:31:27 GMT

Hello experts,

My isuue is when I am going to create a program in transaction SE37, it is throughing the Runtime error 'DBSQL_NO_MORE' with short text 'No resources available for further secondary database connections.' and 'The resources for further secondary database connections have been used up.' Can you please guide me to solve this error.

Thanking you sir.

Re: Runtime Errors 'DBSQL_NO_MORE'

matt — Wed, 12 Apr 2023 08:38:43 GMT

Your program is trying to open a secondary database connection, and there aren't enough resources to do it.

Re: Runtime Errors 'DBSQL_NO_MORE'

Sandra_Rossi — Wed, 12 Apr 2023 13:01:28 GMT

Your short dump explains why: If "Cannot open more than 16 connections" appears here, reason 2 applies. If not, reason 1 applies.

If you need further help, please attach the complete short dump as a zipped text file, not the screenshots of few first lines.

Re: Runtime Errors 'DBSQL_NO_MORE'

S_Sriram — Fri, 14 Apr 2023 17:49:56 GMT

Hi Suresh

From your primary to secondary DB connections in Sync mode? if it is yes means make the connection async and check the secondary DB data files disk space. if possible check with DB admin.

Regards

Re: Runtime Errors 'DBSQL_NO_MORE'

former_member837200 — Thu, 07 Sep 2023 14:00:33 GMT

we have the same error ? did your issue get resolved. how can we fix it ?

Re: Runtime Errors 'DBSQL_NO_MORE'

Sandra_Rossi — Fri, 08 Sep 2023 16:58:18 GMT

The OP has never answered the questions from experts here and never posted any feedback, why asking now?

Better post your own question, and PLEASE be kind by answering experts and posting a feedback to help future visitors 😉