Numeric Overflow Error seen when attempting to mask data in TDM Portal

book

Article ID: 222413

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

After upgrading to TDM Portal 4.9.345.0, we started seeing "Numeric Overflow" errors when attempting to run a certain masking job.

{\"rowsNotMaskedInCurrentRun\":\"0\",\"rowsMaskedInCurrentRun\":\"0\",\"rowsNotMaskedInPreviousRuns\":\"0\",\"rowsMaskedInPreviousRuns\":\"0\"},\"SOT22.SOT22.CLM_CLAIM\": ... Line 15612: 2021-08-23 19:30:09.347 UTC [INFO ] [SimpleAsyncTaskExecutor-7] --- [U:][M:][P:] c.c.t.f.s.CallFastDataMasker: runFDM: job: 1440: fdm#: 0 state: FAILED schema:<hostname>.SOT22 errors: (1) <hostname>.SOT22: Numeric Overflow Line 15630: 2021-08-23 19:30:09.347 UTC [ERROR]

 

Cause

This appears to be due to trying to insert data that is larger than what the column allows. In Oracle, if you store numeric data and this data is out of range from the column data type, then you got this type of Exception.

Upon further investigation, we found that the Range Start and End range is larger than 2 billion, and hitting a limitation. 

RANGENUM      RANGESTART     RANGEEND         RANGECOUNT

1                              50043076             3843395085         20000000

2                              3843395086         4345169591         20000000

3                              4345169592         4376253808         20000000

4                              4376253809         4408798640         20000000

5                              4408798641         4444474578         20000000

6                              4444474579         4453868590         5225

This is corrected in FastDataMasker-4.9.193.0

Environment

Release : 4.9.1

Component : TDM Web Portal

Resolution

 

You should work with your DBA to review the SQL statement and determine what is causing the numeric overflow.


 

Additional Information

Here is an example description https://stackoverflow.com/questions/46642726/java-jdbc-caused-by-java-sql-sqlexception-numeric-overflow/46644445