I setup a test environment and on the Reporting Services Tab in the app server, I told it to import, and the location of the reports, I had copied and changed the name so not to interfere with my live environment. After deploying, no one in the live environment is bale to print.
I have regenerated the live data model, removed the ssrs and redeployed in the test environment. Ideas?
What does the system monitor say for users in LIVE? Are you sure you deployed the correct environment?
This error message, or one lsike it, depending on the report:
Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask: System.Web.Services.Protocols.SoapException: An error has occurred during report processing. —> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. —> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset ‘OrderHed’. —> System.Data.SqlClient.SqlException: Invalid object name ‘OrderHed_2a785828c5914951b4e059ea6032671e’.
at Microsoft.ReportingServices.Library.ReportExecution2005Impl.SetExecutionParameters(ParameterValue[] Parameters, String ParameterLanguage, ExecutionInfo2& executionInfo)
at Microsoft.ReportingServices.WebServer.ReportExecutionService.SetExecutionParameters(ParameterValue[] Parameters, String ParameterLanguage, ExecutionInfo& executionInfo)
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.SetExecutionParameters(ParameterValue[] Parameters, String ParameterLanguage) in c:_Releases\ICE\3.1.400.19\source\Server\Internal\Lib\TaskLib\Web References\SsrsReportService\Reference.cs:line 497
at Ice.Core.SsrsReporting.SsrsRendererBase.ConfigureReportServerForReport(String reportPath, ParameterValue[] parameters) in c:_Releases\ICE\3.1.400.19\source\Server\Internal\Lib\TaskLib\SsrsReporting\SsrsRendererBase.cs:line 176
at Ice.Core.SsrsReporting.SsrsSingleDocumentRenderer.<>c__DisplayClass5.b__4() in c:_Releases\ICE\3.1.400.19\source\Server\Internal\Lib\TaskLib\SsrsReporting\SsrsSingleDocumentRenderer.cs:line 49
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.OM.SalesOrderAck.RunProcess(Int64 instanceTaskNum, String outputFileName) in c:\_Releases\ERP\RL10.1.400.0\Source\Server\Internal\OM\SalesOrderAck\SalesOrderAck.cs:line 589 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)
What does the admin console look like in Reporting for your live environment?
Per the error looks like you accidentaly pointed Prod to the Test RPT DB… or something of the sort.
How do i fix this? And I didn’t even touch Prod, so kinda confused on how i did that.
Re-Deploy Prod pointing to the right place… but don’t quote me on this, may be time to call Support.
support gave me some guidance. But didn’t make much sense to me. Learning all the time.
If your CustomReports are under the CustomReports folder you should be fine… (again Backup back up back up) just in case.
William, I had the same problem recently, it has nothing to do with your setup, it has to do with the fact that OrderHed table is not being found.
Check the query definition in you SSRS and make sure that the query is actually calling for that table. At least in my case that is what it solved that issue
Interstingly, depending on the report, nothing can seem to be found. Like company as well. Now Epicor has my App SErver all jacked up and it won’t install. @aidacra If you are seeing htis, I could use some help before I get killed by my boss! LOL!
I’ll call you once I get off my current remote session regarding this issue.
–Nathan.
Thanks! I have one guy on now, but now I don’t evenhave a task agent.
um, it’s actually me and one of my resources. I join remote sessions under an alias 
you are in good hands!
–Nathan.
LOL! Understand.
NOTE: this is a live tweeting like situation as things come to me so the content is subject to change.
Some notes, but, definitely not based on any specific current or previous remote session:
. Recycling = 
(there will be some slowness as we recache things, but, things will still work) Always best to do the least amount of destructive force in a production environment as is needed to accomplish the goal if you don’t have an office with a door that locks, and you don’t have a lot of ambient noise to drown out the angry mob at your door.@aidacra I took my epicor from 10.1.400.9 to 10.1.400.37 and I am back to a similiar reporting issue as this thread. Kinda curious why, and If you could help in getting this fixed again. I am wondeirng when I applied the newest security patch for SQL if it didn’t erease what you did.
I see your new support case and it has been assigned for an analyst to get back to you this morning.
