Dashboard Error

Epicor ERP 10
1

I’m getting this error while working on a dashboard. Any ideas?

Application Error

Error Detail

Message: WC-ShipmentsPerCustomer-By Order: View Filter exception. View Filter not applied. A DataColumn has been dropped from BAQ results table.
Inner Exception Message: Cannot perform ‘=’ operation on System.Int32 and System.String.
Program:
Method:

Inner Exception

Cannot perform ‘=’ operation on System.Int32 and System.String.

Inner Stack Trace

at System.Data.BinaryNode.BinaryCompare(Object vLeft, Object vRight, StorageType resultType, Int32 op, CompareInfo comparer)
at System.Data.BinaryNode.EvalBinaryOp(Int32 op, ExpressionNode left, ExpressionNode right, DataRow row, DataRowVersion version, Int32[] recordNos)
at System.Data.BinaryNode.Eval(DataRow row, DataRowVersion version)
at System.Data.DataExpression.Invoke(DataRow row, DataRowVersion version)
at System.Data.Index.AcceptRecord(Int32 record, IFilter filter)
at System.Data.Index.InitRecords(IFilter filter)
at System.Data.Index…ctor(DataTable table, IndexField[] indexFields, Comparison`1 comparison, DataViewRowState recordStates, IFilter rowFilter)
at System.Data.DataTable.GetIndex(IndexField[] indexDesc, DataViewRowState recordStates, IFilter rowFilter)
at System.Data.DataView.UpdateIndex(Boolean force, Boolean fireEvent)
at System.Data.DataView.UpdateIndex(Boolean force)
at System.Data.DataView.SetIndex2(String newSort, DataViewRowState newRowStates, IFilter newRowFilter, Boolean fireEvent)
at System.Data.DataView.SetIndex(String newSort, DataViewRowState newRowStates, IFilter newRowFilter)
at System.Data.DataView.set_RowFilter(String value)
at Ice.UI.Dashboard.DashboardView.ApplyViewFilter(IPublisher pub, PublishEventArgs args)

2

Did you change the underlying BAQ?

3

No. This is the same error I got when i was using the built in CSR-Dashboard in Epicor. SO i decided to copy and redo it from the beginning. Got the same errors, even without the customization built into the system one. Just can’t seem to pin it down. It only affects the By Order ones, so I may just delete those and do it differently.