Skip to main content
Question

Google Sheet Writer 409 Error Code

  • February 11, 2020
  • 7 replies
  • 57 views
M
Forum|alt.badge.img

I'm attempting to write several features unto a google sheet via google writer. What's odd is that when the workspace is finished running, only a fraction of the records are actually on the spreadsheet. Despite the software saying all of it went through. Looking at the log, I see the following error :

 

'Google Sheets Writer: Server reported error code 409 (Conflict) when writing to cell A4 on worksheet 'Notes Pairing'. The worksheet may have been modified outside of FME during this translation'

This error repeats 89 more times since FME is attempting to write on 90 cells.

Not sure how to proceed at this point.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

7 replies

redgeographics
Celebrity
Forum|alt.badge.img+62

How have you set up your Google Sheets writer?

FME rocks! \m/
M
Forum|alt.badge.img
  • mariofederis
  • Author
  • February 11, 2020

How have you set up your Google Sheets writer?

 

I don't think it's any different from all the other writers I have on the workbench. I made sure that the fme_db_operation is 'UPSERT' and not 'INSERT'. See attached picture below:

redgeographics
Celebrity
Forum|alt.badge.img+62

 

I don't think it's any different from all the other writers I have on the workbench. I made sure that the fme_db_operation is 'UPSERT' and not 'INSERT'. See attached picture below:

Hmmm... that's how I have them set up too.

Can you post a screenshot of the entire workspace? Are you by any chance reading and writing to the same sheet?

FME rocks! \m/
M
Forum|alt.badge.img
  • mariofederis
  • Author
  • February 11, 2020

Hmmm... that's how I have them set up too.

Can you post a screenshot of the entire workspace? Are you by any chance reading and writing to the same sheet?

Here's the main part of the workbench that's a mystery.

Yes, I'm reading and writing to the same google sheet. I'm also using a change detector in the middle

redgeographics
Celebrity
Forum|alt.badge.img+62

Here's the main part of the workbench that's a mystery.

Yes, I'm reading and writing to the same google sheet. I'm also using a change detector in the middle

Since you're doing an upsert, are you sure that row attribute is present when you're writing?

FME rocks! \m/
M
Forum|alt.badge.img
  • mariofederis
  • Author
  • February 13, 2020

Since you're doing an upsert, are you sure that row attribute is present when you're writing?

For the row attribute, I typically leave it at 'google_sheets_row_number' or blank. The latter I thought automatically adds a record after the last row with data.

redgeographics
Celebrity
Forum|alt.badge.img+62

For the row attribute, I typically leave it at 'google_sheets_row_number' or blank. The latter I thought automatically adds a record after the last row with data.

Yes, that's what it should do. I think best option for now is to inspect features before writing, see what it says for the row number and then check whether or not they're actually written.

If you could bring it down to a small example that would really help in trying to find the cause for this.

FME rocks! \m/

Community Stats

32,154
Posts
122,043
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.