Overview
AGR automatically pulls new data from your ERP once a day and runs a AGR logic calculation following the refreshed data.
Data refresh allows you to:
monitor the data refresh between AGR and your ERP
refresh data outside of the regularly scheduled time
You can find the Data Refresh by selecting the cogwheel > Data Management > Data refresh. The feature is only visible to Admin users.
We recommend not making other changes in the system while the data refresh job is running.
Refresh the data in AGR
To refresh the data in AGR during the day,
find the data refresh
click the Run button to update your data.
Data refresh Dashboard
The Data refresh dashboard is divided into several areas, each described below.
Scheduled
Displays the scheduled time for the data refresh in GMT.
Average last 7 days - Duration
The average duration of data refresh processes over the past seven days. This helps users understand the typical time required for a refresh and identify any deviations from the norm.
Average last 7 days - In queue
Displays the average time data refresh processes spent in the queue over the past seven days. This metric helps users understand delays before the actual data refresh begins.
History
A graphical representation and a detailed table of past data refresh activities, including start and end times, duration, and the user who initiated the refresh.
Graph
Displays run time and average run time over the runs shown in the table. The table by default displays the last 10 runs. Press the Load more button to load older runs.
Table
Lists historical data refreshes with columns for:
Run number (#) - Automatically assigned by AGR
Coloured dots - Status of the run
Blue = refresh running
Red = refresh failed
Yellow = refresh needs attention
Green = refresh successful
Black = refresh cancelled
Start Time - When the data refresh started
End Time - When the data refresh ended
Duration - How long the refresh took
Started by - Who initiated the request
Queue - How long before the data refresh request was run. Scheduled jobs go into a queue before running.
Failed refresh
It is possible that your data refresh request will fail, indicated by the red dot next to the run number (#). To find out more about why the request failed, navigate to the Execution list.
Click on the Execution list (double bars).
Click on Show More to open the complete list of actions.
A complete list of pending or recently failed user actions will appear.
Click on the user action you wish to review.
Click on the "i" button in the upper right corner of the toolbar.
Review the action in the side bar that opens.
Contact your customer success manager if there is an error (red) or delay (yellow) shown in the History table status indicator.