Recently I have been messing around in pilot with auto attaching documents. I am programmatically adding and deleting records to the XFileRef and XFileAttch tables. However in my testing, I keep screwing up the syntax and getting stuck in infinite loops. I thought I had it all figure out this last time, but I must have missed something again. After trying to run my delete UBAQ, and crashing out, I get a server side error with very little useful info in it. The error persists even after I restart Epicor:
Server Side Exception
A server error occurred. Review the server event logs for details.
Exception caught in: Epicor.ServiceModel
Error Detail
============
Correlation ID: 84256aa9-1ffb-4162-8b2c-d4cb8267c5bf
Description: A server error occurred. Review the server event logs for details.
Program: Epicor.Ice.Server.Wcf.Core.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\ICE4.1.200.13\Source\Server\Hosting\Wcf\Ice.Server.Wcf.Core\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.SecurityChannelListener`1.ReceiveItemAndVerifySecurityAsyncResult`2.InnerTryReceiveCompletedCallback(IAsyncResult result)
at System.Runtime.Fx.AsyncThunk.UnhandledExceptionFrame(IAsyncResult result)
at System.Runtime.AsyncResult.Complete(Boolean completedSynchronously)
at System.Runtime.InputQueue`1.AsyncQueueReader.Set(Item item)
at System.Runtime.InputQueue`1.EnqueueAndDispatch(Item item, Boolean canDispatchOnThisThread)
at System.Runtime.InputQueue`1.EnqueueAndDispatch(T item, Action dequeuedCallback, Boolean canDispatchOnThisThread)
at System.ServiceModel.Channels.SingletonChannelAcceptor`3.Enqueue(QueueItemType item, Action dequeuedCallback, Boolean canDispatchOnThisThread)
at System.ServiceModel.Channels.HttpPipeline.EnqueueMessageAsyncResult.CompleteParseAndEnqueue(IAsyncResult result)
at System.ServiceModel.Channels.HttpPipeline.EnqueueMessageAsyncResult.HandleParseIncomingMessage(IAsyncResult result)
at System.Runtime.AsyncResult.AsyncCompletionWrapperCallback(IAsyncResult result)
at System.Runtime.Fx.AsyncThunk.UnhandledExceptionFrame(IAsyncResult result)
at System.Runtime.AsyncResult.Complete(Boolean completedSynchronously)
at System.ServiceModel.Channels.HttpInput.ParseMessageAsyncResult.OnRead(IAsyncResult result)
at System.Runtime.Fx.AsyncThunk.UnhandledExceptionFrame(IAsyncResult result)
at System.Web.Hosting.AsyncResultBase.Complete(Int32 hresult, Boolean synchronous)
at System.Web.Hosting.PipelineRuntime.AsyncCompletionHandler(IntPtr rootedObjectsPointer, Int32 bytesCompleted, Int32 hresult, IntPtr pAsyncCompletionContext)
Client Stack Trace
==================
at Epicor.ServiceModel.Channels.ImplBase`1.ShouldRethrowNonRetryableException(Exception ex, DataSet[] dataSets)
at Ice.Proxy.BO.GenXDataImpl.StoreData(GenXDataDataSet dsGenXData)
at Ice.Lib.Framework.GenXObject.StoreData(GenXDataDataSet ds)
at Ice.Lib.Framework.GenXObject.handleChunkAndSave(Boolean doCompression, String company, String productID, String typeCode, String cgcCode, String key1, String key2, String key3, String description, String comment, String version, Boolean layerWIP, String data)
at Ice.Lib.Framework.GenXObject.ChunkNSaveStringByID(String company, String productID, String typeCode, String cgcCode, String key1, String key2, String key3, String description, String comment, String version, Boolean layerWIP, String data)
at Ice.Lib.Framework.GenXObject.ChunkNSaveStringByID(String company, String productID, String typeCode, String key1, String key2, String key3, String description, String comment, String version, Boolean layerWIP, String data)
at Ice.Lib.Framework.FormFunctions.ChunkNSaveStringByID(Session s, String company, String productID, String typeCode, String key1, String key2, String key3, String description, String comment, String version, Boolean layerWIP, String data)
at Ice.Lib.Framework.FormFunctions.ChunkNSaveStringByID(Object sender, String company, String productID, String typeCode, String key1, String key2, String key3, String description, String comment, String version, Boolean layerWIP, String data)
I have been asking Epicor Support to reimage my live DB to get my Pilot DB back up and running. This solution works ok, but I would love to have a way to clear the server side error myself without having to wait for support. Is this possible? Does this error tell you anything useful?
Thanks!
Nate