Question Re: Error DBSQL_SQL_ERROR after upgrade sap kernel from 742 to 753 in Spend Management Q&A

Error DBSQL_SQL_ERROR after upgrade sap kernel from 742 to 753

former_member322439 — Tue, 24 Nov 2020 03:22:30 GMT

Hi Expert,

How to fix the error after upgarde sap kernel from 742 to 753 ? My system is ECC6 EHP7, Linux SLES 12.5 and DB2 10.5 FP11. ST22 check below :

Category Installation Errors
Runtime Errors DBSQL_SQL_ERROR
Except. CX_SY_OPEN_SQL_DB
Date and Time 24.11.2020 10:21:15

Short Text
SQL error "SQL code: -930" occurred while accessing table "TTREE_SFW_NODES".
What happened?
Database error text: "SQL message: SQL0930N There is not enough storage
available to process the statement. SQLSTATE=57011"
What can you do?
Note which actions and entries caused the error to occur.

Consult your SAP administrator.

Using transaction ST22 for ABAP dump analysis, you can view, manage,
and retain termination messages for longer periods.
Error analysis
An exception has occurred which is explained in more detail below. The
exception is assigned to class 'CX_SY_OPEN_SQL_DB' and was not caught in
procedure
"STREE_SFW_CHECK_NODES_ACTIVE" "(FUNCTION)", nor was it propagated by a
RAISING clause.
Since the caller of the procedure could not have anticipated this
exception, the current program was terminated.
The reason for the exception is:
Database error text: SQL message: SQL0930N There is not enough storage
available to process the statement. SQLSTATE=57011
Return value of the database layer: "SQL dbsl rc: 99"

REGARDS,

Luki

Re: Error DBSQL_SQL_ERROR after upgrade sap kernel from 742 to 753

S_Sriram — Tue, 24 Nov 2020 03:35:08 GMT

Hi Luki.

Check the overall disk space in the database & log folders,

Database error text: "SQL message: SQL0930N There is not enough storage
available to process the statement. SQLSTATE=57011"

Regards

Re: Error DBSQL_SQL_ERROR after upgrade sap kernel from 742 to 753

former_member322439 — Tue, 24 Nov 2020 03:42:34 GMT

Hallo Sriram,

I check the disk space its oke not full, any ideas ?

Re: Error DBSQL_SQL_ERROR after upgrade sap kernel from 742 to 753

S_Sriram — Tue, 24 Nov 2020 05:07:36 GMT

Hi Muda.

1. Have you checked any error messages in the database level logs?

2. From the following link check the error code "SQL0930NThere is not enough storage available to process the statement." and take necessary action

https://www.columbia.edu/sec/acis/db2/db2m0/sql0900.htm

Regards

Re: Error DBSQL_SQL_ERROR after upgrade sap kernel from 742 to 753

former_member322439 — Tue, 24 Nov 2020 14:29:28 GMT

Hi Sriram,

Thanks for your answer, I'll try to check the error code from the link