Symptom
Persisting a View leads to the following error:
{"correlationId":"0593d081-0699-43d3-b9bd-937c20171cdf","errorMessage":"SQL error 403: internal error: \"DWH$TEC\".\"$$VIEW_MATERIALIZATION_ON$$\": line 206 col 7 (at pos 7485): internal error: \"Xxx\".\"$$VIEW_MATERIALIZATION_INSERT_DATA$$\": line 163 col 7 (at pos 4735): Exception while processing request \"SDA Response for ABAPAdapter of type SUCCESS_MSG responding to FEDERATION_GET_NEXT\"\n at SQLScript/Executor/Evaluator/SeEvaluatorImpl_ControlFlow.cpp:315"}
Environment
SAP Datasphere
Reproducing the Issue
- Open the view in Datasphere
- Load a new snapshot for this view
- Navigate to the data integration monitor to see the above error message
Cause
The issue is caused by the mismatch of metadata of the remote table between source system and Datasphere. The same issue can be occurred due to a change in the underlying View.
Resolution
For the resolution open the concerned remote table used as the source in replication and perform refresh to bring in the latest change. Please do not forget to save and redeploy the table after refreshing the remote table.
If the problem still exists, I kindly ask you the followings:
- refer to KBA 2496051 to increase the dpagent log level to ALL/DEBUG? Reproduce the issue then refer to KBA 2807852 to get the the dpagent system dump for the investigation.
Keywords
VIEW_MATERIALIZATION_INSERT_DATA, VIEW_MATERIALIZATION_ON, SQL error 403 , KBA , DS-DI-VIW , View Persistency and Runtime , DS-DI , Data Integration/Data Builder , DS-DI-RT , Remote Tables , Problem