Alerts not triggered/sent SBO 9.2.

[Former Member]

Hi all,

I have setup 3 User Alerts, none of them is triggered or sent.

I've checked the following:

1. The SQL Queries do return results
2. The Alerts have a SQL Query attached
3. The Alerts are Active (they have been unticked and reticked)
4. The user who created the alert and query is a superuser
5. The user is signed into SAP
6. The Alerts do not return a NULL value in the first column
7. The Alerts are not based on a query which includes comments such as "/*...--...*/"
8. The SQL queries do not contain an IF statement
9. All alerts have names, and those are excluding special characters such as (*)

SBO VERSION: SAP Business One 9.2 (9.20.003) PL: 00  (64-bit)

Any ideas?

Any help is much appreciated.

Thanks

Ana

[Former Member · Accepted solution]

This is resolved now!

Even though I was updating the settings (connection setting and database) of the Job Service - Mailer in the service manager, the settings were not saved correctly. By updating the setting in the SLD, and started the service from there, it works OK.

It is needed:

- AlertScv user has to be a superuser (or have the appropriate authorizations)

- AlertScv user has to be selected in the Alert

- Job Service - Mailer has to be configured using the link in the SLD (at least in my case)

Thank you all for your help

Regards

Ana

[Former Member]

Hello everyone,

i was faced the same problem after upgrade to 9.2 PL 03

after adjustment of authorisations for AlertSvc (at least for send message and querry generator) the alerts are being triggered again. Altenative you can define the Alert Svc as super user.

Hope this helps.

[Former Member]

Hi Andreas,

AlesrtSvc is a superuser, but I am still not getting the alert. Any other suggestions anyone?

Thanks you all for your responses

[jb_bryant]

I'm having the same issue. The alerts are enabled but never actually go off. I even tried a simple query and it still doesn't work:

SELECT 'TEST' from dummy

[jb_bryant]

We're on 9.2 PL03 for HANA by the way

[kothandaraman_nagarajan]

Please check SAP note,

2154175 - SBO Mailer does not send email after SAP HANA database restarts

[kothandaraman_nagarajan]

Please attach your SQL query to check.

[ankurch]

Hi Ana,

Have you activate log for Alert in ALRTCATDEF

-> Settings -> Configuration -> Write log

Also add the the used for which email configuration is completed  in SU01.

Thanks

[Former Member]

If I am not wrong you are referring to big SAP and not to SBO?

[julie_jamieson2]

Hi Ana,

Mine did not run until I selected the alertsvc user as a recipient in the alert in SAP, have you tried that?

There doesn't seem to be any documentation on this area yet, which makes it difficult

[ankurch]

Ohh I'm sorry, yes you are right,.. sorry for inconvenience!

[Former Member]

Hi Julie, I have selected the alertsvc user as a recipient, and still nothing. Thanks for your message.

[kothandaraman_nagarajan]

Hi,

Please check following,

1. In alert management, AlertSvc is selected.

2. Job service is running and selected correct database.

Thanks

[frank_wang6]

9.2 is using a new service called Job service, make sure it is running.

before 9.2, alert will rely on user's login to trigger, but in 9.2, it is not.

Frank

[Former Member]

Hi Frank,

Many thanks for your response. The service is running and the user AlertSvc selected, and still no luck. Any more ideas?

Regards,

Ana

[frank_wang6]

I thought you have already marked the question answered?

Anyway, if it is still not working, i suggest you upgrade to PL02, which did solve a lot of problems.

Frank

[Former Member]

It's not resolved yet. Thanks Frank