ERP 10.1.60.11
When Finance try to post a payment from Payment Entry , they select a group in AP Payment entry
Then select Actions>Process payment, try to print out my remittances and I get the following error message (full details below);
Business Layer Exception
Contiguous payment numbers were not generated because another process is allocating new payment numbers and the sequence has been locked momentarily. Please try sending the process again.
SQL
On the server I have run Sql Server mgmt. Studio as administrator, run the following SQL:
SELECT * from ice.systask where taskdescription = ‘Process Payments’
Delete from ice.systask where taskdescription = ‘Process Payments’ AND EndedOn IS NULL
This deleted two stuck records from 04 June
I then stop/restarted the application pool and recycled iis and restarted the task agent (several times) but the error persists even though the stuck transactions are no longer present.
I’ve attached a quoery from our CheckHed Table (payment data removed)
Have logged this with Epicor, they have never seen it before and have no idea.
Full Detail On Error Msg:
Exception caught in: Epicor.ServiceModel
Error Detail
============
Description: Contiguous payment numbers were not generated because another process is allocating new payment numbers and the sequence has been locked momentarily. Please try sending the process again.
Program: Erp.Internal.AP.GenAPCheckNum.dll
Method: ValidateAvailCheckNum
Line Number: 393
Column Number: 29
Table: CheckHed
Server Trace Stack: at Erp.Internal.AP.GenAPCheckNum.ValidateAvailCheckNum(String GroupID, String BankAcctID, Int32 LoadedCheckNum, Boolean OverridePayment, Boolean ElecPayment, String bankAccountDesc, Boolean isPaymentEntry, Boolean PymtCntr) in C:_Releases\ERP\UD10.1.600.11\Source\Server\Internal\AP\GenAPCheckNum\GenAPCheckNum.cs:line 393
at Erp.Internal.AP.ProcessPayment.processChecks(FormatNumberToCheckAmountCache checkAmountFormatterCache) in C:_Releases\ERP\UD10.1.600.11\Source\Server\Internal\AP\ProcessPayment\ProcessPayment.cs:line 2537
at Erp.Internal.AP.ProcessPayment.RunProcess(Int64 instanceTaskNum, String outputFileName) in C:_Releases\ERP\UD10.1.600.11\Source\Server\Internal\AP\ProcessPayment\ProcessPayment.cs:line 719
at Ice.Hosting.TaskCaller.InnerExecuteTask(IceDataContext newContext) in C:_Releases\ICE\3.1.600.11\Source\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 93
at Ice.Hosting.TaskCaller.ExecuteTask(IceDataContext dataContext, Boolean suppressTransaction) in C:_Releases\ICE\3.1.600.11\Source\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 40
at Ice.Lib.RunTask.BpmFriendlyTaskLauncher.Run(String sessionIdPrefix, IceContext db, Action taskRunner) in c:_Releases\ICE\3.1.600.0\Source\Server\Services\Lib\RunTask\BpmFriendlyTaskLauncher.cs:line 58
at Ice.Services.Lib.RunTaskSvc.InnerRunTask(Int64 ipTaskNum, Boolean suppressTransaction) in c:_Releases\ICE\3.1.600.0\Source\Server\Services\Lib\RunTask\RunTask.cs:line 535
at Ice.Services.Lib.RunTaskSvcFacade.RunTaskDirect(Int64 ipTaskNum) in c:_Releases\ICE\3.1.600.0\Source\Server\Services\Lib\RunTask\RunTaskSvcFacade.cs:line 103
at Ice.Core.TaskServiceBase`1.InnerRunDirect(IceRow paramRow) in C:_Releases\ICE\3.1.600.11\Source\Server\Internal\Lib\TaskLib\TaskBase\TaskServiceBase.cs:line 584
at Erp.Services.Rpt.ProcessPaymentSvc.RunDirect(ProcessPaymentTableset ds) in C:_Releases\ERP\UD10.1.600.11\Source\Server\Services\Rpt\ProcessPayment\ProcessPayment.Designer.cs:line 199
at Erp.Services.Rpt.ProcessPaymentSvcFacade.RunDirect(ProcessPaymentTableset ds) in C:_Releases\ERP\UD10.1.600.11\Source\Server\Services\Rpt\ProcessPayment\ProcessPaymentSvcFacade.cs:line 596
at SyncInvokeRunDirect(Object , Object[] , Object[] )
at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
at Epicor.Hosting.OperationBoundInvoker.InnerInvoke(Object instance, Func`2 func) in C:_Releases\ICE\3.1.600.11\Source\Framework\Epicor.System\Hosting\OperationBoundInvoker.cs:line 59
at Epicor.Hosting.OperationBoundInvoker.Invoke(Object instance, Func`2 func) in C:_Releases\ICE\3.1.600.11\Source\Framework\Epicor.System\Hosting\OperationBoundInvoker.cs:line 28
at Epicor.Hosting.Wcf.EpiOperationInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs) in C:_Releases\ICE\3.1.600.11\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)
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.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.Rpt.ProcessPaymentImpl.RunDirect(ProcessPaymentDataSet ds)
at Erp.Adapters.ProcessPaymentAdapter.RunDirect()
at Erp.UI.Rpt.ProcessPayment.Transaction.adapterRunDirect()
at Ice.Lib.Report.ReportRunner.RunForPrintDirect(String ssrsPrintOption)
at Ice.Lib.Report.ReportRunner.Run(String outputType, String ssrsPrintOption)
at Ice.Lib.Framework.EpiReportTransaction.RunDirect(String outputType, String ssrsPrintOpt)