在操作完成之前超时或服务器没有响应.显示包路径 [英] The timeout period elapsed prior to completion of the operation or the server is not responding. with showing package path

问题描述

我正在将一个mdb文件从asp.net上载控件上载到我的sql服务器数据库中.当我上传文件时，它正在从我正在执行SSIS包的数据库中调用存储过程.几秒钟后，只要调用存储过程，就会出现异常，并显示程序包的路径.

I am uploading a mdb file from asp.net upload control into my sql server database. When I am uploading file it is calling a stored procedure from my database in which I m executing my SSIS packages. Whenever I am calling my stored procedure after few seconds I m getting the exception with showing the path of my packages.

$ exception {执行超时已到期.超时时间已过在操作完成之前或服务器未启动响应.\ r \ ndtexec/F\"C:\ DTSX \ DTSXPackage \ DTSXPackage \ Package.dtsx \"} System.Data.SqlClient.SqlException

$exception {"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.\r\ndtexec /F \"C:\DTSX\DTSXPackage\DTSXPackage\Package.dtsx\""} System.Data.SqlClient.SqlException

在我阅读解决方案时.阅读有关SQL的命令超时属性的信息.但是问题仍然是一样的.当我通过SQL Server运行存储过程时，它运行良好，但是当通过asp.net代码调用它时，它给出了异常.

As I read for solution. Read about Command timeout property of SQL. But still issue is same. When I m running stored procedure through SQL server it is running fine but when calling it through the asp.net code it giving exception.

stack  trace -

>       

StackTrace位于System.Data.SqlClient.SqlInternalConnection.OnError(SqlException异常，布尔值breakConnection，操作<代码> 1 wrapCloseInAction)\ r \ n
在System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjectstateObj，布尔值调用者HasConnectionLock，布尔值asyncClose)\ r \ n
在System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObjectstateObj，UInt32错误)\ r \ n位于System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()\ r \ n在System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()\ r \ n在System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()\ r \ n
在System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte&值)\ r \ n位于System.Data.SqlClient.TdsParser.TryRun(RunBehaviorrunBehavior，SqlCommand cmdHandler，SqlDataReader dataStream，BulkCopySimpleResultSet bulkCopyHandler，TdsParserStateObjectstateObj，布尔值和dataReady)\ r \ n位于System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds，RunBehavior runBehavior，字符串resetOptionsString，布尔值isInternal，布尔值forDescribeParameterEncryption)\ r \ n在System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehaviorcmdBehavior，RunBehavior，runBehavior，布尔returnStream，布尔异步，Int32超时，任务和任务，布尔asyncWrite，布尔inRetry，SqlDataReader ds，布尔值describeParameterEncryptionRequest)\ r \ n位于System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehaviorcmdBehavior，RunBehavior，runBehavior，布尔值returnStream，字符串方法，TaskCompletionSource 1完成，Int32超时，Task&任务，布尔值和usedCache，布尔值asyncWrite，布尔值inRetry)\ r \ n位于System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource <代码> 1完成，字符串methodName，布尔型sendToPipe，Int32超时，布尔值和usedCache，布尔值asyncWrite，布尔值inRetry)\ r \ n位于System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\ r \ n位于System.Data.Linq.SqlClient.SqlProvider.Execute(表达式查询，QueryInfo queryInfo，IObjectReaderFactory工厂，Object []parentArgs，对象[] userArgs，ICompiledSubQuery []子查询，对象lastResult)\ r \ n位于System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(表达式查询，QueryInfo [] queryInfos，IObjectReaderFactory工厂，Object []userArguments，ICompiledSubQuery []子查询)\ r \ n位于System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(表达式查询)\ r \ n位于System.Data.Linq.DataContext.ExecuteMethodCall(Object实例，MethodInfo methodInfo，Object []参数)\ r \ n位于DataAccessLayer.EspaceDatasetDataContext.ETL_IMPORT_09_01(可空 1userId，字符串clientMachineIP，字符串loadType，Nullable 1 instId，Nullable 1 bIsIgnoreErrors，Nullable`1&rcout)

StackTrace " at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)\r\n
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\n
at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)\r\n at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()\r\n at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()\r\n at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()\r\n
at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value)\r\n at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\n at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)\r\n at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)\r\n at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)\r\n at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\r\n at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)\r\n at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)\r\n at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)\r\n at System.Data.Linq.DataContext.ExecuteMethodCall(Object instance, MethodInfo methodInfo, Object[] parameters)\r\n at DataAccessLayer.EspaceDatasetDataContext.ETL_IMPORT_09_01(Nullable1 userId, String clientMachineIP, String loadType, Nullable1 instId, Nullable1 bIsIgnoreErrors, Nullable`1& rcout)

存储过程调用方法:-

public int? RunDTSxProcess(long userID, string clientMachineIP, string loadType, long instID, bool ignoreErrors)
        {
            try
            {
                int? result = 0;
                var run = database.storedproc(userID, clientMachineIP, loadType, instID, ignoreErrors,ref result);
                return result;
            }
            catch (Exception)
            {

                throw;
            }
        }

推荐答案

我认为您可能希望对MainContext进行linq to sql的操作，如

I think you may be looking to do something with MainContext for your linq to sql as detailed in this answer.

摘自上述答案:

using (MainContext db = new MainContext())
{
    db.CommandTimeout = 3 * 60; // 3 Mins
}

这篇关于在操作完成之前超时或服务器没有响应.显示包路径的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！