/
Arithmetic overflow error in TX TRS ED Generate

Arithmetic overflow error in TX TRS ED Generate



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. 











Related content

Arithmetic overflow error Generating CalSTRS Report
Arithmetic overflow error Generating CalSTRS Report
More like this
Arithmetic overflow error when generating CalPERS Payroll Contribution Report
Arithmetic overflow error when generating CalPERS Payroll Contribution Report
More like this
Payroll Earnings and Deductions error - Decimal or money value exceeds maximum precision
Payroll Earnings and Deductions error - Decimal or money value exceeds maximum precision
More like this
Hours must be a decimal between -24 and 24
Hours must be a decimal between -24 and 24
More like this
Unemployment reporting validation message - Employee has Hours Worked greater than 999
Unemployment reporting validation message - Employee has Hours Worked greater than 999
More like this
TSDS Generate - Error building staff details because column HighestCompletedLevelOfEducation truncated
TSDS Generate - Error building staff details because column HighestCompletedLevelOfEducation truncated
More like this