Automation Import Wizard activity failing on importing a CSV file to Local Storage database. (4289921)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Automation Import Wizard activity failing on importing a CSV file to Local Storage database.
Description

Attempting to Import a CSV file in to the Local Storage connection database, but it continues to fail.
ERROR:
Create table LS_DB1.Import_01 generated an error

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

Exceeded MySQL Database limitations.
Resolution

The Local Storage database is a MySQL database which has a limitation of 65656 chars per row. The csv file used for the import has exceeded the MySQL Database limitations. The user will need to either exclude importing some columns, manually change the varchar length when defining a new table, or create a new table before importing with correct number of columns and length that does not exceed MySQL rules.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title