# SSRS Report Error **URL:** \ **Category:** Epicor ERP 10\ **Created:** [June 12, 2017, 7:53am UTC](https://www.epiusers.help/t/ssrs-report-error/38801 "2017-06-12T07:53:18Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![EChristy](https://www.epiusers.help/letter_avatar_proxy/v4/letter/e/e19adc/32.png) [@EChristy](https://www.epiusers.help/u/EChristy)\ **Post date:** [June 12, 2017, 7:53am UTC](https://www.epiusers.help/t/ssrs-report-error/38801/1 "2017-06-12T07:53:18Z")
Hi, I’ve created a new version of our Quote Report. It works perfectly in Test, however, when I move it to Live (I have created the necessary Report Style and Data Definition) it Errors on me with the following detail. > 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 ‘RptLabels’. —\> System.Data.SqlClient.SqlException: Invalid object name ‘RptLabels\_2c8d09a590894191946f92e43809a72c’. > 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) > 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) > at Ice.Core.SsrsReporting.SsrsReportRenderer.Render(SsrsRenderInformationBase renderInformation) > at Ice.Core.SsrsReporting.ReportProcessorBase`1.RenderReportForPreviewOrClientPrint(SysRptLst sysRptLstRow) at Ice.Core.SsrsReporting.ReportProcessorBase`1.ProcessReportPart(String reportLocation, Action`1 modifySysRptLstRow) at Ice.Core.RptBase.ReportSsrsDatabaseBuilder`1.ProcessReportWithDataInPlace(SqlConnection connection) > at Ice.Core.RptBase.ReportDatabaseBuilder`1.XMLClose() > at Erp.Internal.EQ.QuotForm.RunProcess(Int32 instanceTaskNum, String outputFileName) > at Ice.Hosting.TaskCaller.ExecuteTask() > at Ice.Services.Lib.RunTaskSvc.RunTask(Int32 ipTaskNum) I can see that it’s something to do with the RptLabels, but have no idea how to fix… Does anyone have any ideas how I can resolve this? Many thanks ---
**Author:** ![HAREPSL](https://www.epiusers.help/user_avatar/www.epiusers.help/harepsl/32/2841_2.png) [@HAREPSL](https://www.epiusers.help/u/HAREPSL)\ **Post date:** [June 12, 2017, 9:57am UTC](https://www.epiusers.help/t/ssrs-report-error/38801/2 "2017-06-12T09:57:45Z")
Check the data connections in the SSRS report, I have seen similar issues where the connections needs to be re-created. ---
**Author:** ![jkane](https://www.epiusers.help/user_avatar/www.epiusers.help/jkane/32/57624_2.png) [@jkane](https://www.epiusers.help/u/jkane)\ **Post date:** [June 12, 2017, 12:38pm UTC](https://www.epiusers.help/t/ssrs-report-error/38801/3 "2017-06-12T12:38:52Z")
You have to make sure that the report is pointing to the Production environment. When you transfer a report from Test to Production, you have to change what it is pointing to also. It does not automatically change it. ---
**Author:** ![estm8ben](https://www.epiusers.help/letter_avatar_proxy/v4/letter/e/b9e5f3/32.png) [@estm8ben](https://www.epiusers.help/u/estm8ben)\ **Post date:** [June 13, 2017, 3:29pm UTC](https://www.epiusers.help/t/ssrs-report-error/38801/4 "2017-06-13T15:29:24Z")
> [@EChristy](#): > > ‘RptLabels\_2c8d09a590894191946f92e43809a72c’ Have you accidentally hard coded your GUID? ---
**Author:** ![EChristy](https://www.epiusers.help/letter_avatar_proxy/v4/letter/e/e19adc/32.png) [@EChristy](https://www.epiusers.help/u/EChristy)\ **Post date:** [June 14, 2017, 6:53am UTC](https://www.epiusers.help/t/ssrs-report-error/38801/5 "2017-06-14T06:53:41Z")
Thanks for the suggestions. I’m clearly even more of a novice than I thought. How do I recreate/check that the data connections are pointing at the Live Environment? I thought that because both Test and Live appear in my Data Source Properties, that I’d be OK. Clearly not. ![](https://epiusers.help/uploads/default/original/2X/f/f21c7bb90e5c767ee50c19cad783370a7c511ca0.png) I don’t believe I’ve hard coded the GUID - I don’t input a GUID anywhere when working on the report. Thanks again for your help, all. ---
**Author:** ![knash](https://www.epiusers.help/user_avatar/www.epiusers.help/knash/32/74179_2.png) [@knash](https://www.epiusers.help/u/knash)\ **Post date:** [June 14, 2017, 12:55pm UTC](https://www.epiusers.help/t/ssrs-report-error/38801/6 "2017-06-14T12:55:52Z")
Try and open the report click the prod datasource you have shown, test connection, and then click OK. Even though it shows both on the reports, the correct one needs it to be selected. The report is not clear on which one is selected. ---
**Author:** ![jkane](https://www.epiusers.help/user_avatar/www.epiusers.help/jkane/32/57624_2.png) [@jkane](https://www.epiusers.help/u/jkane)\ **Post date:** [June 14, 2017, 1:19pm UTC](https://www.epiusers.help/t/ssrs-report-error/38801/7 "2017-06-14T13:19:08Z")
I currently don’t have an SSRS environment up and running (very poor install from before me) and we are upgrading from 8. So anything I say is coming from memory (that is to say it is not accurate). I remember it was something like right clicking on the report in the report repository and selecting the properties (or something like that). I found a screen shot online that shows you what you should see. ![](https://epiusers.help/uploads/default/original/2X/2/2c76ce92e030ae13cfd9ffd4c380ea7eb8627cb2.png) Go under Data Sources and check there. ---
**Author:** ![HAREPSL](https://www.epiusers.help/user_avatar/www.epiusers.help/harepsl/32/2841_2.png) [@HAREPSL](https://www.epiusers.help/u/HAREPSL)\ **Post date:** [June 14, 2017, 4:21pm UTC](https://www.epiusers.help/t/ssrs-report-error/38801/8 "2017-06-14T16:21:58Z")
Try using the Embedded Connection option and manually create the connection. ---
**Author:** ![EChristy](https://www.epiusers.help/letter_avatar_proxy/v4/letter/e/e19adc/32.png) [@EChristy](https://www.epiusers.help/u/EChristy)\ **Post date:** [June 26, 2017, 11:24am UTC](https://www.epiusers.help/t/ssrs-report-error/38801/9 "2017-06-26T11:24:11Z")
Thanks - I’ve done this and it works perfectly! ---
**Author:** ![knash](https://www.epiusers.help/user_avatar/www.epiusers.help/knash/32/74179_2.png) [@knash](https://www.epiusers.help/u/knash)\ **Post date:** [June 26, 2017, 12:50pm UTC](https://www.epiusers.help/t/ssrs-report-error/38801/10 "2017-06-26T12:50:19Z")
Great please mark complete!!! Thanks, Ken