QlikView to Essbase 21c (21.5.3.0) data extraction failed with QVX_UNKNOWN_ERROR
Summary
Essbase 21c can successfully establish an XMLA connection to QlikView, but fails to retrieve data after 2 minutes. However, the MDX query triggered to Essbase completes successfully.
Content (please ensure you mask any confidential information):
Dear All,
We recently upgraded our Essbase version to 21c (21.5.3.0), and since then, we have encountered an issue with data extraction from QlikView. When we attempt to run the job from the QlikView side, we can successfully connect to Essbase (using XMLA) and trigger the MDX query. However, after approximately 2 minutes, we receive a "QVX_UNKNOWN_ERROR: Cancel - Abort reading" message, which causes the job in QlikView to terminate. Despite this, the job that was triggered on the Essbase side continues to run and completes the MDX query without any issues.