Invalid NUMERIC Value: nnnnnn.nnnnnnnn
(Doc ID 2862901.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle GoldenGate Big Data and Application Adapters - Version 19.1.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
While replicating to Google BigQuery we are facing Invalid NUMERIC errors.
gg.handler.bigquery.adjustScale=true parameter is also used.
=ERROR 2022-01-04 10:25:02.000267 [main] - Error executing batch for target table ORDERDETAIL
=ERROR 2022-01-04 10:25:02.000283 [main] - id: null location: unitprice message: Invalid NUMERIC value: 5766258.4307999993 reason: invalid
=ERROR 2022-01-04 10:25:02.000307 [main] - id: null location: message: reason: stopped
Exception in thread "main" oracle.goldengate.util.GGException: Error detected handling operation added event.
at oracle.goldengate.datasource.UserExitDataSource.addOperationToTransactionAndFireEvent(UserExitDataSource.java:2357)
at oracle.goldengate.datasource.UserExitDataSource.createOperation(UserExitDataSource.java:1639)
at oracle.goldengate.datasource.UserExitDataSource.createOperation(UserExitDataSource.java:1396)
GG BIG DATA : Oracle GoldenGate for Big Data Version 19.1.0.0.8 (Build 002)
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |