Model / Script works in ArcMap but doesn't run when in Windows Scheduler

PanGIS — Thu, 17 Oct 2019 10:47:18 GMT

Hi everyone,

I' ve created a model that updates a table in PostgreSQL

The model runs perfectly as model and as tool as well.

Exported the Model into python script an it runs in Arc Python window.

I have created also a script that calls the toolbox and model inside and it works when run into Arc Python Window.

When I put it in Windows scheduler the task starts and completes but the table isn't updated meaning that the script doesn't run correctly.

I tried to run the same script in PyScripter and I get this error message:

Message File Name Line Position
Traceback
    <module> C:\Folder\script_startModel.py 15
TableReadings2 C:\Folder\Toolbox.tbx 75
ExecuteError: Failed to execute. Parameters are not valid.
The value does not exist.
ERROR 000732: Output Location: Dataset Database Connections\database_publish.sde does not exist or is not supported
The value does not exist.
ERROR 000732: Output Location: Dataset Database Connections\database_publish.sde does not exist or is not supported
The value does not exist.
ERROR 000732: Input Table: Dataset database.sde.Building_Readings does not exist or is not supported
ERROR 000989: Tool CalculateField cannot use VB expressions for services
ERROR 000989: Tool CalculateField cannot use VB expressions for services
ERROR 000989: Tool CalculateField cannot use VB expressions for services
ERROR 000989: Tool CalculateField cannot use VB expressions for services
Failed to execute (ScriptReadings2).

I tried to run the same script in Windows CMD and I get this error message:

C:\Users\username>C:\python27\Arcgis10.5\python.exe C:\Folder\Script_startModel.py
Traceback (most recent call last):
File "C:\Folder\Script_startModel.py", line 15, in <module>
arcpy.ModelReadings2_Toolbox()
File "C:\Folder\Toolbox.tbx", line 75, in ModelReadings2

arcgisscripting.ExecuteError: Failed to execute. Parameters are not valid.
The value does not exist.
ERROR 000732: Input Table: Dataset database_publish.sde.Building_Readings does not exist or is not supported
Failed to execute (ScriptReadings2).

The main issue seems to be the database which is not recognised.

Any idea?

Thanks

Re: Model / Script works in ArcMap but doesn't run when in Windows Scheduler

CCWeedcontrol — Fri, 18 Oct 2019 18:59:54 GMT

I've ran into this and for me I have to put the full path of the database\featuredataset\featureclass. It might be helpful if you posted your python code.

C:\Users\***\AppData\Roaming\ESRI\Desktop10.6\ArcCatalog\***_***_***.sde\yourfeaturedataset\featureclass

topic Model / Script works in ArcMap but doesn't run when in Windows Scheduler in Python Questions

Model / Script works in ArcMap but doesn't run when in Windows Scheduler

Re: Model / Script works in ArcMap but doesn't run when in Windows Scheduler