When copying a table to a SQL, I will often run into the following error:
Error while copying table: {"method":"POST","url":"/api/template/copyAppTable","source":{"src":"fetch","response":{},"text":"{\"title\":\"An error occured: ExceptionHandlerFramework.CustomerFacingException\",\"status\":400,\"detail\":\"Row+size+too+large.+The+maximum+row+size+for+the+used+table+type%2c+not+counting+BLOBs%2c+is+65535.+This+includes+storage+overhead%2c+check+the+manual.+You+have+to+change+some+columns+to+TEXT+or+BLOBs\".....
---------------------------------------------------------------------------------------------------------------------------
Seems like someone forgot to put in a catch for this. ๐
Something like:
if (error.detail.includes("Row+size+too+large")) {
columns.forEach(column => {
if (appsheet.column.type === "LongText") {
SQL.column.type = "TEXT"; // Make sure LongText columns are set to TEXT type, not VARCHAR
}
});
// Retry operation after adjustments
}
---------------------------------------------------------------------------------------------------------------------------
Fixing this would go a long way to making things MUCH smoother.
Thanks!
LinkedIn
Twitter
