/
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:
Open the Employee Job/Salary program
Select Search
Enter >8 in the Hours/Day field
Select Accept
Review all returned records and make corrections as needed
Additional Information
Error messaging will be improved under low priority (master) work ticket MUN-351725.
, multiple selections available,
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