Python script with user input options not working in geoprocessing service

JayakumarPD

Hi,  we are using arcgis 10.4 and server also same.

We have created a arcpy script with From_date, To_date options with additional two parameters for user to enter.  In local machine and in server machine it is running, when we run in arcpy window.

But when it is published as service, it is taking time and with out any error it publishes.

when we run it with parameter, it shows message submitted...executing then it fails, giving the error ESRI type error, with out any time lag.

Is it possible to debug this gp service while running, how to put the checks to know where I am failing.

Kindly suggest. 

 

 

Anonymous User

So, I see where you are getting the dates, but I do not see you use them anywhere in your code.  Are you using them in your sql query? Have you tried with a default value from the script and not from the geoprocessing service input?

# sets a default if the parameter comes back empty or None
stdate_param = arcpy.GetParameterAsText(1)
if stdate_param == '#' or not stdate_param:
    stdate_param = '2020-05-01'

 and here, you are concatenating the strings together

query1 = "some sql query for mandatory inputs"
    ###################################################
      ifelse condition lader for optional user inputs
    ###################################################
    if sectioncode_param != '':
        query1 = query1 + "and sectionCode = '"+sectioncode_param+"'"

 will make your query1 end up like:

"some sql query for mandatory inputs and sectionCode = '"+sectioncode_param+"'"

Unless you took it out to post on the forum since you mentioned that it works as a script...

Last thing I can think of as is, can the server you have this process on use the myDB connection (username/password, SSO, etc)- i.e., its not tied to your login so it only works when you are logged in?