Error on deploying app with SSRS

New Install of 10.2.300…

Trying to enable SSRS on an App that successfully deployed w/o SSRS Configured. But I get the following:

“SSRS - The SSRS URL is not valid.”

image

Which URL is that referring to?
The “SSRS Web Service URL”, or the “SSRS ReportServer Location”

The SQL server is on a different box than the App server.
But if I enter the SSRS Web Service URL into IE on the App server, I get an HTTP error 500
image

Yet from the App server, I can use IE to see http://xxxx00375/Reports (which redirects to “http://xxxx00375/Reports/browse/

image

Can someone point in the right direction?

Firewall issue? I’m guessing you meant to say you can access it from SQL Server but not app server

Both the images above are from the App server.

I get the HTTP Error 500 when trying to get to http://xxxx00375/ReportServer while on the SQL server (\xxxx00375), too.

Go to the SQL Server box open Report Configuration Manager
and see what the Services URL is in that?

That’s where I got the URL from

And is it okay to use the network path containing a “C$” to reference the C drive of a remote computer? Or should I create a share on that computer? (highlighted below)

Did you open file sharing ports on windows firewall (MSSQL Server)?

  • UDP 138, File and Printer Sharing (NB-Datagram-In)
  • UDP 137, File and Printer Sharing (NB-Name-In)
  • TCP 139, File and Printer Sharing (NB-Session-In)
  • TCP 445, File and Printer Sharing (SMB-In)

They are all open

Was there ever a solution to this? We are getting this exact same error for some reason and I have confirmed all the same checks to make sure the URL matches what we have on SQL Server. I can put the url in on our APP Server, SQL Server and my desktop and all seem to work and bring up Live/Pilot/Test report folder dir. This was working until recently when we started to try and start working with SSRS reports vs. Crystal which most are custom reports use currently. I was able to deploy the newer version if I unchecked SSRS but obviously we need to use SSRS reports with E10.

Hopefully this was already figured out but just not posted.

Thank you,

It turned out to be something rather stupid, which compounded upon deployment…

I had the path to SSRS (the field near the bottom of the SSRS tab in EAC) using ‘/’ , instead of ‘’.
//servername/c$/.... was bad. Not only would the deployment fail, it would mess up the webconfig file.

\\servername\c$\.... worked. (After fixing the webconfig file too)

Post #5 shows it the right way. It still wasnt working after i changed it, UNTIL I fixed the webconfig file.

Thanks for the update, For us it actually turned out to be an issue with corrupt encryption keys for the SSRS reports DB. Epicor support wanted us to just restore our whole LIVE DB back to a date when it was working (3-4 days ago). It turns out we got a girl in support that was so far out of her comfort zone that she even started the call with a backup person on IM to assist. So long story short it took us about 45 min. to just re-install the SSRS report DB after deleting the old one (saved all our custom reports first) then we were back up and able to again deploy Report Services again. So what I think anyone that has used Epicor for more then 10 years knows already is make sure you get a second opinion if you end up with a inexperienced support agent especially when they give you the “ultimate fix” to restore everything back to a time when it did work. I am very sure if I had of told our accounting department what Epicor support had told us to do they all would have quit since it was month-end when this happened. On another note: thankfully we still use Crystal Reports and I was able to keep things going (quotes, invoices, shop travellers, etc.) by using the Crystal Report versions I still keep and some we still use instead of SSRS report due to complexities with the reports.

hola buenas tardes , por favor necesito ayuda con el tema mencionado…si me puedes ayudar le agradezco

Oye Henry, por que usas el nobmre de la base de datos en este espacio?

Igual quitas eso.

image

Pero al final, con referencia a los que han escrito antes, es algo con el enlace final de “SSRS Report Server Location.”

Has llamado a Epicor ya? Tienen un equipo de instalaciones que pueden ayudarte.

y llame pero me dijeron que estaba dañado este archivo…pero como no era de problema de ellos no me podian resolver

Ninguno de tus instalaciones funcionan o solo este? Veo k tienes EpicorPilot, Test, y otros.

Is it normal for your executable files (.exe) to show with the Notepad icon?

Is your server is setup to always show file extensions in the File Manager?
I ask because the file displayed as “RSPortal” has type “Application”

the one that displays as “RSPortal.exe” may actually be RSPorta.exe.config, with files with the .config extension having Notepad as their default program.

Open “RSPortal.exe” (the one that looks like a notepad icon), and then hit CTRL+END. There might be info in that file it is just way off to the right side.

1 Like

el archivo esta totalmente en blanco…puedes conectarse conmigo al WhatsApp al +573046338148

ninguna

Calvin, I can’t tell if the issue is that reporting services were setup wrong on the SQL server or if the deployment is just failing because of a setting in the admin console… What is your take?

estaba funcionando todo sin inconvenientes…pero el dia de ayer se reinicio el servidor y desde ese momento tengo ese inconveniente …

  1. no me cargaba el servicio del SQL server reporting service…emplace el archivo web.config
    y luego se verifico y veo que tambien el RSportal.exe.config esta dañado…no tiene ninguna informacion