That’s right. The baq_Dates never errored, even with the small datatype. It’s the other query which referenced baq_Dates that gives the error. When I refresh BAQ designer and immediately run the other query test, I get the hex error. Run again and get the truncation error. Seems to repro reliably.
1 Like
well, i cannot repro it, that is why I ask what do you have in the other query
Same on my side.
1 Like
Other Query Repro: (first make baq_Dates have a x(8) on Calculated_WeekDayName)
New Query
Add Params: Company, StartDate, EndDate
Add Refereced Query > baq_Dates
Accept defaults > save
add all fields > save
Refresh page
TEST Run > HEX ERROR
TEST Run again > TRUNCATION ERROR
i assume you add display fields too?
anyway, i did the same and i see correct error.
1 Like