HiI have configured the UDC as per the last mail from Ken Eio. I have attached the screenshot of the UDC.1) I have created UDC as per UDC_Creation screenshot. 2) When the table went under REORG PENDING status this query ran from the foglight and get the output as UDC_Query_output screenshot in which i will get reorg_pending field as "Y" means Yes the mentioned table in schema_table field is in reorg pending state.3) Now I have set the Rules from the Add Rule tab in Rules & Notification.4) Refer Rules_Definition screenshot where I ahve created the rule name.5) Than I have created variable refer Rules_variables screenshot.6) I have given the condition as Critical one in Condition, alarms tab refer Conditions Screenshot. Please let me know whether my condition will throw the critical alram with message and do i will get the mail also for the same? My concern is whenever the table get the output as "Y" than i should get the alarm with DBname Schema name and table name i.e. on which schema.table name need reorg.
I will ask:
Please share your answers to those, as they will assist those who would like to help you in this forum.
com.quest.nitro.service.scripting.errors.noisy.OptionalDataMissingScriptServerException: reorg_pending (script: a644189dc992ab2bf5ba911a58382d67)
Yes I am looking for critical alarm to trigger when reorg_pending column as "Y" and I should get an email in my mail box.
Please try the Run Condition Query with just #reorg_pending# as the query. Does it return a value?
It returned a error messgae:
com.quest.nitro.service.sl.interfaces.scripting.ScriptingException: com.quest.nitro.service.sl.interfaces.scripting.ScriptUndefinedObservationException: undefined observation (present but empty observed data for topology object b06b31b5-a9a7-43e5-910b-1e7c3b34502e) in query: reorg_pending ----script start------ #reorg_pending# ---- script end ------
Please try the following:
I got the below error message:
com.quest.nitro.service.scripting.errors.noisy.OptionalDataMissingScriptServerException: reorg_pending (script: 6905eb7546bbc0947a498b1d969498de)