Skip to main content
Solved

How to get Excel file to finish writing in one job before being read in the next (FMEServerJobSubmitter)?

  • February 7, 2018
  • 2 replies
  • 35 views
aaron
Contributor
Forum|alt.badge.img+12

We have a workspace - published in FME Server - that crunches a bunch of data, writes out one or more records to an Excel file, and then kicks off an FMEServerJobSubmitter to a second job that reads in the Excel file to update some features in ArcGIS Online. Our issue is that the second FME Server job fails because the Excel file it is trying to read is still in the process of being written in the first job. How do we ensure the Excel file is done writing in the first job before the second tries to read it? We are running FME Desktop and Server 2016.

 

Thanks,

Aaron

Best answer by larry

If you have workspace A calling workspace B, the trick is to use an extra workspace C who will call A waiting for the job to terminate and then call B. By doing this, A no longer have to call B by itself.

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

L
Forum|alt.badge.img
  • larry
  • Best Answer
  • February 7, 2018

If you have workspace A calling workspace B, the trick is to use an extra workspace C who will call A waiting for the job to terminate and then call B. By doing this, A no longer have to call B by itself.

aaron
Contributor
Forum|alt.badge.img+12
  • aaronContributor
  • Author
  • Contributor
  • February 7, 2018

If you have workspace A calling workspace B, the trick is to use an extra workspace C who will call A waiting for the job to terminate and then call B. By doing this, A no longer have to call B by itself.

Makes sense. That should do the trick. Thanks!

 

 

Community Stats

32,154
Posts
122,048
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.