First published on TECHNET on Jun 25, 2018
Hi SCOM folk
Today I am going to blog how to resolve event ID 26319 on System Center Operations Manager (SCOM) 1801 related to the p_GetDatawarehouseVersion stored procedure from getting generated.
Looking at the Operations Manager event log on Management Server(s) from time to time, as any good SCOM Administrator should do, you will find some instances of the event ID 26319 (yeah, the well-known generic 26319 ).
What will surprise you is that among all these instances, there are some of them which have an interesting description. They report about the lack of permissions to execute a given stored procedure or that a stored procedure is missing. These instances of event 26319 get generated *only* on SCOM 1801 installations, every time the Operations Console is opened.
As anticipated above, opening the Operations console will cause the generation of event ID 26319.
This event is generated with 2 different descriptions, depending on what type of installation has been carried out. That means that:
The reason behind is that during the installation, the setup procedure for some unknown and strange reasons:
Luckily, there is a solution for this mess. To resolve the issue and to stop the event ID 26319 from getting generated in both cases, follow the steps below:
The procedure above will fix the issue with the p_GetDatawarehouseVersion stored procedure and will stop the generation of event ID 26319 related to it … and will save you from headache
Thank you all and enjoy problem solving
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.