Data Shuttle: Delete all rows (indent): "Server timeout exceeded. Request has failed."

Elisa Bragunde

Hi!

I'm updating a sheet using replace, but now I'm getting an error message.

The first time I uploaded the file it worked fine, this is the Log:

Rows updated 0

Rows added 7301

Rows deleted 7226

Rows filtered 0

Rows skipped 0

Column choices updated 0

But now the message I get on the Log is this:

Delete all rows (indent): "Server timeout exceeded. Request has failed."

Workflow Execute: deleteAllRows failed, cannot proceed adding new rows

I'm using the same file both times, so I don't know what it could be. Too many rows?

Thanks!

Bassam Khalil

Hi @Elisa Bragunde

Hope you are fine, Have you checked whether you have reached the limits for the number of rows and columns?

Intake Sheet

If your Intake Sheet has reached the general sheet limitations, you won’t be able to create more projects. These limitations are:

• 20,000 rows
• 400 columns
• 500,000 cells (in any combination of rows and columns)

Elisa Bragunde

Hi Bassam,

I have 7.302 rows

65 columns

So-> 474.630 cells

I'm close to the limit, maybe could reduce it to 40 columns -> 357.798 cells, but I don't think it will be much help.

Elisa

Jennifer Murphy

Hi Elisa,

The solution for "Workflow Execute: deleteAllRows failed, cannot proceed adding new rows" is to delete the rows on your smartsheet prior to attaching the file that triggers your data shuttle.

This has happened to me a number of times and seems to happen when the combination of rows and columns is large but less than the 500,000 cell limit.

I delete my rows prior to attaching my file to the sheet which triggers the datashuttle and all works well.

I hope that helps.

Jennifer