Notifications
Clear all
Topic starter
I have been having an issue which started last week where my DTS server just decides to stop processing data. The server or service is running and just looks like there is nothing to process as the files stack up in the llogic folder. If I start the DTS client instead of the LinkLogicDTS service I can see why. It is usually first thing in the morning when I am looking at it and it usually says "job startup "was" at 12:22PM or so which is in the future. I would fully expect it to just start processing jobs at that time but I can't wait for that to happen so I run the following script to kick start it:
update l3taskstatus set attemptat=0, successat=0 where recurid=1
I got the script from GE, case #1-777843401. The tech said that he does not know why it happens but he has seen it before, about 4-5 times. I did not think I was going to have to make this a daily routine but the very next day I had the same problem again which was also solved by running that script. I figure this will be the way it goes from now on so I tried to set it up as a SQL job but it does not seem to help. It is successfully running according to the SQL logs.
Every morning I have the same issue but it works just fine after I manually run the script
Mike Zavolas
Tallahassee Neurological Clinic
Posted : November 23, 2015 5:14 am
Not that this is a fix but could you script a scheduled task that stops DTS then runs the SQL Query and Starts DTS? That's what I would do while I kept trying to make GE fix it.
Posted : December 1, 2015 8:18 am
Topic starter
I ended up just hitting on the correct time. Every day I was dealing with a failure I pushed the start time ahead by 15 minutes and I finally hit on a time which works.
The tech wouldn't even return calls or emails so I guess I am on my own on this one. Maybe some other CHUGgers will have the same problem and see this workaround at least but I don't know how GE would fix it because I wouldn't even know how to reproduce it.
Posted : December 1, 2015 9:14 am
