CEN-advoco-infor-eam-training-online-log
How Training Works
Infor EAM Training Courses
Pricing
Sign Up
Member Login
  1. Connector Community
  2. Ask the EAM Community
  3. Difference in Alert Begin time and database record timestamp
Search
caroline.mcmanus
Dec 12, 2019

Difference in Alert Begin time and database record timestamp

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?

ALERT 10029
.docx
Download DOCX • 14KB

The alert Before SQL is attached.

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
Login to the Connect Education Network

POWERED BY

No-Drop Shadow (RGB-Digital).png

LEARN MORE

How Training Works
Infor EAM Training Courses
Pricing

SIGN UP

Start Your Free Trial
How to Sign Up
Enter Token Code

CONTACT

ADDITIONAL RESOURCES

Contact Advoco
Connect - Annual User Conference
Cancel
Advoco
Testimonials
FAQ