Skip to main content
Solved

Read all features from source before writing to AGOL

  • May 25, 2018
  • 2 replies
  • 29 views
R

Hi, was wondering whether there is an option to read all the features from a feature class in a SQL Server geodatabase or SQL Server spatial table before they get written to an ArcGIS Online (AGOL) feature layer when I click the run button in the toolbar. The problem I'm running into in our environment is that part way through writing to AGOL I get an error like the following "Microsoft SQL Server Spatial Reader: Query failed, possibly due to a malformed statement. Query Text `[no query]'. Provider error `(-2147467259) TCP Provider: An existing connection was forcibly closed by the remote host.".

Thanks.

Best answer by austinh

try the featureHolder transformer before writing to your dataset.

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.

2 replies

austinh
Contributor
Forum|alt.badge.img+4
  • austinhContributor
  • Contributor
  • Best Answer
  • May 25, 2018

try the featureHolder transformer before writing to your dataset.

R
  • raj3singh
  • Author
  • May 25, 2018

Awesome! This works like a charm.

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.