SOLVED SCCM Reporting Service not working

[hirenshinde]

Hi,

I have been trying to generate reports from SCCM Reporting service but not sure why it's failing. The srsrpMSI.log and srsrpsetup.log says that the reporting service is installed succesfully.
However srsrpsetup.log gives below error:

Delete old SCCMErrorResources folder
Could not find a part of the path 'D:\SCCMErrorResources'.

(!) InitializeSrsWhenNeeded error = The parameter is incorrect.
Failures reported during periodic health check by the SRS Server xyz.abc.com.

Please help.. I browsed the URLs and confirmed that I can access both reports and reportserver url successfully but those URL have nothing rather link with my site code.

Also health status for reporting service in SCCM Console is critical.

Regards,
Hiren Shinde.

 

[Garth]

Please help.. I browsed the URLs and confirmed that I can access both reports and reportserver url successfully but those URL have nothing rather link with my site code.

Does this mean that the SCCM reports exist and you can run them?

If you reset the error within the console, does it come back? Is it about the same time every day?

 

[hirenshinde]

I can access the portal. Reports are not getting generated. If i try to generate manually it gives me error "The Report Builder click-once application does not exist on the report server."

Regards,
Hiren Shinde

 

[Garth]

You need to look at the SRSMSI and SRSRP logs to see what is happening then.

 

[hirenshinde]

SRSRP gives below error:

Delete old SCCMErrorResources folder
Could not find a part of the path 'D:\SCCMErrorResources'.

(!) InitializeSrsWhenNeeded error = The parameter is incorrect.
Failures reported during periodic health check by the SRS Server xyz.abc.com.

 

[Garth]

Does the Path exist?

 

[hirenshinde]

It's not.. But if i create a folder SCCM deletes it and then says "couldn't find a part of the path"

 

[hirenshinde]

Add to this.. the system center logs giving below error:

Message ID 7402: " Reporting Point failed to monitor SQL Reporting Services Server on "SRVSCCMRPT.ABC.COM".

 

[Garth]

Remove the Reporting Point, Wait a few hours. add it back again.

 

[Prajwal Desai]

@hirenshinde - Did you try what Garth suggested ?.

 

[hirenshinde]

Hi... Sorry for the delayed response.. That didn't work... So i just upgraded from SP2 to 1606... Now I am getting below error while generating custom reports.

"Error while loading code module: ‘SrsResources, culture=neutral’. Details: Could not load file or assembly 'SrsResources, Culture=neutral' or one of its dependencies. The system cannot find the file specified."

 

[hirenshinde]

Sorry forgot to mention that I am using SQL 2017 Standard Edition. Can it be the reason of the issue!!

 

[Garth]

Hi... Sorry for the delayed response.. That didn't work... So i just upgraded from SP2 to 1606... Now I am getting below error while generating custom reports.

"Error while loading code module: ‘SrsResources, culture=neutral’. Details: Could not load file or assembly 'SrsResources, Culture=neutral' or one of its dependencies. The system cannot find the file specified."

This is not the same error as above. where exactly are you seeing this error?

 

[hirenshinde]

This error appears during custom reports creation after specifying folder name for reports.

 

[hirenshinde]

Issue Resolved after I upgraded the SCCM to version 1710.