288243 Connect sys_backup@localhost as anonymous on 288243 Query /*!40100 SET @@SQL_MODE='' */ 288243 Query /*!40103 SET TIME_ZONE='+00:00' */ 288243 Query set optimizer_switch='semijoin=off' 288243 Query SELECT LOGFILE_GROUP_NAME, FILE_NAME, TOTAL_EXTENTS, INITIAL_SIZE, ENGINE, EXTRA FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE = 'UNDO LOG' AND FILE_NAME IS NOT NULL AND LOGFILE_GROUP_NAME IN (SELECT DISTINCT LOGFILE_GROUP_NAME FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE = 'DATAFILE' AND TABLESPACE_NAME IN (SELECT DISTINCT TABLESPACE_NAME FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA IN ('information_schema'))) GROUP BY LOGFILE_GROUP_NAME, FILE_NAME, ENGINE ORDER BY LOGFILE_GROUP_NAME 288243 Query SELECT DISTINCT TABLESPACE_NAME, FILE_NAME, LOGFILE_GROUP_NAME, EXTENT_SIZE, INITIAL_SIZE, ENGINE FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE = 'DATAFILE' AND TABLESPACE_NAME IN (SELECT DISTINCT TABLESPACE_NAME FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA IN ('information_schema')) ORDER BY TABLESPACE_NAME, LOGFILE_GROUP_NAME 288243 Query set optimizer_switch=default 288243 Init DB information_schema 288243 Query show tables 288243 Query SELECT engine FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = DATABASE() AND table_name = 'ALL_PLUGINS' 288243 Query SET SQL_QUOTE_SHOW_CREATE=1 288243 Query SET SESSION character_set_results = 'binary' 288243 Query show create table `ALL_PLUGINS` 288243 Query SET SESSION character_set_results = 'utf8' 288243 Query show fields from `ALL_PLUGINS` 288243 Query SELECT /*!40001 SQL_NO_CACHE */ * FROM `ALL_PLUGINS` 276603 Query SET NAMES UTF8 276603 Query SELECT GroupBy1.A1 AS C1 FROM ( SELECT Count(1) AS A1 FROM EmailMessage AS Extent1 WHERE (CAST(Extent1.StatusID AS SIGNED)) = 0 ) AS GroupBy1 288107 Query INSERT INTO D_MC3 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (1, 268811, 4, '**REMOVE**', 'RAW', 0) 288107 Query INSERT INTO D_MC3 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (1, 268811, 9, '**VERY LONG XML FILE**', null, 0) 288107 Query UPDATE D_MC3 SET CONTENT = '**XML FILE**', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 1 AND MESSAGE_ID = 268811 AND CONTENT_TYPE = 10 288107 Query INSERT INTO D_MC3 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (1, 268811, 5, '**~2000 chars', null, 0) 288107 Query UPDATE D_MM3 SET SEND_ATTEMPTS = 1, SEND_DATE = '2016-10-27 22:05:00', RESPONSE_DATE = '2016-10-27 22:05:01' WHERE ID = 1 AND MESSAGE_ID = 268811 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288107 Query INSERT INTO D_MC3 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (1, 268811, 6, '<**Cencored**>', 'RAW', 0) 288107 Query UPDATE D_MM3 SET STATUS = 'P' WHERE ID = 1 AND MESSAGE_ID = 268811 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288107 Query commit 288107 Query rollback 288107 Query INSERT INTO D_MC3 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (1, 268811, 7, '.ASP**Cencored**', 0) 288107 Query INSERT INTO D_MC3 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (1, 268811, 8, '<**Cencored**>', 'RAW', 0) 288107 Query UPDATE D_MC3 SET CONTENT = '**~1900chars', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 1 AND MESSAGE_ID = 268811 AND CONTENT_TYPE = 9 288107 Query UPDATE D_MC3 SET CONTENT = '**~280chars', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 1 AND MESSAGE_ID = 268811 AND CONTENT_TYPE = 10 288107 Query INSERT INTO D_MC3 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (1, 268811, 11, '<**Cencored**>', null, 0) 288107 Query UPDATE D_MM3 SET STATUS = 'S' WHERE ID = 1 AND MESSAGE_ID = 268811 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288243 Query SET SESSION character_set_results = 'binary' 288243 Init DB information_schema 288243 Query select @@collation_database 288107 Query commit 288243 Query SELECT TRIGGER_NAME FROM INFORMATION_SCHEMA.TRIGGERS WHERE EVENT_OBJECT_SCHEMA = DATABASE() AND EVENT_OBJECT_TABLE = 'ALL_PLUGINS' 288243 Query SET SESSION character_set_results = 'utf8' 288243 Query SELECT engine FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = DATABASE() AND table_name = 'APPLICABLE_ROLES' 288107 Query rollback 288243 Query SET SQL_QUOTE_SHOW_CREATE=1 288243 Query SET SESSION character_set_results = 'binary' 288243 Query show create table `APPLICABLE_ROLES` 288107 Query UPDATE D_MM3 SET SEND_ATTEMPTS = 1, SEND_DATE = null, RESPONSE_DATE = '2016-10-27 22:05:01' WHERE ID = 0 AND MESSAGE_ID = 268811 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288243 Query SET SESSION character_set_results = 'utf8' 288243 Query show fields from `APPLICABLE_ROLES` 288107 Query INSERT INTO D_MC3 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (0, 268811, 6, '<**Cencored**>', null, 0) 288107 Query INSERT INTO D_MC3 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (0, 268811, 11, '<**Cencored**>', null, 0) 288243 Query SELECT /*!40001 SQL_NO_CACHE */ * FROM `APPLICABLE_ROLES` 288243 Query SET SESSION character_set_results = 'binary' 288243 Init DB information_schema 288243 Query select @@collation_database 288107 Query UPDATE D_M3 SET PROCESSED = TRUE WHERE ID = 268811 288243 Query SELECT TRIGGER_NAME FROM INFORMATION_SCHEMA.TRIGGERS WHERE EVENT_OBJECT_SCHEMA = DATABASE() AND EVENT_OBJECT_TABLE = 'APPLICABLE_ROLES' 288107 Query commit 288243 Query SET SESSION character_set_results = 'utf8' 288243 Query SELECT engine FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = DATABASE() AND table_name = 'CHARACTER_SETS' 288243 Query SET SQL_QUOTE_SHOW_CREATE=1 288243 Query SET SESSION character_set_results = 'binary' 288107 Query rollback 288243 Query show create table `CHARACTER_SETS` 288243 Query SET SESSION character_set_results = 'utf8' 288243 Query show fields from `CHARACTER_SETS` 288107 Query INSERT INTO D_MC28 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (2, 86598, 4, 'null', 'RAW', 0) 288108 Query SELECT ID FROM D_MSQ3 FOR UPDATE 288243 Query SELECT /*!40001 SQL_NO_CACHE */ * FROM `CHARACTER_SETS` 288108 Query UPDATE D_MSQ3 SET ID = ID + 1 288107 Query UPDATE D_MC28 SET CONTENT = '**~1000chars', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 2 AND MESSAGE_ID = 86598 AND CONTENT_TYPE = 10 288243 Query SET SESSION character_set_results = 'binary' 288243 Init DB information_schema 288243 Query select @@collation_database 288108 Query commit 288243 Query SELECT TRIGGER_NAME FROM INFORMATION_SCHEMA.TRIGGERS WHERE EVENT_OBJECT_SCHEMA = DATABASE() AND EVENT_OBJECT_TABLE = 'CHARACTER_SETS' 288107 Query UPDATE D_MC28 SET CONTENT = '**~200chars', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 2 AND MESSAGE_ID = 86598 AND CONTENT_TYPE = 11 288107 Query INSERT INTO D_MC28 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (2, 86598, 5, '<**Cencored**>', null, 0) 288243 Query SET SESSION character_set_results = 'utf8' 288243 Query SELECT engine FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = DATABASE() AND table_name = 'COLLATIONS' 288108 Query rollback 288107 Query UPDATE D_MM28 SET SEND_ATTEMPTS = 1, SEND_DATE = '2016-10-27 22:05:00', RESPONSE_DATE = '2016-10-27 22:05:01' WHERE ID = 2 AND MESSAGE_ID = 86598 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288108 Query INSERT INTO D_M3 (ID, SERVER_ID, RECEIVED_DATE, PROCESSED, ORIGINAL_ID, IMPORT_ID, IMPORT_CHANNEL_ID) VALUES (268812, 'e120f5ef-28eb-4595-95fa-c2925d4034e4', '2016-10-27 22:05:01', 0, null, null, null) 288243 Query SET SQL_QUOTE_SHOW_CREATE=1 288243 Query SET SESSION character_set_results = 'binary' 288243 Query show create table `COLLATIONS` 288108 Query INSERT INTO D_MM3 (ID, MESSAGE_ID, SERVER_ID, RECEIVED_DATE, STATUS, CONNECTOR_NAME, SEND_ATTEMPTS, SEND_DATE, RESPONSE_DATE, ERROR_CODE, CHAIN_ID, ORDER_ID) VALUES (0, 268812, 'e120f5ef-28eb-4595-95fa-c2925d4034e4', '2016-10-27 22:05:01', 'R', 'Source', 0, null, null, 0, 0, 0) 288107 Query INSERT INTO D_MC28 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (2, 86598, 6, '<**Cencored**>', 'RAW', 0) 288243 Query SET SESSION character_set_results = 'utf8' 288243 Query show fields from `COLLATIONS` 288243 Query SELECT /*!40001 SQL_NO_CACHE */ * FROM `COLLATIONS` 288243 Query SET SESSION character_set_results = 'binary' 288243 Init DB information_schema 288243 Query select @@collation_database 288243 Query SELECT TRIGGER_NAME FROM INFORMATION_SCHEMA.TRIGGERS WHERE EVENT_OBJECT_SCHEMA = DATABASE() AND EVENT_OBJECT_TABLE = 'COLLATIONS' 288108 Query INSERT INTO D_MC3 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (0, 268812, 15, '<**Cencored**>', null, 0) 288108 Query INSERT INTO D_MC3 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (0, 268812, 1, '**60chars', 'RAW', 0) 288243 Query SET SESSION character_set_results = 'utf8' 288243 Query SELECT engine FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = DATABASE() AND table_name = 'COLLATION_CHARACTER_SET_APPLICABILITY' 288108 Query commit 288243 Query SET SQL_QUOTE_SHOW_CREATE=1 288243 Query SET SESSION character_set_results = 'binary' 288243 Query show create table `COLLATION_CHARACTER_SET_APPLICABILITY` 288243 Query SET SESSION character_set_results = 'utf8' 288243 Query show fields from `COLLATION_CHARACTER_SET_APPLICABILITY` 288108 Query rollback 288243 Query SELECT /*!40001 SQL_NO_CACHE */ * FROM `COLLATION_CHARACTER_SET_APPLICABILITY` 288108 Query UPDATE D_MM3 SET STATUS = 'T' WHERE ID = 0 AND MESSAGE_ID = 268812 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288243 Query SET SESSION character_set_results = 'binary' 288243 Init DB information_schema 288243 Query select @@collation_database 288243 Query SELECT TRIGGER_NAME FROM INFORMATION_SCHEMA.TRIGGERS WHERE EVENT_OBJECT_SCHEMA = DATABASE() AND EVENT_OBJECT_TABLE = 'COLLATION_CHARACTER_SET_APPLICABILITY' 288108 Query INSERT INTO D_MC3 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (0, 268812, 10, '**~60chars', null, 0) 288107 Query UPDATE D_MM28 SET STATUS = 'P' WHERE ID = 2 AND MESSAGE_ID = 86598 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288108 Query UPDATE D_MC3 SET CONTENT = '<**Cencored**>', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 0 AND MESSAGE_ID = 268812 AND CONTENT_TYPE = 15 288243 Query SET SESSION character_set_results = 'utf8' 288243 Query SELECT engine FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = DATABASE() AND table_name = 'COLUMNS' 288108 Query INSERT INTO D_MC3 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (0, 268812, 3, '**122 chars', 'RAW', 0) 288243 Query SET SQL_QUOTE_SHOW_CREATE=1 288108 Query INSERT INTO D_MC3 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (0, 268812, 4, '**~100chars', 'RAW', 0) 288243 Query SET SESSION character_set_results = 'binary' 288243 Query show create table `COLUMNS` 288107 Query commit 288108 Query INSERT INTO D_MM3 (ID, MESSAGE_ID, SERVER_ID, RECEIVED_DATE, STATUS, CONNECTOR_NAME, SEND_ATTEMPTS, SEND_DATE, RESPONSE_DATE, ERROR_CODE, CHAIN_ID, ORDER_ID) VALUES (1, 268812, 'e120f5ef-28eb-4595-95fa-c2925d4034e4', '2016-10-27 22:05:01', 'R', 'Create Login Cookie', 0, null, null, 0, 1, 1) 288243 Query SET SESSION character_set_results = 'utf8' 288108 Query INSERT INTO D_MC3 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (1, 268812, 10, '**60 chars', null, 0) 288243 Query show fields from `COLUMNS` 288108 Query commit 288107 Query rollback 288108 Query rollback 288107 Query INSERT INTO D_MC28 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (2, 86598, 7, '.ASP**Cencored**', 0) 288243 Query SELECT /*!40001 SQL_NO_CACHE */ * FROM `COLUMNS` 288107 Query INSERT INTO D_MC28 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (2, 86598, 8, '<**Cencored**>', 'RAW', 0) 288107 Query UPDATE D_MC28 SET CONTENT = '**100chars', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 2 AND MESSAGE_ID = 86598 AND CONTENT_TYPE = 10 288107 Query UPDATE D_MC28 SET CONTENT = '**794chars', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 2 AND MESSAGE_ID = 86598 AND CONTENT_TYPE = 11 288107 Query UPDATE D_MM28 SET STATUS = 'S' WHERE ID = 2 AND MESSAGE_ID = 86598 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288107 Query INSERT INTO D_MM28 (ID, MESSAGE_ID, SERVER_ID, RECEIVED_DATE, STATUS, CONNECTOR_NAME, SEND_ATTEMPTS, SEND_DATE, RESPONSE_DATE, ERROR_CODE, CHAIN_ID, ORDER_ID) VALUES (3, 86598, 'e120f5ef-28eb-4595-95fa-c2925d4034e4', '2016-10-27 22:05:01', 'R', 'LogiControl - Get vehicle mappings', 0, null, null, 0, 1, 3) 288107 Query INSERT INTO D_MC28 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (3, 86598, 10, '**1432chars', null, 0) 288107 Query INSERT INTO D_MC28 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (3, 86598, 11, '**794chars', null, 0) 288107 Query commit 288107 Query rollback 288107 Query SELECT ID FROM D_MSQ13 FOR UPDATE 288107 Query UPDATE D_MSQ13 SET ID = ID + 1 288107 Query commit 288107 Query rollback 288107 Query INSERT INTO D_M13 (ID, SERVER_ID, RECEIVED_DATE, PROCESSED, ORIGINAL_ID, IMPORT_ID, IMPORT_CHANNEL_ID) VALUES (258620, 'e120f5ef-28eb-4595-95fa-c2925d4034e4', '2016-10-27 22:05:01', 0, null, null, null) 288107 Query INSERT INTO D_MM13 (ID, MESSAGE_ID, SERVER_ID, RECEIVED_DATE, STATUS, CONNECTOR_NAME, SEND_ATTEMPTS, SEND_DATE, RESPONSE_DATE, ERROR_CODE, CHAIN_ID, ORDER_ID) VALUES (0, 258620, 'e120f5ef-28eb-4595-95fa-c2925d4034e4', '2016-10-27 22:05:01', 'R', 'Source', 0, null, null, 0, 0, 0) 288107 Query INSERT INTO D_MC13 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (0, 258620, 15, '<**Cencored**>', null, 0) 288107 Query INSERT INTO D_MC13 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (0, 258620, 1, '**431chars', 'RAW', 0) 288107 Query commit 288107 Query rollback 288107 Query UPDATE D_MM13 SET STATUS = 'T' WHERE ID = 0 AND MESSAGE_ID = 258620 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288107 Query INSERT INTO D_MC13 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (0, 258620, 10, '**243chars', null, 0) 288107 Query UPDATE D_MC13 SET CONTENT = '<**Cencored**>', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 0 AND MESSAGE_ID = 258620 AND CONTENT_TYPE = 15 288107 Query INSERT INTO D_MC13 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (0, 258620, 4, '**431chars', 'RAW', 0) 288107 Query INSERT INTO D_MM13 (ID, MESSAGE_ID, SERVER_ID, RECEIVED_DATE, STATUS, CONNECTOR_NAME, SEND_ATTEMPTS, SEND_DATE, RESPONSE_DATE, ERROR_CODE, CHAIN_ID, ORDER_ID) VALUES (1, 258620, 'e120f5ef-28eb-4595-95fa-c2925d4034e4', '2016-10-27 22:05:01', 'R', 'Get Vehicles', 0, null, null, 0, 1, 1) 288107 Query INSERT INTO D_MC13 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (1, 258620, 10, '**696chars', null, 0) 288107 Query commit 288107 Query rollback 288107 Query INSERT INTO D_MC13 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (1, 258620, 4, '**431chars', 'RAW', 0) 288107 Query INSERT INTO D_MC13 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (1, 258620, 9, '**1977chars', null, 0) 288107 Query UPDATE D_MC13 SET CONTENT = '**696chars', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 1 AND MESSAGE_ID = 258620 AND CONTENT_TYPE = 10 288107 Query INSERT INTO D_MC13 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (1, 258620, 5, '<**Cencored**>', null, 0) 288107 Query UPDATE D_MM13 SET SEND_ATTEMPTS = 1, SEND_DATE = '2016-10-27 22:05:01', RESPONSE_DATE = '2016-10-27 22:05:01' WHERE ID = 1 AND MESSAGE_ID = 258620 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288107 Query INSERT INTO D_MC13 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (1, 258620, 6, '**465chars', 'RAW', 0) 288107 Query UPDATE D_MM13 SET STATUS = 'P' WHERE ID = 1 AND MESSAGE_ID = 258620 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288107 Query commit 288107 Query rollback 288107 Query UPDATE D_MC13 SET CONTENT = '**1977chars', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 1 AND MESSAGE_ID = 258620 AND CONTENT_TYPE = 9 288107 Query UPDATE D_MC13 SET CONTENT = '**696chars', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 1 AND MESSAGE_ID = 258620 AND CONTENT_TYPE = 10 288107 Query INSERT INTO D_MC13 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (1, 258620, 11, '**544chars', null, 0) 288107 Query UPDATE D_MM13 SET STATUS = 'S' WHERE ID = 1 AND MESSAGE_ID = 258620 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288107 Query commit 288107 Query rollback 288107 Query UPDATE D_MM13 SET SEND_ATTEMPTS = 1, SEND_DATE = null, RESPONSE_DATE = '2016-10-27 22:05:01' WHERE ID = 0 AND MESSAGE_ID = 258620 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288107 Query INSERT INTO D_MC13 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (0, 258620, 11, '**544chars', null, 0) 288107 Query UPDATE D_M13 SET PROCESSED = TRUE WHERE ID = 258620 288107 Query commit 288107 Query rollback 288107 Query INSERT INTO D_MC28 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (3, 86598, 3, 'null', 'RAW', 0) 288107 Query INSERT INTO D_MC28 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (3, 86598, 4, 'null', 'RAW', 0) 288107 Query UPDATE D_MC28 SET CONTENT = '**1432chars', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 3 AND MESSAGE_ID = 86598 AND CONTENT_TYPE = 10 288107 Query UPDATE D_MC28 SET CONTENT = '**1049chars', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 3 AND MESSAGE_ID = 86598 AND CONTENT_TYPE = 11 288107 Query INSERT INTO D_MC28 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (3, 86598, 5, '<**Cencored**>', null, 0) 288107 Query UPDATE D_MM28 SET SEND_ATTEMPTS = 1, SEND_DATE = '2016-10-27 22:05:01', RESPONSE_DATE = '2016-10-27 22:05:01' WHERE ID = 3 AND MESSAGE_ID = 86598 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288107 Query INSERT INTO D_MC28 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (3, 86598, 6, '**186chars', 'RAW', 0) 288107 Query UPDATE D_MC28 SET CONTENT = '**1432chars', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 3 AND MESSAGE_ID = 86598 AND CONTENT_TYPE = 10 288107 Query UPDATE D_MC28 SET CONTENT = '**1049chars', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 3 AND MESSAGE_ID = 86598 AND CONTENT_TYPE = 11 288107 Query UPDATE D_MM28 SET STATUS = 'S' WHERE ID = 3 AND MESSAGE_ID = 86598 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288107 Query INSERT INTO D_MM28 (ID, MESSAGE_ID, SERVER_ID, RECEIVED_DATE, STATUS, CONNECTOR_NAME, SEND_ATTEMPTS, SEND_DATE, RESPONSE_DATE, ERROR_CODE, CHAIN_ID, ORDER_ID) VALUES (4, 86598, 'e120f5ef-28eb-4595-95fa-c2925d4034e4', '2016-10-27 22:05:01', 'R', 'LogiControl - Get employee mappings', 0, null, null, 0, 1, 4) 288244 Connect sys_monitor@localhost as anonymous on 288244 Query show /*!50002 GLOBAL */ status 288107 Query INSERT INTO D_MC28 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (4, 86598, 10, '**1432chars', null, 0) 288107 Query INSERT INTO D_MC28 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (4, 86598, 11, '**1049chars', null, 0) 288107 Query commit 288107 Query rollback 288107 Query SELECT ID FROM D_MSQ6 FOR UPDATE 288107 Query UPDATE D_MSQ6 SET ID = ID + 1 288107 Query commit 288107 Query rollback 288107 Query INSERT INTO D_M6 (ID, SERVER_ID, RECEIVED_DATE, PROCESSED, ORIGINAL_ID, IMPORT_ID, IMPORT_CHANNEL_ID) VALUES (258599, 'e120f5ef-28eb-4595-95fa-c2925d4034e4', '2016-10-27 22:05:01', 0, null, null, null) 288107 Query INSERT INTO D_MM6 (ID, MESSAGE_ID, SERVER_ID, RECEIVED_DATE, STATUS, CONNECTOR_NAME, SEND_ATTEMPTS, SEND_DATE, RESPONSE_DATE, ERROR_CODE, CHAIN_ID, ORDER_ID) VALUES (0, 258599, 'e120f5ef-28eb-4595-95fa-c2925d4034e4', '2016-10-27 22:05:01', 'R', 'Source', 0, null, null, 0, 0, 0) 288107 Query INSERT INTO D_MC6 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (0, 258599, 15, '**459chars', null, 0) 288107 Query INSERT INTO D_MC6 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (0, 258599, 1, '**432chars', 'RAW', 0) 288107 Query commit 288107 Query rollback 288107 Query UPDATE D_MM6 SET STATUS = 'T' WHERE ID = 0 AND MESSAGE_ID = 258599 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288107 Query INSERT INTO D_MC6 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (0, 258599, 10, '**725chars', null, 0) 288244 Quit 288107 Query UPDATE D_MC6 SET CONTENT = '**459chars', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 0 AND MESSAGE_ID = 258599 AND CONTENT_TYPE = 15 288107 Query INSERT INTO D_MC6 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (0, 258599, 4, '**432chars', 'RAW', 0) 288107 Query INSERT INTO D_MM6 (ID, MESSAGE_ID, SERVER_ID, RECEIVED_DATE, STATUS, CONNECTOR_NAME, SEND_ATTEMPTS, SEND_DATE, RESPONSE_DATE, ERROR_CODE, CHAIN_ID, ORDER_ID) VALUES (1, 258599, 'e120f5ef-28eb-4595-95fa-c2925d4034e4', '2016-10-27 22:05:01', 'R', 'Get Employees', 0, null, null, 0, 1, 1) 288107 Query INSERT INTO D_MC6 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (1, 258599, 10, '**725chars', null, 0) 288107 Query commit 288107 Query rollback 288107 Query INSERT INTO D_MC6 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (1, 258599, 4, '**432chars', 'RAW', 0) 288107 Query INSERT INTO D_MC6 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (1, 258599, 9, '**1977chars', null, 0) 288107 Query UPDATE D_MC6 SET CONTENT = '**725chars', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 1 AND MESSAGE_ID = 258599 AND CONTENT_TYPE = 10 288107 Query INSERT INTO D_MC6 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (1, 258599, 5, '**3121chars', null, 0) 288107 Query UPDATE D_MM6 SET SEND_ATTEMPTS = 1, SEND_DATE = '2016-10-27 22:05:01', RESPONSE_DATE = '2016-10-27 22:05:01' WHERE ID = 1 AND MESSAGE_ID = 258599 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288107 Query INSERT INTO D_MC6 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (1, 258599, 6, '**986chars', 'RAW', 0) 288107 Query UPDATE D_MM6 SET STATUS = 'P' WHERE ID = 1 AND MESSAGE_ID = 258599 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288107 Query commit 288107 Query rollback 288107 Query UPDATE D_MC6 SET CONTENT = '**1977chars', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 1 AND MESSAGE_ID = 258599 AND CONTENT_TYPE = 9 288107 Query UPDATE D_MC6 SET CONTENT = '**725chars', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 1 AND MESSAGE_ID = 258599 AND CONTENT_TYPE = 10 288107 Query INSERT INTO D_MC6 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (1, 258599, 11, '**1065chars', null, 0) 288107 Query UPDATE D_MM6 SET STATUS = 'S' WHERE ID = 1 AND MESSAGE_ID = 258599 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288107 Query commit 288107 Query rollback 288107 Query UPDATE D_MM6 SET SEND_ATTEMPTS = 1, SEND_DATE = null, RESPONSE_DATE = '2016-10-27 22:05:01' WHERE ID = 0 AND MESSAGE_ID = 258599 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288107 Query INSERT INTO D_MC6 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (0, 258599, 11, '**1065chars', null, 0) 288107 Query UPDATE D_M6 SET PROCESSED = TRUE WHERE ID = 258599 288107 Query commit 288107 Query rollback 288107 Query INSERT INTO D_MC28 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (4, 86598, 3, 'null', 'RAW', 0) 288107 Query INSERT INTO D_MC28 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (4, 86598, 4, 'null', 'RAW', 0) 288107 Query UPDATE D_MC28 SET CONTENT = '<**Cencored**>', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 4 AND MESSAGE_ID = 86598 AND CONTENT_TYPE = 10 288107 Query UPDATE D_MC28 SET CONTENT = '<**Cencored**>', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 4 AND MESSAGE_ID = 86598 AND CONTENT_TYPE = 11 288107 Query INSERT INTO D_MC28 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (4, 86598, 5, '<**Cencored**>', null, 0) 288107 Query UPDATE D_MM28 SET SEND_ATTEMPTS = 1, SEND_DATE = '2016-10-27 22:05:01', RESPONSE_DATE = '2016-10-27 22:05:01' WHERE ID = 4 AND MESSAGE_ID = 86598 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288107 Query INSERT INTO D_MC28 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (4, 86598, 6, '<**Cencored**>', 'RAW', 0) 288107 Query UPDATE D_MC28 SET CONTENT = '<**Cencored**>', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 4 AND MESSAGE_ID = 86598 AND CONTENT_TYPE = 10 288107 Query UPDATE D_MC28 SET CONTENT = '<**Cencored**>', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 4 AND MESSAGE_ID = 86598 AND CONTENT_TYPE = 11 288107 Query UPDATE D_MM28 SET STATUS = 'S' WHERE ID = 4 AND MESSAGE_ID = 86598 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288107 Query INSERT INTO D_MM28 (ID, MESSAGE_ID, SERVER_ID, RECEIVED_DATE, STATUS, CONNECTOR_NAME, SEND_ATTEMPTS, SEND_DATE, RESPONSE_DATE, ERROR_CODE, CHAIN_ID, ORDER_ID) VALUES (7, 86598, 'e120f5ef-28eb-4595-95fa-c2925d4034e4', '2016-10-27 22:05:01', 'R', 'LogiControl - Get last message mappings', 0, null, null, 0, 1, 5) 288107 Query INSERT INTO D_MC28 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (7, 86598, 10, '<**Cencored**>', null, 0) 288107 Query INSERT INTO D_MC28 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (7, 86598, 11, '<**Cencored**>', null, 0) 288107 Query commit 288107 Query rollback 288107 Query SELECT ID FROM D_MSQ18 FOR UPDATE 288107 Query UPDATE D_MSQ18 SET ID = ID + 1 288107 Query commit 288107 Query rollback 288107 Query INSERT INTO D_M18 (ID, SERVER_ID, RECEIVED_DATE, PROCESSED, ORIGINAL_ID, IMPORT_ID, IMPORT_CHANNEL_ID) VALUES (212474, 'e120f5ef-28eb-4595-95fa-c2925d4034e4', '2016-10-27 22:05:01', 0, null, null, null) 288107 Query INSERT INTO D_MM18 (ID, MESSAGE_ID, SERVER_ID, RECEIVED_DATE, STATUS, CONNECTOR_NAME, SEND_ATTEMPTS, SEND_DATE, RESPONSE_DATE, ERROR_CODE, CHAIN_ID, ORDER_ID) VALUES (0, 212474, 'e120f5ef-28eb-4595-95fa-c2925d4034e4', '2016-10-27 22:05:01', 'R', 'Source', 0, null, null, 0, 0, 0) 288107 Query INSERT INTO D_MC18 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (0, 212474, 15, '<**Cencored**>', null, 0) 288107 Query INSERT INTO D_MC18 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (0, 212474, 1, '{**Cencored**}', 'RAW', 0) 288107 Query commit 288107 Query rollback 288107 Query UPDATE D_MM18 SET STATUS = 'T' WHERE ID = 0 AND MESSAGE_ID = 212474 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288107 Query INSERT INTO D_MC18 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (0, 212474, 10, '<**Cencored**>', null, 0) 288107 Query UPDATE D_MC18 SET CONTENT = '<**Cencored**>', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 0 AND MESSAGE_ID = 212474 AND CONTENT_TYPE = 15 288107 Query INSERT INTO D_MC18 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (0, 212474, 3, '{**Cencored**}', 'RAW', 0) 288107 Query INSERT INTO D_MC18 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (0, 212474, 4, '{**Cencored**}', 'RAW', 0) 288107 Query INSERT INTO D_MM18 (ID, MESSAGE_ID, SERVER_ID, RECEIVED_DATE, STATUS, CONNECTOR_NAME, SEND_ATTEMPTS, SEND_DATE, RESPONSE_DATE, ERROR_CODE, CHAIN_ID, ORDER_ID) VALUES (1, 212474, 'e120f5ef-28eb-4595-95fa-c2925d4034e4', '2016-10-27 22:05:01', 'R', 'Get Messages', 0, null, null, 0, 1, 1) 288107 Query INSERT INTO D_MC18 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (1, 212474, 10, '<**Cencored**>', null, 0) 288107 Query commit 288107 Query rollback 288107 Query INSERT INTO D_MC18 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (1, 212474, 4, '{**Cencored**}', 'RAW', 0) 288107 Query INSERT INTO D_MC18 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (1, 212474, 9, '<**Cencored**>', null, 0) 288107 Query UPDATE D_MC18 SET CONTENT = '<**Cencored**>', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 1 AND MESSAGE_ID = 212474 AND CONTENT_TYPE = 10 288107 Query INSERT INTO D_MC18 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (1, 212474, 5, '<**Cencored**>', null, 0) 288107 Query UPDATE D_MM18 SET SEND_ATTEMPTS = 1, SEND_DATE = '2016-10-27 22:05:01', RESPONSE_DATE = '2016-10-27 22:05:01' WHERE ID = 1 AND MESSAGE_ID = 212474 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288107 Query INSERT INTO D_MC18 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (1, 212474, 6, '<**Cencored**>', 'RAW', 0) 288107 Query UPDATE D_MM18 SET STATUS = 'P' WHERE ID = 1 AND MESSAGE_ID = 212474 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288107 Query commit 288107 Query rollback 288107 Query INSERT INTO D_MC18 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (1, 212474, 7, '[**Cencored**]', 'RAW', 0) 288107 Query INSERT INTO D_MC18 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (1, 212474, 8, '<**Cencored**>', 'RAW', 0) 288107 Query UPDATE D_MC18 SET CONTENT = '<**Cencored**>', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 1 AND MESSAGE_ID = 212474 AND CONTENT_TYPE = 9 288107 Query UPDATE D_MC18 SET CONTENT = '<**Cencored**>', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 1 AND MESSAGE_ID = 212474 AND CONTENT_TYPE = 10 288107 Query INSERT INTO D_MC18 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (1, 212474, 11, '<**Cencored**>', null, 0) 288107 Query UPDATE D_MM18 SET STATUS = 'S' WHERE ID = 1 AND MESSAGE_ID = 212474 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288107 Query commit 288107 Query rollback 288107 Query UPDATE D_MM18 SET SEND_ATTEMPTS = 1, SEND_DATE = null, RESPONSE_DATE = '2016-10-27 22:05:01' WHERE ID = 0 AND MESSAGE_ID = 212474 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288107 Query INSERT INTO D_MC18 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (0, 212474, 6, '<**Cencored**>', null, 0) 288107 Query INSERT INTO D_MC18 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (0, 212474, 11, '<**Cencored**>', null, 0) 288107 Query UPDATE D_M18 SET PROCESSED = TRUE WHERE ID = 212474 288107 Query commit 288107 Query rollback 288107 Query INSERT INTO D_MC28 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (7, 86598, 3, 'null', 'RAW', 0) 288107 Query INSERT INTO D_MC28 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (7, 86598, 4, 'null', 'RAW', 0) 288107 Query UPDATE D_MC28 SET CONTENT = '<**Cencored**>', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 7 AND MESSAGE_ID = 86598 AND CONTENT_TYPE = 10 288107 Query UPDATE D_MC28 SET CONTENT = '<**Cencored**>', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 7 AND MESSAGE_ID = 86598 AND CONTENT_TYPE = 11 288107 Query INSERT INTO D_MC28 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (7, 86598, 5, '<**Cencored**>', null, 0) 288107 Query UPDATE D_MM28 SET SEND_ATTEMPTS = 1, SEND_DATE = '2016-10-27 22:05:01', RESPONSE_DATE = '2016-10-27 22:05:01' WHERE ID = 7 AND MESSAGE_ID = 86598 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288107 Query INSERT INTO D_MC28 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (7, 86598, 6, '<**Cencored**>', 'RAW', 0) 288107 Query UPDATE D_MM28 SET STATUS = 'P' WHERE ID = 7 AND MESSAGE_ID = 86598 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288107 Query commit 288107 Query rollback 288107 Query INSERT INTO D_MC28 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (7, 86598, 7, '[**Cencored**]', 'RAW', 0) 288107 Query INSERT INTO D_MC28 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (7, 86598, 8, '<**Cencored**>', 'RAW', 0) 288107 Query UPDATE D_MC28 SET CONTENT = '<**Cencored**>', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 7 AND MESSAGE_ID = 86598 AND CONTENT_TYPE = 10 288107 Query UPDATE D_MC28 SET CONTENT = '<**Cencored**>', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 7 AND MESSAGE_ID = 86598 AND CONTENT_TYPE = 11 288107 Query UPDATE D_MM28 SET STATUS = 'S' WHERE ID = 7 AND MESSAGE_ID = 86598 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288107 Query INSERT INTO D_MM28 (ID, MESSAGE_ID, SERVER_ID, RECEIVED_DATE, STATUS, CONNECTOR_NAME, SEND_ATTEMPTS, SEND_DATE, RESPONSE_DATE, ERROR_CODE, CHAIN_ID, ORDER_ID) VALUES (5, 86598, 'e120f5ef-28eb-4595-95fa-c2925d4034e4', '2016-10-27 22:05:01', 'R', 'Mercedes - Login', 0, null, null, 0, 1, 6) 288107 Query INSERT INTO D_MC28 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (5, 86598, 10, '<**Cencored**>', null, 0) 288107 Query INSERT INTO D_MC28 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (5, 86598, 11, '<**Cencored**>', null, 0) 288107 Query commit 288107 Query rollback 288107 Query INSERT INTO D_MC28 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (5, 86598, 3, 'null', 'RAW', 0) 288107 Query UPDATE D_MM28 SET STATUS = 'F' WHERE ID = 5 AND MESSAGE_ID = 86598 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288107 Query UPDATE D_MC28 SET CONTENT = '<**Cencored**>', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 5 AND MESSAGE_ID = 86598 AND CONTENT_TYPE = 10 288107 Query UPDATE D_MC28 SET CONTENT = '<**Cencored**>', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 5 AND MESSAGE_ID = 86598 AND CONTENT_TYPE = 11 288107 Query INSERT INTO D_MM28 (ID, MESSAGE_ID, SERVER_ID, RECEIVED_DATE, STATUS, CONNECTOR_NAME, SEND_ATTEMPTS, SEND_DATE, RESPONSE_DATE, ERROR_CODE, CHAIN_ID, ORDER_ID) VALUES (8, 86598, 'e120f5ef-28eb-4595-95fa-c2925d4034e4', '2016-10-27 22:05:01', 'R', 'Mercedes - Get reports for each vehicle', 0, null, null, 0, 1, 7) 288107 Query INSERT INTO D_MC28 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (8, 86598, 10, '<**Cencored**>', null, 0) 288107 Query INSERT INTO D_MC28 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (8, 86598, 11, '<**Cencored**>', null, 0) 288107 Query commit 288107 Query rollback 288107 Query SELECT ID FROM D_MSQ31 FOR UPDATE 288107 Query UPDATE D_MSQ31 SET ID = ID + 1 288107 Query commit 288107 Query rollback 288107 Query INSERT INTO D_M31 (ID, SERVER_ID, RECEIVED_DATE, PROCESSED, ORIGINAL_ID, IMPORT_ID, IMPORT_CHANNEL_ID) VALUES (84882, 'e120f5ef-28eb-4595-95fa-c2925d4034e4', '2016-10-27 22:05:01', 0, null, null, null) 288107 Query INSERT INTO D_MM31 (ID, MESSAGE_ID, SERVER_ID, RECEIVED_DATE, STATUS, CONNECTOR_NAME, SEND_ATTEMPTS, SEND_DATE, RESPONSE_DATE, ERROR_CODE, CHAIN_ID, ORDER_ID) VALUES (0, 84882, 'e120f5ef-28eb-4595-95fa-c2925d4034e4', '2016-10-27 22:05:01', 'R', 'Source', 0, null, null, 0, 0, 0) 288107 Query INSERT INTO D_MC31 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (0, 84882, 15, '<**Cencored**>', null, 0) 288107 Query INSERT INTO D_MC31 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (0, 84882, 1, '{**Cencored**}', 'RAW', 0) 288107 Query commit 288107 Query rollback 288107 Query UPDATE D_MM31 SET STATUS = 'T' WHERE ID = 0 AND MESSAGE_ID = 84882 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288107 Query INSERT INTO D_MC31 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (0, 84882, 10, '<**Cencored**>', null, 0) 288107 Query UPDATE D_MC31 SET CONTENT = '<**Cencored**>', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 0 AND MESSAGE_ID = 84882 AND CONTENT_TYPE = 15 288107 Query INSERT INTO D_MC31 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (0, 84882, 3, '', 'RAW', 0) 288107 Query INSERT INTO D_MC31 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (0, 84882, 4, '', 'RAW', 0) 288107 Query INSERT INTO D_MM31 (ID, MESSAGE_ID, SERVER_ID, RECEIVED_DATE, STATUS, CONNECTOR_NAME, SEND_ATTEMPTS, SEND_DATE, RESPONSE_DATE, ERROR_CODE, CHAIN_ID, ORDER_ID) VALUES (4, 84882, 'e120f5ef-28eb-4595-95fa-c2925d4034e4', '2016-10-27 22:05:01', 'R', 'Get pos report', 0, null, null, 0, 1, 1) 288107 Query INSERT INTO D_MC31 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (4, 84882, 10, '<**Cencored**>', null, 0) 288107 Query commit 288107 Query rollback 161027 22:05:02 288108 Query UPDATE D_MS3 SET RECEIVED = RECEIVED + 1, RECEIVED_LIFETIME = RECEIVED_LIFETIME + 1, FILTERED = FILTERED + 0, FILTERED_LIFETIME = FILTERED_LIFETIME + 0, SENT = SENT + 1, SENT_LIFETIME = SENT_LIFETIME + 1, ERROR = ERROR + 0, ERROR_LIFETIME = ERROR_LIFETIME + 0 WHERE METADATA_ID IS NULL AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288109 Query INSERT INTO D_MC3 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (1, 268812, 4, '{**Cencored**}', 'RAW', 0) 288107 Query INSERT INTO D_MC31 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (4, 84882, 4, '', 'RAW', 0) 288109 Query INSERT INTO D_MC3 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (1, 268812, 9, '<**Cencored**>', null, 0) 288109 Query UPDATE D_MC3 SET CONTENT = '<**Cencored**>', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 1 AND MESSAGE_ID = 268812 AND CONTENT_TYPE = 10 288108 Query UPDATE D_MS3 SET RECEIVED = RECEIVED + 1, RECEIVED_LIFETIME = RECEIVED_LIFETIME + 1, FILTERED = FILTERED + 0, FILTERED_LIFETIME = FILTERED_LIFETIME + 0, SENT = SENT + 0, SENT_LIFETIME = SENT_LIFETIME + 0, ERROR = ERROR + 0, ERROR_LIFETIME = ERROR_LIFETIME + 0 WHERE METADATA_ID = 0 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288107 Query UPDATE D_MC31 SET CONTENT = '<**Cencored**>', DATA_TYPE = null, IS_ENCRYPTED = 0 WHERE METADATA_ID = 4 AND MESSAGE_ID = 84882 AND CONTENT_TYPE = 10 288245 Connect sys_monitor@localhost as anonymous on 288245 Query show /*!50002 GLOBAL */ status 288109 Query INSERT INTO D_MC3 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (1, 268812, 5, '<**Cencored**>', null, 0) 288108 Query UPDATE D_MS3 SET RECEIVED = RECEIVED + 1, RECEIVED_LIFETIME = RECEIVED_LIFETIME + 1, FILTERED = FILTERED + 0, FILTERED_LIFETIME = FILTERED_LIFETIME + 0, SENT = SENT + 1, SENT_LIFETIME = SENT_LIFETIME + 1, ERROR = ERROR + 0, ERROR_LIFETIME = ERROR_LIFETIME + 0 WHERE METADATA_ID = 1 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288108 Query UPDATE D_MS6 SET RECEIVED = RECEIVED + 1, RECEIVED_LIFETIME = RECEIVED_LIFETIME + 1, FILTERED = FILTERED + 0, FILTERED_LIFETIME = FILTERED_LIFETIME + 0, SENT = SENT + 1, SENT_LIFETIME = SENT_LIFETIME + 1, ERROR = ERROR + 0, ERROR_LIFETIME = ERROR_LIFETIME + 0 WHERE METADATA_ID IS NULL AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288107 Query INSERT INTO D_MC31 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (4, 84882, 5, '<**Cencored**>', null, 0) 288109 Query UPDATE D_MM3 SET SEND_ATTEMPTS = 1, SEND_DATE = '2016-10-27 22:05:01', RESPONSE_DATE = '2016-10-27 22:05:02' WHERE ID = 1 AND MESSAGE_ID = 268812 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288108 Query UPDATE D_MS6 SET RECEIVED = RECEIVED + 1, RECEIVED_LIFETIME = RECEIVED_LIFETIME + 1, FILTERED = FILTERED + 0, FILTERED_LIFETIME = FILTERED_LIFETIME + 0, SENT = SENT + 0, SENT_LIFETIME = SENT_LIFETIME + 0, ERROR = ERROR + 0, ERROR_LIFETIME = ERROR_LIFETIME + 0 WHERE METADATA_ID = 0 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288107 Query UPDATE D_MM31 SET SEND_ATTEMPTS = 1, SEND_DATE = '2016-10-27 22:05:01', RESPONSE_DATE = '2016-10-27 22:05:01' WHERE ID = 4 AND MESSAGE_ID = 84882 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288108 Query UPDATE D_MS6 SET RECEIVED = RECEIVED + 1, RECEIVED_LIFETIME = RECEIVED_LIFETIME + 1, FILTERED = FILTERED + 0, FILTERED_LIFETIME = FILTERED_LIFETIME + 0, SENT = SENT + 1, SENT_LIFETIME = SENT_LIFETIME + 1, ERROR = ERROR + 0, ERROR_LIFETIME = ERROR_LIFETIME + 0 WHERE METADATA_ID = 1 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288109 Query INSERT INTO D_MC3 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (1, 268812, 6, '<**Cencored**>', 'RAW', 0) 288108 Query UPDATE D_MS31 SET RECEIVED = RECEIVED + 1, RECEIVED_LIFETIME = RECEIVED_LIFETIME + 1, FILTERED = FILTERED + 0, FILTERED_LIFETIME = FILTERED_LIFETIME + 0, SENT = SENT + 0, SENT_LIFETIME = SENT_LIFETIME + 0, ERROR = ERROR + 0, ERROR_LIFETIME = ERROR_LIFETIME + 0 WHERE METADATA_ID IS NULL AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288109 Query UPDATE D_MM3 SET STATUS = 'P' WHERE ID = 1 AND MESSAGE_ID = 268812 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288108 Query UPDATE D_MS31 SET RECEIVED = RECEIVED + 1, RECEIVED_LIFETIME = RECEIVED_LIFETIME + 1, FILTERED = FILTERED + 0, FILTERED_LIFETIME = FILTERED_LIFETIME + 0, SENT = SENT + 0, SENT_LIFETIME = SENT_LIFETIME + 0, ERROR = ERROR + 0, ERROR_LIFETIME = ERROR_LIFETIME + 0 WHERE METADATA_ID = 0 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288109 Query commit 288107 Query INSERT INTO D_MC31 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (4, 84882, 6, '<**Cencored**>', 'RAW', 0) 288108 Query UPDATE D_MS31 SET RECEIVED = RECEIVED + 1, RECEIVED_LIFETIME = RECEIVED_LIFETIME + 1, FILTERED = FILTERED + 0, FILTERED_LIFETIME = FILTERED_LIFETIME + 0, SENT = SENT + 0, SENT_LIFETIME = SENT_LIFETIME + 0, ERROR = ERROR + 0, ERROR_LIFETIME = ERROR_LIFETIME + 0 WHERE METADATA_ID = 4 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288107 Query UPDATE D_MM31 SET STATUS = 'P' WHERE ID = 4 AND MESSAGE_ID = 84882 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288108 Query UPDATE D_MS13 SET RECEIVED = RECEIVED + 1, RECEIVED_LIFETIME = RECEIVED_LIFETIME + 1, FILTERED = FILTERED + 0, FILTERED_LIFETIME = FILTERED_LIFETIME + 0, SENT = SENT + 1, SENT_LIFETIME = SENT_LIFETIME + 1, ERROR = ERROR + 0, ERROR_LIFETIME = ERROR_LIFETIME + 0 WHERE METADATA_ID IS NULL AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288107 Query commit 288108 Query UPDATE D_MS13 SET RECEIVED = RECEIVED + 1, RECEIVED_LIFETIME = RECEIVED_LIFETIME + 1, FILTERED = FILTERED + 0, FILTERED_LIFETIME = FILTERED_LIFETIME + 0, SENT = SENT + 0, SENT_LIFETIME = SENT_LIFETIME + 0, ERROR = ERROR + 0, ERROR_LIFETIME = ERROR_LIFETIME + 0 WHERE METADATA_ID = 0 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288108 Query UPDATE D_MS13 SET RECEIVED = RECEIVED + 1, RECEIVED_LIFETIME = RECEIVED_LIFETIME + 1, FILTERED = FILTERED + 0, FILTERED_LIFETIME = FILTERED_LIFETIME + 0, SENT = SENT + 1, SENT_LIFETIME = SENT_LIFETIME + 1, ERROR = ERROR + 0, ERROR_LIFETIME = ERROR_LIFETIME + 0 WHERE METADATA_ID = 1 AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288109 Query rollback 288108 Query UPDATE D_MS18 SET RECEIVED = RECEIVED + 1, RECEIVED_LIFETIME = RECEIVED_LIFETIME + 1, FILTERED = FILTERED + 0, FILTERED_LIFETIME = FILTERED_LIFETIME + 0, SENT = SENT + 1, SENT_LIFETIME = SENT_LIFETIME + 1, ERROR = ERROR + 0, ERROR_LIFETIME = ERROR_LIFETIME + 0 WHERE METADATA_ID IS NULL AND SERVER_ID = 'e120f5ef-28eb-4595-95fa-c2925d4034e4' 288109 Query INSERT INTO D_MC3 (METADATA_ID, MESSAGE_ID, CONTENT_TYPE, CONTENT, DATA_TYPE, IS_ENCRYPTED) VALUES (1, 268812, 7, '.ASP**Cencored**', 0) 288107 Query rollback