search

SAP-samples / hana-developer-cli-tool-example

Learn how to build a developer-centric SAP HANA command line tool, particularly designed to be used when performing SAP HANA development in non-SAP tooling (for example from VS Code).
Apache License 2.0
90 stars 24 forks source link

Error: invalid table name: Could not find table/view BIMC REPORTABLE VIEWS in schema SYS BI #86

Closed PavelLazhbanau closed 2 years ago

PavelLazhbanau commented 2 years ago

Hi Colleagues,

I’m trying to walkthrough the HANA DB migration jorney from NEO to CF Hana Cloud, but I’m stack on the following command

hana-cli massConvert -s C5295502 -t TWITTER_HASHTAGS true -a Here I'm trying to convert a table calld TWITTER_HASHTAGS into a cds artifact.

The output is Error: invalid table name: Could not find table/view BIMC_REPORTABLE_VIEWS in schema SYS BI: line 2 col 18 (at Dos 98).

I managed to find the root of this issue in Hana CLI tools source code. Also in official documentation I found out that this view is only available from HANA 2.0, but in my setup I use Hana 1.0 in Neo and I already checked the view is not defined in SYS_BI shcema.

image

Is it a prerequisete for hana cli to use HANA 2.0?

Best Regards, Pavel

jung-thomas commented 2 years ago

I've just pushed an updated version. Last month I added some new functionality that has special logic for Calculation Views, but this logic requires this BIMC_REPORTABLE_VIEWS. I've added a check to exclude this functionality if the target HANA system is HANA 1.0. This should fix the error you were receiving on your Neo 1.0 system.

PavelLazhbanau commented 2 years ago

Thanks, Now I can execute the script

Best Regards, Pavel