GG Extract Fails With Error Arithmetic Overflow Error For Data Type Smallint (Doc ID 1557227.1)

Last updated on MAY 17, 2017

Applies to:

Oracle GoldenGate - Version 11.2.1.0.3 and later
Information in this document applies to any platform.

Symptoms

On : 11.2.1.0.3 version, EXTRACT executable

When attempting to run extract, the following error occurs.

ERROR
-----------------------
ERROR   OGG-00146  VAM function VAMRead returned unexpected result:
error 600 - VAM Client Report <[mssqlvam::MetadataResolver2K5::GetName] Arithmetic overflow error for data type smallint, value = 61489. Error (-2147217833): Arithmetic overflow error for data type smallint, value = 61489.

Changes

In mssql views, format of data in smallint datatype columns causing data overflow error in OGG.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms