Qlik Replicate: How to resolve row size too large error while loading into MySQL as target DB

Sonja_Bauernfeind — Tue, 20 Jun 2023 09:06:26 GMT

Loading into the target database may fail with the following error:

RetCode: SQL_ERROR SqlState: HY000 NativeError: 1118 Message: [MySQL][ODBC 8.0(w) Driver][mysqld-8.0.30]Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs; execute create table statement failed,

Resolution

Change any one VARCHAR(4000) to TEXT.

In general, change the latest VARCHAR(4000) (no need to "ENGINE=MyISAM").

article Qlik Replicate: How to resolve row size too large error while loading into MySQL as target DB in Official Support Articles

Qlik Replicate: How to resolve row size too large error while loading into MySQL as target DB

Resolution

Environment