Error with AR Advanced Billing/Deposit Report

Epicor ERP 10
1

Has anyone ever run into an error like the one below with this report? Nothing has changed in our system since the report was last run 3 days ago.

Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask: [A]System.Action2[System.Data.SqlClient.SqlDataReader,System.Collections.Generic.List1[Erp.Internal.AR.GenAdvBillDep+OrderDtl2]] cannot be cast to [B]System.Action2[System.Data.SqlClient.SqlDataReader,System.Collections.Generic.List1[Erp.Internal.AR.GenAdvBillDep+OrderDtl2]]. Type A originates from ‘mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089’ in the context ‘LoadNeither’ at location ‘C:\Windows\Microsoft.Net\assembly\GAC_64\mscorlib\v4.0_4.0.0.0__b77a5c561934e089\mscorlib.dll’. Type B originates from ‘mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089’ in the context ‘LoadNeither’ at location ‘C:\Windows\Microsoft.Net\assembly\GAC_64\mscorlib\v4.0_4.0.0.0__b77a5c561934e089\mscorlib.dll’.
Stack Trace:
at Epicor.ServiceModel.Tableset.DataReaderToTableDelegateCache.GetItem[TData](SqlDataReader reader, Type tableType, IceColumnCollection columns) in C:_Releases\ICE\3.1.500.8\Source\Shared\Framework\Epicor.ServiceModel\Tableset\DataReaderToTableDelegateCache.cs:line 60
at Epicor.ServiceModel.Tableset.DBReaderAdapter.LoadFromReader[TData](SqlDataReader reader, List1 table, IceColumnCollection iceColumns) in C:\_Releases\ICE\3.1.500.8\Source\Shared\Framework\Epicor.ServiceModel\Tableset\DBReaderAdapter.cs:line 75 at Epicor.ServiceModel.Tableset.DBReaderAdapter.LoadFromReader[TData](SqlDataReader reader, List1 table) in C:_Releases\ICE\3.1.500.8\Source\Shared\Framework\Epicor.ServiceModel\Tableset\DBReaderAdapter.cs:line 62
at Epicor.ServiceModel.Tableset.DBReaderAdapter.LoadFromReader[TData](SqlDataReader reader) in C:_Releases\ICE\3.1.500.8\Source\Shared\Framework\Epicor.ServiceModel\Tableset\DBReaderAdapter.cs:line 28
at Ice.Lib.ExecuteQuery.executeQuery[TRow](String sqlQuery) in C:_Releases\ICE\3.1.500.8\Source\Server\Internal\Lib\Ice.Lib.Shared\ExecuteQuery\ExecuteQuery.cs:line 209
at Ice.Lib.ExecuteQuery.Run[TRow](String[] pcTableName, String[] pcEFL, String[] pcFieldName, String[] pcJoinType, String[] pcWhereClause, String pcOrderBy, Int32 piRowIdBuffer, List1 hResultTable, String& pcErrorMsg, Boolean includeUDFields) in C:\_Releases\ICE\3.1.500.8\Source\Server\Internal\Lib\Ice.Lib.Shared\ExecuteQuery\ExecuteQuery.cs:line 152 at Erp.Internal.AR.GenAdvBillDep.BuildOrderDtlQuery(OrderDtl2List ttOrderDtlRows) in C:\_Releases\ERP\UD10.1.500.8\Source\Server\Internal\AR\GenAdvBillDep\GenAdvBillDep.cs:line 1144 at Erp.Internal.AR.GenAdvBillDep.BuildTempTable(List1 ttAdvDepLineRows) in C:_Releases\ERP\UD10.1.500.8\Source\Server\Internal\AR\GenAdvBillDep\GenAdvBillDep.cs:line 1185
at Erp.Internal.AR.GenAdvBillDep.RunProcess(Int64 instanceTaskNum, String outputFileName) in C:_Releases\ERP\UD10.1.500.8\Source\Server\Internal\AR\GenAdvBillDep\GenAdvBillDep.cs:line 776
at Ice.Hosting.TaskCaller.InnerExecuteTask(IceDataContext newContext) in C:_Releases\ICE\3.1.500.8\Source\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 93
at Ice.Hosting.TaskCaller.ExecuteTask() in C:_Releases\ICE\3.1.500.8\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.500.8\Source\Server\Services\Lib\RunTask\BpmFriendlyTaskLauncher.cs:line 63
at Ice.Services.Lib.RunTaskSvc.InnerRunTask(Int64 ipTaskNum, Boolean suppressTransaction) in C:_Releases\ICE\3.1.500.8\Source\Server\Services\Lib\RunTask\RunTask.cs:line 526
at Ice.Services.Lib.RunTaskSvc.InnerRunTask(Int64 ipTaskNum, Boolean suppressTransaction) in C:_Releases\ICE\3.1.500.8\Source\Server\Services\Lib\RunTask\RunTask.cs:line 526
at Ice.Services.Lib.RunTaskSvcFacade.RunTask(Int64 ipTaskNum) in C:_Releases\ICE\3.1.500.8\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.500.8\Source\Framework\Epicor.System\Hosting\OperationBoundInvoker.cs:line 59 at Epicor.Hosting.OperationBoundInvoker.Invoke(Object instance, Func2 func) in C:_Releases\ICE\3.1.500.8\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.500.8\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)

2

I am having the same error with Inventory/WIP Reconciliation Report and also nothing changed in our System. Seems like a.NET issue but we have not yet resolved it.

3

Having the same problem/error with my Stock Status report - Regenerating the data model worked for us as mentioned by another user over on the EUG website. Putting this out here on this old thread for future use.

It seems that if you make a UD field change, after a certain amount of time the system has trouble dealing with the discrepancy between the database and the data model.

4

This worked for us as well