3165574 - Data Preparation for HANA Calculation Views Fails with Code 11204 - SAP Data Intelligence

You want to do data preparation for a HANA calculation view with mandatory input parameters, it fails with following error:

Module
dh-app-preparation
Code
11204
Message
Retrieving dataset preview from flow agent was unsuccessful
Detail
{"response":{"statusCode":400,"body":{"code":"10001","guid":"<*>","message":"Failed to get dataset data for ... ","module":"flowagent","hostname":"data-hub-flow-agent-bb951ad6a2e9052102822e-b8b2d-6587ffd6fm9z67","causes":[{"code":"1300037","message":"Failed to execute query ..."Failed to get dataset data for <CV_name>. ","module":"flowagent","hostname":"data-hub-flow-agent-bb951ad6a2e9052102822e-b8b2d-6587ffd6fm9z67","causes":[{"code":"1300037","message":"Failed to execute query ...]}}

HANA Index Server trace error is like:

[51179]{252840}[1959/-1] 2022-02-22 01:39:02.487156 e CalcEngine       ceInstantiationHandler.cpp(00280) : CalcEngine Exception: exception 306106: Undefined variable: $$<variable_name>$$. Variable is marked as required but not set in the query.

Prepare data, HANA calculation view, code 11204, Data Intelligence, Undefined variable , KBA , CA-DI , Data Intelligence , Problem