Question
After a database upgrade, a report using datetime calculations does not complete due to an arithmetic overflow error. Which of the following is the best way for a data analyst to troubleshoot the issue?
- A. Changing the report filter
- B. Reviewing error logs
- C. Verifying the columns' data types Correct
- D. Checking that the data has refreshed
Explanation
An arithmetic overflow error means a calculated value does not fit the data type that holds it, which often happens when an upgrade changes column types or defaults, for example a datetime difference that exceeds the range of an int. Verifying the columns' data types goes straight to that cause. Changing a filter only hides the symptom, checking the refresh does not explain a type error, and the error message already names the problem, so reviewing logs adds little.
