In using MySQL (InnoDB) for the Local Storage, MySQL imposes a row-size limit. In this SR, theses tables had a much larger row count than supported my MySQL. When trying to use Toad Automation to import the data to Local storage it failed.
*
Although InnoDB supports row sizes larger than 65,535 bytes internally, MySQL itself imposes a row-size limit of 65,535 for the combined size of all columns:
·
· mysql> CREATE TABLE t (a VARCHAR(8000), b VARCHAR(10000),
· -> c VARCHAR(10000), d VARCHAR(10000), e VARCHAR(10000),
· -> f VARCHAR(10000), g VARCHAR(10000)) ENGINE=InnoDB;
· ERROR 1118 (42000): Row size too large. The maximum row size for the
· used table type, not counting BLOBs, is 65535. You have to change some
· columns to TEXT or BLOBs
A suggestion would be to revisit the SQL engine that Toad Data Point is using to store data and or come up with some error trapping to test tables structures during the Automation process and warn users prior to execution of the script.