DataMesh error. Failed to issue the request. Error code: 504. GATEWAY_TIMEOUT

Neil Egsgard

Hello,

I have been running a DataMesh for a few months and have started getting the error below. Does anyone know what could be causing this?

Error message

Error! Failed to issue the request, please relogin and try again.

Error code: 504 - Error message:GATEWAY_TIMEOUT

Grid sizing

Source:

• 49 columns
• 3,631 rows
• 177,919 cells

Target:

• 88 columns
• 3,869 rows
• 340,472 cells

Screen shots of running DataMesh

Genevieve P.

Hi @Neil Egsgard

This TimeOut error typically happens when the request times out because the target sheet is becoming too large for the workflow to run successfully.

Even though the target sheet isn't yet at the top limit for a Smartsheet sheet (500,000), the workflow still has to run through both 340,472 cells from the destination sheet and all 177,919 cells in the source sheet, which is where I think it's hitting the error.

You could potentially try running the workflow on different network connections in case a stronger network may help, but I would suggest the most efficient way to fix this would be to split the target sheet into multiple sheets. (See: Issue: Smartsheet Is Slow to Load or Save)

Cheers,

Genevieve