Kinetic Dashboard does not display data with Ice.Common.EpicorServerException

Kinetic ERP
1

I am running 2023.1.6
I have a BAQ that runs in a Classic Dashboard no issues. No Sort or Parameters.
The BAQ also runs and returns the correct result when I execute it in running the new BAQ web app.
When I create an Application Studio Wizard Kinetic Dashboard in the webapp and try to Preview or refresh the dashboard I get this message in Epicor App Server event viewer. The exception about invalid column name is for a subquery 6 layers into the BAQ. Again this BAQ executes in the BAQ Designer perfectly. Suggestions???

"The description for Event ID 0 from source IceAppServer cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

Ice.Common.EpicorServerException: Invalid column name ‘Calculated_BLDueToShop’."

2

There’s an issue where the grid is trying to display columns from the subquery. If I recall, the fix is to go into the grid’s properties > Data > Grid Model > Columns and then delete the extra columns from the subquery. I’ll see if I can find the related thread.

This is similar:

2 Likes
3

I ran the Guided Setup per the link you provided and changed no settings. Ran the preview again and it worked.

We are spinning up a test server with the latest version for any future tests i am going to create. Hopefully this will make the process go smoother.

Thanks for the quick response.

2 Likes