Integrated Workbench (Bad Vendor Records) Can't Delete

Has anyone ever had bad records stuck in the Queue table from Multi-Company and couldnt delete the bad records, I dont want these records… I want them to be gone? Any hints. I tried to Delete By Group etc… they seem to be superglued =)

Delete not allowed. (BLException) at Erp.Services.BO.IntgWorkbenchSvc.IntQueInBeforeDelete() in c:_Releases\ERP\RL10.1.500\Source\Server\Services\BO\IntgWorkbench\IntgWorkbench.cs:line 3065 at Ice.Services.Trace.TablesetProfilingCollector.DoRowEventTrace(String tableName, String methodName, Int32 rowCount, Action action) in C:_Releases\ICE\3.1.500.18\Source\Framework\Epicor.Ice\Services\TablesetProfilingCollector.cs:line 146 at Ice.TablesetBound3.DeleteRow(IceDataContext dataContext, String tableName, LinqRow dbRow, TablesetProfilingCollector parentTraceCollector) in C:\_Releases\ICE\3.1.500.18\Source\Framework\Epicor.Ice\Services\TablesetBound.cs:line 1255 at Ice.TablesetBound3.DeleteRow(IceDataContext dc, Int32 tableNum, IIceTable tbl, IceRow row, TablesetProfilingCollector parentTraceCollector) in C:_Releases\ICE\3.1.500.18\Source\Framework\Epicor.Ice\Services\TablesetBound.cs:line 1229 at Ice.TablesetBound3.WriteTable(IceDataContext dataContext, Int32 tableIndex, IIceTable table, TablesetProfilingCollector parentTraceCollector) in C:\_Releases\ICE\3.1.500.18\Source\Framework\Epicor.Ice\Services\TablesetBound.cs:line 906 at Ice.TablesetBound3.InnerUpdate(IceDataContext dataContext, TFullTableset tableset) in C:_Releases\ICE\3.1.500.18\Source\Framework\Epicor.Ice\Services\TablesetBound.cs:line 797 at Erp.Services.BO.IntgWorkbenchSvc.Update(IntgWorkbenchTableset& ds) in c:_Releases\ERP\RL10.1.500\Source\Server\Services\BO\IntgWorkbench\IntgWorkbench.Designer.cs:line 619 at Erp.Services.BO.IntgWorkbenchSvcFacade.Update(IntgWorkbenchTableset& ds) in c:_Releases\ERP\RL10.1.500\Source\Server\Services\BO\IntgWorkbench\IntgWorkbenchSvcFacade.cs:line 325 at SyncInvokeUpdate(Object , Object[] , Object[] ) at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs) at Epicor.Hosting.OperationBoundInvoker.InnerInvoke(Object instance, Func2 func) in C:\_Releases\ICE\3.1.500.18\Source\Framework\Epicor.System\Hosting\OperationBoundInvoker.cs:line 59 at Epicor.Hosting.OperationBoundInvoker.Invoke(Object instance, Func2 func) in C:_Releases\ICE\3.1.500.18\Source\Framework\Epicor.System\Hosting\OperationBoundInvoker.cs:line 47 at Epicor.Hosting.Wcf.EpiOperationInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs) in C:_Releases\ICE\3.1.500.18\Source\Framework\Epicor.System\Hosting\Wcf\EpiOperationInvoker.cs:line 23 at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage11(MessageRpc& rpc) at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)

1 Like

Ancient post here. Any advice outside of working with Epicor for a DataFix? Any attempts to fix the bad sync of records seems to be ignored. I’ve got some bad CustCnt records that are trying to sync to a customer with a custnum that doesn’t exist, in a company it shouldn’t be syncing to