Bug when copying table to SQL

AppSheet AppSheet Q&A
,
1

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. :downcast_face_with_sweat:

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!

4 Likes
2

Attn @Adam-google ?

2 Likes