Solved

Communication Link Failure issue in SQL job

Posted on 2014-02-28
4
1,302 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
A company’s centralized system that manages user data, security, and distributed resources is often a focus of criminal attention. Active Directory (AD) is no exception. In truth, it’s even more likely to be targeted due to the number of companies …
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

756 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