OGG Big Data Kafka JSON - Junk Data For MS SQL Boolean (BIT datatype) (Doc ID 2674427.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

 Source Table has a BIT column with values 1 and 0

Receiving bad data Kafka Messages (JSON and AVRO), like

"AA=="

"AQ=="

Added column conversion function @NUMBIN and instead got

"MA=="

"MQ=="

Example JSON

{
"table": "DBO.ABC",
"op_type": "I",
"op_ts": "2019-05-07 03:12:04.916666",
"current_ts": "2019-05-07T11:12:07.910000",
"pos": "00000000000000009670",
"ID": 1,
"DESCRIPTION": "Test May 7 2019 11:12AM",
"SINGLE_REGISTER": "AQ=="
}

expected "1" or "0"

------- Details ------

Source Database: MS SQL 2014
DDL

CREATE TABLE [dbo].[ABC](
[id] [int] NOT NULL,
[description] [varchar](50) NULL,
[single_register] [bit] NULL,
CONSTRAINT [PK_pocbit] PRIMARY KEY CLUSTERED
(
[id] ASC
)

Cause

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