Batch Processes and Integrator Load/Extracts 5-37
Batch Processes
See the section on “Working with Scheduler" of the User Guide
Working with Tasks
The VCC Scheduler is preloaded with the tasks (commands) required to facilitate basic VCC processing needs. Ordinarily, you do not have to add new tasks for any VCC processing requirements. You can, however, add any other system task (command) and schedule it for processing using the scheduler.
See Scheduler Task Descriptions table, it gives a brief description of each preloaded Task.
5 5 Manual Stream Changes
Note: Superadmin will see list of Tasks associated with
company-assigned Modules; Superuser and ServerAdmin will see a list of Tasks associated with Modules licensed to the Hub.
Table 5–18 Scheduler Task Descriptions Scheduler Tasks Descriptions 1. Complete
Exception Criteria Creation
- Creates a new aggregate stream, or links to an existing aggregate stream.
- Changes the aggregate exception criteria ‘Status’ from “Pending” to
“Active”.
2. Extract Supply Blocked Dates
- Extracts Supply Blocked Dates from the VCC Database.
- Extracts data to: Syncra\Integrator\Exports\Extraction (Scheduler machine).
3. Extract UOMs - Extracts the current Unit-of-Measure (UOM) options from the VCC database.
- Extracts data to: Syncra\Integrator\Exports\Extraction (Scheduler machine).
- (Or, to directory path configured in the VCC Integrator UI).
4. Extract Users - Extracts the current Users from the VCC database.
- Extracts data to: Syncra\Integrator\Exports\Extraction (Scheduler machine).
- (Or, to directory path configured in the VCC Integrator UI).
5. Process Aggregate Actions
- Processes “In-Process” and “Resolution” actions for all leaf and aggregate exceptions.
Table 5–17 (Cont.) Extractor Jobs Table
Job Screen
Display Job Type Lock Type
Job/Lock Trigger: Click “Run” button on Integrator - Extractor after selecting control file for...
6. Process Aggregate Exceptions
- Identifies aggregate data revisions.
- Identifies and re-synchs aggregate criteria with "any" folders marked 'dirty' by hierarchy changes.
- Obsoletes any exceptions triggered by items no longer included in folder marked 'dirty' by hierarchy changes.
- Identifies any exceptions resulting from the aggregate stream revisions.
- Identifies any group exceptions.
- Processes “Initial” actions for all new Aggregate exceptions triggered.
7. Process Exception Alerts
- Sends e-mails to supplied e-mail addresses in Exceptions' “Send Alert Requests” list.
- Run this task after processing exceptions through these tasks:
•Process Leaf Exceptions
• Process Aggregate Exceptions
• Process Leaf Actions; Process Aggregate Actions 8. Process Extract
Requests
- When an extract request has been created in the Extract UI for any/all of the options:
• Extracts requested data from the Syncra Database.
• Extracts data to: Syncra\Integrator\Exports\Retrieval (Scheduler machine).
• (Or, to the 'File Path' / 'File URL' as configured in Syncra Configuration-Client screen.)
- If the data_retrieval.log file (generated in Syncra_
Home/integrator/logs directory) contains errors like
“FileNotFound” or “NoSuchFileOrDirectory”, it could mean the following:
1. Either the user who is processing the Extract request does not have permission to the Directroy path where the system (integrator) is trying to save the extracted file.
2. The Directory Path where the system is trying to save the extracted file does not exist.
9. Process Leaf Actions
- Processes “In-Process” and “Resolution” actions for all leaf exceptions.
10. Process Leaf Exceptions
- Identifies leaf stream data revisions.
- Identifies and re-synchs the "any" folders marked 'dirty' by hierarchy changes.
- Obsoletes any exceptions triggered by items no longer included in folder marked 'dirty' by hierarchy changes.
- Identifies any exceptions resulting from the leaf stream revisions.
- Tags any aggregates affected by the leaf stream revisions.
- Identifies any group exceptions.
- Processes “Initial” actions for all new Leaf exceptions triggered.
11. Purge Jobs Monitor - Purges all Job Monitor items (included in purge requests for the hub) in the Purge Request screen at the time this task event is executed.
- Purges these items up to the “Retain 'N” number” (initial default = 50k) specified in the edit screen for the Purge Jobs Monitor option in the Purge Data screen.
Table 5–18 (Cont.) Scheduler Task Descriptions Scheduler Tasks Descriptions
Batch Processes
Batch Processes and Integrator Load/Extracts 5-39 12. Purge User
Activity
- Purges all current connections (included in purge requests) in the Purge Request screen at the time this task is executed.
13. Recalculate Aggregates
- Identifies leaf stream data revisions.
- Identifies and recalculates aggregates created on folders that were affected by a hierarchy change.
- Tags any aggregates affected by the leaf stream revisions.
- Updates the tagged aggregates. Identifies any group exceptions.
14. Recalculate Disaggregation Factors
- Recalculates the Profile factors set in Disagg. Profiles.
- Computes the proportion to distribute aggregate values among the aggregates' leaves.
15. Recalculate Metrics -Recalculates all Metrics that are check marked in the Run Override column in the Metrics UI at the time this task event is executed.
- Also recalculates whenever the Repeat Frequency time has been reached.
16. Report Usage Whenever this event is executed:
- Computes the current collaboration usage status and sends it to Monitor-Usage.
- Sends copy of usage status to any E-mail addresses supplied in the Configuration-Billing screen when its “Send E-mail” check box is checked.
17. Roll Criteria -Roll the “Start Date” forward, and “obsolete” the exception (triggered by the first period) for criteria defined with rolling dates.
-Roll Criteria defined using Rolling Period Overlays.
-Roll Criteria defined using fixed Period Overlays with Rolling Dates.
18. Run And Send Reports
- Processes 'flagged' reports (in each format type defined) as created in the Reports UI. (See 'Run Reports' description on this page.) - For each report where Destination = E-mail, Sends report (in defined formats) to respective E-mail address supplied.
- For each report where Destination = FTP, Sends report to the IPAddress/name with Username/Password.
(While processing reports, if “java.lang.OutOfMemoryError” occurs, the java.runtime.params parameter in the ServerCommon.properties file should be modified to increase the JVM size. This file is found in
Syncra_Home/lib directory on the server machine.) 19. Run Demand &
Lift Factor Batch Requests
- Creates a Demand forecast for each Demand Request created since last time this task event was executed.
- Calculates Lift Factors for each Lift Factor request created since last time this task event was executed.
20. Run Demand Batch Requests
- Creates a Demand forecast for each Demand Request created since last time this task event was executed.
21. Run Lift Factor Batch Requests
- Calculates Lift Factors for each Lift Factor request created since last time this task event was executed.
Table 5–18 (Cont.) Scheduler Task Descriptions Scheduler Tasks Descriptions
22. Run Reports - Processes all reports that had been 'flagged' at the time this task event is executed.
- Reports will be flagged in one of two ways:
- The 'Run' schedule defined in the Report UI has been reached.
- The “Override Run Schedule check box for a Report has been checked in the Report-List screen.
23. Run Safety Stock Batch Requests
- Calculates Safety Stock for each Safety Stock Calc Request created since last time this task event was executed.
24. Run Supply &
Safety Stock Batch Requests
- Creates a Supply Plan for each Supply Request created since last time this task event was executed.
- Calculates Safety Stock for each Safety Stock Calc Request created since last time this task event was executed.
- Also runs if Run Override is performed on a batch job, or if the Repeat Frequency time has been reached.
25. Run Supply Batch Requests
- Creates a Supply Plan for each Supply Request created since last time this task event was executed.
- Also runs if Run Override is performed on a batch job, or if the Repeat Frequency time has been reached.
26. Send Promotion Alerts
For any E-mail addresses/notification offsets supplied within any Promotion:
- Sends E-mail notification about Status changes to Promotion.
- Sends E-mail notification about Milestone Due Date changes to Promotion.
27. Send Reports For each report where the Report's Destination = E-mail - Sends report (in defined formats) to respective E-mail address supplied.
- For each report where Destination = Extract
- Extracts data to: Syncra\Integrator\Exports\Retrieval (Scheduler machine).
- (Or, to directory path configured in the Report UI.) 28. Update Promotions - Performs system updates to Promotion Status.
- Updates Condition based on Milestone Due Dates.
29. Process Events Totals
- Process the computation of Totals for Events and Promotions.
Table 5–18 (Cont.) Scheduler Task Descriptions Scheduler Tasks Descriptions
Integrator Data Loader and Data Extractor Field Definitions A-1