Hi all,

This is a common occurence and I’m not going to go through the manual process of configuring the SSRS server for the Reporting Code DLL when it is not placed on the Data Warehouse Management Serveras this can be found here:

https://technet.microsoft.com/en-us/system-center-docs/sm/deploy/deploy-manual-steps-to-configure-the-remote-sql-server-reporting-services

But why would this occur when the Report Server IS located on the Data Warehouse Management Server?

We get the normal 33410 occur:

deploymenterror

The error in more detail:

reportcode-error

Again we have the error pointing to the fact that the SSRS services cannot locate the reporting code dll but everything is correct as per the technet support page with the DLL (correct version) and the config files configured correctly but the reports are empty:

codedll

The following Report Deployment shows the failures and the reson why no reports are deployed:

mpdeployfail

Scratching my head for a little while led me to checking everything else, SSRS Services, Permissions for the Data Reader Account etc. to make sure it wasn’t something obvious.

IT WAS 🙂 But isn’t it always when you have the answer 🙂

, Getting back to the DLL file – I examined the properties and found that the file was set to be blocked as it was copied in from another server.  This is odd but could be down to a specific circumstance regarding our automated installation process for the System Center Suite (please see http://www.poweronplatforms.com/system-center-automated-deployment/ for mor details) but remains a vaild occurence if copying from another server if configuring manually:

 

unblock

Going back to the Console – and selecting the “Restart Deployment” then resulted in the following events being generated:

reportfailerror

 

And finnally reports being deployed to the servers  🙂

 

Hopefully that will save someone a few hours of headscratching and second guessing solid installation and adherance to TechNet procedures.

 

Damian

SCSM Report Deployment Failed – Error 33410 – No Reports in Service Manager 2012 and 2016

Leave a Reply

Your email address will not be published. Required fields are marked *