advoco-connect-education-network-logo-wh
How Training Works
Infor EAM Training Courses
Pricing
Sign Up
Member Login
To see this working, head to your live site.
  • Categories
  • All Posts
  • My Posts
caroline.mcmanus
Dec 12, 2019

Difference in Alert Begin time and database record timestamp

in Ask the EAM Community

I ran an Alert to update 168 records and then ran a query in the Advanced Report Studio to see if the data was updated correctly. There appeared to be a delay of 8 minutes from when the Alert began to when the database record was actually updated. This is the method used by the vendor whom deployed the software and one I have also used to make other data corrections. I've not noticed this with the previous alerts. Can you help me understand why there is a delay and how long I should wait before checking data?

The alert Before SQL is attached.

1 comment
0
Michele Page
Dec 16, 2019

After looking at the SQL that you are running you are updating some really large tables r5events, r5translines and r5propertyvalues Also the SQL statements where clause for r5propertyvalues does not limit the data to the entity 'EVNT' which means it will not use the index to help it run more efficiently Not knowing the Business rules that are in place or the size of the tables this could affect the cost (time it takes) to run the data through the alert. Hope this helps.

0