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