Support Article
BatchUpdateException: Arithmetic overflow error
Summary
BatchUpdateException is generated in the Pega logs.
Error Messages
[egaRULES UsageDaemon] [STANDARD] [ ] [ ](nitor.internal.UsageDaemonImpl) ERROR - Unable to save usage data to the database; verify that the table for Log-Usage has the correct schema
[egaRULES UsageDaemon] [STANDARD] [ ] [ ](nitor.internal.UsageDaemonImpl) ERROR - Error occurred while attempting to commit
[egaRULES UsageDaemon] [STANDARD] [ ] [ ](nitor.internal.UsageDaemonImpl) ERROR - Usage Failure Reason 1: Arithmetic overflow error converting numeric to data type numeric.
DatabaseException caused by prior exception: java.sql.BatchUpdateException: Arithmetic overflow error converting numeric to data type numeric.
| SQL Code: 8115 | SQL State: S0008
[egaRULES UsageDaemon] [STANDARD] [ ] [ ] (nitor.internal.UsageDaemonImpl) ERROR - Usage Failure Reason 2: Arithmetic overflow error converting numeric to data type numeric.
[egaRULES UsageDaemon] [STANDARD] [ ] [ ] (nitor.internal.UsageDaemonImpl) ERROR - Usage data discarded
Steps to Reproduce
Not Applicable
Root Cause
Issue with table connected to the log-Usage class. The below columns did not define a property value when the datatype is defined.
- pxDecryptCount
- pxDecryptCPU
- pxDecryptElapsed
- pxEncryptElapsed
- pxEncryptCPU
- pxEncryptCount
Resolution
Perform the following local-change:
- Back up the pr_perf_stats database table.
- Execute the Alter commands.
alter table <PegaDataSchema>.pr_perf_stats alter column pxDecryptCount numeric(18,6);
alter table <PegaDataSchema>.pr_perf_stats alter column pxDecryptCPU numeric(18,6);
alter table <PegaDataSchema>.pr_perf_stats alter column pxDecryptElapsed numeric(18,6);
alter table <PegaDataSchema>.pr_perf_stats alter column pxEncryptElapsed numeric(18,6);
alter table <PegaDataSchema>.pr_perf_stats alter column pxEncryptCPU numeric(18,6);
alter table <PegaDataSchema>.pr_perf_stats alter column pxEncryptCount numeric(18,6);
Published February 10, 2020 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.