SAP HANA Model Validation and DataPreview Error

[ChengJiajia]

Dear Expert,

We get some trouble when Data Preview the build HANA Model on HANA rev 91.

Here is a sample CA view, quite simple, only 2 tables join together. And it works fine on the same HANA db with rev91 several weeks ago.

When clicking the data preview button, hana studio now did not generate the expected data preview window. When using the SQL editor to data preview the Calculation View, it automatically generate below ERROR and trying to find the BIMC_DIMENSION_VIEW under SYSTEM schema.
This is quite different than before!
Since my understanding when data preview HANA model, it should go to query the column view under _SYS_BIC.
And I try to manually query the column view _SYS_BIC.TRAINING.02_TextJoin/ZCA_TEXT_JOIN  it still work.

Then I try to copy the HANA model to another CA named ZCA_TEXT_JOIN_001, make NO change, and activate the model again. The activation failed with below ERROR. ..

Repository: Encountered an error in repository runtime extension; Index $IDX$ out of range[$BEG$,$END$)

I also attached the related information in indexserver trace. BTW, this data preview error and activation error not only happened in this model.
All the other HANA model on this system, all have this  issue. Seems like a system wide problem.

Let me known if you have any idea about this! Thanks a million.

indexserver_trace.txt.zip

[lbreddemann · Accepted solution]

Hi Echo,

the MDX query is performed by the data preview to figure out what dimensions and keyfigures are defined in the model. That has been done as long as there had been data preview in SAP HANA Studio.

So, it's nothing new.

As you keep writing after "before", "now" and "after" - the obvious question seems to be: what element did change?

From the indexserver trace excerpt you posted it looks like the text join definition in the model got somehow messed up. Maybe deleting the join and putting it in again will help here.

Another - maybe related - point is the actual MDX error message: looks like the access to the virtual MDX view BIMC_DIMENSION_VIEW doesn't deliver the correct structure (column DIMENSION_NAME is apparently not there).

Had there been a failed upgrade attempt on this SAP HANA instance? Maybe the catalog and system objects are invalid.

- Lars

[ChengJiajia · Accepted solution]

Hello Lars,

Thanks for the reply. It is more like the last attempting of upgrade this HANA box has encountered some issues. We also guess there  should be something wrong with catalog and system object.

We have re-install the HANA box, and upgraded to the latest revision.

Now the system is working fine.

Thanks!

Echo Chen