SQL Server 代理 - SSIS 包 - 错误 0x80131904 - 超时已过期 [英] SQL Server Agent - SSIS Package - Error 0x80131904 - Timeout expired

问题描述

最近在 SQL Server 代理计划作业中随机出现了一系列以下错误，我一直无法找到解决方案.

There's been a string of random occurrences of the following error in the SQL Server Agent scheduled jobs lately that I have been unable to find a solution to.

该错误很少发生，但对于每日计划的作业通常每周发生一次，但在任意数量的不同作业中且并不总是相同的作业.每个作业都共享一个事实，即它从运行该作业的同一服务器执行 SSIS 包.它也总是运行几乎正好 30 秒的经过时间，我猜这是超时阈值.如果服务器只是连接到它自己的 SSIS 目录，我不确定为什么它会超时.还值得注意的是，它实际上从未到达执行 SSIS 包的地步，无论尝试执行哪个包，都会发生这种情况.

The error occurs infrequently, but usually once a week for a daily scheduled job, but in any number of different jobs and not always the same one. Each job shares the fact that it executes an SSIS package from the same server that is running the job. It also always runs for almost exactly 30 seconds elapsed time, which I guess is the timeout threshold. I'm not sure why it would timeout if the server is just connecting to its own SSIS catalog. Also of note is that it never actually gets to the point where it executes the SSIS package, and this occurs regardless of which package is trying to be executed.

在我的研究过程中，我遇到很多人建议只需将 SQL Server 2012 更新到最新的 CU* 或 SP2 即可解决问题.但是，将服务器升级到 SP2 还没有.

During my research I came across many people suggesting that simply updating SQL Server 2012 to the latest CU* or SP2 would solve the problem. However, upgrading the server to SP2 has not.

尝试过的一种解决方案(公认的丑陋)是在作业步骤失败时简单地重试一次，这实际上在大约 30% 的情况下确实解决了问题.

One solution tried (which admittedly was ugly) was to simply have a single retry upon failure of the job step, which actually did solve the problem in about 30% of the cases.

我欢迎任何有此错误经验的人，或任何有任何建议的人.

I would welcome anyone who has experience with this error, or anyone who has any suggestions.

错误信息如下:

Date        16/07/2014 6:00:11 AM
Log     Job History ({$jobname})

Step ID     1
Server      {$productionserver}
Job Name        {$jobname}
Step Name       {$stepname}
Duration        00:00:31
Sql Severity    0
Sql Message ID  0
Operator Emailed    
Operator Net sent   
Operator Paged  
Retries Attempted   0

Message
Executed as user: {$user}. 
Microsoft (R) SQL Server Execute Package Utility  Version 11.0.5058.0 for 64-bit  Copyright (C) Microsoft Corporation. All rights reserved.    

Started:  6:00:11 AM  Failed to execute IS server package because of error 0x80131904. 
Server: {$productionserver}, 
Package path: {$packagepath}, 
Environment reference Id: NULL.  
Description: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.  
Source: .Net SqlClient Data Provider  
Started:  6:00:11 AM  Finished: 6:00:42 AM  
Elapsed:  31.122 seconds.  The package execution failed.  The step failed.

推荐答案

试试这个:

超时已过期.操作完成前超时时间已过或服务器没有响应

还有这个

https://connect.microsoft.com/SQLServer/feedback/details/783291/ssis-package-fails-to-start-application-lock-timeout-in-ssisdb-catalog-create-执行

看起来像是一个已知的错误.

Looks like its a known bug.

这篇关于SQL Server 代理 - SSIS 包 - 错误 0x80131904 - 超时已过期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！