Failed conversions 830 & 840 Regarding Vietnamese Data Field Creation

Epicor ERP 10
1

Our automatic uplift (via workbench not cloud services) failed conversions 830 and 840, and this causes us not to be able to view AR invoice edit list, nor post AR invloice group.

Error messages from the conversions we attempted to re-run are below. Any feedback appreciated.

Thanks
…Monty.

*830 conversion attempt:

This is a duplicate entry of an existing record
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.TaskServiceBase1.InnerRunDirect(IceRow paramRow) in C:\_Releases\ICE\3.1.600.16\Source\Server\Internal\Lib\TaskLib\TaskBase\TaskServiceBase.cs:line 584 at Ice.Services.Proc.CnvProgsProcessSvc.RunDirect(CnvProgsProcessTableset ds) in c:\_Releases\ICE\3.1.600.0\Source\Server\Services\Proc\CnvProgsProcess\CnvProgsProcess.Designer.cs:line 189 at Ice.Services.Proc.CnvProgsProcessSvc.RunConversion(String systemCode, String converionID) in c:\_Releases\ICE\3.1.600.0\Source\Server\Services\Proc\CnvProgsProcess\CnvProgsProcess.cs:line 48 at Ice.Services.Proc.CnvProgsProcessSvcFacade.RunConversion(String systemCode, String converionID) in c:\_Releases\ICE\3.1.600.0\Source\Server\Services\Proc\CnvProgsProcess\CnvProgsProcessSvcFacade.cs:line 55 at SyncInvokeRunConversion(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.600.16\Source\Framework\Epicor.System\Hosting\OperationBoundInvoker.cs:line 59
at Epicor.Hosting.OperationBoundInvoker.Invoke(Object instance, Func2 func) in C:\_Releases\ICE\3.1.600.16\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.16\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.SecurityChannelListener1.ReceiveItemAndVerifySecurityAsyncResult`2.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)

*840 conversion attempt

Corresponding UD fields (‘VNACGroup’, ‘VNACType’) for table ‘GLJrnDtl’ should be added before
Corresponding UD fields (‘VNACGroup’, ‘VNACType’) for table ‘GLJrnDtlMnl’ should be added before
Corresponding UD fields (‘VNACGroup’, ‘VNACType’) for table ‘RvJrnTrDtl’ should be added before
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.TaskServiceBase1.InnerRunDirect(IceRow paramRow) in C:\_Releases\ICE\3.1.600.16\Source\Server\Internal\Lib\TaskLib\TaskBase\TaskServiceBase.cs:line 584 at Ice.Services.Proc.CnvProgsProcessSvc.RunDirect(CnvProgsProcessTableset ds) in c:\_Releases\ICE\3.1.600.0\Source\Server\Services\Proc\CnvProgsProcess\CnvProgsProcess.Designer.cs:line 189 at Ice.Services.Proc.CnvProgsProcessSvc.RunConversion(String systemCode, String converionID) in c:\_Releases\ICE\3.1.600.0\Source\Server\Services\Proc\CnvProgsProcess\CnvProgsProcess.cs:line 48 at Ice.Services.Proc.CnvProgsProcessSvcFacade.RunConversion(String systemCode, String converionID) in c:\_Releases\ICE\3.1.600.0\Source\Server\Services\Proc\CnvProgsProcess\CnvProgsProcessSvcFacade.cs:line 55 at SyncInvokeRunConversion(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.600.16\Source\Framework\Epicor.System\Hosting\OperationBoundInvoker.cs:line 59
at Epicor.Hosting.OperationBoundInvoker.Invoke(Object instance, Func2 func) in C:\_Releases\ICE\3.1.600.16\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.16\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.SecurityChannelListener1.ReceiveItemAndVerifySecurityAsyncResult`2.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)

Best,
…Monty.
Monty Wilson ERP Developer
ERP Developer
Black Horse LLC
Houston TX
832-399-4643

2

Those 2 are like you say related to Vietnam and are under the User Run Conversions.

I only ever run the Auto Run conversions, I don’t attempt to run the User Run ones at the point of uplifting versions. I would imagine that the Vietname CSF or at least having set the Country Code within License Management in EAC to Vietnam is a pre-req.

3

Dear Mark,

That is what we thought; when the Vietnamese conversions failed in the auto uplift we thought, we don’t transact in Viet Nam anyway so no problem. But even in our all-USA, all-American-dollars installation, we cannot preview an AR invoice edit list, and we cannot post AR invoices, and the error messages specifically mention the Vietnamese fields not being set up correctly. Thank you! …M.

4

On my system, the posting rules import always fails on AR Invoice. I have to go into the system after finishing other conversation and specifically import the AR Invoice posting rules. We don’t have them customised, completely bog standard.

What’s the actual error when trying to preview? You’ve only shown the error from conversion workbench thus far?

5

Error: Business Logic Error
Business Layer Exception
BLException
Description: There is no field VNACGroup in table GLJrnDtl in Data Model
There is no field VNACGroup in table RvJrnTrDtl in Data Model
There is no field VNACSubGroup_c in table GLJrnDtl in Data Model
There is no field VNACSubGroup_c in table RvJrnTrDtl in Data Model
There is no field VNACType in table GLJrnDtl in Data Model
There is no field VNACType in table RvJrnTrDtl in Data Model
Check UD Fields definitions and regenerate Data Model.

Program: Erp.Internal.PE.ValidationRule.dll
Method: CheckUDFieldsDataDefinitions
Line Number: 3200
Column Number: 17
Server Trace Stack:    at Erp.Internal.PE.ValidationRule.CheckUDFieldsDataDefinitions() in c:\_Releases\ERP\RL10.1.600.0\Source\Server\Internal\PE\ValidationRule\ValidationRule.cs:line 3200

at Erp.Internal.PE.PEFunctionsPRG.ProcCreateGLTransaction(String ACTName, String JournalCode, Int32 JournalLine, Nullable1 TranDate, Int32 ARInvoiceNum, String APInvoiceNum, String TranGroupID, Amount TranAmount, Amount BookAmount, Account aGLAccount, Boolean inIsDebit, String BookID, Int32 BRuleUID, Int32 CheckNumRef, String BankSlipRef, Int32 BankTransactionNum, Int32 CashReceiptRef, Int32 VendorRef, TransactionText tranText, TransactionText commText, Int32 ClosingPeriodNum, String BankAcctID, Boolean lMultiCompany, String cExternalCompany, String cExternalAccount, Int32 iTranSeq, String inScourceModule, UDField clUDField, String glLegalNumber, Decimal StatAmount) in C:\_Releases\ERP\UD10.1.600.16\Source\Server\Internal\PE\PEFunctionsPRG\PEFunctionsPRG.cs:line 1546 at Erp.Internal.PE.AR_INVOICE_BH_Post_58371DCD68781C4FFF8C731C1C770BCD20.CreateTransaction(Int32 BRuleUID, GLControl gReference_GLControl, TransactionText tranText, TransactionText commText) at Erp.Internal.PE.AR_INVOICE_BH_Post_58371DCD68781C4FFF8C731C1C770BCD20.rule_PosCF_InvFF_AmoDC_to_AccBE_RecCB_741() at Erp.Internal.PE.AR_INVOICE_BH_Post_58371DCD68781C4FFF8C731C1C770BCD20.processDocLineRules() at Erp.Internal.PE.AR_INVOICE_BH_Post_58371DCD68781C4FFF8C731C1C770BCD20.Post() at Erp.Internal.PE.PEABT.Post() in C:\_Releases\ERP\UD10.1.600.16\Source\Server\Internal\PE\PEABT\PEABT.cs:line 285 at Erp.Internal.PE.AR_InvoicePre_Post.Post() in C:\_Releases\ERP\UD10.1.600.16\Source\Server\Internal\PE\AR_Invoice\AR_InvoicePre_Post.cs:line 2454 at Erp.Internal.PE.AR_InvoicePre_Post.RunProcess() in C:\_Releases\ERP\UD10.1.600.16\Source\Server\Internal\PE\AR_Invoice\AR_InvoicePre_Post.cs:line 488 at Erp.Internal.PE.Pre_PostBase._RunProcess(Int64 instance_TaskNum, String groupID, PostingMode mode, Boolean skipPEDataInit) in c:\_Releases\ERP\RL10.1.600.0\Source\Server\Internal\PE\Pre_PostBase\Pre_PostBase.cs:line 172 at Erp.Internal.PE.AR_InvoicePre_Post.Pre_Post(Int64 instance_TaskNum, String groupID, PostingMode mode) in C:\_Releases\ERP\UD10.1.600.16\Source\Server\Internal\PE\AR_Invoice\AR_InvoicePre_Post.cs:line 434 at Erp.Internal.AR.ARR10.RunProcess(Int64 instanceTaskNum, String outputFileName) in C:\_Releases\ERP\UD10.1.600.16\Source\Server\Internal\AR\ARR10\ARR10.cs:line 425 at Ice.Hosting.TaskCaller.InnerExecuteTask(IceDataContext newContext) in C:\_Releases\ICE\3.1.600.16\Source\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 93 at Ice.Hosting.TaskCaller.ExecuteTask() in C:\_Releases\ICE\3.1.600.16\Source\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 54 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.RunTask(Int64 ipTaskNum) in c:\_Releases\ICE\3.1.600.0\Source\Server\Services\Lib\RunTask\RunTaskSvcFacade.cs:line 87 at SyncInvokeRunTask(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.600.16\Source\Framework\Epicor.System\Hosting\OperationBoundInvoker.cs:line 59
at Epicor.Hosting.OperationBoundInvoker.Invoke(Object instance, Func2 func) in C:\_Releases\ICE\3.1.600.16\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.16\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.SecurityChannelListener1.ReceiveItemAndVerifySecurityAsyncResult`2.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)

6

The error appears to be within the Posting Engine (PE) code – something is telling it to look at the Vietnam rules for some reason.

Is this your live or test environment?

If test, and you know whether you have customised rules or not, I would look to re-import the AR Invoice Type using GL Transaction Type.

7

Based on our downloaded instructions from Epicor, we were able to get AR Edit Lists to both print and post, following these steps.

  • Run conversion 830: VNAcctCorrCreation – it is expected outcome that this step fails.
  • Regenerate data model.
  • Run conversion 840: VNAcctCorrMigration – this one completes without error.
1 Like