Skip to main content
Question

ArcGIS Online Feature Service Writer: Error 405

  • August 19, 2024
  • 4 replies
  • 168 views

stfcjoe
Participant
Forum|alt.badge.img+1

Hi there,

 

I keep getting this error message:

 

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.' 

 

Any ideas? It’s attempting a truncate. I have purged temporary files and tried to replace all the connections and make a copy of the workbench but still no dice.

 

Thanks,

Joe

4 replies

jhobbins
Participant
Forum|alt.badge.img
  • Participant
  • November 5, 2024

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.


crystalatsafe
Safer
Forum|alt.badge.img+18

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 

 


whichwayisnorth
Contributor
Forum|alt.badge.img+2

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

Mode Delete
Truncate first No
Features per request 1000
Global IDs No
Preserve Global IDs No

 

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

 


crystalatsafe
Safer
Forum|alt.badge.img+18

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 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings