Skip to main content
Solved

Can't run a batch file (that runs successfully when run manually) as a scheduled task.

K
Forum|alt.badge.img

Hello,

I am trying to run an FMW file using a batch script and although I can run the batch file manually and it will run successfully without any hiccups and in very little time (2-3 mins) when I try running the same batch script as a Scheduled Task it takes way too much time to run (I haven't even let it finish as it was running for over half an hour) and doesn't look to run the same way (their log files differ).

I would love some help to get this working properly. I know FME Server does this much easier but our office doesn't have the resources (or business requirements) to purchase Server and so I'm stuck trying to make this work with a Scheduled Task. Any help would be greatly appreciated, thank you.

Best answer by krenty

I found out what the problem was, I was using a dedicated network path for the Site_Data.dbf and needed to use a UNC for the location within my FMW file. I just changed the data parameter for that reader to use the UNC instead of the network drive path and it worked like a charm. :)

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

3 replies

K
Forum|alt.badge.img
  • krenty
  • Author
  • October 30, 2018
You can compare the two log files attached in this zip file.site-table-join.zip
erik_jan
Contributor
Forum|alt.badge.img+18
  • erik_janContributor
  • Contributor
  • October 30, 2018

I had a look at the 2 log files, and they do not match the same workspace.

If you search for "Site_Data.dbf", you will find the dataset as a reader in one of the log files, but not in the other.

Different source files will give different results.

K
Forum|alt.badge.img
  • krenty
  • Author
  • Best Answer
  • October 30, 2018

I found out what the problem was, I was using a dedicated network path for the Site_Data.dbf and needed to use a UNC for the location within my FMW file. I just changed the data parameter for that reader to use the UNC instead of the network drive path and it worked like a charm. :)

Reply


Helpful Members This Week

Community Stats

31,241
Posts
118,462
Replies
38,834
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.