Arithmetic overflow error in TX TRS ED Generate

Owned by Knowledge Assistant
Sept 27, 2022
1 min read



Description of Issue

Generating ED - Employee Data Report Type in TX TRS Report and receiving an error -  


usp_TXTRS_Generate failed: <?xml version ="1.0" encoding = "windows-1252"?>

<SQLError>

<row Value = "8115 Arithmetic overflow error converting numeric to data type numeric. Line in SP:1889"/>

<SQLError>


0 records Generate.



Context

  • Payroll

  • Texas

  • TX TRS Report



Cause

Incorrect value in Employee Job/Salary Hours/Day field. 



Resolution

Correct the Hours/Day value. 

To find affected records: 

  1. Open the Employee Job/Salary program

  2. Select Search

  3. Enter >8 in the Hours/Day field

  4. Select Accept

  5. Review all returned records and make corrections as needed



Additional Information

Error messaging will be improved under low priority (master) work ticket MUN-351725.Â