重现步骤


日志

 CODE:O1531492
Error:15_102_1_-2146232060
SQL:SELECT b.WareHouseName AS '仓库', CASE a.MoveType WHEN 1 THEN '产品爆旺平移库' WHEN 2 THEN '合并库位移库' WHEN 3 THEN '重型货架移库' WHEN 4 THEN '特定SKU移库' END AS '移库类型', rp.SKU AS '系统SKU', rp.ClientSKU AS '自定义SKU', CASE a.ProductVitalityType WHEN 0 THEN '普通款' WHEN 1 THEN '爆款' WHEN 2 THEN '平款' WHEN 3 THEN '旺款' WHEN 4 THEN '滞销款' END AS '产品爆旺平', wps.PositionCode AS '当前库位', CASE a.PositionVitalityType WHEN 0 THEN '未设置' WHEN 1 THEN '爆款' WHEN 2 THEN '平款' WHEN 3 THEN '旺款' WHEN 4 THEN '滞销款' END AS '库位爆旺平', a.AvaliableStockNumber AS '库位可用库存', wa.AreaName AS '库位区域', a.OutFrequency AS '出库频次', a.AddTime AS '加载时间' FROM RB_Region_MovePosition_RecommandProduct a WITH(NOLOCK) INNER JOIN RB_Product rp(NOLOCK) ON a.SKU=rp.SKU AND a.CustomerID=rp.CustomerIDINNER JOIN RB_WareHouse wh(NOLOCK) ON a.WareHouseID = wh.ID AND a.CustomerID = wh.CustomerIDINNER JOIN RB_WareHouse_Position wps(NOLOCK) ON a.PositionID = wps.ID AND a.CustomerID = wps.CustomerIDINNER JOIN RB_WareHouseArea wa(NOLOCK) ON a.WarehouseAreaID = wa.ID AND a.CustomerID = wa.CustomerID a.CustomerID=1 AND a.MoveStatus=0 ORDER BY a.ID DESC
MESSAGE:“a”附近有语法错误。
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.ExecuteReader(CommandBehavior behavior, String method)
   在 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   在 GotDotNet.ApplicationBlocks.Data.AdoHelper.ExecuteDataset(IDbCommand command)
   在 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(SqlCommand command)
   在 PandaBuy.ERP.DAL.DBOperator.GetDSExecuteSqlNoTimeOut(String p_Sql, Boolean IsWriteDB)   在 PandaBuy.ERP.DAL.DBOperator.E8mARE5em(SqlException  , String  )
   在 PandaBuy.ERP.DAL.DBOperator.GetDSExecuteSqlNoTimeOut(String p_Sql, Boolean IsWriteDB)
   在 Biz.TaskApply.ReportTaskApply.ReportTaskExecute_OLD(RB_ReportApply_Task task)
   在 Biz.TaskApply.ReportTaskApply.ProcessExportExcel(RB_ReportApply_Task task)
   在 RB.Utility.TaskSmartManager`1.execute(Func`2 execFunction)
   在 RB.Utility.TaskSmartManager`1.<>c__DisplayClass17_0.<TaskExecute>b__0()
   在 System.Threading.Tasks.Task.InnerInvoke()
   在 System.Threading.Tasks.Task.Execute()
   在 System.Threading.Tasks.Task.ExecutionContextCallback(Object obj)
   在 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.Task.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
   在 System.Threading.ThreadPoolWorkQueue.Dispatch()
   在 System.Threading._ThreadPoolWaitCallback.PerformWaitCallback()

-------------------------------------------------------------

   

历史记录  
  1. 2023-02-11 15:34:05, 由 刘超 创建。
  2. 2023-02-13 14:10:47, 由 唐飞飞 解决,方案为 程序BUG 。
    修改了 解决方案,旧值为 "",新值为 "code"。
    修改了 解决版本,旧值为 "",新值为 "trunk"。
    修改了 解决日期,旧值为 "",新值为 "2023-02-13 11:19:01"。
    修改了 指派给 ,旧值为 "tangfeifei",新值为 "liuchao"。
    修改了 Bug状态 ,旧值为 "active",新值为 "resolved"。
    修改了 是否确认,旧值为 "0",新值为 "1"。
    修改了 解决者 ,旧值为 "",新值为 "tangfeifei"。

    bug原因:

         导出的时候sql语句拼接错误,关键词和sql语句之间没有留空格


    bug解决后的效果

    1、单个关键词搜索

    2、批量搜索




  3. 2023-02-13 19:03:43, 由 刘超 编辑。
    修改了 重现步骤,区别为:
    005- CODE:O1531492Error:15_102_1_-2146232060SQL:SELECT b.WareHouseName AS '仓库', CASE a.MoveType WHEN 1 THEN '产品爆旺平移库' WHEN 2 THEN '合并库位移库' WHEN 3 THEN '重型货架移库' WHEN 4 THEN '特定SKU移库' END AS '移库类型', rp.SKU AS '系统SKU', rp.ClientSKU AS '自定义SKU', CASE a.ProductVitalityType WHEN 0 THEN '普通款' WHEN 1 THEN '爆款' WHEN 2 THEN '平款' WHEN 3 THEN '旺款' WHEN 4 THEN '滞销款' END AS '产品爆旺平', wps.PositionCode AS '当前库位', CASE a.PositionVitalityType WHEN 0 THEN '未设置' WHEN 1 THEN '爆款' WHEN 2 THEN '平款' WHEN 3 THEN '旺款' WHEN 4 THEN '滞销款' END AS '库位爆旺平', a.AvaliableStockNumber AS '库位可用库存', wa.AreaName AS '库位区域', a.OutFrequency AS '出库频次', a.AddTime AS '加载时间' FROM RB_Region_MovePosition_RecommandProduct a WITH(NOLOCK) INNER JOIN RB_Product rp(NOLOCK) ON a.SKU=rp.SKU AND a.CustomerID=rp.CustomerIDINNER JOIN RB_WareHouse wh(NOLOCK) ON a.WareHouseID = wh.ID AND a.CustomerID = wh.CustomerIDINNER JOIN RB_WareHouse_Position wps(NOLOCK) ON a.PositionID = wps.ID AND a.CustomerID = wps.CustomerIDINNER JOIN RB_WareHouseArea wa(NOLOCK) ON a.WarehouseAreaID = wa.ID AND a.CustomerID = wa.CustomerID a.CustomerID=1 AND a.MoveStatus=0 ORDER BY a.ID DESC MESSAGE:“a”附近有语法错误。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&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.ExecuteDbDataReader(CommandBehavior behavior) 在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) 在 GotDotNet.ApplicationBlocks.Data.AdoHelper.ExecuteDataset(IDbCommand command) 在 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(SqlCommand command) 在 PandaBuy.ERP.DAL.DBOperator.GetDSExecuteSqlNoTimeOut(String p_Sql, Boolean IsWriteDB) 在 PandaBuy.ERP.DAL.DBOperator.E8mARE5em(SqlException , String ) 在 PandaBuy.ERP.DAL.DBOperator.GetDSExecuteSqlNoTimeOut(String p_Sql, Boolean IsWriteDB) 在 Biz.TaskApply.ReportTaskApply.ReportTaskExecute_OLD(RB_ReportApply_Task task) 在 Biz.TaskApply.ReportTaskApply.ProcessExportExcel(RB_ReportApply_Task task) 在 RB.Utility.TaskSmartManager`1.execute(Func`2 execFunction) 在 RB.Utility.TaskSmartManager`1.&lt;&gt;c__DisplayClass17_0.&lt;TaskExecute&gt;b__0() 在 System.Threading.Tasks.Task.InnerInvoke() 在 System.Threading.Tasks.Task.Execute() 在 System.Threading.Tasks.Task.ExecutionContextCallback(Object obj) 在 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.Task.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem() 在 System.Threading.ThreadPoolWorkQueue.Dispatch() 在 System.Threading._ThreadPoolWaitCallback.PerformWaitCallback()-------------------------------------------------------------
    005+ CODE:O1531492Error:15_102_1_-2146232060SQL:SELECT b.WareHouseName AS '仓库', CASE a.MoveType WHEN 1 THEN '产品爆旺平移库' WHEN 2 THEN '合并库位移库' WHEN 3 THEN '重型货架移库' WHEN 4 THEN '特定SKU移库' END AS '移库类型', rp.SKU AS '系统SKU', rp.ClientSKU AS '自定义SKU', CASE a.ProductVitalityType WHEN 0 THEN '普通款' WHEN 1 THEN '爆款' WHEN 2 THEN '平款' WHEN 3 THEN '旺款' WHEN 4 THEN '滞销款' END AS '产品爆旺平', wps.PositionCode AS '当前库位', CASE a.PositionVitalityType WHEN 0 THEN '未设置' WHEN 1 THEN '爆款' WHEN 2 THEN '平款' WHEN 3 THEN '旺款' WHEN 4 THEN '滞销款' END AS '库位爆旺平', a.AvaliableStockNumber AS '库位可用库存', wa.AreaName AS '库位区域', a.OutFrequency AS '出库频次', a.AddTime AS '加载时间' FROM RB_Region_MovePosition_RecommandProduct a WITH(NOLOCK) INNER JOIN RB_Product rp(NOLOCK) ON a.SKU=rp.SKU AND a.CustomerID=rp.CustomerIDINNER JOIN RB_WareHouse wh(NOLOCK) ON a.WareHouseID = wh.ID AND a.CustomerID = wh.CustomerIDINNER JOIN RB_WareHouse_Position wps(NOLOCK) ON a.PositionID = wps.ID AND a.CustomerID = wps.CustomerIDINNER JOIN RB_WareHouseArea wa(NOLOCK) ON a.WarehouseAreaID = wa.ID AND a.CustomerID = wa.CustomerID a.CustomerID=1 AND a.MoveStatus=0 ORDER BY a.ID DESC MESSAGE:“a”附近有语法错误。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&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.ExecuteDbDataReader(CommandBehavior behavior) 在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) 在 GotDotNet.ApplicationBlocks.Data.AdoHelper.ExecuteDataset(IDbCommand command) 在 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(SqlCommand command) 在 PandaBuy.ERP.DAL.DBOperator.GetDSExecuteSqlNoTimeOut(String p_Sql, Boolean IsWriteDB) 在 PandaBuy.ERP.DAL.DBOperator.E8mARE5em(SqlException , String ) 在 PandaBuy.ERP.DAL.DBOperator.GetDSExecuteSqlNoTimeOut(String p_Sql, Boolean IsWriteDB) 在 Biz.TaskApply.ReportTaskApply.ReportTaskExecute_OLD(RB_ReportApply_Task task) 在 Biz.TaskApply.ReportTaskApply.ProcessExportExcel(RB_ReportApply_Task task) 在 RB.Utility.TaskSmartManager`1.execute(Func`2 execFunction) 在 RB.Utility.TaskSmartManager`1.&lt;&gt;c__DisplayClass17_0.&lt;TaskExecute&gt;b__0() 在 System.Threading.Tasks.Task.InnerInvoke() 在 System.Threading.Tasks.Task.Execute() 在 System.Threading.Tasks.Task.ExecutionContextCallback(Object obj) 在 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.Task.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem() 在 System.Threading.ThreadPoolWorkQueue.Dispatch() 在 System.Threading._ThreadPoolWaitCallback.PerformWaitCallback()-------------------------------------------------------------
    005- <p>CODE:O1531492<br />Error:15_102_1_-2146232060<br />SQL:SELECT b.WareHouseName AS '仓库', CASE a.MoveType WHEN 1 THEN '产品爆旺平移库' WHEN 2 THEN '合并库位移库' WHEN 3 THEN '重型货架移库' WHEN 4 THEN '特定SKU移库' END AS '移库类型', rp.SKU AS '系统SKU', rp.ClientSKU AS '自定义SKU', CASE a.ProductVitalityType WHEN 0 THEN '普通款' WHEN 1 THEN '爆款' WHEN 2 THEN '平款' WHEN 3 THEN '旺款' WHEN 4 THEN '滞销款' END AS '产品爆旺平', wps.PositionCode AS '当前库位', CASE a.PositionVitalityType WHEN 0 THEN '未设置' WHEN 1 THEN '爆款' WHEN 2 THEN '平款' WHEN 3 THEN '旺款' WHEN 4 THEN '滞销款' END AS '库位爆旺平', a.AvaliableStockNumber AS '库位可用库存', wa.AreaName AS '库位区域', a.OutFrequency AS '出库频次', a.AddTime AS '加载时间' FROM RB_Region_MovePosition_RecommandProduct a WITH(NOLOCK) INNER JOIN RB_Product rp(NOLOCK) ON a.SKU=rp.SKU AND a.CustomerID=rp.CustomerIDINNER JOIN RB_WareHouse wh(NOLOCK) ON a.WareHouseID = wh.ID AND a.CustomerID = wh.CustomerIDINNER JOIN RB_WareHouse_Position wps(NOLOCK) ON a.PositionID = wps.ID AND a.CustomerID = wps.CustomerIDINNER JOIN RB_WareHouseArea wa(NOLOCK) ON a.WarehouseAreaID = wa.ID AND a.CustomerID = wa.CustomerID a.CustomerID=1 AND a.MoveStatus=0 ORDER BY a.ID DESC <br />MESSAGE:“a”附近有语法错误。<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.ExecuteReader(CommandBehavior behavior, String method)<br /> 在 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)<br /> 在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)<br /> 在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)<br /> 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)<br /> 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)<br /> 在 GotDotNet.ApplicationBlocks.Data.AdoHelper.ExecuteDataset(IDbCommand command)<br /> 在 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(SqlCommand command)<br /> 在 PandaBuy.ERP.DAL.DBOperator.GetDSExecuteSqlNoTimeOut(String p_Sql, Boolean IsWriteDB) 在 PandaBuy.ERP.DAL.DBOperator.E8mARE5em(SqlException , String )<br /> 在 PandaBuy.ERP.DAL.DBOperator.GetDSExecuteSqlNoTimeOut(String p_Sql, Boolean IsWriteDB)<br /> 在 Biz.TaskApply.ReportTaskApply.ReportTaskExecute_OLD(RB_ReportApply_Task task)<br /> 在 Biz.TaskApply.ReportTaskApply.ProcessExportExcel(RB_ReportApply_Task task)<br /> 在 RB.Utility.TaskSmartManager`1.execute(Func`2 execFunction)<br /> 在 RB.Utility.TaskSmartManager`1.&lt;&gt;c__DisplayClass17_0.&lt;TaskExecute&gt;b__0()<br /> 在 System.Threading.Tasks.Task.InnerInvoke()<br /> 在 System.Threading.Tasks.Task.Execute()<br /> 在 System.Threading.Tasks.Task.ExecutionContextCallback(Object obj)<br /> 在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)<br /> 在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)<br /> 在 System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task&amp; currentTaskSlot)<br /> 在 System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution)<br /> 在 System.Threading.Tasks.Task.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()<br /> 在 System.Threading.ThreadPoolWorkQueue.Dispatch()<br /> 在 System.Threading._ThreadPoolWaitCallback.PerformWaitCallback()<br /><br />-------------------------------------------------------------<br /><br /> <br /></p>
    005+ <p>CODE:O1531492<br />Error:15_102_1_-2146232060<br />SQL:SELECT b.WareHouseName AS '仓库', CASE a.MoveType WHEN 1 THEN '产品爆旺平移库' WHEN 2 THEN '合并库位移库' WHEN 3 THEN '重型货架移库' WHEN 4 THEN '特定SKU移库' END AS '移库类型', rp.SKU AS '系统SKU', rp.ClientSKU AS '自定义SKU', CASE a.ProductVitalityType WHEN 0 THEN '普通款' WHEN 1 THEN '爆款' WHEN 2 THEN '平款' WHEN 3 THEN '旺款' WHEN 4 THEN '滞销款' END AS '产品爆旺平', wps.PositionCode AS '当前库位', CASE a.PositionVitalityType WHEN 0 THEN '未设置' WHEN 1 THEN '爆款' WHEN 2 THEN '平款' WHEN 3 THEN '旺款' WHEN 4 THEN '滞销款' END AS '库位爆旺平', a.AvaliableStockNumber AS '库位可用库存', wa.AreaName AS '库位区域', a.OutFrequency AS '出库频次', a.AddTime AS '加载时间' FROM RB_Region_MovePosition_RecommandProduct a WITH(NOLOCK) INNER JOIN RB_Product rp(NOLOCK) ON a.SKU=rp.SKU AND a.CustomerID=rp.CustomerIDINNER JOIN RB_WareHouse wh(NOLOCK) ON a.WareHouseID = wh.ID AND a.CustomerID = wh.CustomerIDINNER JOIN RB_WareHouse_Position wps(NOLOCK) ON a.PositionID = wps.ID AND a.CustomerID = wps.CustomerIDINNER JOIN RB_WareHouseArea wa(NOLOCK) ON a.WarehouseAreaID = wa.ID AND a.CustomerID = wa.CustomerID a.CustomerID=1 AND a.MoveStatus=0 ORDER BY a.ID DESC <br />MESSAGE:“a”附近有语法错误。<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.ExecuteReader(CommandBehavior behavior, String method)<br /> 在 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)<br /> 在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)<br /> 在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)<br /> 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)<br /> 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)<br /> 在 GotDotNet.ApplicationBlocks.Data.AdoHelper.ExecuteDataset(IDbCommand command)<br /> 在 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(SqlCommand command)<br /> 在 PandaBuy.ERP.DAL.DBOperator.GetDSExecuteSqlNoTimeOut(String p_Sql, Boolean IsWriteDB) 在 PandaBuy.ERP.DAL.DBOperator.E8mARE5em(SqlException , String )<br /> 在 PandaBuy.ERP.DAL.DBOperator.GetDSExecuteSqlNoTimeOut(String p_Sql, Boolean IsWriteDB)<br /> 在 Biz.TaskApply.ReportTaskApply.ReportTaskExecute_OLD(RB_ReportApply_Task task)<br /> 在 Biz.TaskApply.ReportTaskApply.ProcessExportExcel(RB_ReportApply_Task task)<br /> 在 RB.Utility.TaskSmartManager`1.execute(Func`2 execFunction)<br /> 在 RB.Utility.TaskSmartManager`1.&lt;&gt;c__DisplayClass17_0.&lt;TaskExecute&gt;b__0()<br /> 在 System.Threading.Tasks.Task.InnerInvoke()<br /> 在 System.Threading.Tasks.Task.Execute()<br /> 在 System.Threading.Tasks.Task.ExecutionContextCallback(Object obj)<br /> 在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)<br /> 在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)<br /> 在 System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task&amp; currentTaskSlot)<br /> 在 System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution)<br /> 在 System.Threading.Tasks.Task.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()<br /> 在 System.Threading.ThreadPoolWorkQueue.Dispatch()<br /> 在 System.Threading._ThreadPoolWaitCallback.PerformWaitCallback()<br /><br />-------------------------------------------------------------<br /><br /></p>

  4. 2023-02-13 19:05:37, 由 刘超 关闭。
    修改了 Bug状态 ,旧值为 "resolved",新值为 "closed"。
    修改了 指派给 ,旧值为 "liuchao",新值为 "closed"。
    修改了 由谁关闭,旧值为 "",新值为 "liuchao"。
    修改了 关闭日期,旧值为 "",新值为 "2023-02-13 19:05:37"。

所属项目 技术中心-需求池
所属模块 /
所属计划
所属迭代 技术研发中心 2月第1版本(2023年)
Bug类型
严重程度 提示
优先级 P2
Bug状态 已关闭
业务部门
影响功能
开发责任人
测试责任人
解决时效 0
激活次数 0
激活日期
是否确认 是
当前指派 Closed 于 2023-02-13 19:05:37
截止日期 0000-00-00
上线时间
上线时效
操作系统
浏览器
关键词
抄送给
由谁创建 刘超 于 2023-02-11 15:34:05
影响环境 651
由谁解决 唐飞飞 于 2023-02-13 11:19:01
解决版本 主干
解决方案 程序BUG
由谁关闭 刘超 于 2023-02-13 19:05:37
最后修改 刘超 于 2023-02-13 19:05:37
相关Bug