December 21, 2005 at 2:32 am
Hello guys..i m in weird here..
I already posted it in DTS forum but didnt get any solutions..so i posted it again here in trusted group....
We have some DTS packages here scheduled to run..Sometimes we got error that job failed. When i checked it in event viewer i got message like.....
Step 'DTSStep_DTSExecuteSQLTask_16' succeeded
Step Execution Started: 12/20/2005 5:43:35 AM
Step Execution Completed: 12/20/2005 5:43:42 AM
Total Step Execution Time: 6.672 seconds
Progress count in Step: 0
Step 'DTSStep_DTSExecuteSQLTask_17' failed
Step Error Source: Microsoft OLE DB Provider for SQL Server
Step Error Description:Timeout expired
Step Error code: 80040E31
Step Error Help File:
Step Error Help Context ID:0
Step Execution Started: 12/20/2005 5:48:31 AM
Step Execution Completed: 12/20/2005 8:35:13 AM
Total Step Execution Time: 10001.61 seconds
Progress count in Step: 0
Step 'DTSStep_DTSExecuteSQLTask_18' succeeded
Step Execution Started: 12/20/2005 5:30:02 AM
Step Execution Completed: 12/20/2005 5:30:16 AM
Total Step Execution Time: 14.14 seconds
Progress count in Step: 0
Step 'DTSStep_DTSExecuteSQLTask_19' succeeded
Step Execution Started: 12/20/2005 5:43:53 AM
Step Execution Completed: 12/20/2005 5:44:48 AM
Total Step Execution Time: 55.656 seconds
Progress count in Step: 0
What may be reason cause this failure and another thing is that see failure occure at 'DTSStep_DTSExecuteSQLTask_17' and see the time for started and completed..after that step no. 18 and 19 executed and see their time...how that was possible before completion of this step 17 how step 18 nad 19 completed????..I chked in log also same thing i observed that 'DTSStep_DTSExecuteSQLTask_1,'DTSStep_DTSExecuteSQLTask_2,
'DTSStep_DTSExecuteSQLTask_6' (actually it shoud be 'DTSStep_DTSExecuteSQLTask_3..????) wheather these number 1,2,6,..like that17,18,19 is logically sequenced with actual runniing step??? please guide me what u observed in above confusing senario......pls help me out ..its urgent...
Regards,
Papillon
December 21, 2005 at 8:57 am
What is task 17 doing? I've seen timeout expired errors due to poor or lack of indexing.
December 21, 2005 at 9:24 am
The task 17 is definitely causing an issue with your package.
December 21, 2005 at 9:37 am
Papillon,
I've replied to your thread in the DTS forum.
Greg
Greg
December 22, 2005 at 9:29 am
Try to Shncrhonized the threads...right click on DTS designer while opening the package and check
NUmber of threads->1
Execute package on main thread->ON
and then run with appropriate dependencies of COMPLETION of previous steps..
Hope this Helps
Regards
-Nirmal.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy