Sunday, February 7, 2016

2135985 - SAP HANA: Can't unload index exception when unloading Column Store Tables

Symptom
After upgrading to HANA Revision >= 92, the Indexserver trace contains many error messages like the following:
[45436]{-1}[15/-1] 2015-02-10 01:30:32.478991 e tableload TableLoad.cpp(00856) : exception occurred during unload of SCHEMA:TABLEPART (38655):ContainerName $ns$ - $n$ not found.
[45436]{-1}[15/-1] 2015-02-10 01:30:32.478991 e SERVER_TRACE TRexApiSystem.cpp(00192) : unassign: can't unload index SCHEMA:TABLEPART (38655): An unknown exception occurred;object=SCHEMA:TABLEPARTen,ContainerName $ns$ - $n$ not found.(1972)


Other Terms
SAP HANA, L2-Delta Migration, Table Unload


Reason and Prerequisites
When upgrading from older SAP HANA Revisions to SAP HANA SPS09, Column Store Tables are migrated to a new Column Store format (L2-Delta).
If the table runtime data was accessed before the L2-Delta migration, e.g. by querying M_CS_TABLES, a subsequent table unload produces the error messages mentioned above.
Prerequisites:
  • The SAP HANA Database was upgraded to HANA Revision >= 92.


Solution
Apply SAP HANA database Revision 94 or later.
Remarks:
  • The issue does only happen for Column Store Tables that were not migrated and does not have any negative side effect apart from the errors in the Indexserver trace.
  • To avoid the error messages, you can load all ColumnStore Tables into Memory which triggers the L2-Delta migration.




Header Data

Released On 23.03.2015 12:41:03
Release Status Released for Customer
Component HAN-DB SAP HANA Database
Priority Correction with medium priority
Category Program error

No comments:

Post a Comment