Troubleshooting Auto Upload Problems - Revision history

Nic at 00:53, 29 June 2020

2020-06-29T00:53:49Z

← Older revision		Revision as of 19:53, 28 June 2020
Line 34:		Line 34:

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

Jeff: /* Overview */

2019-07-23T04:26:22Z

Overview

← Older revision		Revision as of 23:26, 22 July 2019
Line 4:		Line 4:

	Most problems relating to Auto Upload revolve around your windows environment. This article will provide solutions to ensure the Auto Upload process runs smoothly.		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 ==		== Test the Auto Upload can be run manually ==

Nic at 00:00, 6 July 2018

2018-07-06T00:00:28Z

← Older revision		Revision as of 19:00, 5 July 2018
Line 1:		Line 1:
	== Overview ==		== 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.		[[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.		Most problems relating to Auto Upload revolve around your windows environment. This article will provide solutions to ensure the Auto Upload process runs smoothly.

Nic at 23:46, 5 July 2018

2018-07-05T23:46:43Z

← Older revision		Revision as of 18:46, 5 July 2018
Line 16:		Line 16:

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

	~~== If Excel does not Start ==~~

	~~You can test this by checking the Task Manager. When the schedule task triggers a new Excel process should run the back ground. If you don't see this process then it has not started.~~

	~~It may be because the association between .xls files and Excel is not working~~

	~~Try appending the Excel.exe path to the Scheduled Task > Action > Program/.script: field before the AutoUpload.xls path. Separate the two paths with a space.~~

	~~== If Excel Opens but does not run ==~~

	~~You can test for this by opening Windows Task Manager and monitoring the Excel Process. If it starts but has no CPU usage then its not running.~~

	~~# Ensure macro warnings are not not preventing Excel from Running. Run the auto upload manually and enable macros in this app to run.~~
	~~# The existing user may not have permissions to run scheduled tasks in the back ground. Try creating a new Local User and setting up auto upload in that session~~
	~~# Set the Task to '''Run only when user is logged on'''~~

	== Configure the Auto Upload Scheduled Task to terminate after a set number of hours ==		== Configure the Auto Upload Scheduled Task to terminate after a set number of hours ==

Nic at 23:45, 5 July 2018

2018-07-05T23:45:40Z

← Older revision		Revision as of 18:45, 5 July 2018
Line 12:		Line 12:

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

	== If Excel does not Start ==		== If Excel does not Start ==

Jeff: /* If Excel does not Launch */

2017-03-31T21:28:36Z

If Excel does not Launch

← Older revision		Revision as of 16:28, 31 March 2017
Line 13:		Line 13:
	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]].		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]].

	== If Excel does not ~~Launch~~ ==		== If Excel does not Start ==

	~~[[Add~~ the Excel.exe path to the Action Program/.~~scrip~~: path]]		You can test this by checking the Task Manager. When the schedule task triggers a new Excel process should run the back ground. If you don't see this process then it has not started.

			It may be because the association between .xls files and Excel is not working

			Try appending the Excel.exe path to the Scheduled Task > Action > Program/.script: field before the AutoUpload.xls path. Separate the two paths with a space.

	== If Excel Opens but does not run ==		== If Excel Opens but does not run ==

Jeff: /* If Excel Opens but does not run */

2017-03-31T21:22:14Z

If Excel Opens but does not run

← Older revision		Revision as of 16:22, 31 March 2017
Line 22:		Line 22:

	# Ensure macro warnings are not not preventing Excel from Running. Run the auto upload manually and enable macros in this app to run.		# Ensure macro warnings are not not preventing Excel from Running. Run the auto upload manually and enable macros in this app to run.

	# The existing user may not have permissions to run scheduled tasks in the back ground. Try creating a new Local User and setting up auto upload in that session		# The existing user may not have permissions to run scheduled tasks in the back ground. Try creating a new Local User and setting up auto upload in that session

	# Set the Task to '''Run only when user is logged on'''		# Set the Task to '''Run only when user is logged on'''

Jeff: /* If Excel Opens but does not run */

2017-03-31T21:21:29Z

If Excel Opens but does not run

← Older revision		Revision as of 16:21, 31 March 2017
Line 19:		Line 19:
	== If Excel Opens but does not run ==		== If Excel Opens but does not run ==

	~~Macro' warnings may prevent~~ Excel ~~from Running~~. ~~Run the auto upload manually and disable macros~~		You can test for this by opening Windows Task Manager and monitoring the Excel Process. If it starts but has no CPU usage then its not running.

	The existing user may not have permissions to run scheduled tasks in the back ground. ~~Create~~ a new Local User		# Ensure macro warnings are not not preventing Excel from Running. Run the auto upload manually and enable macros in this app to run.

			# The existing user may not have permissions to run scheduled tasks in the back ground. Try creating a new Local User and setting up auto upload in that session

			# Set the Task to '''Run only when user is logged on'''

	== Configure the Auto Upload Scheduled Task to terminate after a set number of hours ==		== Configure the Auto Upload Scheduled Task to terminate after a set number of hours ==

Jeff: /* If Excel Opens but does not run */

2017-03-31T21:16:47Z

If Excel Opens but does not run

← Older revision		Revision as of 16:16, 31 March 2017
Line 21:		Line 21:
	Macro' warnings may prevent Excel from Running. Run the auto upload manually and disable macros		Macro' warnings may prevent Excel from Running. Run the auto upload manually and disable macros

	The existing user may not have permissions to run. Create a new Local User		The existing user may not have permissions to run scheduled tasks in the back ground. Create a new Local User

	== Configure the Auto Upload Scheduled Task to terminate after a set number of hours ==		== Configure the Auto Upload Scheduled Task to terminate after a set number of hours ==

Jeff: /* If Excel Opens but does not run */

2017-03-31T21:16:22Z

If Excel Opens but does not run

← Older revision		Revision as of 16:16, 31 March 2017
Line 19:		Line 19:
	== If Excel Opens but does not run ==		== If Excel Opens but does not run ==

	~~[[Disable Excels~~ Macro'~~s]]~~		Macro' warnings may prevent Excel from Running. Run the auto upload manually and disable macros
	[[Create a new Local User]]
			The existing user may not have permissions to run. Create a new Local User

	== Configure the Auto Upload Scheduled Task to terminate after a set number of hours ==		== Configure the Auto Upload Scheduled Task to terminate after a set number of hours ==