Install the original Reports to the SQL server

Epicor ERP 10
1

We’re running into issues when we deploy an App with SSRS enabled, and the option to install the reports enabled. Part of the way through the copying of the reports, the deployment errors out. If I re-deploy without enabling the Install Reports option selected, it deploys okay.

But now I don’t have all the reports on the SQL server. I’ve found the reports on the App server in
C:\Epicor\ERP10\ERP10.2.300.0\SupplementalInstalls\SSRS\reports

There is also a file reports.zip in the \SSRS folder of the path mentioned above.

Can I just upload these reports to the root folder specified in the EAC SSRS configuration?

And for what it’s worth - the error I get when the EAC deploy is copying of the reports is:

Application Server Setup Failed.
Errors:
System.InvalidOperationException: Client found response content type of '', but expected 'text/xml'.
The request failed with an empty response.
   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.Lib.SsrsReporting.ReportingService2010.CreateCatalogItem(String ItemType, String Name, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings)
   at Ice.Lib.Reporting.SsrsFolder.<>c__DisplayClass7_0.<CreateReport>b__0(IReportingService service)
   at Ice.Lib.Reporting.SsrsReportingServiceCaller.DoWithService[TReturn](Func`2 action)
   at Ice.Lib.Reporting.SsrsFolder.CreateReport(String reportPath, Byte[] reportBytes)
   at Ice.Lib.Reporting.SsrsReportingServiceCaller.DoWithService[TReturn](Func`2 action)
   at Ice.Lib.Reporting.SsrsReportImporter.ImportReport(String reportPath, XDocument reportDocument)
   at SetupEnvironment.Steps.ImportSsrsReports.ImportReportsInZipFile(SsrsReportImporter reportImporter, SsrsFolder ssrsFolder, String reportsBasePath, String reportZipPath)
   at SetupEnvironment.Steps.ImportSsrsReports.ImportReportsInZipFiles(SsrsReportingServiceCaller serviceCaller, String reportsBasePath, String reportZipPaths)
   at SetupEnvironment.StepBase.Run()
2

open the appserver on admin console, go to ssrs tab, check import reports checkbox, redeploy

3

The error happens every time I re-deploy. I can only do a successful deployment when I don’t select the Import Reports.

4

Bummer. Contact support? lol

5

You might want to have a look at the SSRS log files under C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\LogFiles (I guess the path is not the correct one, it’s just to help you locate it).

6

When I look through the events and log files I see something odd. Sometimes the error refers to MSSQLSERVER_0 while other times it refers to MSSQLSERVER_1

Is it normal for that reference to constantly change back and forth?