Adhoc and Calc script failing after migration to 11.2.19.
We are trying to migrate from EPM 11.2.14 to 11.2.19 in a Windows 2019 environment. Exported a planning application from old version to the new version and seems to work fine except for an Adhoc query in SmartView. It gets a "Invalid Form" error when the Total Cost account is included. The identical adhoc works when it's pointed to the old version but not in the new.
| AP |
|---|---|
| PPBE26-F |
| Entity |
| Plan |
| FY25 |
| YearTotal |
Total Cost | 5,826,616 |
Total Transactions | 80,917 |
Rates | 72.01 |
Appreciate any help trouble shooting this.
Also have a couple of calc scripts that run against the same RATES cube that the adhoc is using. All I see is a message that they failed but nothing about why. Again this is only in the new version of Planning and Essbase.