深圳智汇创想科技有限公司

003- [期望]
003+ CODE:N2307202
004-
004+ Error:11_-2_0_-2146232060SQL:SELECT COUNT(1) FROM ( select b.OrderSourceName,c.ASINorItemID,c.SKU,d.ClientSKU,d.ProductNameCN,a.* from RB_AmazonSalesTrafficReports a (nolock)left join RB_OrderSource b (nolock) on b.CustomerID = a.CustomerID and a.Country=b.OrderSourceCountryleft join RB_Amazon_Product_Base c (nolock)on a.CustomerID = b.CustomerID and a.OrderSourceSKU = c.OrderSourceSKU and c.OrderSourceID = b.ID and c.IsDelete=0and a.ASIN = c.ASINorItemID left join RB_Product d (nolock) on d.CustomerID=b.CustomerID and d.SKU=c.SKU where a.CustomerID=1 and c.ASINorItemID is not null and a.ReportsDate>='2022-03-11' and a.ReportsDate <= '2022-03-17 23:59:59' ) AS PagerTablePARAMS:MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。 TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 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) 在 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) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteScalar() 在 RB.DAL.DBOperator.GetSingle(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms) 在 RB.DAL.DBOperator.GetSingle(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DAL.DBOperator.QueryPager(String SQLString, String strOrder, Int32 pageIndex, Int32 pageSize, Int32& recordCount, Int32 times, SqlParameter[] cmdParms) 在 RB.DAL.DBOperator.QueryPager(String SQLString, String strOrder, Int32 pageIndex, Int32 pageSize, Int32& recordCount, Int32 times) 在 RB.DALExtendV2.RB_AmazonSalesTrafficReportsExtendV2.GetPagerList(RB_AmazonSalesTrafficReports_PSParameters parameters, Int32& recordCount) 在 PandaBuy.ERP.Web.IrobotBox.SalesAnalysis.AmazonDetailPageSalesandTraffic.Page_Load(Object sender, EventArgs e) 在 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) 在 System.Web.UI.Control.OnLoad(EventArgs e) 在 System.Web.UI.Control.LoadRecursive() 在 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 在 System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 在 System.Web.UI.Page.ProcessRequest() 在 System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) 在 System.Web.UI.Page.ProcessRequest(HttpContext context) 在 ASP.irobotbox_salesanalysis_amazondetailpagesalesandtraffic_aspx.ProcessRequest(HttpContext context) 在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() 在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) 在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) 在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error) 在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb) 在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) 在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus) 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)------------------------------------------------------------- [期望]
005+

003- <br /><p>[期望]</p>
003+ CODE:N2307202<br />
004- <br />
004+ Error:11_-2_0_-2146232060<br />SQL:SELECT COUNT(1) FROM ( select <br />b.OrderSourceName<br />,c.ASINorItemID<br />,c.SKU<br />,d.ClientSKU<br />,d.ProductNameCN<br />,a.* from RB_AmazonSalesTrafficReports a (nolock)<br />left join RB_OrderSource b (nolock) <br />on b.CustomerID = a.CustomerID and a.Country=b.OrderSourceCountry<br />left join RB_Amazon_Product_Base c (nolock)<br />on a.CustomerID = b.CustomerID and a.OrderSourceSKU = c.OrderSourceSKU and c.OrderSourceID = b.ID and c.IsDelete=0<br />and a.ASIN = c.ASINorItemID <br />left join RB_Product d (nolock) on d.CustomerID=b.CustomerID and d.SKU=c.SKU <br />where a.CustomerID=1 and c.ASINorItemID is not null and a.ReportsDate&gt;='2022-03-11' and a.ReportsDate &lt;= '2022-03-17 23:59:59' ) AS PagerTable<br />PARAMS:<br />MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。 <br />TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)<br /> 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)<br /> 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)<br /> 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp; dataReady)<br /> 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()<br /> 在 System.Data.SqlClient.SqlDataReader.get_MetaData()<br /> 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)<br /> 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task&amp; task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)<br /> 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task&amp; task, Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry)<br /> 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)<br /> 在 System.Data.SqlClient.SqlCommand.ExecuteScalar()<br /> 在 RB.DAL.DBOperator.GetSingle(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)<br /> 在 RB.DAL.DBOperator.GetSingle(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)<br /> 在 RB.DAL.DBOperator.QueryPager(String SQLString, String strOrder, Int32 pageIndex, Int32 pageSize, Int32&amp; recordCount, Int32 times, SqlParameter[] cmdParms)<br /> 在 RB.DAL.DBOperator.QueryPager(String SQLString, String strOrder, Int32 pageIndex, Int32 pageSize, Int32&amp; recordCount, Int32 times)<br /> 在 RB.DALExtendV2.RB_AmazonSalesTrafficReportsExtendV2.GetPagerList(RB_AmazonSalesTrafficReports_PSParameters parameters, Int32&amp; recordCount)<br /> 在 PandaBuy.ERP.Web.IrobotBox.SalesAnalysis.AmazonDetailPageSalesandTraffic.Page_Load(Object sender, EventArgs e)<br /> 在 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)<br /> 在 System.Web.UI.Control.OnLoad(EventArgs e)<br /> 在 System.Web.UI.Control.LoadRecursive()<br /> 在 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)<br /> 在 System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)<br /> 在 System.Web.UI.Page.ProcessRequest()<br /> 在 System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)<br /> 在 System.Web.UI.Page.ProcessRequest(HttpContext context)<br /> 在 ASP.irobotbox_salesanalysis_amazondetailpagesalesandtraffic_aspx.ProcessRequest(HttpContext context)<br /> 在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()<br /> 在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)<br /> 在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&amp; completedSynchronously)<br /> 在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)<br /> 在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)<br /> 在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)<br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /> 在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus&amp; notificationStatus)<br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /><br />-------------------------------------------------------------<br /><br /> <br /><br /><p>[期望]</p>
005+ <br />