重现步骤

[步骤]


CODE:N1714411

Error:15_137_2_-2146232060

SQL: -- DECLARE @StartTime datetime = '2024-08-09';
 -- DECLARE @EndTime datetime = '2024-09-10';
 -- DECLARE @CustomerId int  = 1;
SELECT
a.ShipTime AS '发货时间',
a.OrderCode AS '系统订单号',
a.TrackNumbers AS '上传追踪号',
a.MainOrderCode AS '海外仓订单号',
d.Country_cn AS '国家',
e.WareHouseName AS '发货仓库',
c.TransportName AS '运输方式',
ISNULL(MAX(PredFreight), 0) AS '系统预估运费',
-SUM(b.OverSeasShipFees + b.FBATransactionFees)AS '海外仓返回运费',
min(TotalFee) '同步海外仓费用'
FROM 
dbo.RB_OrderInfo(NOLOCK) AS a
LEFT JOIN dbo.RB_Report_OrderSettlement(NOLOCK) AS b 
ON a.CustomerID = b.CustomerID AND a.OrderCode = b.OrderCode
LEFT JOIN dbo.RB_Transport(NOLOCK) AS c ON a.TransportID = c.ID
LEFT JOIN dbo.E_Country(NOLOCK) AS d ON a.Country = d.Shorthand
LEFT JOIN dbo.RB_WareHouse(NOLOCK) AS e ON a.CustomerID = e.CustomerID AND a.WareHouseID = e.ID
LEFT JOIN RB_OverseaOrderFee(NOLOCK) as f on a.OrderCode=f.OrderCode and a.CustomerID = f.CustomerID
LEFT JOIN RB_OrderInfo_Expand(NOLOCK) as opf on a.OrderCode=opf.OrderCode and a.CustomerID = opf.CustomerID
WHERE a.CustomerID = @CustomerID AND a.OrderStatus !=2 AND a.IsStockOrder = 0 AND e.WareHouseType NOT IN (1,3) AND IsFBAOrder = 0
AND a.ShipTime >= @StartTime AND a.ShipTime <= @EndTime
GROUP BY
a.ShipTime,
a.TrackNumbers,
a.OrderCode,
a.MainOrderCode,
d.Country_cn,
e.WareHouseName,
c.TransportName

PARAMS:@StartTime = 2025-05-01 ,@CustomerId = 1 ,

MESSAGE:Must declare the scalar variable "@EndTime".

