Troubleshooting

Who can use this?

Plans:

  • Smartsheet Advance Package

Permissions:

  • Editor
  • Admin
  • Owner

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

Message

Cause

How to Fix

Error reading Excel file.andnbsp; Expected x columns, but row y has z

Source file changed, but column mapping wasn't updated.

Fix the columns on your destination sheet.

Workflow Execute: invalid_grant

Workflow Execute: Your Access Token is invalid

We can't access the Smartsheet source or target.

Edit the workflow and reselect the source and targets.

Workflow Execute: Error refreshing OneDrive credentials

Workflow Execute: OneDrive File URL is null for id x

We can't access the OneDrive source or target. May be caused different upload and offload permissions.

Edit the workflow, re-authenticate to OneDrive and re-select the source and targets.

Error reading Google Drive, Status code 404, Not Found

Workflow Execute: Error retrieving Google file stream

Error reading Google Drive, Status code 403, Forbidden

Error reading Google Drive, Status code 401, Unauthorized

We can't access the Google Drive source or target.

Edit the workflow, re-authenticate to Google Drive, and re-select the source and targets.

Workflow Execute: Attachment file type application/ pdf is unsupported. Supported types are CSV and EXCEL

Workflow Execute: Attachment file type image/ jpeg is unsupported. Supported types are CSV and EXCEL

Workflow Execute: File type application/pdf is unsupported. Supported types are CSV and EXCEL

Workflow Execute: Attachment file type inode/x-empty is unsupported. Supported types are CSV and EXCEL

We only support XLSX and CSV files.

Only use CSV and XLSX files. We don't support legacy Excel (.xls) files and aren't going to.

Workflow Execute: Your account is currently locked out due to a billing issue. Please contact Smartsheet Finance at finance@smartsheet.com

Smartsheet account disabled for billing reasons.

Only customers should see this: contact Support or the TAM/account manager/CS rep.

Add rows to target sheet: \"Updating a cell in a column formula isn't supported. columnId : 361055416280964\

Mapped column contains a column formula.

Don't map rows writing to column formula columns. Build column formulas outside the column.

Update rows in target sheet: \"The value \\\"xxxxx\\" could not be saved in column \\\"yyyyy\\\". This column is restricted to PICKLIST values only.\

Mapped column is restricted to certain values but the source contains something else.

Edit the column to allow the desired type of data, OR fix incoming data source.

Update rows in target sheet: \"Multi-contact list columns cannot have more than 20 contacts\

Mapped column is multi-contact, but source data exceeds limit of 20 contacts

Edit the column to allow the desired type of data, OR fix incoming data source.

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

Workflow sync timeout. Job will be retried.

Workflow Execute: read ECONNRESET

General size of data / timeout issues.

Confirm customer is within supported limits (5k replace, 20k merge); check data complexity and file size. Use filters to break workflows down into multiples.

Workflow Execute: Not Found

Workflow Execute: data file path not set for file

Generic problem downloading source file.

Check the source file.

Workflow Execute: data upload target could not be initialized.andnbsp; Please check for configuration errors.

Generic problem writing to target.

Check the target destination.

Workflow Execute: Parse Error: expected: ',' OR new line got: 'S'. at ' SEQ CONTR

Parsing Error.

  • Remove special characters on the CSV file (“ and #)
  • Ensure column types consistent between sheets
  • Ensure values that start with "" also end with "" in Multi-select dropdown lists

The workflow has been executed with an error: Add rows to target sheet: An unexpected error has occurred. Please try your request. If you encounter this error repeatedly, please contact the support team for assistance.

Issue adding rows to sheet.

  • Reduce sheet complexity
  • Archive rows before merge
  • Schedule the merge workflow to run during off-peak hours

Error Code: 4004: Request failed because sheetId x is currently being updated by another request that uses the same access token.andnbsp; Retry your request once the previous request has completed

Request failed because multiple configs are working on the same target sheet.

Check if multiple Data shuttle configs are working on the same target sheet. Each config must update a unique target sheet.

Troubleshooting Data Shuttle

Who can use this?

Plans:

  • Smartsheet Advance Package

Permissions:

  • Editor
  • Admin
  • Owner

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

BehaviorResolution
I can't sign into Data Shuttle
  • Sign in and out:
  • Change browsers: Smartsheet works best with the latest browsers and the latest browser versions.
  • Disable browser extensions:
    • Some browser extensions interfere with Smartsheet. Check if you have any extensions enabled in Chrome by navigating to Menu > Settings > Extensions. If so, open an incognito window and try using Smartsheet. If Smartsheet works, temporarily deactivate each extension in your regular browser by turning off the toggle. 
    • Access Smartsheet again to see if the problem persists. If the issue is resolved, re-enable the extensions selectively to determine which one conflicts with Smartsheet. Keep conflicting extensions deactivated when working in Smartsheet.
  • Check your VPN: If you're using one, turn off the VPN and sign back into the Smartsheet app.
Numbers from my uploads import as a string (with leading 0s or an apostrophe)
  • Check that the column type is set to Number in the Mapping section of the workflow.
  • You can try using the VALUE function instead, like =VALUE([Current Budget]@row). This function should translate values with a leading apostrophe into being recognized as numerical
I'm having trouble mapping to a Google Sheet with tab connected to BigQueryYou need to set First Row = 2 to pull in the column names. If you set First Row = 1, it pulls in the tab name.
I'm having trouble using OneDrive/Sharepoint as the source location

You receive the following message: Need a permission to access resources in your organization that only an admin can grant. Please ask an Admin to grant permission to this app before you can use it.

This notification occurs because a Microsoft admin locked down the ability to use your Microsoft account for third-party authentication. A Valid Admin (usually the IT department) can give permissions to certain apps. A Microsoft admin must grant Data Shuttle permission before using OneDrive/Sharepoint as a source location.

Tips and best practices

  • With Data Shuttle, Smartsheet limitations still apply.
  • If you need to upload from a source to replace more than or merge data into 20,000 rows, you can apply filters or map to only a selection of columns. You can also create multiple workflows using a standard data category to distribute the data into multiple sheets. You can offload up to 20,000 rows. 
  • If you typically work with large datasets that exceed the sheet limitation of 20,000 rows, consider uploading to a DataTable.
  • Adding, renaming, or removing columns might affect dependent automations. If an error occurs due to column renaming, revert to the original name or update the automation to refer to the new name.
  • Manually delete attachments and their versions from sheets that use multiple workflows or those that are frequently accessed. Currently, there's no automatic way to replace or delete versions, so regular auditing is necessary to prevent issues related to excessive attachments.
  • When updating checkbox columns with Data Shuttle, only the values TRUE and FALSE are supported. While using 1 and 0 may appear to work, they can cause Data Shuttle to log all rows as updated, even though no actual changes occur in the sheet. To ensure accurate run logs and updates, use TRUE and FALSE when mapping checkbox values.