Error while printing Job traveler


(William) #1

Anyone seen this one before? I’m thinking it has something to do with the customization.

Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask: System.Web.Services.Protocols.SoapException: The Hidden expression for the tablix ‘Tablix1’ contains an error: The expression references the field ‘Calc_comment’, which does not exist in the Fields collection. Expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope. Letters in the names of fields must use the correct case. —> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Hidden expression for the tablix ‘Tablix1’ contains an error: The expression references the field ‘Calc_comment’, which does not exist in the Fields collection. Expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope. Letters in the names of fields must use the correct case.
at Microsoft.ReportingServices.Library.ReportExecution2005Impl.InternalRender(String Format, String DeviceInfo, PageCountMode pageCountMode, Stream& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at Microsoft.ReportingServices.Library.ReportExecution2005Impl.Render(String Format, String DeviceInfo, PageCountMode pageCountMode, Byte[]& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
at Microsoft.ReportingServices.WebServer.ReportExecutionService.Render(String Format, String DeviceInfo, Byte[]& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
Stack Trace:
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Ice.Core.SsrsReportService.ReportExecutionService.Render(String Format, String DeviceInfo, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds) in c:_Releases\ICE\3.1.400.19\source\Server\Internal\Lib\TaskLib\Web References\SsrsReportService\Reference.cs:line 633
at Ice.Core.SsrsReporting.SsrsRendererBase.Render(SsrsRenderInformationBase renderInformation) in c:_Releases\ICE\3.1.400.19\source\Server\Internal\Lib\TaskLib\SsrsReporting\SsrsRendererBase.cs:line 141
at Ice.Core.SsrsReporting.SsrsRendererBase.<>c__DisplayClass2.b__0() in c:_Releases\ICE\3.1.400.19\source\Server\Internal\Lib\TaskLib\SsrsReporting\SsrsRendererBase.cs:line 87
at Epicor.Hosting.Trace.TraceHandle.TimeAction(Action actionToTime) in c:_Releases\ICE\3.1.400.19\source\Framework\Epicor.System\Hosting\Trace\TraceHandle.cs:line 91
at Epicor.Hosting.Trace.TraceHandle.AddTimedIfEnabled(String traceFlag, Action actionToTime, Func2 messageBuilder) in c:\_Releases\ICE\3.1.400.19\source\Framework\Epicor.System\Hosting\Trace\TraceHandle.cs:line 43 at Ice.Core.SsrsReporting.SsrsRendererBase.TraceReportRendered(String printProgram, String ssrsRenderFormat, Func1 timedAction) in c:_Releases\ICE\3.1.400.19\source\Server\Internal\Lib\TaskLib\SsrsReporting\SsrsRendererBase.cs:line 95
at Ice.Core.SsrsReporting.ReportProcessorBase1.ProcessReportPart(String reportLocation) in c:\_Releases\ICE\3.1.400.19\source\Server\Internal\Lib\TaskLib\SsrsReporting\ReportProcessorBase.cs:line 161 at Ice.Core.SsrsReporting.StandardReportProcessor1.ProcessReportParts() in c:_Releases\ICE\3.1.400.19\source\Server\Internal\Lib\TaskLib\SsrsReporting\StandardReportProcessor.cs:line 33
at Ice.Core.RptBase.ReportSsrsDatabaseBuilder1.ProcessUnroutedReport() in c:\_Releases\ICE\3.1.400.19\source\Server\Internal\Lib\TaskLib\RptBase\ReportSsrsDatabaseBuilder.cs:line 215 at Ice.Core.RptBase.ReportDatabaseBuilder1.XMLClose() in c:_Releases\ICE\3.1.400.19\source\Server\Internal\Lib\TaskLib\RptBase\ReportDatabaseBuilder.cs:line 134
at Ice.Core.RptTaskBase1.XMLClose() in c:\_Releases\ICE\3.1.400.19\source\Server\Internal\Lib\TaskLib\RptBase\RptTaskBase.cs:line 134 at Erp.Internal.JC.JobTrav.RunProcess(Int64 instanceTaskNum, String outputFileName) in c:\_Releases\ERP\UD10.1.400.19\Source\Server\Internal\JC\JobTrav\JobTrav.cs:line 685 at Ice.Hosting.TaskCaller.InnerExecuteTask(IceDataContext newContext) in c:\_Releases\ICE\3.1.400.19\source\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 78 at Ice.Hosting.TaskCaller.ExecuteTask(Boolean suppressTransaction) in c:\_Releases\ICE\3.1.400.19\source\Framework\Epicor.Ice\Hosting\TaskCaller\TaskCaller.cs:line 31 at Ice.Lib.RunTask.BpmFriendlyTaskLauncher.Run(String sessionIdPrefix, IceContext db, Action taskRunner) in c:\_Releases\ICE\3.1.400.19\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.400.19\source\Server\Services\Lib\RunTask\RunTask.cs:line 502 at Ice.Services.Lib.RunTaskSvc.InnerRunTask(Int64 ipTaskNum, Boolean suppressTransaction) in c:\_Releases\ICE\3.1.400.19\source\Server\Services\Lib\RunTask\RunTask.cs:line 502 at Ice.Services.Lib.RunTaskSvcFacade.RunTask(Int64 ipTaskNum) in c:\_Releases\ICE\3.1.400.19\source\Server\Services\Lib\RunTask\RunTaskSvcFacade.cs:line 99 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.400.19\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.400.19\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.400.19\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.ProcessMessage31(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.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.Security.NegotiateStream.ProcessFrameBody(Int32 readBytes, Byte[] buffer, Int32 offset, Int32 count, AsyncProtocolRequest asyncRequest)
at System.Net.Security.NegotiateStream.ReadCallback(AsyncProtocolRequest asyncRequest)
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.ServiceModel.Channels.SocketConnection.OnReceiveAsync(Object sender, SocketAsyncEventArgs eventArgs)
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)


(Joshua Giese) #2

There is an error in the SSRS RDL I assume this is custom?


(William) #3

Yeah, before my time. Interestingly, all the other jobs are doing just fine, so I bet someone messed up something in the job.


(Joshua Giese) #4

The error indicates that the calc field is missing is that from a table link that the field is null from the join?


(William) #5

I pulled up the customization in Report Builder and see where the calc is mentioned, but i cannot find what the calc is. The only thing I can see rihg tnow is =Replace(Fields!Calc_comment.Value,Chr(13),Chr(10)) This tells me the calc field is part of the base query, but i can not find it anywhere.


(William) #6

And this comment comes from Job Assembly but the cal is the part i am not sure of.


(Joshua Giese) #7

The error say’s it’s hidden, I guess they did a good job!

Admittedly my SSRS is pretty rusty, I hate it so I continue to use Crystal. Have you ensure it’s still defined in the datasource field list. It’s a generic SSRS error maybe the Google has some info too.


(Rob Bucek) #8

look in the RDD, you should see it under calculated fields under the relevant table (i assume JobAsmbl) if it’s not there add new calculated field and you can rebuild it from there.


(William) #9

What is the RDD?


(Rob Bucek) #10

Report Data Definition, it’s what generates your dataset within Epicor. There is a maintenance screen for it.


(William) #11

Ah, thanks! Found the calculated field, now need to access it. However, i did get the traveler to print, i went to the job and looked at at the Job Assembly comment section. I twas blank, so I typed Blank, and it printed just fine. Gotta get that fixed!