Question Re: SQL Caught Rabax in Technology Q&A

SQL Caught Rabax

i_only — Mon, 22 Jul 2024 04:04:44 GMT

Dear All,
Please help for this problem,
pop-up always show when user access tcode

this what i got from sbwp

I am using SAP_BASIS 754

Thanks

Re: SQL Caught Rabax

S_Sriram — Mon, 22 Jul 2024 05:15:30 GMT

1. Check the free disk space in the DB and SAP USR folders.

2. Share the full dumps as a text file attachment.

Regards

Re: SQL Caught Rabax

alex_frank — Mon, 22 Jul 2024 06:29:27 GMT

Hi,

The dump occurs in a Z transaction, which means it's not part of the standard SAP shipment, but was created in your customer system. So you'll have to debug it on your side. Likely there's an SQL statement which is not selective enough and returns way too many rows.

BR,
Alex

Re: SQL Caught Rabax

S_Sriram — Mon, 22 Jul 2024 06:41:19 GMT

Hi Alex,

Since it is a Z transaction you have to enable the ST12 trace to check the overall expense SQL statement with the help of ABAPer to fix or create the Z index for the expense SQL statement to avoid the dumps.

Regards

Re: SQL Caught Rabax

Sandra_Rossi — Mon, 22 Jul 2024 06:46:40 GMT

Indexing of the question: SQL_CAUGHT_RABAX, TSV_TNEW_PAGE_ALLOC_FAILED.

Re: SQL Caught Rabax

Sandra_Rossi — Mon, 22 Jul 2024 06:48:38 GMT

No need to use ST12, the faulty SELECT is shown in the short dump, and it's not an index problem, the problem has been explained by @alex_frank.

Re: SQL Caught Rabax

Sandra_Rossi — Mon, 22 Jul 2024 06:49:17 GMT

It's not a database space problem, the problem has been explained by @alex_frank.

Re: SQL Caught Rabax

S_Sriram — Tue, 23 Jul 2024 06:19:40 GMT

Hi All, While executing the Z-transaction it is pulling a huge amount of data from the DB, the dump shows that the ABAP program error and TSV_TNEW_PAGE_ALLOC_FAILED, you have to enable the trace to analyze z transaction to fix the issue.

Re: SQL Caught Rabax

qwertie — Wed, 24 Jul 2024 11:02:06 GMT

Hello,

it seems one buffer is not sufficient in your system (check st02) . Mostly it is the heap memory. you can adjust it with restart or on the fly with the following report RSMEMORY

Re: SQL Caught Rabax

qwertie — Wed, 24 Jul 2024 11:02:30 GMT

Re: SQL Caught Rabax

qwertie — Mon, 29 Jul 2024 13:46:48 GMT

hi there, you can also try to have a look in st02. there you should find the buffer which is not sufficient. furthermore you can then adjust it on the fly with rsmemory. mostly it is the heap buffer