3691265 - View Persistency Failure When Using Remote Table based on BW Object as Source - SAP Datasphere

View persistency fails when the view uses a remote table derived from a BW object (e.g., a CompositeProvider – HCPR) as its data source.

The following error message is returned:

{"code":403, "message":"internal error: \"BASE$TEC\".\"$$VIEW_MATERIALIZATION_INSERT_DATA$$\": line 295 col 11 (at pos 11148): Error opening the cursor for the remote database <spaceid.connectionid> [SAP AG][LIBODBCHDB SO][HDBODBC] Base table not found;259 invalid table name: Could not find table/view <HCPR>-FACTVIEW in schema <spaceid>: line 1 col 6919 (at pos 6918) ", "insertingData":true}

SAP Datasphere

The underlying BW CompositeProvider (HCPR) or one of the objects included in it is not active in the BW system.
As a result:

• The corresponding generated remote table/view <HCPR>-FACTVIEW is missing in the schema.
• The system cannot open the cursor for the remote source.
• The view persistency (materialization) operation fails.

To resolve the issue:

1. In the BW or BW Bridge system, ensure that the HCPR is active.
2. Verify that all dependent objects inside the HCPR (e.g., InfoProviders, InfoObjects, etc.) are also active.
3. Reactivate the CompositeProvider if necessary.
4. After activation, confirm that the generated remote table/view (such as <HCPR>-FACTVIEW) exists and is accessible from the remote source connection.
5. Retry the view persistency operation.

View persistency, FACTVIEW , KBA , DS-DI-VIW , View Persistency and Runtime , Problem