Skip to main content
Question

Python Script will not run as Startup Script but runs in IDLE

  • September 13, 2017
  • 2 replies
  • 28 views

Hi All,

I have a python script that runs successfully in IDLE, but when I copy and paste the same script into the startup python script box in my workbench the script fails.

Below is the script:

 

# Import modules

 

import arcpy

 

import arcgisscripting

 

import arceditor

 

arcpy.env.overwriteOutput = True

 

arcpy.env.workspace = "C:\\Users\\GRAUP\\AppData\\Roaming\\ESRI\\Desktop10.3\\ArcCatalog\\Connection to NRGISSQLS03 WWW_GIS USER.sde\\www_gis.GIS_ADMIN.WastewaterDataset"# Local variables:

 

www_gis_GIS_ADMIN_RMoN_San_GravityMain = "C:\\Users\\GRAUP\\AppData\\Roaming\\ESRI\\Desktop10.3\\ArcCatalog\\Connection to NRGISSQLS03 WWW_GIS USER.sde\\\\www_gis.GIS_ADMIN.WastewaterDataset\\\\www_gis.GIS_ADMIN.RMoN_San_GravityMain"

 

RMoN_San_GravityMain_Route_Output = "H:\\\\O.10_Operating_Projects\\\\Linear_Referencing\\\\Reference\\\\Linear Referencing Shannon Working\\\\Linear_Referencing_Working.gdb\\\\RMoN_San_GravityMain_Route_sde_connection" # Process: Create Routes arcpy.CreateRoutes_lr(www_gis_GIS_ADMIN_RMoN_San_GravityMain, "GISOBJID", RMoN_San_GravityMain_Route_Output, "LENGTH", "", "", "UPPER_LEFT", "1", "0", "IGNORE", "INDEX")

 

Below is the error I get when trying to run in start-up in my workbench:

 

Python Exception <ExecuteError>: Failed to execute. Parameters are not valid.

ERROR 000732: Input Line Features: Dataset C:\\Users\\GRAUP\\AppData\\Roaming\\ESRI\\Desktop10.3\\ArcCatalog\\Connection to NRGISSQLS03 WWW_GIS USER.sde\\www_gis.GIS_ADMIN.WastewaterDataset\\www_gis.GIS_ADMIN.RMoN_San_GravityMain does not exist or is not supported

WARNING 000725: Output Route Feature Class: Dataset H:\\O.10_Operating_Projects\\Linear_Referencing\\Reference\\Linear Referencing Shannon Working\\Linear_Referencing_Working.gdb\\RMoN_San_GravityMain_Route_sde_connection already exists.

Failed to execute (CreateRoutes).

Wondering if anyone has experienced this issue before or has ideas to what the cause is.

Thanks.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

bruceharold
Supporter
Forum|alt.badge.img+19
  • Supporter
  • September 13, 2017

It may be the interpreter, is it Python 3? Try raw string:

www_gis_GIS_ADMIN_RMoN_San_GravityMain = r"C:\\Users\\GRAUP\\AppData\\Roaming\\ESRI\\Desktop10.3\\ArcCatalog\\Connection to NRGISSQLS03 WWW_GIS USER.sde\\\\www_gis.GIS_ADMIN.WastewaterDataset\\\\www_gis.GIS_ADMIN.RMoN_San_GravityMain"

"\\U" might look like unicode.


  • Author
  • September 14, 2017

It may be the interpreter, is it Python 3? Try raw string:

www_gis_GIS_ADMIN_RMoN_San_GravityMain = r"C:\\Users\\GRAUP\\AppData\\Roaming\\ESRI\\Desktop10.3\\ArcCatalog\\Connection to NRGISSQLS03 WWW_GIS USER.sde\\\\www_gis.GIS_ADMIN.WastewaterDataset\\\\www_gis.GIS_ADMIN.RMoN_San_GravityMain"

"\\U" might look like unicode.

I have a custom interpreter set up - the one with ESRI so that python can run the geoprocessing tools. I have ArcGIS 10.3.1 so the python interpreter is 2.7

 

Unfortunately raw string did not work, and the same error came up :( Thank you for the suggestion!