TRACE:   在 System.Data.SqlClient.SqlConnection.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.ExecuteReader(CommandBehavior behavior, String method)

   在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)

   在 RB.DAL.DBOperator.ExecuteReader(String SQLString, SqlParameter[] cmdParms, Boolean IsWriteDB, Int32 Timeout)   在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)

   在 RB.DAL.DBOperator.ExecuteReader(String SQLString, SqlParameter[] cmdParms, Boolean IsWriteDB, Int32 Timeout)

   在 Biz.Irobotbox.ReportCentre.CustomReportService.GetPageDataForCustomReportToSqlDataReader(String firstFileFullPath, RB_CustomReportTask customReportTask, String[] noPermsissionfields, Dictionary`2 paramList, List`1 exportFields, String orderBy, Int32 timeOut)

   在 Biz.Irobotbox.ReportCentre.CustomReportService.ExportCSVBySteam(RB_CustomReportTask customReportTask, String[] noPermsissionfields, Dictionary`2 paramValues, List`1 exportFields, String orderField, Int32 timeOut)

   在 Biz.Irobotbox.ReportCentre.CustomReportService.ExecuteCustomReportTask(List`1 customReportList)

   在 System.Threading.Tasks.Task.Execute()

   在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

   在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

   在 System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot)

   在 System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution)

   在 System.Threading.Tasks.Schedulers.LimitedConcurrencyLevelTaskScheduler.<NotifyThreadPoolOfPendingWork>b__6_0(Object _)

   在 System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()

   在 System.Threading.ThreadPoolWorkQueue.Dispatch()



[结果]


[期望]



修复异常

历史记录  
  1. 2025-05-20 17:21:58, 由 袁慧斌 创建。
  2. 2025-05-20 17:29:03, 由 李乐同 指派给 张明磊。
    修改了 指派给,旧值为 "liletong",新值为 "zhangminglei"。
  3. 2025-05-20 17:37:58, 由 张明磊 解决,方案为 配置问题 。
    修改了 解决方案,旧值为 "",新值为 "deploy"。
    修改了 解决日期,旧值为 "",新值为 "2025-05-20 17:37:29"。
    修改了 指派给 ,旧值为 "zhangminglei",新值为 "yuanhuibin"。
    修改了 Bug状态 ,旧值为 "active",新值为 "resolved"。
    修改了 是否确认,旧值为 "0",新值为 "1"。
    修改了 解决者 ,旧值为 "",新值为 "zhangminglei"。

    自定义报告未设置必填 已调整

  4. 2025-05-21 17:26:29, 由 曾倩 编辑。
    修改了 测试责任人,旧值为 "",新值为 "yuanhuibin"。
    修改了 解决时效 ,旧值为 "0",新值为 "0.26"。
    修改了 重现步骤 ,区别为:
    002-
    002+ CODE:N1714411Error:15_137_2_-2146232060SQL: -- DECLARE @StartTime datetime = '2024-08-09';-- DECLARE @EndTime datetime = '2024-09-10';-- DECLARE @CustomerId int = 1;SELECTa.ShipTime AS '发货时间',a.OrderCode AS '系统订单号',a.TrackNumbers AS '上传追踪号',a.MainOrderCode AS '海外仓订单号',d.Country_cn AS '国家',e.WareHouseName AS '发货仓库',c.TransportName AS '运输方式',ISNULL(MAX(PredFreight), 0) AS '系统预估运费',-SUM(b.OverSeasShipFees + b.FBATransactionFees)AS '海外仓返回运费',min(TotalFee) '同步海外仓费用'FROMdbo.RB_OrderInfo(NOLOCK) AS aLEFT JOIN dbo.RB_Report_OrderSettlement(NOLOCK) AS bON a.CustomerID = b.CustomerID AND a.OrderCode = b.OrderCodeLEFT JOIN dbo.RB_Transport(NOLOCK) AS c ON a.TransportID = c.IDLEFT JOIN dbo.E_Country(NOLOCK) AS d ON a.Country = d.ShorthandLEFT JOIN dbo.RB_WareHouse(NOLOCK) AS e ON a.CustomerID = e.CustomerID AND a.WareHouseID = e.IDLEFT JOIN RB_OverseaOrderFee(NOLOCK) as f on a.OrderCode=f.OrderCode and a.CustomerID = f.CustomerIDLEFT JOIN RB_OrderInfo_Expand(NOLOCK) as opf on a.OrderCode=opf.OrderCode and a.CustomerID = opf.CustomerIDWHERE a.CustomerID = @CustomerID AND a.OrderStatus !=2 AND a.IsStockOrder = 0 AND e.WareHouseType NOT IN (1,3) AND IsFBAOrder = 0AND a.ShipTime &gt;= @StartTime AND a.ShipTime &lt;= @EndTimeGROUP BYa.ShipTime,a.TrackNumbers,a.OrderCode,a.MainOrderCode,d.Country_cn,e.WareHouseName,c.TransportNamePARAMS:@StartTime = 2025-05-01 ,@CustomerId = 1 ,MESSAGE:Must declare the scalar variable "@EndTime".TRACE: 在 System.Data.SqlClient.SqlConnection.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&amp; 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&amp; 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&amp; task, Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) 在 RB.DAL.DBOperator.ExecuteReader(String SQLString, SqlParameter[] cmdParms, Boolean IsWriteDB, Int32 Timeout) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms) 在 RB.DAL.DBOperator.ExecuteReader(String SQLString, SqlParameter[] cmdParms, Boolean IsWriteDB, Int32 Timeout) 在 Biz.Irobotbox.ReportCentre.CustomReportService.GetPageDataForCustomReportToSqlDataReader(String firstFileFullPath, RB_CustomReportTask customReportTask, String[] noPermsissionfields, Dictionary`2 paramList, List`1 exportFields, String orderBy, Int32 timeOut) 在 Biz.Irobotbox.ReportCentre.CustomReportService.ExportCSVBySteam(RB_CustomReportTask customReportTask, String[] noPermsissionfields, Dictionary`2 paramValues, List`1 exportFields, String orderField, Int32 timeOut) 在 Biz.Irobotbox.ReportCentre.CustomReportService.ExecuteCustomReportTask(List`1 customReportList) 在 System.Threading.Tasks.Task.Execute() 在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) 在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) 在 System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task&amp; currentTaskSlot) 在 System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution) 在 System.Threading.Tasks.Schedulers.LimitedConcurrencyLevelTaskScheduler.&lt;NotifyThreadPoolOfPendingWork&gt;b__6_0(Object _) 在 System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem() 在 System.Threading.ThreadPoolWorkQueue.Dispatch()
    003- CODE:N1714411Error:15_137_2_-2146232060SQL: -- DECLARE @StartTime datetime = '2024-08-09';-- DECLARE @EndTime datetime = '2024-09-10';-- DECLARE @CustomerId int = 1;SELECTa.ShipTime AS '发货时间',a.OrderCode AS '系统订单号',a.TrackNumbers AS '上传追踪号',a.MainOrderCode AS '海外仓订单号',d.Country_cn AS '国家',e.WareHouseName AS '发货仓库',c.TransportName AS '运输方式',ISNULL(MAX(PredFreight), 0) AS '系统预估运费',-SUM(b.OverSeasShipFees + b.FBATransactionFees)AS '海外仓返回运费',min(TotalFee) '同步海外仓费用'FROMdbo.RB_OrderInfo(NOLOCK) AS aLEFT JOIN dbo.RB_Report_OrderSettlement(NOLOCK) AS bON a.CustomerID = b.CustomerID AND a.OrderCode = b.OrderCodeLEFT JOIN dbo.RB_Transport(NOLOCK) AS c ON a.TransportID = c.IDLEFT JOIN dbo.E_Country(NOLOCK) AS d ON a.Country = d.ShorthandLEFT JOIN dbo.RB_WareHouse(NOLOCK) AS e ON a.CustomerID = e.CustomerID AND a.WareHouseID = e.IDLEFT JOIN RB_OverseaOrderFee(NOLOCK) as f on a.OrderCode=f.OrderCode and a.CustomerID = f.CustomerIDLEFT JOIN RB_OrderInfo_Expand(NOLOCK) as opf on a.OrderCode=opf.OrderCode and a.CustomerID = opf.CustomerIDWHERE a.CustomerID = @CustomerID AND a.OrderStatus !=2 AND a.IsStockOrder = 0 AND e.WareHouseType NOT IN (1,3) AND IsFBAOrder = 0AND a.ShipTime &gt;= @StartTime AND a.ShipTime &lt;= @EndTimeGROUP BYa.ShipTime,a.TrackNumbers,a.OrderCode,a.MainOrderCode,d.Country_cn,e.WareHouseName,c.TransportNamePARAMS:@StartTime = 2025-05-01 ,@CustomerId = 1 ,MESSAGE:Must declare the scalar variable "@EndTime".TRACE: 在 System.Data.SqlClient.SqlConnection.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&amp; 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&amp; 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&amp; task, Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) 在 RB.DAL.DBOperator.ExecuteReader(String SQLString, SqlParameter[] cmdParms, Boolean IsWriteDB, Int32 Timeout) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms) 在 RB.DAL.DBOperator.ExecuteReader(String SQLString, SqlParameter[] cmdParms, Boolean IsWriteDB, Int32 Timeout) 在 Biz.Irobotbox.ReportCentre.CustomReportService.GetPageDataForCustomReportToSqlDataReader(String firstFileFullPath, RB_CustomReportTask customReportTask, String[] noPermsissionfields, Dictionary`2 paramList, List`1 exportFields, String orderBy, Int32 timeOut) 在 Biz.Irobotbox.ReportCentre.CustomReportService.ExportCSVBySteam(RB_CustomReportTask customReportTask, String[] noPermsissionfields, Dictionary`2 paramValues, List`1 exportFields, String orderField, Int32 timeOut) 在 Biz.Irobotbox.ReportCentre.CustomReportService.ExecuteCustomReportTask(List`1 customReportList) 在 System.Threading.Tasks.Task.Execute() 在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) 在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) 在 System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task&amp; currentTaskSlot) 在 System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution) 在 System.Threading.Tasks.Schedulers.LimitedConcurrencyLevelTaskScheduler.&lt;NotifyThreadPoolOfPendingWork&gt;b__6_0(Object _) 在 System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem() 在 System.Threading.ThreadPoolWorkQueue.Dispatch()
    003+
    004-
    004+
    005-
    005+ [结果]
    006- [结果]
    006+ [期望]
    007- [期望]
    007+
    008-
    008+ 修复异常
    009- 修复异常
    009+
    010-
    002- <p></p>
    002+ <p><br />CODE:N1714411<br /><br />Error:15_137_2_-2146232060<br /><br />SQL: -- DECLARE @StartTime datetime = '2024-08-09';<br />-- DECLARE @EndTime datetime = '2024-09-10';<br />-- DECLARE @CustomerId int = 1;<br />SELECT<br />a.ShipTime AS '发货时间',<br />a.OrderCode AS '系统订单号',<br />a.TrackNumbers AS '上传追踪号',<br />a.MainOrderCode AS '海外仓订单号',<br />d.Country_cn AS '国家',<br />e.WareHouseName AS '发货仓库',<br />c.TransportName AS '运输方式',<br />ISNULL(MAX(PredFreight), 0) AS '系统预估运费',<br />-SUM(b.OverSeasShipFees + b.FBATransactionFees)AS '海外仓返回运费',<br />min(TotalFee) '同步海外仓费用'<br />FROM<br />dbo.RB_OrderInfo(NOLOCK) AS a<br />LEFT JOIN dbo.RB_Report_OrderSettlement(NOLOCK) AS b<br />ON a.CustomerID = b.CustomerID AND a.OrderCode = b.OrderCode<br />LEFT JOIN dbo.RB_Transport(NOLOCK) AS c ON a.TransportID = c.ID<br />LEFT JOIN dbo.E_Country(NOLOCK) AS d ON a.Country = d.Shorthand<br />LEFT JOIN dbo.RB_WareHouse(NOLOCK) AS e ON a.CustomerID = e.CustomerID AND a.WareHouseID = e.ID<br />LEFT JOIN RB_OverseaOrderFee(NOLOCK) as f on a.OrderCode=f.OrderCode and a.CustomerID = f.CustomerID<br />LEFT JOIN RB_OrderInfo_Expand(NOLOCK) as opf on a.OrderCode=opf.OrderCode and a.CustomerID = opf.CustomerID<br />WHERE a.CustomerID = @CustomerID AND a.OrderStatus !=2 AND a.IsStockOrder = 0 AND e.WareHouseType NOT IN (1,3) AND IsFBAOrder = 0<br />AND a.ShipTime &gt;= @StartTime AND a.ShipTime &lt;= @EndTime<br />GROUP BY<br />a.ShipTime,<br />a.TrackNumbers,<br />a.OrderCode,<br />a.MainOrderCode,<br />d.Country_cn,<br />e.WareHouseName,<br />c.TransportName<br /><br />PARAMS:@StartTime = 2025-05-01 ,@CustomerId = 1 ,<br /><br />MESSAGE:Must declare the scalar variable "@EndTime".<br /><br />TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)<br /><br /> 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)<br /><br /> 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp; dataReady)<br /><br /> 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()<br /><br /> 在 System.Data.SqlClient.SqlDataReader.get_MetaData()<br /><br /> 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)<br /><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 /><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 /><br /> 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)<br /><br /> 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)<br /><br /> 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)<br /><br /> 在 RB.DAL.DBOperator.ExecuteReader(String SQLString, SqlParameter[] cmdParms, Boolean IsWriteDB, Int32 Timeout) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)<br /><br /> 在 RB.DAL.DBOperator.ExecuteReader(String SQLString, SqlParameter[] cmdParms, Boolean IsWriteDB, Int32 Timeout)<br /><br /> 在 Biz.Irobotbox.ReportCentre.CustomReportService.GetPageDataForCustomReportToSqlDataReader(String firstFileFullPath, RB_CustomReportTask customReportTask, String[] noPermsissionfields, Dictionary`2 paramList, List`1 exportFields, String orderBy, Int32 timeOut)<br /><br /> 在 Biz.Irobotbox.ReportCentre.CustomReportService.ExportCSVBySteam(RB_CustomReportTask customReportTask, String[] noPermsissionfields, Dictionary`2 paramValues, List`1 exportFields, String orderField, Int32 timeOut)<br /><br /> 在 Biz.Irobotbox.ReportCentre.CustomReportService.ExecuteCustomReportTask(List`1 customReportList)<br /><br /> 在 System.Threading.Tasks.Task.Execute()<br /><br /> 在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)<br /><br /> 在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)<br /><br /> 在 System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task&amp; currentTaskSlot)<br /><br /> 在 System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution)<br /><br /> 在 System.Threading.Tasks.Schedulers.LimitedConcurrencyLevelTaskScheduler.&lt;NotifyThreadPoolOfPendingWork&gt;b__6_0(Object _)<br /><br /> 在 System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()<br /><br /> 在 System.Threading.ThreadPoolWorkQueue.Dispatch()</p>
    003- <p><br />CODE:N1714411<br /><br />Error:15_137_2_-2146232060<br /><br />SQL: -- DECLARE @StartTime datetime = '2024-08-09';<br />-- DECLARE @EndTime datetime = '2024-09-10';<br />-- DECLARE @CustomerId int = 1;<br />SELECT<br />a.ShipTime AS '发货时间',<br />a.OrderCode AS '系统订单号',<br />a.TrackNumbers AS '上传追踪号',<br />a.MainOrderCode AS '海外仓订单号',<br />d.Country_cn AS '国家',<br />e.WareHouseName AS '发货仓库',<br />c.TransportName AS '运输方式',<br />ISNULL(MAX(PredFreight), 0) AS '系统预估运费',<br />-SUM(b.OverSeasShipFees + b.FBATransactionFees)AS '海外仓返回运费',<br />min(TotalFee) '同步海外仓费用'<br />FROM<br />dbo.RB_OrderInfo(NOLOCK) AS a<br />LEFT JOIN dbo.RB_Report_OrderSettlement(NOLOCK) AS b<br />ON a.CustomerID = b.CustomerID AND a.OrderCode = b.OrderCode<br />LEFT JOIN dbo.RB_Transport(NOLOCK) AS c ON a.TransportID = c.ID<br />LEFT JOIN dbo.E_Country(NOLOCK) AS d ON a.Country = d.Shorthand<br />LEFT JOIN dbo.RB_WareHouse(NOLOCK) AS e ON a.CustomerID = e.CustomerID AND a.WareHouseID = e.ID<br />LEFT JOIN RB_OverseaOrderFee(NOLOCK) as f on a.OrderCode=f.OrderCode and a.CustomerID = f.CustomerID<br />LEFT JOIN RB_OrderInfo_Expand(NOLOCK) as opf on a.OrderCode=opf.OrderCode and a.CustomerID = opf.CustomerID<br />WHERE a.CustomerID = @CustomerID AND a.OrderStatus !=2 AND a.IsStockOrder = 0 AND e.WareHouseType NOT IN (1,3) AND IsFBAOrder = 0<br />AND a.ShipTime &gt;= @StartTime AND a.ShipTime &lt;= @EndTime<br />GROUP BY<br />a.ShipTime,<br />a.TrackNumbers,<br />a.OrderCode,<br />a.MainOrderCode,<br />d.Country_cn,<br />e.WareHouseName,<br />c.TransportName<br /><br />PARAMS:@StartTime = 2025-05-01 ,@CustomerId = 1 ,<br /><br />MESSAGE:Must declare the scalar variable "@EndTime".<br /><br />TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)<br /><br /> 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)<br /><br /> 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp; dataReady)<br /><br /> 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()<br /><br /> 在 System.Data.SqlClient.SqlDataReader.get_MetaData()<br /><br /> 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)<br /><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 /><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 /><br /> 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)<br /><br /> 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)<br /><br /> 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)<br /><br /> 在 RB.DAL.DBOperator.ExecuteReader(String SQLString, SqlParameter[] cmdParms, Boolean IsWriteDB, Int32 Timeout) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)<br /><br /> 在 RB.DAL.DBOperator.ExecuteReader(String SQLString, SqlParameter[] cmdParms, Boolean IsWriteDB, Int32 Timeout)<br /><br /> 在 Biz.Irobotbox.ReportCentre.CustomReportService.GetPageDataForCustomReportToSqlDataReader(String firstFileFullPath, RB_CustomReportTask customReportTask, String[] noPermsissionfields, Dictionary`2 paramList, List`1 exportFields, String orderBy, Int32 timeOut)<br /><br /> 在 Biz.Irobotbox.ReportCentre.CustomReportService.ExportCSVBySteam(RB_CustomReportTask customReportTask, String[] noPermsissionfields, Dictionary`2 paramValues, List`1 exportFields, String orderField, Int32 timeOut)<br /><br /> 在 Biz.Irobotbox.ReportCentre.CustomReportService.ExecuteCustomReportTask(List`1 customReportList)<br /><br /> 在 System.Threading.Tasks.Task.Execute()<br /><br /> 在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)<br /><br /> 在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)<br /><br /> 在 System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task&amp; currentTaskSlot)<br /><br /> 在 System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution)<br /><br /> 在 System.Threading.Tasks.Schedulers.LimitedConcurrencyLevelTaskScheduler.&lt;NotifyThreadPoolOfPendingWork&gt;b__6_0(Object _)<br /><br /> 在 System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()<br /><br /> 在 System.Threading.ThreadPoolWorkQueue.Dispatch()<br /></p><div><br /></div>
    003+ <div><br /></div>
    004-
    004+ <p><br /></p>
    005- <p><br /></p>
    005+ <p>[结果]</p>
    006- <p>[结果]</p>
    006+ <br /><p>[期望]</p>
    007- <br /><p>[期望]</p>
    007+ <br /><div><span style="color:#333333;"><br /></span></div>
    008- <br /><div><span style="color:#333333;"><br /></span></div>
    008+ <div><span style="color:#333333;">修复异常</span></div>
    009- <div><span style="color:#333333;">修复异常</span></div>
    009+ <div><span style="color:#333333;"><br /></span></div>
    010- <div><span style="color:#333333;"><br /></span></div>
  5. 2025-05-21 17:27:21, 由 曾倩 编辑。
    修改了 测试责任人,旧值为 "yuanhuibin",新值为 "huangfeng"。
  6. 2025-05-21 17:27:53, 由 曾倩 编辑。
    修改了 上线时间,旧值为 "0000-00-00 00:00:00",新值为 "2025-05-20 17:40"。
    修改了 上线时效,旧值为 "-1",新值为 "0.30"。
  7. 2025-05-21 17:27:56, 由 曾倩 关闭。
    修改了 Bug状态 ,旧值为 "resolved",新值为 "closed"。
    修改了 指派给 ,旧值为 "yuanhuibin",新值为 "closed"。
    修改了 由谁关闭,旧值为 "",新值为 "zengqian"。
    修改了 关闭日期,旧值为 "",新值为 "2025-05-21 17:27:56"。
所属项目 技术中心-需求池
所属模块 财务   盛宝隆
所属计划
所属迭代
Bug类型
严重程度 一般
优先级 P2
Bug状态 已关闭
业务部门 亚马逊平台运营中心
影响功能
开发责任人 张明磊
测试责任人 黄凤
解决时效 0.26
激活次数 0
激活日期
是否确认 是
当前指派 Closed 于 2025-05-21 17:27:56
截止日期 0000-00-00
上线时间 2025-05-20 17:40:00
上线时效 0.3
操作系统
浏览器
关键词
抄送给
所属迭代
相关需求
相关任务
由谁创建 袁慧斌 于 2025-05-20 17:21:58
影响环境 生产环境-业务反馈
由谁解决 张明磊 于 2025-05-20 17:37:29
解决版本
解决方案 配置问题
由谁关闭 曾倩 于 2025-05-21 17:27:56
最后修改 曾倩 于 2025-05-21 17:27:56
相关Bug