Skip to Content
avatar image
Former Member

Alerts Management Issue

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 03, 2015 at 04:33 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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