View source for 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.

Follow the steps maticulously as its important none of them a missed in the process in order for it to work

== 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]].

== Configure SQL Server data warehouses to not 'Use Trusted Connection' ==

With SQL Server, using 'Use Trusted Connection' can be problematic when  running the auto upload via the scheduled task as the user may be impersonated. See [[Configuring Data Warehouse to not use trusted connection when running task via auto upload]].

== Related Topics ==

* [[Auto Upload]]
* [[Troubleshooting]]

[[Category:Troubleshooting]]