2608634 - Invalid definition of structured privilege when use HANA external view for modified composite provider

Symptom

The composite provider was modifed and then activated successfully, but its external hana view stopped working afterwards. Received the following error when trying to data preview:

Error: SAP DBTech JDBC: [485]: invalid definition of structured privilege: Retrieving referenced objects from sql ap filter conditions failed. Reason is: Error while parsing injection query: SELECT * FROM "_SYS_BIC"."system-local.bw.bw2hana/<ViewName>" WHERE "<ColumnName>" LIKE '%' with default schema: <SchemaName>: invalid column name

Environment

SAP HANA Platform 1.0
SAP HANA Platform 2.0

SAPBW 750

Product

SAP HANA, platform edition 2.0

Keywords

Infocube, DSO, not authorized, AP, SQL prvilege , KBA , HAN-DB-ENG-BW , SAP HANA BW Engine , BW-WHM-MTD-HMOD , HANA Model Generation in BW , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.