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

TOPIC: Scheduled Task Hangs (sometimes)

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

  • DeanCovey
  • DeanCovey's Avatar Topic Author
  • Offline
  • Gold Boarder
  • Gold Boarder
  • Posts: 199
  • Karma: 1
  • Thank you received: 9
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 11 months ago #15233

  • DeanCovey
  • DeanCovey's Avatar Topic Author
  • Offline
  • Gold Boarder
  • Gold Boarder
  • Posts: 199
  • Karma: 1
  • Thank you received: 9
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 11 months ago #15234

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7510
  • Karma: 33
  • Thank you received: 409
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
Mike
The following user(s) said Thank You: DeanCovey

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

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

  • DeanCovey
  • DeanCovey's Avatar Topic Author
  • Offline
  • Gold Boarder
  • Gold Boarder
  • Posts: 199
  • Karma: 1
  • Thank you received: 9
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 11 months ago #15236

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

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

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

  • DeanCovey
  • DeanCovey's Avatar Topic Author
  • Offline
  • Gold Boarder
  • Gold Boarder
  • Posts: 199
  • Karma: 1
  • Thank you received: 9
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 928 guests and no members online