Extract Data Load Errors
Use the Extract Data Load Errors scheduled process to extract error messages from failed records when loading CSV files with the Load Planning Data from Files scheduled process.
The process is applicable to these products:
- Supply Planning
- Demand and Supply Planning
- Demand Planning
- Replenishment Planning
- Global Order Promising
- Backlog Management
When to Use
Use the process when you want to extract error messages from failed records when loading CSV files with the Load Planning Data from Files scheduled process.
The Load Planning Data from Files scheduled process status will display either a warning or an error, which indicates that you must run the Extract Data Load Errors scheduled process to extract messages to review.
Privileges Required
- Perform Order Orchestration and Planning Data Collection (MSP_PERFORM_ORDER_ORCHESTRATION_AND_PLANNING_DATA_COLLECTION_PRIV)
Specifications
Review these specifications before setting up this scheduled process:
Specification | Description |
Job Type | Ad hoc job, but can be scheduled based on requirements. |
Frequency | When required, on an as-needed basis. |
Time of Day | After work hours is preferred. It's recommended that you run the job after the Load Planning Data from Files scheduled process finishes. |
Duration | Typically, a few minutes. However, the time might vary across processes based on data and other conditions. |
Compatibility | There should be only one instance of the job running at any one time for a specific collection cycle ID. |
Parameters
Parameter | Optional or Required | Description | Parameter Value | Special Combinations Required | Notes |
Collection Cycle ID | Required | The refresh number from the load-entity log file of any entity’s collection during the Load Planning Data from Files scheduled process. |
User-entered value for refresh number. |
None | The refresh number is available in the load-entity log file, which ends in a warning or error. You can download log file from the Scheduled Processes work area. |
Troubleshooting Information
- You can view the status of the Extract Data Load Errors process in the Scheduled Processes work area.
- The validation errors and warning messages that prevented the Extract Data Load Errors from completing display in the error log.
- After you submit the scheduled process, you can perform any of these tasks in the
Scheduled Processes work area:
- Resubmit it
- Put it on hold
- Cancel the process
- Release the process
- For a long-running Extract Data Load Errors scheduled process that is not finishing and appears to be stuck, click the Cancel Process button and then resubmit the job.
- If the job fails:
- Review the error messages in the log file.
- If the reason for the failure isn’t clear from the logs, review the diagnostic logs and contact product support for more help.