Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Some columns values are getting corrupted #15

Open
ankitsingh95 opened this issue Feb 27, 2021 · 0 comments
Open

Some columns values are getting corrupted #15

ankitsingh95 opened this issue Feb 27, 2021 · 0 comments

Comments

@ankitsingh95
Copy link

Hi Team,

I am facing an issue with oracle connector when RBMS datatype is NUMBER(19) then massage getting corrupted.

{
"op":"c",
"ts_ms":1614264234618,
"before":{
"ID":"TEtD"
},
"after":{
"ID":"TEtD",
"CREATED_BY":"System",
"CREATED_DATE":"AXdmmwOG",
"ENTITY_STATE":"ACTIVE",
"MODIFIED_BY":null,
"MODIFIED_DATE":null,
"UPDATE_COUNTER":null,
"AUTH_CODE":"SERVICE_ACCOUNT_ACCESS"
},
"source":{
"instance_number":1,
"version":"19.0.0.0.0",
"instance_name":"ndli23",
"host_name":"BUILD-LMSPERF-APP-U2-63-92",
"dbid":683527118,
"database_name":"NDLI23",
"platform_name":"Linux x86 64-bit",
"query":"BLANK_SETUP_CONFIG.AUTHORITY",
"pdb_name":null,
"owner":"BLANK_SETUP_CONFIG",
"table":"AUTHORITY",
"scn":0,
"ts_ms":1614264234618
}
}

SQL> desc BLANK_SETUP_CONFIG.AUTHORITY;
Name Null? Type

ID NOT NULL NUMBER(19)
CREATED_BY VARCHAR2(255 CHAR)
CREATED_DATE NUMBER(19)
ENTITY_STATE VARCHAR2(255 CHAR)
MODIFIED_BY VARCHAR2(255 CHAR)
MODIFIED_DATE NUMBER(19)
UPDATE_COUNTER NUMBER(19)
AUTH_CODE VARCHAR2(255 CHAR)

ID CREATED_BY CREATED_DATE ENTITY_STATE MODIFIED_BY MODIFIED_DATE UPDATE_COUNTER AUTH_CODE
5000000 System 1612334170687 ACTIVE ADMIN_ACCESS
5000001 System 1612334170986 ACTIVE CONFIGURATION_ACCESS
5000002 System 1612334171000 ACTIVE READ_ONLY_ACCESS
5000003 System 1612334171014 ACTIVE SERVICE_ACCOUNT_ACCESS

Regards,
Ankit

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant