Skip to main content
Solved

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

aaron
Contributor
Forum|alt.badge.img+10
  • aaronContributor
  • Contributor

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.

View original
Did this help you find an answer to your question?

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+10
  • aaronContributor
  • Author
  • Contributor
  • February 7, 2018
larry wrote:

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!

 

 

Reply


Helpful Members This Week

Community Stats

30,937
Posts
117,250
Replies
38,740
Members

Latest FME

Terms & ConditionsCookie settings

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