April 21, 2005 at 3:10 am
Hi Gents,
I am encountering yet another DTS problem. I have a job that runs every morning at 6 am. The job picks up 2 data files stored on the local machine that each contain about 300000 records in each. For the last 2 weeks this job has been failing. When I run the job manually the job executes ok. I know that the agent runs the job in another context but before the job fails it inserts 90000 recs into one of the tables, so I presume this rules out the security issues. I have checked the errors and I found the following errors:
2005-04-21 06:05:31.83 spid63 Time out occurred while waiting for buffer latch type 4,bp 0xf53840, page 1:7589), stat 0x9, object ID 15:1621580815:0, EC 0x65571588 : 0, waittime 300. Not continuing to wait.
2005-04-21 06:05:31.83 spid63 Waiting for type 0x4, current count 0x100320, current owning EC 0x00000000.
If anyone has any feedback I would be greatly appreciated.
M
April 22, 2005 at 6:25 am
Try out following two options
1. Increase tempdb size
2. in Target server connection properties go to advanvced tab,set connect time out to 0.
HTH
April 22, 2005 at 6:35 am
Thanks Tejal,
I will give that a try now. Have you come across this before? Do you have any idea why it suddenly happened?
M
April 22, 2005 at 7:21 am
Hi,
we had problem of pulling of large amount of data from source server due to security reason as from the source server only 500 mb data could be pulled.
we resolved our problem using loops in activeX task, that helped us to pull data on month id instead of pulling data in a single go.
But in your case,it seems there is no security problem. it is a latch problem.
you can go through
http://www.sqldev.net/articles/WaitTypes.htm
HTH
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply