We migrated some reports from UAT to PROD. The reports work well in the UAT OBIEE. But after the migration we get an error in few reports. The error is as follows.
[nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 42015] Cannot function ship the following expression: EVALUATE. (HY000)
The EVALUATE_SUPPORT_LEVEL = 2; in the NQS config file. I followed the below DOC ID and this seems to be fine as well. (Doc ID 1982475.1).
I tried to reproduce this issue by copying the EVALUATE formula which is giving me the error in a new analysis, but it seems to be working fine. I do not understand why this particular report throws such an error. Kindly help.