SAP Knowledge Base Article - Preview

3413855 - Dump error for Full partition even there is other partition is empty

Symptom

There is the dump error " maximum number of rows per table or partition reached" when you access the application tables.  The dump message looks like below:

Runtime Errors         DBSQL_SQL_ERROR                                                              
Except.                CX_SY_OPEN_SQL_DB                                                            
Date and Time          26.09.2023 18:21:30                                                     
                                                                                               
Short Text                                                                                        
    SQL error "SQL code: 2055" occurred while accessing table "xxx".                    
 
What happened?                                                                                    
    Database error text: "SQL message: maximum number of rows per table or                        
     partition reached: 'xxx'"    

But when you check the details about table partitions, you find there is only one partition getting full,  some other partitions are still empty.


Read more...

Environment

  • SAP HANA Database 1.0
  • SAP HANA Database 2.0

Product

SAP HANA 1.0, platform edition ; SAP HANA, enterprise edition all versions ; SAP HANA, platform edition 2.0

Keywords

Partition, full, 2055, maximum number of rows per, empty , KBA , HAN-DB-ENG-BW , SAP HANA BW Engine , 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.