We use engineering methods to add assemblies, materials, and operations from another job. Sometimes, the BOM (parent, child, nextpeer, priorpeer etc.) sequences get out of whack. When you try to remove the assembly, the system times out and fails. Usually rebooting the servers unlocks this and we can continue. We rebooted and it is still locked. Does anyone else have this issue? What is the solution?
Is this on 9 or 10?
It has happened when we were on 9 and 10. It is still happening on our current version of Kinetic 2023.1.6 (11.2.300.0)
1 Like
Bery odd, but sounds really familiar.
@skhan do you remember this type of behavior? I swear I do, but can’t recall what we did or what the root cause was.
Epicor Error Message:
An error occurred while reading from the store provider’s data reader. See the inner exception for details.
Details:
Application Error
Exception caught in: Epicor.ServiceModel
Error Detail
Message: An error occurred while reading from the store provider’s data reader. See the inner exception for details.
Inner Exception Message: Lock request time out period exceeded.
Program: Epicor.ServiceModel.dll
Method: CallWithCommunicationFailureRetry
Client Stack Trace
at Ice.Cloud.ProxyBase1.CallWithCommunicationFailureRetry(String methodName, ProxyValuesIn valuesIn, ProxyValuesOut valuesOut, RestRpcValueSerializer serializer) at Ice.Cloud.ProxyBase1.CallWithMultistepBpmHandling(String methodName, ProxyValuesIn valuesIn, ProxyValuesOut valuesOut, Boolean useSparseCopy)
at Ice.Cloud.ProxyBase`1.Call(String methodName, ProxyValuesIn valuesIn, ProxyValuesOut valuesOut, Boolean useSparseCopy)
at Erp.Proxy.BO.JobEntryImpl.Update(JobEntryDataSet ds)
at Erp.Adapters.JobEntryAdapter.OnDelete()
at Ice.Lib.Framework.EpiBaseAdapter.Delete(DataRow dr)
at Erp.UI.App.JobEntry.Transaction.Delete()
Inner Exception
Lock request time out period exceeded.
Server Event Log:
Ice.Common.EpicorServerException: An error occurred while reading from the store provider’s data reader. See the inner exception for details.
—> System.Data.Entity.Core.EntityCommandExecutionException: An error occurred while reading from the store provider’s data reader. See the inner exception for details.
—> System.Data.SqlClient.SqlException (0x80131904): Lock request time out period exceeded.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.Read() at System.Data.Entity.Core.Common.Internal.Materialization.Shaper1.StoreRead()
ClientConnectionId:bd2b7b93-3bd4-4b34-937b-ecd75e0d859c
Error Number:1222,State:51,Class:16
— End of inner exception stack trace —
at System.Data.Entity.Core.Common.Internal.Materialization.Shaper1.HandleReaderException(Exception e) at System.Data.Entity.Core.Common.Internal.Materialization.Shaper1.StoreRead()
at System.Data.Entity.Core.Common.Internal.Materialization.Shaper1.SimpleEnumerator.MoveNext() at System.Linq.Enumerable.TryGetFirst[TSource](IEnumerable1 source, Boolean& found)
at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable1 source) at System.Data.Entity.Core.Objects.CompiledQuery.ExecuteQuery[TResult](ObjectContext context, Object[] parameterValues) at Epicor.Data.DBExpressionCompiler.<>c__DisplayClass55_13.b__3(TContext c, Func3 query) in C:\_releases\ICE\ICE4.2.300.6\Source\Server\Framework\Epicor.System\Data\DBExpressionCompiler.Generated.cs:line 1201 at Epicor.Data.DBExpressionCompiler.GetResult[TDataContext,TQuery,TResult](Func3 executeQuery, Cache cacheSetting, TDataContext dataContext, TQuery query) in C:_releases\ICE\ICE4.2.300.6\Source\Server\Framework\Epicor.System\Data\DBExpressionCompiler.cs:line 449
at Epicor.Data.DBExpressionCompiler.InvokeSingle[TDataContext,TQuery,TResult](Expression expression, Cache currentCacheSetting, Boolean cacheQuery, TDataContext dataContext, Func2 getDataCacheKey, Func2 compileQuery, Func3 executeQuery) in C:\_releases\ICE\ICE4.2.300.6\Source\Server\Framework\Epicor.System\Data\DBExpressionCompiler.cs:line 310 at Epicor.Data.DBExpressionCompiler.<>c__DisplayClass55_03.b__0(TContext context, TArg1 arg1) in C:_releases\ICE\ICE4.2.300.6\Source\Server\Framework\Epicor.System\Data\DBExpressionCompiler.Generated.cs:line 0
at Ice.TablesetBound3.UpdateRow(IceDataContext dataContext, Int32 tableNum, IIceTable table, IceRow updatedRow, IceRow originalRow, IColumnUncensor uncensor, TablesetProfilingCollector parentTraceCollector) in C:\_releases\ICE\ICE4.2.300.6\Source\Server\Framework\Epicor.Ice\Services\TablesetBound.cs:line 1268 at Ice.TablesetBound3.WriteTable(IceDataContext dataContext, Int32 tableIndex, IIceTable table, TablesetProfilingCollector parentTraceCollector) in C:_releases\ICE\ICE4.2.300.6\Source\Server\Framework\Epicor.Ice\Services\TablesetBound.cs:line 954
at Ice.TablesetBound3.InnerUpdate[TUpdater](IceDataContext dataContext, TFullTableset tableset) in C:\_releases\ICE\ICE4.2.300.6\Source\Server\Framework\Epicor.Ice\Services\TablesetBound.cs:line 874 at Erp.Services.BO.JobEntrySvc.Update(JobEntryTableset& ds) in C:\_releases\ERP\ERP11.2.300.6\Source\Server\Services\BO\JobEntry\JobEntry.Designer.cs:line 8429 at Epicor.Customization.Bpm.MethodCustomizationBase22.RunDirectives(TParam parameters) in C:_releases\ICE\ICE4.2.300.6\Source\Server\Internal\Lib\Epicor.Customization.Bpm\MethodCustomizationBase2.cs:line 177
at Epicor.Customization.Bpm.CustomizationBase2`2.Execute(TParam parameters) in C:_releases\ICE\ICE4.2.300.6\Source\Server\Internal\Lib\Epicor.Customization.Bpm\CustomizationBase2.cs:line 98
at Epicor.Customization.Bpm.BO.JobEntrySvcCustomization.Update(JobEntryTableset& ds)
at Erp.Services.BO.JobEntrySvcFacade.Update(JobEntryTableset& ds) in C:_releases\ERP\ERP11.2.300.6\Source\Server\Services\BO\JobEntry\JobEntrySvcFacade.cs:line 11385
at Erp.Controllers.BO.JobEntryController.Update(Update_InputModel model) in C:_releases\ERP\ERP11.2.300.6\Source\Server\Services\BO\JobEntry\Generated\JobEntryController.cs:line 4467
at lambda_method107758(Closure , Object , Object )
at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object arguments)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync()
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync()
— End of inner exception stack trace —
Hi, I am not sure why this is happening. But I can suggest to use Resequence feature whenever you remove any operation or material. This may help.
Hi @JeffSanders,
We had this issue before. Most recently December 2022. The only solution was to delete the offending assemblies by a data fix. Never did find out the true root cause.
Data Fix is never a great answer but that was our experience.
I wish they had an assembly resequence.
1 Like
Please correct me if I am wrong, but assemblies are treated as Material in Eng Workbench, they probably just have pull as assembly checked. So you can do material resequence if you need to delete any assembly.
1 Like