Tore
2009-12-21 14:01:01 UTC
I have sql server 2000 installed om windows 2000 server. All service-packs
are installed. I have many DTS-jobs running, and they have been running for
years.
One new DTS-job hangs. I write a log message after each task to a log table
of my application. From the log I see that the last task of the batch job is
executed, but the batch job does not close itself. On the next schedule, 24
hours later, the job does not start because it is already running (i.e.
hanging from the day before).
The job actually does what it should do during the first 10 minutes, then it
hangs undefinitely. In the event viewer I see this message:
Application popup: DTSRun.exe - Application Error : The instruction at
"0x77fcd79a" referenced memory at "0xffffffff". The memory could not be
"read". Click on OK to terminate the program
The event viewer message is timestamped and can be compared with my log
file. The event viewer message seem to appear as the batch-job finish
recalculation of an olap cube. I have many of olap-cubes that are
recalculated in various batch-jobs. There is only one that cause this
problem. This cube is fairly small compared to the others and it is hard to
see why it should cause this problem.
When I right-click and select "execute" on the olap cube symbol in the
DTS-designer it runs without any error. No message is given in the event
viewer.
How can I repair?
Regards from
Tore
are installed. I have many DTS-jobs running, and they have been running for
years.
One new DTS-job hangs. I write a log message after each task to a log table
of my application. From the log I see that the last task of the batch job is
executed, but the batch job does not close itself. On the next schedule, 24
hours later, the job does not start because it is already running (i.e.
hanging from the day before).
The job actually does what it should do during the first 10 minutes, then it
hangs undefinitely. In the event viewer I see this message:
Application popup: DTSRun.exe - Application Error : The instruction at
"0x77fcd79a" referenced memory at "0xffffffff". The memory could not be
"read". Click on OK to terminate the program
The event viewer message is timestamped and can be compared with my log
file. The event viewer message seem to appear as the batch-job finish
recalculation of an olap cube. I have many of olap-cubes that are
recalculated in various batch-jobs. There is only one that cause this
problem. This cube is fairly small compared to the others and it is hard to
see why it should cause this problem.
When I right-click and select "execute" on the olap cube symbol in the
DTS-designer it runs without any error. No message is given in the event
viewer.
How can I repair?
Regards from
Tore