Error Message :
The application, , generated an application error The error occurred
on 07/20/2004 @. 06:12:28.203 The exception generated was c0000005 at
address 41504E2C (<nosymbols>)
This happened this morning, but the DTS package runs every 10 minutes
and it is the only occurance of this error. Nothing in the DTS package
has changed and there will not have been any users on the network. I'm
as convinced as I can be that the DTS package is fine. Nothing obvious
as to what has caused the error, and it hasn't happened again, but I
would like to understand it more if possible.
The closest answer we found was for a SQL2000 error (
http://support.microsoft.com/defaul...en-us%3BQ290644 ),
but we are running SQL7 (latest sp), so any fix wouldn't apply.
The DTS package does a fair amount of importing data and then various
SP's are run to generate a final table of data. From the timing, it
looks to have happened at the end of the process, so would suggest
something with an SP. Unfortunately, I cannot tell which one. 10
minutes after it failed, it worked again and has since, but no-one was
in to correct anything.
Any ideas ?
Thanks
RyanOn further investigation, it looks to have got to right at the end of
the DTS package and then failed. The second to last task outputs a
date / time value along with a record count, which has worked. After
that is a bit of code to dump the transaction log and the scheduled
task should e-mail if it fails. I'm wondering if an exchange server
problem has caused this ? We do have a few issues with Exchange, but
these should have been sorted.
Is this a likely explanation ?
No comments:
Post a Comment