How to customize the message of the robot inactive alarm

[Jose Romero]

Dear community, I have applied the customization of the "Robot is inactive" alarm legend described in the following documentation.

https://knowledge.broadcom.com/external/article/135748 

Aug 16 09:56:00:455 [140231923709696] 0 nas: [ndbOracleIsConnected] IsInitalized: 1.  Env: 0x0x7f8a38079cf0 Auth: 0x0x7f8a380f8fe0 Svc: 0x0x7f8a380b9380

Aug 16 09:56:01:354 [140231923709696] 0 nas: [ndbOracleExecuteInternal]- Error: ndbOracleExecuteInternal                 OCI_ERROR - ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property of an existing object.

                OCIEnv: 0x0x7f8a38079cf0 OCIAuthInfo: 0x0x7f8a380f8fe0 OCISvcCtx: 0x0x7f8a380b9380 

Aug 16 09:56:01:519 [140231923709696] 0 nas: [ndbOracleExecuteInternal]- Error: ndbOracleExecuteInternal                 OCI_ERROR - ORA-38824: A CREATE OR REPLACE command may not change the EDITIONABLE property of an existing object.

Could you please guide me on whether I am missing any permission or parameter in the database?

Regards

[Petr Ketner]

Hi, 

would you mind to share <enrichment-source> section from nas?

The other way to change robot is inactive message we use is this:

1) in NAS/A-O/Scripts create new script - robot_is_inactive.lua

if event then

   -- Robot* msg prefixing
   match = regexp( event.message, "/^Robot.*is inactive.*/")
   
   if match == true and platform_Windows == true and company_INSURANCE == false then
      event.message = "APP: "..event.message   --if you want just to add prefix, do it this way
	  event.message = "APP: "..event.message.."lorem ipsum dolor"   --if you want  to add prefix and postfix as well, do it this way
      event.message = "Lorem ipsum dolor"   --if you want make completely different message, do it this way
   end
   
   return event
end

2) create preprocessing rule that matches this kind of message with filter type - custom - set the section custom script for robot_is_inactive.lua

regards

[Jose Romero]

Thanks for your reply, I will work on this script option in Lua, although I also wanted to know if the database error I get is due to some permissions issue that I am missing.

[Petr Ketner]

Hi Jose,

therefor I have asked you to share <enrichment-sources> section from nas probe, at least the part that is configured for connecting to database.

Regards

Petr

[Jose Romero]

Here are the images

[Petr Ketner]

Hi Jose,

are you able to make this query directly in the DB with same user?

Are you sure that udata.messages is valid udata parameter? I would bet its udata.message, not messages. 

Try to change this and it may help.

Regards

[Christopher Duryea]

We do this also for inactive robots using LUA.  But be careful using LUA scripts, I find if you have an alarm that occurs often from many devices often then LUA script is triggered often and can bring NAS to its knees.  

Waiting for the roadmap to improve scripting performance so we can implement more automation without having to offload to another tool.