Error when creating a new user

Epicor ERP 10
1

Hi,

When I am trying to create a new user in Epicor, it takes too long and after a while, it tells me that an error occurred and for more information, check the logs.

image
image953×786 42.5 KB

Server Side Exception

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

Exception caught in: Epicor.ServiceModel

Error Detail

Correlation ID: c19b398a-46a1-41d5-9b05-2296fa32d9c6
Description: A server error occurred. Review the server event logs for details.
Program: Epicor.System.dll
Method: ProvideFault
Line Number: 33
Column Number: 17
Server Trace Stack: at Epicor.Hosting.Wcf.ErrorHandler.ProvideFault(Exception error, MessageVersion version, Message& fault) in C:_Releases\ICE\RL10.2.600.0FW\Source\Framework\Epicor.System\Hosting\Wcf\ErrorHandler.cs:line 33
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 Ice.Proxy.BO.UserFileImpl.Update(UserFileDataSet ds)
at Ice.Adapters.UserFileAdapter.OnUpdate()
at Ice.Lib.Framework.EpiBaseAdapter.Update()
at Ice.UI.App.UserAccountEntry.Transaction.Update()

2

So do you check the server log as suggested? what is the error there?

3

Hi @Olga, this is the message.

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: 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()
— 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.FirstOrDefault[TSource](IEnumerable1 source)
at System.Data.Entity.Core.Objects.CompiledQuery.ExecuteQuery[TResult](ObjectContext context, Object[] parameterValues)
at System.Data.Entity.Core.Objects.CompiledQuery.Invoke[TArg0,TArg1,TResult](TArg0 arg0, TArg1 arg1)
at Epicor.Data.DBExpressionCompiler.GetResult[TDataContext,TQuery,TResult](Func3 executeQuery, Cache cacheSetting, TDataContext dataContext, TQuery query) in C:\_Releases\ICE\RL10.2.600.0FW\Source\Framework\Epicor.System\Data\DBExpressionCompiler.cs:line 445 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\RL10.2.600.0FW\Source\Framework\Epicor.System\Data\DBExpressionCompiler.cs:line 306
at Epicor.Data.DBExpressionCompiler.<>c__DisplayClass33_03.<Compile>b__0(TContext context, TArg1 arg1) in C:\_Releases\ICE\RL10.2.600.0FW\Source\Framework\Epicor.System\Data\DBExpressionCompiler.Generated.cs:line 1082 at Ice.TableCache.UserFileCache.OnGet(String userID, IceContext dataContext) in C:\_Releases\ICE\RL10.2.600.0FW\Source\Framework\Epicor.Ice\Cache\TableCache\UserFileCache.cs:line 83 at Ice.Cache.DataContextCacheBase3.OnGet(TKey key) in C:_Releases\ICE\RL10.2.600.0FW\Source\Framework\Epicor.System\Cache\DataContextCacheBase.cs:line 38
at Ice.Cache.CacheBase2.Get(TKey key) in C:\_Releases\ICE\RL10.2.600.0FW\Source\Framework\Epicor.System\Cache\CacheBase.cs:line 58 at Ice.Triggers.SysUserFile.WriteTrigger.PasswordBeingExpired(SysUserFile newRecord) in C:\_Releases\ICE\RL10.2.600.0FW\Source\Server\Db\Triggers\SysUserFile\WriteTrigger.cs:line 327 at Ice.Triggers.SysUserFile.WriteTrigger.VerifyNonSecurityManagersCanNotResetPasswords(SysUserFile newRecord, SysUserFile currentUserRecord) in C:\_Releases\ICE\RL10.2.600.0FW\Source\Server\Db\Triggers\SysUserFile\WriteTrigger.cs:line 293 at Ice.Triggers.SysUserFile.WriteTrigger.Write(SysUserFile newRecord, SysUserFile oldRecord) in C:\_Releases\ICE\RL10.2.600.0FW\Source\Server\Db\Triggers\SysUserFile\WriteTrigger.cs:line 24 at Ice.DataTrigger2.Ice.ILinqTrigger.Write(LinqRow newRecord, LinqRow oldRecord) in C:_Releases\ICE\RL10.2.600.0FW\Source\Framework\Epicor.Ice\Triggers\TriggerBase.cs:line 22
at Ice.Triggers.TriggerQueue.ExecuteWriteTrigger(IceDataContext context, LinqRow modifiedRecord, LinqRow originalRecord) in C:_Releases\ICE\RL10.2.600.0FW\Source\Framework\Epicor.System\Triggers\TriggerQueue.cs:line 298
at Ice.Triggers.TriggerQueue.RunWriteTriggerInNewLevel(IceDataContext context, LinqRow modifiedRecord, LinqRow originalRecord, Boolean forAddedRow) in C:_Releases\ICE\RL10.2.600.0FW\Source\Framework\Epicor.System\Triggers\TriggerQueue.cs:line 156
at Ice.Triggers.TriggerQueue.<>c__DisplayClass9_0.b__1() in C:_Releases\ICE\RL10.2.600.0FW\Source\Framework\Epicor.System\Triggers\TriggerQueue.cs:line 147
at Ice.Triggers.TriggerQueue.RunAtNewLevel(Func1 buildTriggerRunState, Action action) in C:\_Releases\ICE\RL10.2.600.0FW\Source\Framework\Epicor.System\Triggers\TriggerQueue.cs:line 501 at Ice.Triggers.TriggerQueue.RunTriggers(IceDataContext context) in C:\_Releases\ICE\RL10.2.600.0FW\Source\Framework\Epicor.System\Triggers\TriggerQueue.cs:line 82 at Ice.IceDataContext.RunUntilAllTriggersHaveExecuted() in C:\_Releases\ICE\RL10.2.600.0FW\Source\Framework\Epicor.System\Data\IceDataContext.cs:line 565 at Ice.Triggers.TriggerQueue.RunAtNewLevel(Func1 buildTriggerRunState, Action action) in C:_Releases\ICE\RL10.2.600.0FW\Source\Framework\Epicor.System\Triggers\TriggerQueue.cs:line 501
at Ice.IceDataContext.Validate[TLinqRow](TLinqRow row) in C:_Releases\ICE\RL10.2.600.0FW\Source\Framework\Epicor.System\Data\IceDataContext.cs:line 328
at Ice.TablesetBound3.CreateRow(IceDataContext dataContext, Int32 tableNum, IIceTable table, IceRow newTablesetRow, TablesetProfilingCollector parentTraceCollector) in C:\_Releases\ICE\RL10.2.600.0FW\Source\Framework\Epicor.Ice\Services\TablesetBound.cs:line 1149 at Ice.TablesetBound3.WriteTable(IceDataContext dataContext, Int32 tableIndex, IIceTable table, TablesetProfilingCollector parentTraceCollector) in C:_Releases\ICE\RL10.2.600.0FW\Source\Framework\Epicor.Ice\Services\TablesetBound.cs:line 971
at Ice.TablesetBound3.InnerUpdate[TUpdater](IceDataContext dataContext, TFullTableset tableset) in C:\_Releases\ICE\RL10.2.600.0FW\Source\Framework\Epicor.Ice\Services\TablesetBound.cs:line 872 at Ice.Services.BO.UserFileSvc.Update(UserFileTableset& ds) in C:\_Releases\ICE\RL10.2.600.0FW\Source\Server\Services\BO\UserFile\UserFile.Designer.cs:line 939 at Ice.Services.BO.UserFileSvcFacade.Update(UserFileTableset& ds) in C:\_Releases\ICE\RL10.2.600.0FW\Source\Server\Services\BO\UserFile\UserFileSvcFacade.cs:line 1230 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\RL10.2.600.0FW\Source\Framework\Epicor.System\Hosting\OperationBoundInvoker.cs:line 59
at Epicor.Hosting.OperationBoundInvoker.Invoke(Object instance, Func`2 func) in C:_Releases\ICE\RL10.2.600.0FW\Source\Framework\Epicor.System\Hosting\OperationBoundInvoker.cs:line 28
— End of inner exception stack trace —

4

Have you tried creating the user in EAC on the server? If I recall, you can even choose an existing user to copy.

5

Hi @ckrusen

image

6

Something locks user record forever until timeout ends. Do you have any BPM on Ice.SysUserFile table?

1 Like