Kinetic 2024.1 SSRS deployment

Kinetic ERP
22

Yeah it was running

1 Like
23

I’d be checking the Event logs on the app server to see any further details, and as @knash says the SSRS Logs.

The other place to look is the \ProgramData\Epicor Software Corporation\Setup Configuration\ConfigEnv~.log files

Might give some more info

You can also mess about witht he DemoSetupData.xml in the SSRS section and see if you can force it…What I found was the as soon as you modified the SSRSImport key setting it to True and opening up the app server configuration, then hit deploy it would change the value to false.

and because of the way they use the ICECommon database now I understand why you actually don’t need standard reports to be installed to the SSRS server folders any more, as it does some epimagic getting the RDL from the database. Only custom reports appear to be added.

But I am rambling, that’s probably not your problem.

1 Like
24

Thanks, look I see a bunch of “cannot access file” in the SSRS logs which would hint at the permissions that changed to get around the error I was having when trying to register the app server.

25

Thank you for that log very interesting.

26

I learned two things back at the 10 to 11 conversion

  • Always deploy the appserver WITHOUT SSRS first. When you’re sure it works, then go back and deploy SSRS. Too many errors back then when they split SSRS from SQL and required certs and all that.

  • I create a UNC share on the SQL Server that points to the “ReportServer” folder path. That makes it available to everyone working with SSRS. Only me right now, but it works great in the Appsever deployment even if it’s on the same server.

3 Likes
27

100% all the way on that one @MikeGross

2022 to 23 and 24 is another new ballgame with SSRS
You get these new dbs
image

2 Likes
28

Dude that’s what the documentation lends me to believe people are doing. They create a share like that. Yesterday the support agent who I called told me to create a share, but chose to share the base folder in ProgramFiles…

1 Like
29

Yeah I saw that haha, at least I got that far.

30

We had an expired version of ssrs running and it caused issues like you are describing.

What does the database setting in the Report Server Configuration Manager look like?

You can access the Web Service and Web Portal URLs with no issues.

1 Like