Troubleshooting Auto Upload Problems

From ExcelReportLink Wiki
Jump to navigation Jump to search

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.

Related Topics