April 30, 2003 at 8:51 am
We have an ETL process which consists of a scheduled job which: Step1 - launches a DTS package, which launches a VB program, which in turn launches another DTS package. The VB program does the job of looping thru various subdirectories to load files from our subsidiaries. Step 2 of the scheduled job reprocesses our OLAP cubes via a DTS package.
This process has worked fine for several years. Recently, on our test server only, Step 1 (the ETL part), has been hanging for over a week. The job step never completes and the job is left hanging before the cubes get reprocessed. Looking in task manager, there are many DTSRUN.exe processes running, I presume that something is causing each iteration of the DTS package to hang. The only resolution is to kill the job and all the hanging DTSRUN.exe tasks and then reprocess the cubes manually.
There have been no updates to our system recently. The hanging just started out of the blue. In the past, we have had many instances of spontaneous errors such as the Alert Sev 19 Error. They are random and infrequent. No clue as to why.
Any ideas out there? We're running SQL Server 2000 SP2 on Win NT 4.0 SP6a.
THANKS!
May 5, 2003 at 12:00 pm
This was removed by the editor as SPAM
May 5, 2003 at 1:34 pm
U might want to check to see if the version has changed, i.e someone made changes and saved it. Try to run a version that is a week old where the step did not get hung.
May 6, 2003 at 12:47 am
No changes made to programs or code whatsoever. Only consultants change the code (they haven't been here in weeks) and only I update the server software.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply