2175609 - HANA metadata integrator cannot collect the SQL of HANA views

Symptom

• HANA metadata integrator cannot collect the SQL information of HANA views
• The SQL of the views shows <unknown> or empty

Environment

Information Steward 4.2 SP4

Reproducing the Issue

Configure a HANA integrator and run it, check the SQL information in metadata management.

Cause

The HANA database user used to configure HANA integrator has no enough permission to get the SQL information of the HANA views.

Resolution

Grant CATALOG READ role to the user used to configure the HANA integrator.

Keywords

null, blank, space, nothing, right, authentication

Header Data

Released On	03.06.2015 00:25:59
Release Status	Released to Customer
Component	EIM-IS-MM Information Steward - Metadata Manager
Priority	Normal
Category	Problem