I get this error commonly on one of my workspaces. I run the workspace weekly and sometimes it works, sometimes it doesn’t. I am also attempting to truncate. I haven’t been able to find a fix so I am also interested in possible causes.

Hi @jhobbins 

Which version of FME are you using? 

Can you send your log file or a screenshot of the error (including a few rows above the error)? 

Crystal 

UPDATE: Seems that changing the Features per Request value to 500 from 1000 & reauthenticating my AGOL Web Connection allowed it work as normal. Must be some things going on at AGOL’s end or with my network.

Hi Crystal,

I’m seeking an answer to the same question. My workbench generally runs fine but I occasionally get the error that the last 1000 operations couldn’t be completed and starting yesterday, I’m now getting the OP error.

Thanks

Version

FME(R) 2021.0.0.1 (20210315 - Build 21306 - WIN64)

Feature Writer Parameters

Log Snippet

2025-01-17 10:05:38|   0.8|  0.0|INFORM|ArcGIS Online Feature Service Writer: Using proxy <proxy>
2025-01-17 10:05:38|   0.8|  0.0|INFORM|ArcGIS Online Feature Service Writer: Getting item with ID <id>
2025-01-17 10:05:45|   1.0|  0.2|INFORM|ArcGIS Online Feature Service Writer: Write requests will be issued in batches of 1000 features each
2025-01-17 10:05:45|   1.0|  0.0|INFORM|ArcGIS Online Feature Service Writer: Getting item with ID <id>
2025-01-17 10:05:45|   1.0|  0.0|INFORM|ArcGIS Online Feature Service Writer: Requesting metadata for Feature Service at <AGOL URL>
2025-01-17 10:05:46|   1.2|  0.2|INFORM|The ESRIWKID number of the FME coordinate system 'LL-GDA94' is '4283'
2025-01-17 10:05:46|   1.2|  0.0|INFORM|ArcGIS Online Feature Service Writer: Getting item with ID <id>
2025-01-17 10:05:46|   1.2|  0.0|INFORM|ArcGIS Online Feature Service Writer: Requesting metadata for Feature Service at <AGOL URL>
2025-01-17 10:05:47|   1.2|  0.0|INFORM|ArcGIS Online Feature Service Writer: Found layer/table <layer name> with ID 0 for feature type <layer name>
2025-01-17 10:05:47|   1.2|  0.0|INFORM|ArcGIS Online Feature Service Writer: Requesting metadata for layer/table 0 of Feature Service at <AGOL URL>
2025-01-17 10:05:47|   1.2|  0.0|INFORM|FME Configuration: Using FME Reprojection Engine
2025-01-17 10:05:47|   1.2|  0.0|INFORM|TextEncoder_10_OUTPUT_-1_84_Player (RecorderFactory): Playing back feature 500
2025-01-17 10:05:47|   1.3|  0.1|INFORM|ArcGIS Online Feature Service Writer: Writing features for layer/table <layer name>, with 0 inserts, 0 updates, and 1000 deletes
2025-01-17 10:06:20|   1.3|  0.0|ERROR |ArcGIS Online Feature Service Writer: Encountered an unexpected error. The error code from the server was '405' and the message was: 'This SqlTransaction has completed; it is no longer usable.'. Details: 'Unable to apply edits. Please check your parameters.'
2025-01-17 10:06:20|   1.3|  0.0|ERROR |ARCGISONLINEFEATURES writer: A fatal error has occurred. Check the logfile above for details

Hi ​@whichwayisnorth 

Thank you for updating the post with your solution.

I'm glad to hear that you were able to get it working.

Crystal