Ambiguous Column Name

Kinetic ERP
, ,
1

Hello,

I am uplifting some Dashboards to the new Kinetic version and I have come across an issue with one of the grids. When I try to run the BAQ via the dashboard I get this error in Event Viewer (trace says bad sql statement and to check the logs):

Ice.Common.EpicorServerException: Query Id: zResourceGroupList. Ambiguous column name ‘ResourceGroup_Description’.

As you can see this uses the zResourceGroupList out of the box BAQ. When I open that BAQ up in BAQ designer (Kinetic version) it has zero columns on the display side.

image
image1433×815 73.7 KB

Would that cause this error? I’m just confused about the ambiguous column error.

1 Like
2

that is weird. I’d make a copy of the BAQ and add the key fields and the Description columns to the BAQ then change the dashboard to use the new BAQ.

1 Like