cancel
Showing results for 
Search instead for 
Did you mean: 

Message Alerts not appearing in SAP B1 9.3

former_member622276
Discoverer
0 Kudos

Dear Experts,

I have some questions on alert management.

We are running SAP Business One 9.3 (9.30.150) PL: 05 (32-bit) and we have number of Query Alerts.

If you run the queries they produce the expected data. However, If you attached the query to an Alert the alert does not appear..

This is query which we created:

SELECT T0.DOCNUM AS 'SO No',T0.DOCDATE AS 'SO Date', T0.CARDCODE AS 'Customer Code',T0.CARDNAME AS 'Customer Name' FROM ORDR T0 WHERE CONVERT(VARCHAR,T0.CREATEDATE,103) = CONVERT(VARCHAR,GETDATE(), 103)

We've checked the following already:

  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 (*)

Does any one have any idea as to why the Alerts are not appearing?

Looking forward to your responses.

Best regards

Ha Vu

Accepted Solutions (0)

Answers (3)

Answers (3)

Abdul
Active Contributor
0 Kudos

Please check either one user is able to send message in business one to other user ?

SAP B1 messaging service is running in Windows service, user is SLD for alerts should be correctly spelled and same as in B1 like AlertSvc and also check this user is super user and not locked in SAP B1

former_member225732
Contributor
0 Kudos

Dear ha vu,

1. Please check you have activated Job Services as explained by Hakan Ucar.

2. Also please check you tick mark on "Display Inbox When New Message Arrives" in General setting "Services" tab or in per user if it is user define setting.

Hope this will help you and revert back for any issue.

Best Regards,

Sandesh Shinde

former_member595093
Participant
0 Kudos

Hi havt ,

Pls check SLD, Is Alert Service running?

former_member622276
Discoverer
0 Kudos

Hi Hakan Ucar,

Message Alerts work now normally.

Many thanks for your supporting!

hakan_ucar_90