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
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