Skip to main content
Solved

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

  • October 30, 2018
  • 3 replies
  • 130 views
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. :)

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.

3 replies

K
Forum|alt.badge.img
  • krenty
  • Author
  • 12 replies
  • 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+22
  • erik_janContributor
  • Contributor
  • 2179 replies
  • 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
  • 12 replies
  • 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. :)

Community Stats

32,084
Posts
121,835
Replies
39,721
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.