Skip to main content
  • EN

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.

How have you set up your Google Sheets writer?

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:

 

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?

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

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?

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.

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.

Reply


Community Stats

30,112
Posts
114,303
Replies
37,745
Members
Terms & ConditionsCookie settings
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.