Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1
  • 2

TOPIC: Scheduled Task Hangs (sometimes)

Scheduled Task Hangs (sometimes) 2 years 9 months ago #15231

  • DeanCovey
  • DeanCovey's Avatar Topic Author
  • Offline
  • Gold Boarder
  • Gold Boarder
  • Posts: 177
  • Karma: 1
  • Thank you received: 8
We have an ETL process that runs at 3:00 AM. We pull data from from variety of data sources and summarize the data into a SQL table. Works GREAT!! Once in a while, it stalls.

How do we go about diagnosing? I read online where virus scanners and such may interfere.

In additional note, there server log seems to indicate that a delete workflow isn't done while it is wanting to start the actual import data flow. Would I be wiser to write a delete query and attach it to the data flow?

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

Scheduled Task Hangs (sometimes) 2 years 9 months ago #15233

  • DeanCovey
  • DeanCovey's Avatar Topic Author
  • Offline
  • Gold Boarder
  • Gold Boarder
  • Posts: 177
  • Karma: 1
  • Thank you received: 8
Here is the screenshot of the server log. Is this a case two things are trying to run at the same time?


Attachments:

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

Scheduled Task Hangs (sometimes) 2 years 9 months ago #15234

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7453
  • Karma: 33
  • Thank you received: 399
Dean.

We had number of issues addressed regarding to execution stalling.
They were addressed in the latest release.
My suggestion is to upgrade first than if it does not help we can continue the investigation
The following user(s) said Thank You: DeanCovey

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

Mike

Scheduled Task Hangs (sometimes) 2 years 9 months ago #15235

  • DeanCovey
  • DeanCovey's Avatar Topic Author
  • Offline
  • Gold Boarder
  • Gold Boarder
  • Posts: 177
  • Karma: 1
  • Thank you received: 8
That sounds easy enough. I'll do that this weekend for the one client (I have three total)



Has there been issues of locks placed on Access db's or text files?

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

Scheduled Task Hangs (sometimes) 2 years 9 months ago #15236

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7453
  • Karma: 33
  • Thank you received: 399
The issues we had were related to repository tables locking (Including MS Access repositiry)

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

Mike

Scheduled Task Hangs (sometimes) 2 years 9 months ago #15237

  • DeanCovey
  • DeanCovey's Avatar Topic Author
  • Offline
  • Gold Boarder
  • Gold Boarder
  • Posts: 177
  • Karma: 1
  • Thank you received: 8
Did the upgrade to the clients server. Went really well until I went to schedule it. i even created a bat file so I could see the code try to run.






Attachments:

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

  • Page:
  • 1
  • 2

We have 271 guests and no members online