Troubleshooting Auto Upload Problems
Overview
Auto Upload is a function that runs the Get Data process on a schedule. The main purpose of Auto Upload is to remove the manual running of the Get Data process and to move the processing to a non-productive time such as overnight.
Most problems relating to Auto Upload revolve around your windows environment. This article will provide solutions to ensure the Auto Upload process runs smoothly.
Test the Auto Upload can be run manually
We recommend you test the Auto Upload manually to ensure it is running correctly. For more information, see Test the Auto Upload can be run manually.
Test the Auto Upload Scheduled Task is configured correctly
Once the Auto Upload Scheduled tasks is configured, we recommend you test it. For more information, see Test the Auto Upload Scheduled Task is configured correctly.
Test using the Auto Upload Test file
If the auto upload does not run correctly as a scheduled task, we recommend you test using the Auto Upload Test file. For more information see Test the scheduled task using the Auto Upload Test file.
Configure the Auto Upload Scheduled Task to terminate after a set number of hours
If the Auto Upload task does not finish (for various reasons), windows will schedule it to run when next required. It is recommended to configure the scheduled task to terminate if it runs longer than it should. For more information, see Configure the Auto Upload Scheduled Task to terminate after a set number of hours.
Configure required folders for Auto Upload and Scheduled Tasks
In order for newer versions of windows to run excel spreadsheets as a scheduled task, see Configure required folders for Auto Upload and Scheduled Tasks.
Configure DCOM settings for Auto Upload and Scheduled Tasks
In order for newer versions of windows to run excel spreadsheets as a scheduled task, the related DCOM components must be created correctly. For more information, see Configure DCOM settings for Auto Upload and Scheduled Tasks.
Create user to run the Auto Upload Scheduled Tasks
On some machines, creating a new user with the correct administrative rights is the only way to get the auto upload to work. See Create user to run the Auto Upload Scheduled Tasks.