An error occurred while updating the entries. See the inner exception for details. (UpdateException)

when we are try to do any process to affect the almacens for example (job receipt to inventory, receipt entry, issue material or quantity adjustment), throws us the next error:
Server Side Exception

A server error occurred. Review the server event logs for details.

Exception caught in: Epicor.ServiceModel

Error Detail

Correlation ID: fb7a95a3-4cbb-473e-8017-e7bf7ae352c8
Description: A server error occurred. Review the server event logs for details.
Program: Epicor.System.dll
Method: ProvideFault
Line Number: 34
Column Number: 17
Server Trace Stack: at Epicor.Hosting.Wcf.ErrorHandler.ProvideFault(Exception error, MessageVersion version, Message& fault) in C:_Releases\ICE\UD10.2.500.8FW\Source\Framework\Epicor.System\Hosting\Wcf\ErrorHandler.cs:line 34
at System.ServiceModel.Dispatcher.ErrorBehavior.ProvideFault(Exception e, FaultConverter faultConverter, ErrorHandlerFaultInfo& faultInfo)
at System.ServiceModel.Dispatcher.ErrorBehavior.ProvideMessageFaultCore(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage8(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.MessageRpc.ProcessError(Exception e)
at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)
at System.ServiceModel.Dispatcher.ChannelHandler.DispatchAndReleasePump(RequestContext request, Boolean cleanThread, OperationContext currentOperationContext)
at System.ServiceModel.Dispatcher.ChannelHandler.HandleRequest(RequestContext request, OperationContext currentOperationContext)
at System.ServiceModel.Dispatcher.ChannelHandler.AsyncMessagePump(IAsyncResult result)
at System.ServiceModel.Dispatcher.ChannelHandler.OnAsyncReceiveComplete(IAsyncResult result)
at System.Runtime.Fx.AsyncThunk.UnhandledExceptionFrame(IAsyncResult result)
at System.Runtime.AsyncResult.Complete(Boolean completedSynchronously)
at System.ServiceModel.Channels.SecurityChannelListener1.ReceiveItemAndVerifySecurityAsyncResult2.InnerTryReceiveCompletedCallback(IAsyncResult result)
at System.Runtime.Fx.AsyncThunk.UnhandledExceptionFrame(IAsyncResult result)
at System.Runtime.AsyncResult.Complete(Boolean completedSynchronously)
at System.ServiceModel.Channels.TransportDuplexSessionChannel.TryReceiveAsyncResult.OnReceive(IAsyncResult result)
at System.Runtime.Fx.AsyncThunk.UnhandledExceptionFrame(IAsyncResult result)
at System.Runtime.AsyncResult.Complete(Boolean completedSynchronously)
at System.ServiceModel.Channels.SynchronizedMessageSource.ReceiveAsyncResult.OnReceiveComplete(Object state)
at System.ServiceModel.Channels.SessionConnectionReader.OnAsyncReadComplete(Object state)
at System.Runtime.Fx.AsyncThunk.UnhandledExceptionFrame(IAsyncResult result)
at System.Net.LazyAsyncResult.Complete(IntPtr userToken)
at System.Net.LazyAsyncResult.ProtectedInvokeCallback(Object result, IntPtr userToken)
at System.Net.Security.NegotiateStream.ProcessFrameBody(Int32 readBytes, Byte[] buffer, Int32 offset, Int32 count, AsyncProtocolRequest asyncRequest)
at System.Net.Security.NegotiateStream.ReadCallback(AsyncProtocolRequest asyncRequest)
at System.Net.AsyncProtocolRequest.CompleteRequest(Int32 result)
at System.Net.FixedSizeReader.CheckCompletionBeforeNextRead(Int32 bytes)
at System.Net.FixedSizeReader.ReadCallback(IAsyncResult transportResult)
at System.Runtime.AsyncResult.Complete(Boolean completedSynchronously)
at System.ServiceModel.Channels.ConnectionStream.IOAsyncResult.OnAsyncIOComplete(Object state)
at System.Net.Sockets.SocketAsyncEventArgs.OnCompleted(SocketAsyncEventArgs e)
at System.Net.Sockets.SocketAsyncEventArgs.FinishOperationSuccess(SocketError socketError, Int32 bytesTransferred, SocketFlags flags)
at System.Net.Sockets.SocketAsyncEventArgs.CompletionPortCallback(UInt32 errorCode, UInt32 numBytes, NativeOverlapped* nativeOverlapped)
at System.Threading._IOCompletionCallback.PerformIOCompletionCallback(UInt32 errorCode, UInt32 numBytes, NativeOverlapped* pOVERLAP)

Client Stack Trace

at Epicor.ServiceModel.Channels.ImplBase`1.ShouldRethrowNonRetryableException(Exception ex, DataSet[] dataSets)
at Erp.Proxy.BO.ReceiptsFromMfgImpl.ReceiveMfgPartToInventory(ReceiptsFromMfgDataSet ds, Decimal pdSerialNoQty, Boolean plNegQtyAction, String& pcMessage, String& pcPartTranPKs, String pcProcessID)
at Erp.Adapters.ReceiptsFromMfgAdapter.ReceiveMfgPartToInventory(Decimal pdSerialNoQty, Boolean plNegQtyAction, String& pcMessage, String& pcPartTranPKs, String pcProcessID)
at Erp.UI.App.RcptToInvEntry.RcptToInvTransaction.UpdateMfgJobToInventory(Boolean hardSave)

SERVER LOG




>> A severe error occurred on the current command. The results, if any, should be discarded. (SqlException) at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 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.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at 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) at 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) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed) at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext) at System.Data.Entity.Core.Mapping.Update.Internal.DynamicUpdateCommand.Execute(Dictionary`2 identifierValues, List`1 generatedValues) at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update() ]]>

Does this happen for any part or just specific parts?

Any BPM’s enanbled?

Have you tried running a trace to see which BO is throwing the error?

this happens in all the movements that affect warehouse and they are all

we don’t have any BPM’s enabled

i think is in
at Erp.Services.BO.ReceiptsFromMfgSvc.ReceiveMfgPartTranRowToInventory(PartTranRow ttPartTran, ReceiptsFromMfgTableset ds, Decimal pdSerialNoQty, Boolean plNegQtyAction, String& pcMessage, String& pcPartTranPKs, String pcProcessID, String& legalNumberMessage) in C:_Releases\ERP\RL10.2.500.0\Source\Server\Services\BO\ReceiptsFromMfg\ReceiptsFromMfg.cs:line 1908
at Erp.Services.BO.ReceiptsFromMfgSvc.ReceiveMfgPartToInventory(ReceiptsFromMfgTableset& ds, Decimal pdSerialNoQty, Boolean plNegQtyAction, String& pcMessage, String& pcPartTranPKs, String pcProcessID) in C:_Releases\ERP\RL10.2.500.0\Source\Server\Services\BO\ReceiptsFromMfg\ReceiptsFromMfg.cs:line 1569
at Erp.Services.BO.ReceiptsFromMfgSvcFacade.ReceiveMfgPartToInventory(ReceiptsFromMfgTableset& ds, Decimal pdSerialNoQty, Boolean plNegQtyAction, String& pcMessage, String& pcPartTranPKs, String pcProcessID) in C:_Releases\ERP\RL10.2.500.0\Source\Server\Services\BO\ReceiptsFromMfg\ReceiptsFromMfgSvcFacade.cs:line 1129

I found some cases where restarting the AppServer solved the problem and also tried to Regenerate the data model because I thought the problem was related to the UD fields , but it was not solved this issue

In the end it was data corruption in the PartTran table, with the following comand the table was repaired

DBCC CHECKTABLE (‘erp.PartTran’,REPAIR_REBUILD);

2 Likes

how did you come to find it was the PartTran, I came into an issue much like yours, I did a regenerate on the data model for this environment and restarted but I would like to find out what happened that caused the issue to avoid it from occurring again.