Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

URGENT: SQL error 1632 occurred when accessing table

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.

Not what you were looking for? View more on this topic or Ask a question