Conversion overflows

agraue36 · March 30, 2022, 3:32pm

I am updating a dashboard for financials. In the test environment I created my BAQ, modified my dashboard, ran it, deployed it and all was successful. But in Live I am getting a conversion overflow error (specific error listed below). I even tried to export my BAQ from test (where there are no errors) and import it into Live and I still get the error. I don’t even know where to begin to look as the error does not list a table or field and the syntax is ok.

Severity: Error, Table: , Field: , RowID: , Text: Conversion overflows.

gpayne · March 30, 2022, 4:47pm

@agraue36 I would guess it is data related. Are there any calculations that could have large decimal results that you could round down?

fakhruddin · March 30, 2022, 4:49pm

Do you have calculated Fields in BAQ?

agraue36 · March 30, 2022, 4:54pm

Yes I have quite a few calculated fields.

agraue36 · March 30, 2022, 4:55pm

Do you mean making the format on these smaller?

fakhruddin · March 30, 2022, 4:58pm

It looks like one of the Calculated field data types does not match with the Data in live.
Try to remove calculated fields one by one and run it, you will get the column has an issue.