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)
[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:
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:
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