SAP Knowledge Base Article - Preview

3231853 - A database error occurred. The error message in the database was: "feature not supported: cannot support more than 2billion rows".

Symptom

  • A SAP client deletion is started via transaction SCC5N but fails with an exception. 

  

         

         

  

  

    

 

  • The table in question is adequately partitioned already :

 

             

 

 

  • Here is the DELETE command sent to HANA, when checked from the historic thread samples via "SELECT * FROM _SYS_STATISTICS.HOST_SERVICE_THREAD_SAMPLES WHERE THREAD_DETAIL LIKE '%DELETE FROM "EDID4"% " :

           DELETE FROM "EDID4" WHERE "MANDT" = '100'  WITH HINT( IGNORE_PLAN_CACHE )

Note: replace EDID4 with the table for which the error is thrown. This will give you the DELETE command from which you can get the column name to be used further. Then the breakdown for distinct values for that column can be checked via command select <COLUMN_NAME>, count(*) from <TABLE_NAME> group by <COLUMN_NAME>.


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

client copy, deletion SCC5N, feature not supported, partitioning , KBA , HAN-DB , SAP HANA Database , 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.