2108162 - Error HDB 02018: Cannot execute the query: invalid table type - When adding subtotal to Dimension in Lumira connecting to HANA views

SAP Knowledge Base Article - Public

2108162 - Error HDB 02018: Cannot execute the query: invalid table type - When adding subtotal to Dimension in Lumira connecting to HANA views

Symptom

  • SAP Lumira throws the error when trying to add filters on a dimension.
  • This error is in the category of "Persistance errors".

Environment

  • Lumira Desktop
  • SAP HANA Rev 81

Reproducing the Issue

  1. Connect SAP Lumira to HANA in Online mode.
  2. Create a visualization on calculation views to display dimensions and measures in a grid.
  3. Add a subtotal to Dimension.
  4. Error is returned.

Cause

  • SAP HANA Revision 81 contains an issue with auditing which is causing this problem.

Resolution

  • SAP HANA Revision 82 contains a fix to auditing for this issue.
  • Recommended solution is to upgrade to SAP HANA Revision 82 and SAP Lumira 1.19 or highher.
  • A short term workaround is to disable Auditing in the SAP HANA Revision 81 system.

Keywords

HDB_02018 HDB02018 can not , KBA , BI-LUM-DIS , Lumira Desktop/Discovery , BI-LUM-SRV , SAP Lumira Server , BI-LUM-OD , SAP Lumira Cloud , Problem

Product

SAP Lumira, desktop edition 1.0