Symptom
- A query from an ABAP program like 'SELECT "COLUMN" , "COLUMN" , . . . FROM "KONV" WHERE "MANDT" = ? AND "COLUMN" = '' AND " " . . . . ' dumps an exception and triggers an ABAP Dump (ST22 tcode) :
Installation error category
Runtime error DBSQL_SQL_ERROR
Exception CX_SY_OPEN_SQL_DB
Date and time 06/24/2022 10:56:16
short text
SQL error "SQL code: 129" occurred when accessing table "KONV".
What happened?
Database error text: "SQL message: transaction rolled back by an internal
error: Search result size limit exceeded: 10486773317"
. . . . . . . . .
----------------------------------------------------------------------------------------------------
|Source Code Excerpt |
|--------------------------------------------------------------------------------------------------|
|Line|Source |
|--------------------------------------------------------------------------------------------------|
| 512|*& Form CHECK_KONV |
| 513|*&---------------------------------------------------------------------* |
| 514|* text * |
| 515|*----------------------------------------------------------------------* |
| 516|* --> p1 text |
| 517|* <-- p2 text |
| 518|*----------------------------------------------------------------------* |
| 519|FORM check_konv. |
| 520| |
| 521| DATA x_title LIKE boole-boole. " 9.9.98 MG |
| 522| |
| 523| DATA: BEGIN OF i_konv_little OCCURS 1. |
| 524| DATA: waers LIKE konv-waers. |
| 525| DATA: END OF i_konv_little. |
| 526| |
| 527| DATA BEGIN OF i_konv_shown OCCURS 1. |
| 528| INCLUDE STRUCTURE i_konv_little. |
| 529| DATA END OF i_konv_shown. |
| 530| STATICS: LC_KKURS_INIT LIKE KONV-KKURS VALUE IS INITIAL. |
| 531| |
| 532| flag = 'KONV'. |
| 533| |
| 534| SORT i_tcurc. |
| 535| |
| 536| DATA c1 TYPE cursor. |
| 537| OPEN CURSOR c1 FOR SELECT knumv kposn stunr zaehk waers |
| 538| FROM konv |
| 539| WHERE WAERS >< SPACE AND KINAK = SPACE |
| 540| AND KKURS <> LC_KKURS_INIT. |
| 541| DO. |
|>>>>>| FETCH NEXT CURSOR c1 |
| 543| INTO CORRESPONDING FIELDS OF TABLE i_konv |
| 544| PACKAGE SIZE 20. |
| 545| IF sy-subrc <> 0. |
| 546| CLOSE CURSOR c1. |
| 547| EXIT. |
| 548| ELSE. |
| 549| CLEAR i_konv_little. REFRESH i_konv_little. |
| 550| LOOP AT i_konv. |
| 551| MOVE-CORRESPONDING i_konv TO i_konv_little. |
| 552| APPEND i_konv_little. |
| 553| ENDLOOP. |
| 554| LOOP AT i_konv_little. |
| 555| READ TABLE i_tcurc WITH KEY waers = i_konv_little-waers |
| 556| BINARY SEARCH. |
| 557| IF sy-subrc >< 0. |
| 558| IF x_title = ''. " 9.9.98 MG |
| 559| PERFORM title_konv. " 9.9.98 MG |
| 560| x_title = 'X'. " 9.9.98 MG |
| 561| ENDIF. " 9.9.98 MG |
----------------------------------------------------------------------------------------------------
. . . . . . .
--------------------------------------------------------------------------------------------------------
|Database Interface Information |
|--------------------------------------------------------------------------------------------------|
|C|E| EXECUTE() OF C_0408, #REC=0, RC=1, RCSQL=129 [/BAS/753_REL/SRC/DBS/HDB/DBSDBSQL.CPP#2184] |
|C|E|EXECUTE C_0408 ON CONNECTION 0, RC=129 [/BAS/753_REL/SRC/DBS/HDB/DBSLSDB.CPP#10078] |
|C|1|SQLCODE : 129 [/BAS/753_REL/SRC/DBS/HDB/DBSDBTRC.CPP#512] |
|C|1|SQLERRTEXT : TRANSACTION ROLLED BACK BY AN INTERNAL ERROR: SEARCH RESULT SIZE LIMIT EXCEEDED: |
|C|1|SC_P=7FFE67787E60,NO=408,IDC_P=7FFE677E81A8,CON=0,ACT=1,SLEN=138,SMAX=256,#VARS=2,STMT=7FEC195|
|C|1|STMTID = <12/ /147/20220709001510> [/BAS/753_REL/SRC/DB|
|C|1|'SELECT "COLUMN" , "COLUMN" , . . . FROM "KONV" WHERE "MANDT" = ? AND "COLUMN" = '' AND " " |
|C|1|'<>' AND "COLUMN" = '<>' ; [/BAS/753_REL/SRC/DBS/DBFUN/DBSC.C#2428] |
|B|E|***LOG BYO=> DEADLOCK ABORTS TRANSACTION [DBSH#1221] |
|B|E|***LOG BY4=> SQL ERROR 129 PERFORMING PRE ON TABLE KONV [DBDBSLST#5138] |
|B|E|***LOG BY0=> TRANSACTION ROLLED BACK BY AN INTERNAL ERROR: SEARCH RESULT SIZE LIMIT EXCEEDED: |
|B|1|DUMPING DBDBSLSTATEMENT ... [/BAS/753_REL/SRC/KRN/DBI/DBSQL/DBDBSLSTATEMENT.CPP#3394] |
|B|1|DBSL_SS( AMODE=DBSL_ACC_SL STMTID_PTR=7FEC18E70368 DBSL_STMTID( TYP=12 MOD=" |
|B|1|DBSL_DA( LOCKTYPE=DBSL_LOCK_DEF INCNT=2 INMAX=2 OUTCNT=5 OUTMAX=5 BULK_CB=117DDFD48 STA|
|B|1| IN [ 0]: DBSL_TYPE( TYPE=DBSL_DATA_SHORT_CHAR(11) LEN=6 MAXLEN=6 DECS=0 NULLABLE=FALSE |
|B|1| IND=0 PTR=7FFD55FC7F00 DATA= [/BAS/753_REL/SRC/KRN/DBI/DBSQL/DBDBSLSTATEMENT.|
|B|1| IN [ 1]: DBSL_TYPE( TYPE=DBSL_DATA_DECIMAL(0) LEN=5 MAXLEN=5 DECS=5 NULLABLE=FALSE FLAG|
|B|1| IND=0 PTR=1002A8D4962 DATA= [/BAS/753_REL/SRC/KRN/DBI/DBSQL/DBDBSLSTATEMENT.C|
|B|1| OUT[ 0]: DBSL_TYPE( TYPE=DBSL_DATA_SHORT_CHAR(11) LEN=20 MAXLEN=20 DECS=0 NULLABLE=FALSE|
|B|1| IND=0 PTR=0 [/BAS/753_REL/SRC/KRN/DBI/DBSQL/DBDBSLSTATEMENT.CPP#3394] |
|B|1| OUT[ 1]: DBSL_TYPE( TYPE=DBSL_DATA_NUMC(6) LEN=12 MAXLEN=12 DECS=0 NULLABLE=FALSE FLAGS|
|B|1| IND=0 PTR=14 [/BAS/753_REL/SRC/KRN/DBI/DBSQL/DBDBSLSTATEMENT.CPP#3394] |
|B|1| OUT[ 2]: DBSL_TYPE( TYPE=DBSL_DATA_NUMC(6) LEN=6 MAXLEN=6 DECS=0 NULLABLE=FALSE FLAGS=0|
|B|1| IND=0 PTR=20 [/BAS/753_REL/SRC/KRN/DBI/DBSQL/DBDBSLSTATEMENT.CPP#3394] |
|B|1| OUT[ 3]: DBSL_TYPE( TYPE=DBSL_DATA_NUMC(6) LEN=4 MAXLEN=4 DECS=0 NULLABLE=FALSE FLAGS=0|
|B|1| IND=0 PTR=26 [/BAS/753_REL/SRC/KRN/DBI/DBSQL/DBDBSLSTATEMENT.CPP#3394] |
|B|1| OUT[ 4]: DBSL_TYPE( TYPE=DBSL_DATA_SHORT_CHAR(11) LEN=10 MAXLEN=10 DECS=0 NULLABLE=FALSE|
|B|1| IND=0 PTR=2A [/BAS/753_REL/SRC/KRN/DBI/DBSQL/DBDBSLSTATEMENT.CPP#3394] |
|B|1| - FDA PARAMS: LEVEL: DBDBSLFDASTATUSSETBYDBSL(1) [/BAS/753_REL/SRC/KRN/DBI/DBSQL/DBDBSLSTAT|
----------------------------------------------------------------------------------------------------
- Investigation into the table shows billions of records, even when properly partitioned. M_TABLE_PARTITIONS 'RECORD_COUNT' per partition for example, shows over a billion records per partition.
1,080,847,960
1,078,973,785
1,082,427,064
1,080,635,255
1,080,556,141
1,084,760,720
. . . . . . . . . . .
""> Read more...
Environment
SAP HANA, platform edition 2.0
SAP HANA, platform edition 1.0
Product
SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0
Keywords
KBA , HAN-DB-ENG , SAP HANA DB Engines , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.