seems scope is not a problem , just I have changed in where condition Status='5'
sql(SELECT count(ID) into :suspendedCount FROM Ens.MessageHeader where TargetQueueName not like '_S%' and TargetQueueName not like 'ENS%' and Status='5')
working fine
but same query resulting 0 records in sql explorer, and revert the where condition working fine in sql explorer
why the difference where condition requiring for @sql ,sql explorer
It is possible by implementing monitoring integration (business service, business Process as Router, Business Operation as rest call) and deploying in the same production.
1) Implement Customised Business service which triggers by every 5 min (this you can configure) to call methods fr each of your requirement and get the data from cache and prepare the respective type of message and call Business Rules engine.
Example Methods:
1)getHeartbeat() method fetch the currently running version of production and namespace and prepared customised heartbeat message and send to the Rules engine
2) getQueuestatus() this method fetches the interested queues info from the cache and prepare the new message for each queue and send it to the business rules engine
3)getInactivity() this method gets all inactive processes and prepares the new message for each process and sends them to the rules engine.
create as many methods as per your requirement.
Now in business service write rules for each type of message, and check respective values are reaching threshold value (if needed ) then send message to Rest endpoint using Business Operation.
This rest service will read the messages and stored them in a web application database.
Web application Shows the summary of the data and refreshes every 5 minutes.
This way, whatever monitoring values using ENSLIB class methods you can read using cache script by calling embedded SQL, All readings you can show in your web page.
If production is down, As this integration is the same production, your heartbeat messages also missing in next 5 min with other messages. You can build logic in a webpage, if the heartbeat is older than 5 min, shows in the web app as Production down.
Hope this idea helpful to you , we did the same way for our monitoring requirement
go to post
Hi Jon
Thanks for your support, Currently I found the info in Doc.
https://docs.intersystems.com/healthconnectlatest/csp/docbook/DocBook.UI...
We are implementing interface using this kit.
If any help required, I will reach out to you.
Thanks a lot
Prashanth
go to post
Thanks Vitaliy Serdtsev
This answered my question
go to post
thanks Robert ,
seems scope is not a problem , just I have changed in where condition Status='5'
sql(SELECT count(ID) into :suspendedCount FROM Ens.MessageHeader where TargetQueueName not like '_S%' and TargetQueueName not like 'ENS%' and Status='5')
working fine
but same query resulting 0 records in sql explorer, and revert the where condition working fine in sql explorer
why the difference where condition requiring for @sql ,sql explorer
thanks a lot,
Prashanth
go to post
Thanks Eduard for immediate help, still I am getting same error
go to post
Thanks a lot Steve
go to post
no problem, I got answer from Eduard
go to post
*test = optimus
1) yes
2)yes
3)yes
go to post
Thanks Eduard for quick help , working fine now
go to post
Thanks a lot, Roger, yes working fine.
thanks for your time and effort to share the code snippet.
go to post
Hi Utsavi,
It is possible by implementing monitoring integration (business service, business Process as Router, Business Operation as rest call) and deploying in the same production.
1) Implement Customised Business service which triggers by every 5 min (this you can configure) to call methods fr each of your requirement and get the data from cache and prepare the respective type of message and call Business Rules engine.
Example Methods:
1)getHeartbeat() method fetch the currently running version of production and namespace and prepared customised heartbeat message and send to the Rules engine
2) getQueuestatus() this method fetches the interested queues info from the cache and prepare the new message for each queue and send it to the business rules engine
3)getInactivity() this method gets all inactive processes and prepares the new message for each process and sends them to the rules engine.
create as many methods as per your requirement.
Now in business service write rules for each type of message, and check respective values are reaching threshold value (if needed ) then send message to Rest endpoint using Business Operation.
This rest service will read the messages and stored them in a web application database.
Web application Shows the summary of the data and refreshes every 5 minutes.
This way, whatever monitoring values using ENSLIB class methods you can read using cache script by calling embedded SQL, All readings you can show in your web page.
If production is down, As this integration is the same production, your heartbeat messages also missing in next 5 min with other messages. You can build logic in a webpage, if the heartbeat is older than 5 min, shows in the web app as Production down.
Hope this idea helpful to you , we did the same way for our monitoring requirement
Thanks,
Prashanth P