Solved

Communication Link Failure issue in SQL job

Posted on 2014-02-28
4
1,258 Views
Last Modified: 2014-04-07
Communication Link Failure issue in SQL job .
We are facing this error on one of our SQL job on each alternate day .
Please help us to understand reasons for this

Configs :
Windows 2003 server
SQL server 2005
0
Comment
Question by:Pratima Pharande
  • 2
4 Comments
 
LVL 26

Expert Comment

by:Zberteoc
ID: 39894888
What is the error?
0
 
LVL 5

Assisted Solution

by:Lawrence Barnes
Lawrence Barnes earned 250 total points
ID: 39897784
If you are getting this regularly "every other day" it could be lack of resources during a backup, or index unavailability during a re-index job.  Your DBA should check for performance issues during these processes and ensure that the indexes are available during re-indexing.
0
 
LVL 39

Author Comment

by:Pratima Pharande
ID: 39911989
Error


Executed as user: OWENHLT\SQLSVCT. Microsoft (R) SQL Server Execute Package Utility  Version 9.00.4035.00 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  2:44:16 AM  Error: 2014-03-06 04:16:08.21     Code: 0x00000000     Source: Execute SQL Task      Description: TCP Provider: The semaphore timeout period has expired.  End Error  Error: 2014-03-06 04:16:08.22     Code: 0xC002F210     Source: Execute SQL Task Execute SQL Task     Description: Executing the query "exec SPNAME ?,?" failed with the following error: "Communication link failure". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  2:44:16 AM  Finished: 4:16:08 AM  Elapsed:  5511.75 seconds.  The package execution failed.  The step failed.
1
 
LVL 26

Accepted Solution

by:
Zberteoc earned 250 total points
ID: 39912672
And what is this job actually doing? It appears to be some DTS/SSIS package.

By the way, this could help:

http://support.microsoft.com/kb/2006769
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now