Ronny Ritongadi
01/19/2022, 5:19 AMJean-François Paccini
01/19/2022, 10:26 AMNamer Medina
01/19/2022, 1:28 PM{
"status": "failed",
"reason": "/tmp/airbyte_archive2792607089863746237/VERSION"
}
could you advise how to adjust the import file configuration to the latest version?Anouar Hnini
01/21/2022, 11:57 PMairbyte@localhost on app using TCP/IP
SET NAMES utf8
/* mysql-connector-java-8.0.22 (Revision: d64b664fa93e81296a377de031b8123a67e6def2) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@collation_server AS collation_server, @@collation_connection AS collation_connection, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_write_timeout AS net_write_timeout, @@performance_schema AS performance_schema, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@transaction_isolation AS transaction_isolation, @@wait_timeout AS wait_timeout
SHOW WARNINGS
SET character_set_results = NULL
SELECT @@session.autocommit
SET autocommit=1
SELECT `organizationId`,`warehouseId`,`locationId`,`lotNum`,`traceId`,`customerId`,`sku`,`qty`,`qtyAllocated`,`qtyRpIn`,`qtyRpOut`,`qtyMvIn`,`qtyMvOut`,`qtyOnHold`,`onHoldLocker`,`grossWeight`,`netWeight`,`cubic`,`price`,`lpn`,`qtyPa`,`qcStatus`,`lastMaintenanceDate`,`noteText`,`udf01`,`udf02`,`udf03`,`udf04`,`udf05`,`currentVersion`,`oprSeqFlag`,`addWho`,`addTime`,`editWho`,`editTime`,`inLocTime` FROM `app`.`INV_LOT_LOC_ID`
SET autocommit=0
SET autocommit=1
I did enter the same queries from MySQL GUI and it returned not encryptedzeroDateTimeBehavior=CONVERT_TO_NULL
zeroDateTimeBehavior=CONVERT_TO_NULL&characterEncoding=utf8
zeroDateTimeBehavior=CONVERT_TO_NULL&characterEncoding=utf-8
it still returned encrypted
database encoding is utf_8
table encoding is utf8_binEugene Krall
01/25/2022, 1:19 PMSURfOENPTQ==
> ID_8COM
in your system?DESCRIBE app.INV_LOT_LOC_ID;
?SURfOENPTQ==
> ID_8COM
in our systemDESCRIBE app.INV_LOT_LOC_ID;
Ping-Lin Chang
01/28/2022, 1:56 AMcharacterEncoding=utf8_bin
Kyle Mok
01/28/2022, 8:10 PMField#isBinary
method in a wrong way.show create table app.INV_LOT_LOC_ID
? The result will show the charset for each column.
Thanks.Sadik Bakiu
01/31/2022, 2:57 AMCREATE TABLE `INV_LOT_LOC_ID` (
`organizationId` varchar(20) COLLATE utf8_bin NOT NULL,
`warehouseId` varchar(20) COLLATE utf8_bin NOT NULL,
`locationId` varchar(60) COLLATE utf8_bin NOT NULL DEFAULT '',
`lotNum` varchar(10) COLLATE utf8_bin NOT NULL,
`traceId` varchar(30) COLLATE utf8_bin NOT NULL,
`customerId` varchar(30) COLLATE utf8_bin NOT NULL,
`sku` varchar(50) COLLATE utf8_bin NOT NULL,
`qty` decimal(18,8) NOT NULL,
`qtyAllocated` decimal(18,8) NOT NULL,
`qtyRpIn` decimal(23,8) NOT NULL,
`qtyRpOut` decimal(23,8) NOT NULL,
`qtyMvIn` decimal(23,8) NOT NULL,
`qtyMvOut` decimal(23,8) NOT NULL,
`qtyOnHold` decimal(23,8) NOT NULL,
`onHoldLocker` int(11) NOT NULL DEFAULT '0',
`grossWeight` decimal(18,8) NOT NULL,
`netWeight` decimal(18,8) NOT NULL,
`cubic` decimal(18,8) NOT NULL,
`price` decimal(24,8) DEFAULT NULL,
`lpn` varchar(30) COLLATE utf8_bin DEFAULT NULL,
`qtyPa` decimal(18,8) NOT NULL DEFAULT '0.00000000',
`qcStatus` varchar(2) COLLATE utf8_bin DEFAULT NULL,
`lastMaintenanceDate` timestamp NULL DEFAULT NULL,
`noteText` mediumtext COLLATE utf8_bin,
`udf01` varchar(500) COLLATE utf8_bin DEFAULT NULL,
`udf02` varchar(500) COLLATE utf8_bin DEFAULT NULL,
`udf03` varchar(500) COLLATE utf8_bin DEFAULT NULL,
`udf04` varchar(500) COLLATE utf8_bin DEFAULT NULL,
`udf05` varchar(500) COLLATE utf8_bin DEFAULT NULL,
`currentVersion` int(11) NOT NULL DEFAULT '100',
`oprSeqFlag` varchar(65) COLLATE utf8_bin NOT NULL DEFAULT '2016',
`addWho` varchar(40) COLLATE utf8_bin DEFAULT NULL,
`addTime` timestamp NULL DEFAULT NULL,
`editWho` varchar(40) COLLATE utf8_bin DEFAULT NULL,
`editTime` timestamp NULL DEFAULT NULL,
`inLocTime` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`organizationId`,`warehouseId`,`locationId`,`lotNum`,`traceId`),
KEY `auto_shard_key_organizationId` (`organizationId`),
KEY `IDX_INV_LOT_LOC_ID_C` (`organizationId`,`warehouseId`,`locationId`,`sku`),
KEY `IDX_INV_LOT_LOC_ID_QQQQQ` (`organizationId`,`warehouseId`,`qty`,`qtyPa`,`qtyMvIn`,`qtyRpIn`,`qtyAllocated`),
KEY `IDX_LOTXLOCXID_SKU` (`organizationId`,`warehouseId`,`sku`),
KEY `I_INV_LOT_LOC_ID_A` (`organizationId`,`warehouseId`,`customerId`,`sku`),
KEY `I_INV_LOT_LOC_ID_B` (`organizationId`,`warehouseId`,`traceId`),
KEY `I_INV_LOT_LOC_ID_C` (`organizationId`,`warehouseId`,`qty`,`qtyMvIn`,`qtyRpIn`),
KEY `I_INV_LOT_LOC_ID_LOT` (`organizationId`,`warehouseId`,`lotNum`),
KEY `I_INV_LOT_LOC_ID_LOC` (`locationId`),
KEY `I_INV_LOT_LOC_ID_SKU` (`organizationId`,`customerId`,`sku`),
KEY `I_INV_LOT_LOC_ID_LOT2` (`organizationId`,`lotNum`),
KEY `I_INV_LOT_LOC_ID_LO` (`lotNum`,`organizationId`),
KEY `I_INV_LOT_LOC_ID_SCW` (`sku`,`customerId`,`warehouseId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
Gorkem Yurtseven
01/31/2022, 6:28 PMthomas holvoet
01/31/2022, 8:57 PMMartin Prejean
02/02/2022, 2:38 AM