Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
3.1.0
-
None
-
Windows Server 2012 R2 x64
Latest Visual Studio Data Tools
Description
When using an the MariaDB ODBC driver within an SSIS Package to push data to a table with a longtext column I receive the following error:
[Destination - ALLERGY_COMMENT [2]] Error: There was an error while trying to get schema information. state: '00000'. Native Error Code: 0. [ma-3.1.0][10.3.11-MariaDB-log]
The DDL for the destination table (in MariaDB) is included below.
Also attached is the ODBC Trace from the Windows ODBC trace. I wasn't able to generate a trace from the MariaDB file. The MySQL ODBC driver seems to work if I swap it out instead.
CREATE TABLE `allergy_comment` (
`ALLERGY_COMMENT_ID` double NOT NULL,
`ALLERGY_INSTANCE_ID` double NOT NULL,
`ALLERGY_ID` double NOT NULL,
`COMMENT_DT_TM` datetime DEFAULT NULL,
`COMMENT_PRSNL_ID` double NOT NULL,
`ALLERGY_COMMENT` longtext DEFAULT NULL,
`ACTIVE_IND` double DEFAULT NULL,
`ACTIVE_STATUS_CD` double NOT NULL,
`ACTIVE_STATUS_DT_TM` datetime DEFAULT NULL,
`ACTIVE_STATUS_PRSNL_ID` double NOT NULL,
`BEG_EFFECTIVE_DT_TM` datetime NOT NULL,
`END_EFFECTIVE_DT_TM` datetime NOT NULL,
`CONTRIBUTOR_SYSTEM_CD` double NOT NULL,
`DATA_STATUS_CD` double NOT NULL,
`DATA_STATUS_DT_TM` datetime DEFAULT NULL,
`DATA_STATUS_PRSNL_ID` double NOT NULL,
`UPDT_APPLCTX` double NOT NULL,
`UPDT_CNT` double NOT NULL,
`UPDT_DT_TM` datetime NOT NULL,
`UPDT_ID` double NOT NULL,
`UPDT_TASK` double NOT NULL,
`COMMENT_TZ` double DEFAULT NULL,
`BEG_EFFECTIVE_TZ` double DEFAULT NULL,
`CMB_COMMENT_ID` double NOT NULL,
`CMB_PRSNL_ID` double NOT NULL,
`CMB_PERSON_ID` double NOT NULL,
`CMB_DT_TM` datetime DEFAULT NULL,
`CMB_TZ` double DEFAULT NULL,
`CMB_FLAG` double NOT NULL,
`LAST_UTC_TS` timestamp(6) NULL DEFAULT NULL,
`Audit_CreateJobId` bigint(20) DEFAULT NULL,
`Audit_CreateDate` timestamp NOT NULL DEFAULT current_timestamp(),
`Audit_UpdateJobId` bigint(20) DEFAULT NULL,
`Audit_UpdateDate` timestamp NULL DEFAULT NULL,
`Audit_Deleted` bit(1) NOT NULL DEFAULT b'0',
`Audit_DeleteJobId` bigint(20) DEFAULT NULL,
`Audit_DeletedDate` timestamp NULL DEFAULT NULL,
`Audit_ValidFrom` timestamp NULL DEFAULT NULL,
`Audit_ValidUntil` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`ALLERGY_COMMENT_ID`),
KEY `ALLERGY_COMMENT_XIF2ALLERGY_COMMENT` (`ALLERGY_ID`),
KEY `ALLERGY_COMMENT_XIF6ALLERGY_COMMENT` (`ALLERGY_INSTANCE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1