Not Monitored State and Workflow fail

[Magicb0b]

Hi Zvi,
I need your help:
We have installed your MP version 2.2.0.1 in scom2012R2 UR14.
Set up 6 query to monitore by windows authentification.
I do the test connection it's OK but the state is always in Not Monitored and i have a message error :workflow fail

Total Workflows Failed: 2
Details: show/hide

Object Id: {2F545F66-0620-7FB0-2A41-80F412DB4AF9}
Object Display Name: Kofax Seuil 10
Workflows: show/hide

Workflow Id: Workflow Display Name:
QueryOleDbMonitor.OleDBQueryUnitMonitor.fc8d30a560b949288d841f2650a9919d Ole DB Query Unit Monitor
QueryOleDbMonitor.OleDbQueryPerformaceCollection.fc8d30a560b949288d841f2650a9919d OleDb Query Performance Collection

Thanks a lot for your help.

Best Regards
[David]

[UretzkyZvi]

Hi David,
Can you add more details? You should see more information about the exception in the log.

[Magicb0b]

Hi Zvi,
Thanks for your reply.
I don't find the log ,it's in eventviewer ?
my query in your MP 👍 SELECT CASE
WHEN (SELECT COUNT (*)
FROM T_IMPORT_XEROX_ACK_PLI
WHERE CodeErreurACK !=0 and convert(date, DateInsertion) = CONVERT(date,GETDATE())) >= 150
THEN 1
ELSE 0
END

[UretzkyZvi]

the query is Ok. yes, search for the exception in the event log (on the agent that hosting the sql instance )

[Magicb0b]

it's normal the state is Not Monitored ?

[Magicb0b]

Hi Zvi,
Rule/Monitor "QueryOleDbMonitor.OleDbQueryPerformaceCollection.ffadfec4ce504d7783a3e4c523bdeb25" running for instance "Kofax Seuil 100" with id:"{BAE5DF25-4523-7D3D-3BEB-1E9101669F1C}" cannot be initialized and will not be loaded. Management group "SCOM-GIS-FR"

[Magicb0b]

Rule/Monitor "QueryOleDbMonitor.OleDBQueryUnitMonitor.ffadfec4ce504d7783a3e4c523bdeb25" running for instance "Kofax Seuil 100" with id:"{BAE5DF25-4523-7D3D-3BEB-1E9101669F1C}" cannot be initialized and will not be loaded. Management group "SCOM-GIS-FR"

[Magicb0b]

Source :healthService
EventID : 1102

Thanks

[Magicb0b]

Zvi,
I restart the healthservice now and 👍 Rule/Monitor "QueryOleDbMonitor.OleDbQueryPerformaceCollection.a032311048ca4bc0a3905f50208b87d9" running for instance "Kofax Seuil 50" with id:"{6253EF11-8B2D-1C11-4DDA-35769537501F}" cannot be initialized and will not be loaded. Management group "SCOM-GIS-FR"

[UretzkyZvi]

make sure that the agent is enable agent proxy (https://scomandothergeekystuff.com/2017/07/23/enabling-scom-2016-agent-proxy/) same in scom2012

[Magicb0b]

The agent is enable agent proxy,i restart the healthservice and same error 👍 Rule/Monitor "QueryOleDbMonitor.OleDbQueryPerformaceCollection.ffadfec4ce504d7783a3e4c523bdeb25" running for instance "Kofax Seuil 100" with id:"{BAE5DF25-4523-7D3D-3BEB-1E9101669F1C}" cannot be initialized and will not be loaded. Management group "SCOM-GIS-FR"

[UretzkyZvi]

you can try to follow this https://www.opslogix.com/knowledgebase/debugging-scom-workflows-using-powershell to debug.

[Magicb0b]

Zvi,
I'm not a expert of powershell,i must change this ?
$targetName=“Target1”
$monitorName=“OpsLogix.IMP.Monitor.Ping.WMIPingCheck”

[Magicb0b]

$monitorName=OleDBQueryMonitoring
$targetName=DSI-WXXXBDDV0.Groupe.XXXX.fr\SQLT110_TECH8_PB
it's correct ?
thanks

[UretzkyZvi]

Sorry I didn't explain it properly the link is to an example how to debug MP, the PS is not an option for query mp since I didn't implemented such as capability but you can use other 4 options to debug as describe in the link.

[Magicb0b]

Hi Zvi,
I use traceconfig and start tracing.cmd but it doesn't work i have this error : failed to create temporaly file when starting trace session error code 5
Thanks for your help