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
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.