1953194 - HANA: Error 'cannot get catalog object' during view activation

Symptom

When activating a view (it could be an attribute view, analytic view, calculation view) on HANA studio, the following error occurred:

• Internal deployment of object failed;Repository: Encountered an error in repository runtime extension;Table $varTable$ does not exist in Schema $varSchema$.
• CalculationNode (<view_name>): ColumnView _SYS_BIC:<package>/<view_name> not found (cannot get catalog object).

Environment

HANA database 1.0 all releases

Reproducing the Issue

On HANA studio, try to activate a HANA view which might include a row table.

Cause

The view that you're activating includes one or more row tables, which lead to the error.

Resolution

Convert the row table to a column table by running one of the following SQL statements in HANA studio directly:

ALTER TABLE my_table COLUMN;
ALTER TABLE my_table ALTER TYPE COLUMN;

Then re-activate all related HANA views.
For more detailed information about the SQL statement, please refer to the ONLINE help: SAP_HANA_Administration_Guide

See Also

SAP NOTE 1854804 - SAP HANA Database: Changing column property of ROW table
SAP NOTE 1908536 - BW on HANA: How to change the store type for BW InfoProvider and PSA tables

Keywords

deployment, failed, Table $varTable$, Schema $varSchema$, CalculationNode, cannot get catalog object, ColumnView, not found, row table, column table, changing column

Header Data

Released On	05.01.2015 07:18:57
Release Status	Released to Customer
Component	HAN-DB SAP HANA Database
Priority	Normal
Category	How To
Database	HDB 1.0