SAP Knowledge Base Article - Public

3063477 - Error "dberror(PreparedStatement.executeQuery): 2048 - column store error: search table error: [6981] hierarchy index type BLOB build error on hierarchy" occurs in Data Action Import

Symptom

When you import from a Data Action, below error displays

"An unexpected technical error occurred and has been logged.
dberror(PreparedStatement.executeQuery): 2048 - column store error: search table error: [6981] hierarchy index type BLOB build error on hierarchy "TENANT_A"."$MDX//TENANT_A/t.G:JP_SUSS_FUNDCODE//hier/PARENTH1" error:Source query execution error on [JP_SUSS_FUNDCODE].[PARENTH1]: error:SQL: insufficient privilege: "

Environment

SAP Analytics Planning

Reproducing the Issue

Deploy> Import for the Data Actions

Cause

This is a known issue of SAC.

Resolution

Our development team is working on a fix.

Keywords

2048 - column store error; search table error: [6981]; hierarchy index type BLOB build error on hierarchy; error:Source query execution error;  error:SQL: insufficient privilege , KBA , LOD-ANA-PL-DA , Data Actions , Problem

Product

SAP Analytics Cloud all versions