Alerts Management Issue

[Former Member]

SBO Version 9.1 PL08

Dear Forum,

I have a strange issue with one of our alerts. I have two users who are alerted when draft sales orders need to be processed. When one user drills down into these orders from the alerts screen then adds them to the system, the other user's alert which had contained the list of draft sales orders to process has returned a blank screen. The only way this alert list gets re-populated is if they log out of SAP and log back in.

We have tried creating a new alert specific to one user and placed this on a slightly different time sequence to no avail. As we have been unable to recreate this issue on a virtual mahine logged into SAP as one of the users, we have performed a complete uninstall/reinstall of the SAP B1 client, client agent and DI API - this however has not had any impact.

This is a frustrating issue it has to be said so any help would be greatly appreciated.

Thanks,

Sarah

[frank_wang6]

post ur query here, and if possible put no read lock on ur query

http://stackoverflow.com/questions/210171/effect-of-nolock-hint-in-select-statements

[Former Member]

Hello Frank,

Here is the query behind this alert:

SELECT T0.DocEntry, CASE WHEN DateDiff(d, T0.DocDueDate, GetDate()) > 0 THEN 'Overdue' ELSE '' END AS Status, T0.DocDate, T0.DocDueDate, T0.CardCode, T0.CardName, T0.NumAtCard

FROM   ODRF T0

       INNER JOIN OCRD T1

         ON T0.CardCode = T1.CardCode

       INNER JOIN OCRG T2

         ON T1.GroupCode = T2.GroupCode

WHERE  T0.CANCELED = 'N'

       AND T0.DocStatus = 'O'

       AND T0.ObjType = 17

       AND T0.U_INTSenderID <> ''

Many Thanks,

Sarah