[Win32Exception (0x80004005): The semaphore timeout period has expired]
[SqlException (0x80131904): A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.)]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +3335264
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +334
System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) +857
System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() +299
System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() +126
System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() +97
System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) +47
System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +704
System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +89
System.Data.SqlClient.SqlDataReader.get_MetaData() +101
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) +624
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) +3392
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +725
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +84
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +312
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +214
System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +465
System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +147
EzCoding.DB.MSSqlClient.MSSqlDataAccess.ExecuteInquire(SqlSyntaxCommander sqlSyntaxCommander, Int32 timeout) in D:\Workstation\_Project\魁亨科技\Ifun-ECLib\03_程式\01_開發\EzCoding_v9\EzCoding\DB\MSSqlClient\MSSqlDataAccess.cs:355
[LibraryException:
<DBC001>
Priority = Low
TraceLevel = Info
SqlSyntaxInfo
[SQL Statement]
SELECT COUNT(*) AS [COUNT] FROM (
SELECT [MENU].*
FROM
(
SELECT [XSITE_MENU_EXT].*
, [XSITE_MENU].[XSITE_MOD_SID], [XSITE_MENU].[MENU_NAME]
, [XM_MENU].[CONTROLLER_NAME], [XM_MENU].[ACTION_NAME], [XM_MENU].[ROUTE_VALUES], [XSITE_MOD].[URI_SHORT_NAME]
FROM [XSITE_MENU_EXT]
INNER JOIN [XSITE_MENU] ON [XSITE_MENU].[SID] = [XSITE_MENU_EXT].[XSITE_MENU_SID]
INNER JOIN [XSITE_MOD] ON [XSITE_MOD].[SID] = [XSITE_MENU].[XSITE_MOD_SID]
INNER JOIN [XM_MENU] ON [XM_MENU].[CODE] = [XSITE_MENU].[XM_MENU_CODE] AND [XM_MENU].[USE_IN] = [XSITE_MENU].[USE_IN]
INNER JOIN [XM_MOD] ON [XM_MOD].[CODE] = [XM_MENU].[XM_MOD_CODE]
INNER JOIN [XM_CAT] ON [XM_CAT].[CODE] = [XM_MOD].[XM_CAT_CODE]
WHERE [XM_CAT].[ENABLED] = 'Y' AND [XM_MOD].[ENABLED] = 'Y' AND [XM_MENU].[ENABLED] = 'Y' AND [XSITE_MOD].[ENABLED] = 'Y' AND [XSITE_MENU].[ENABLED] = 'Y' AND [XSITE_MENU_EXT].[DATA_SRC] = 1
UNION ALL
SELECT [XSITE_MENU_EXT].*
, NULL AS [XSITE_MOD_SID], NULL AS [MENU_NAME]
, NULL AS [CONTROLLER_NAME], NULL AS [ACTION_NAME], NULL AS [ROUTE_VALUES], NULL AS [URI_SHORT_NAME]
FROM [XSITE_MENU_EXT]
WHERE [XSITE_MENU_EXT].[DATA_SRC] = 2
) [MENU]
WHERE ([MENU].[USE_IN] IN (@P_0,@P_1,@P_2,@P_3,@P_4)) AND ([MENU].[URI_SHORT_NAME] = @P_5) ) [XSITE_MENU_EXT] WHERE ([MDELED] = @PR_1_1 AND [ENABLED] = @PR_1_2)
Parameter: @P_0 = 2 (Int)
Parameter: @P_1 = 3 (Int)
Parameter: @P_2 = 4 (Int)
Parameter: @P_3 = 5 (Int)
Parameter: @P_4 = 6 (Int)
Parameter: @P_5 = NewsLetter (VarChar)
Parameter: @PR_1_1 = N (Char)
Parameter: @PR_1_2 = Y (Char)
At EzCoding.DB.MSSqlClient.MSSqlDataAccess Method:EzCoding.Returner ExecuteInquire(EzCoding.DB.SqlSyntaxCommander, Int32)().
]
EzCoding.DB.MSSqlClient.MSSqlDataAccess.ExecuteInquire(SqlSyntaxCommander sqlSyntaxCommander, Int32 timeout) in D:\Workstation\_Project\魁亨科技\Ifun-ECLib\03_程式\01_開發\EzCoding_v9\EzCoding\DB\MSSqlClient\MSSqlDataAccess.cs:379
EzCoding.DB.DataHandler.GetCountBy(SqlCondsSet conditions) in D:\Workstation\_Project\魁亨科技\Ifun-ECLib\03_程式\01_開發\EzCoding_v9\EzCoding\DB\DataHandler.cs:1390
Ifun.XWeb.SystemEngines.XSiteMenuExt.GetInfoViewCount(InfoViewConds qConds, IncludeScope includeScope) in F:\NICK\電腦與通訊\ITRI_JICT\XWeb Workspace\XWebEntity with MSSQL\EntityTier\Entities\XSiteRelated\XSiteMenuExt.cs:453
Ifun.XWeb.Routing.XSiteModUriShortNameConstraint.Match(HttpContextBase httpContext, Route route, String parameterName, RouteValueDictionary values, RouteDirection routeDirection) in F:\NICK\電腦與通訊\ITRI_JICT\XWeb Workspace\XWebPub\AppCode\Mvc\RouteConstraints\XSiteModUriShortNameConstraint.cs:61
System.Web.Routing.Route.ProcessConstraint(HttpContextBase httpContext, Object constraint, String parameterName, RouteValueDictionary values, RouteDirection routeDirection) +101
System.Web.Routing.Route.ProcessConstraints(HttpContextBase httpContext, RouteValueDictionary values, RouteDirection routeDirection) +219
System.Web.Routing.Route.GetRouteData(HttpContextBase httpContext) +219
System.Web.Routing.RouteCollection.GetRouteData(HttpContextBase httpContext) +239
System.Web.Routing.UrlRoutingModule.PostResolveRequestCache(HttpContextBase context) +73
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +142
System.Web.<>c__DisplayClass285_0.<ExecuteStepImpl>b__0() +38
System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +11860197
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +93
|