Hi Experts,
i was getting this error <b>"SQL error 1632 occurred when accessing table"</b> when updating a custom table from a custom program in the back-ground. i have gone through lot of SAP Notes and forum pages what i found is, when using INSERT instead of MODIFY. my code is working fine when the extraction of records by the program is less, jobs are running successfully. i will copy my code below and dump information.
in the sap notes it was suggested to increase the table space from basis side. in my technical settings of the table i used data class as 2 (3,400 to 13000 records) if i increase this size, will it effect when its crosses the this limit is it anywhere related to this error.
Should i got for INSERT to MODIFY or change in size of table from basis side.
can anyone analyze this error and give me some solution. Points will be awarded for all answers.Thanks in advance.
Check the below dump:
Database error text........: "ORA-01632: max # extents (450) reached in index
SAPR3.ZSCBTWTRFL~001#"
Internal call code.........: "[RSQL/INSR/ZSCBTWTRFL ]"
Please check the entries in the system log (Transaction SM21).
If the error occurred in a non-modified SAP program, you may be
able to find a solution in the SAP note system.
If you have access to the note system yourself, use the following
search criteria:
"DBIF_RSQL_SQL_ERROR"
Source code extract
007050 *& *
007060 *& Form i_update_table
007070 *& *
007080 * *
007090 FORM i_update_table.
007100
007110 LOOP AT i_finaltable.
007120
007130 * Clear Work Areas.
007140 CLEAR: i_vbrk,
007150 wa_zscbtwtrfl,
007160 wa_zscbtwtrfl1.
007170
007180 READ TABLE i_vbrk WITH KEY vbeln = i_finaltable-vbeln
007190 BINARY SEARCH.
007200 IF sy-subrc = 0.
007210
007220 READ TABLE i_zscbtwtrfl INTO wa_zscbtwtrfl WITH KEY
007230 vbeln = i_vbrk-sfakn BINARY SEARCH.
007240
007250 READ TABLE i_zscbtwtrfl INTO wa_zscbtwtrfl1 WITH KEY
007260 vbeln = i_vbrk-sfakn fkart = text-026 BINARY SEARCH.
007270
007280 IF i_finaltable-fkart = text-026
007290 AND i_finaltable-oic_mot = '07'.
007300 *Pass modified date to ZSCBTWTRFL table.
007310 i_finaltable-modat = sy-datum.
007320 *Insert New Record into database table ZSCBTWTRFL
--------> INSERT zscbtwtrfl FROM i_finaltable.
007340
007350 ELSEIF i_finaltable-fkart = text-026
007360 AND i_vbrk-konda = '06'.
007370 *Pass modified date to ZSCBTWTRFL table.
007380 i_finaltable-modat = sy-datum.
007390 *Insert New Record into database table ZSCBTWTRFL
007400 INSERT zscbtwtrfl FROM i_finaltable.
007410
007420 ELSEIF i_finaltable-fkart = text-024
007430 AND i_vbrk-konda = '06'
007440 AND i_finaltable-matnr NE text-017.
007450 *Pass modified date to ZSCBTWTRFL table.
007460 i_finaltable-modat = sy-datum.
007470 *Insert New Record into database table ZSCBTWTRFL
007480 INSERT zscbtwtrfl FROM i_finaltable.
007490
007500 ELSEIF i_finaltable-fkart = text-023.
007510
007520 IF wa_zscbtwtrfl-fkart = text-026.
Active calls / events
No.... Type........ Name..........................
Programm
Include Line
1 FORM I_UPDATE_TABLE
ZSIOPITD
ZSIOPITD 733
2 EVENT START-OF-SELECTION
ZSIOPITD
ZSIOPITD 100
Internal notes
The termination occurred in the function "ExecuteCall" of the SAP
Basis System, specifically in line 5829 of the module
"//bas/46D/src/krn/runt/absapsql.c#22".
The internal operation just processed is "SQLS".
The internal session was started at 20070905100126.
Internal call code.........: "[RSQL/INSR/ZSCBTWTRFL ]"
Active calls in SAP kernel
=> 32 bit R/3 Kernel
=> 64 bit AIX Kernel
=> Heap limit = 134217728
=> Stack limit = unlimited
=> Core limit = 1073741312
=> File size limit = unlimited
=> Heap address = 0x2602a020
=> Stack address = 0x2ff1a0e0
=> Stack low = 0x2ff1a0e0
=> Stack high = 0x2ff22ae0
ABAP control blocks CONT
Include Line source code
Index Name F1 Co Par01 Par2. Par3. Par4. Tabl
ZSIOPITD 723 vbeln = i_vbrk-sfakn BINARY SE
2130 PAR2 80 79 149 342
ZSIOPITD 726 vbeln = i_vbrk-sfakn fkart = t
2132 TREA 14 79 78 87 2 2
2136 PAR2 80 79 149 342
2138 PAR2 81 150 V12
ZSIOPITD 729 AND i_finaltable-oic_mot = '07
2140 COMP 00 190 V12
2142 BRAF 02 3
2143 comp 00 78 223 343
2145 BRAF 02 8
ZSIOPITD 731 i_finaltable-modat = sy-datum.
2146 mvq2 08 5 2124 724
ZSIOPITD 733 INSERT zscbtwtrfl FROM i_final
2148 SQLS 0B
2149 SQLS 00 40
2150 NOP1 00 V2
>>>>> SQLS 0E 81
ZSIOPITD 736 AND i_vbrk-konda = '06'.
2152 BRAX 00 Branch to 3055
2153 COMP 00 190 V12
2155 BRAF 02 3
2156 comp 00 78 346 347
2158 BRAF 02 8
ZSIOPITD 738 i_finaltable-modat = sy-datum.
2159 mvq2 08 5 2124 724
ZSIOPITD 740 INSERT zscbtwtrfl FROM i_final
2161 SQLS 0B
Thanks & Regards,
Poorna.