My Oracle Support Banner

Extract Abended With ERROR OGG-01145 Programming Error, Binary Length Mismatch Converting <name> in SQL Server (Doc ID 2649708.1)

Last updated on MAY 25, 2020

Applies to:

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

Symptoms

Extract abended with below error

Error :

2020-02-26 09:51:02  WARNING OGG-25231  Unsupported datatype 'ABC1 (sql_variant), ABC2 (sql_variant), ABC3 (sql_variant)

........................
ERROR OGG-01145 programming error, binary length mismatch converting <name> (<number>).

Goldengate version : 

    Oracle GoldenGate Capture for SQL Server
                   SQL Server Log Mining Method: CDC
      Version 19.1.0.0.3 OGGCORE_19.1.0.0.0_PLATFORMS_190907.0144
 Windows x64 (optimized), Microsoft SQL Server on <date>

Database Version:
Microsoft SQL Server - Enterprise Edition
Version 13.00.5026 (2016)
ODBC Version 03.80.0000

Changes

 

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
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.