Skip to main content
simply more productive

The Data Specialist

Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
Flowheater Chart

FHDesigner fast but FHBatch slow

  • Andrew Wojciak
  • Topic Author
  • Offline
  • User
  • User
More
9 years 7 months ago #2368 by Andrew Wojciak
FHDesigner fast but FHBatch slow was created by Andrew Wojciak
I have built a definition (.fhd) to simply filter records by date range, from 18MBsize.txt file to ~4MBsize.txt file. When I run this definition in FHDesigner it takes just 30 sec but via FHBatch it run over 1/2 hr and more (I had to stop as I cannot accept more than 5 minutes anyway). I have to use FHBatch to automate and schedule runs nightly. I am using Task Scheduler to run FHBatch.
Any suggestions why is taking so long via FHBatch?
Andrew W.

Please Log in or Create an account to join the conversation.

More
9 years 7 months ago #2369 by FlowHeater-Team
Replied by FlowHeater-Team on topic FHDesigner fast but FHBatch slow
Hi Andrew,

Is the FHBatch job always slow or just when running as scheduled windows task? Have you tried to run the .FHD Definition manually via the Batch Module in the Command (CMD) window?

I guess just the first one is slow. In this case please be sure that you run the scheduled task with the same user rights.

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.

Please Log in or Create an account to join the conversation.

  • Andrew Wojciak
  • Topic Author
  • Offline
  • User
  • User
More
9 years 7 months ago - 9 years 7 months ago #2370 by Andrew Wojciak
Replied by Andrew Wojciak on topic FHDesigner fast but FHBatch slow
Thank you, Robert. Issue has been resolved. As you suggested it was a system login/security related issue. I had to use the same log in for FHDefinition, FHDesigner, FHBatch, and TaskScheduler.
Last edit: 9 years 7 months ago by Andrew Wojciak. Reason: correction

Please Log in or Create an account to join the conversation.

Time to create page: 0.259 seconds
FlowHeater Logo

FlowHeater - The Data Specialist

Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.

Legal information

Support & Contact

Contact

Phone:
0951 / 9933 9792

eMail:
This email address is being protected from spambots. You need JavaScript enabled to view it.


Copyright © 2009-2024 by FlowHeater GmbH. All rights reserved.