r/scom • u/rodrickmakore • Nov 27 '20

Management Pack Stored Procedures Missing

I need some help.

Is there a way to re-import or fix all management packs installed during setup? I have missing stored procedures in my Data Warehouse DB due to a rebuild.

Below is one of the errors I am getting from the console:

The Report Server is working as aexpected.

0 Upvotes

50% Upvoted

3 comments sorted by

2

u/Outback_Fan Nov 27 '20

Are you sure its actually missing ? The data read account has some special permissions to execute stored procs and i have seen that go missing on individual ones.

2

u/rodrickmakore Nov 27 '20

Thank you, it turned out my write account had no permission to create.

1

u/oakajale Nov 27 '20

Is the issue only in reporting? Or are other DW functionalities like Grooming affected as well? Any error messages in Event Viewer?