HANA Live - Iot's of invalid views

[j_vandersterren]

Hi,

We just installed HANA live. In the SAP HANA Live explorer we see a lot of invalid views.

See example of one of the invalid views:

How can we evaluate why these views are invalid?

We use a SAP ECC 6.0 system.

Regards,

Jos van der Sterren

[Former Member · Accepted solution]

Hi Jos van der Sterren,

Please check the view in HANA Studio - Content under package sap.hba.apps.hcmrenewal.views. Open the view in HANA studio and check for availability of schema/tables referred in the view.

~Tarun

[j_vandersterren · Accepted solution]

Hi Tarun,

Thanks for your reply.

The view is invalid in HANA studio.

See error beneath.

Short Text

  Cannot convert the filter expression to a valid query

Cause

  Invalid syntax used in your filter expression

Recommendations

  Use valid syntax in your filter expression

Error Message

  Repository: Encountered an error in repository runtime extension;Model inconsistency. Create Scenario failed:

  ColumnTable SAP_HCM:T77S0 not found (cannot get catalog object)(CalculationNode (T77S0))

  The following errors occured: Inconsistent calculation model (34011)

  Details (Errors):

  - CalculationNode (T77S0): ColumnTable SAP_HCM:T77S0 not found (cannot get catalog object).

When I look at the tables on ECC side, I see that table T77S0 is active and available

How do I need to proceed?

Regards,

Jos.

[Former Member · Accepted solution]

Hi Jos,

The error clearly shows that the view is dependent on table T77S0 and is not able to find it. And it is looking for this table in schema SAP_HCM and not SAP_ECC.

Either all the tables from HCM should be replicated in hana in SAP_ECC schema, or a schema mapping should be created between the physical schema, where relevant HCM tables have been replicated, and the SAP_HCM, authoring schema.

~Tarun

[j_vandersterren · Accepted solution]

Hi Tarun,

Again thanks for the quick reply.

How can we replicate the tables from SAP_HCM to SAP_ECC?

Regards,

Jos.

[Former Member · Accepted solution]

You need to replicate the tables from SAP HCM system to SAP HANA database. Refer HANA Live Admin guide to understand prerequisites for HANA Live. Refer the installation Steps Sec 1.4.

Once all the relevant tables ( refer SAP Note 1849168) from SAP HCM system have been replicated in HANA then you just have to configure schema mapping. You can do this in Quick launch and define Schema mapping. The authoring schema should be SAP_HCM and physical schema as SAPHCM, assuming this is where the tables reside.

If the physical schema in HANA is SAP_HCM, then no schema mapping is needed.

~Tarun