GP service does not work

Question

Hi all

I would like to make a gp tool that return a layer that is a join between a layer and a table Below is a sample of one of my tries in python.

The output parameter is define as derived

The tool run in desktop and published but give error in server.

I do not want the user to give output name so I must define the output as derived.

Should I write my output to %scratchworkspace%?

Do I have to create a real feature class?

What is the right way to do it?

Thanks

Mody

import arcpy

tableName = arcpy.GetParameterAsText(0)

layerName = arcpy.GetParameterAsText(1)

# Local variables:

dbPath = r"C:	mp\Mody.gdb"

local_table = os.path.join(dbPath ,tableName)

local_layer = os.path.join(dbPath ,layerName)

featureClassSelect = "Year = 2004"

arcpy.MakeFeatureLayer_management(local_layer,"t1",featureClassSelect)

arcpy.AddJoin_management("t1", "ID", local_table, "ID")

arcpy.CopyFeatures_management("t1",r"outFCPersistent")

arcpy.Delete_management("t1")

arcpy.SetParameterAsText(2,r"outFCPersistent")

mody_buchbinder · Answer

Hi

I found that using arcpy.env.scratchGDB  is much better then the %scratchworkspace% that I use to use.

It is not replaced by anything when the tool is published.

Using SetParameter when your return value is not text might help too

Thanks all

JonMorris2 · Answer

Oh, and if you are returning an actual feature class, you'll need to use SetParameter for the outputs, not SetParameterAsText. I think it should work with just the feature class name as in your example.

JonMorris2 · Answer

I have a GP service that does a similar thing with rasters, but I think the principle is the same. When saving, I include the full path, e.g.

arcpy.CopyFeatures_management("t1", arcpy.env.scratchGDB + r"\outFCPersistent")

Or, even better, if you have imported the os module,

arcpy.CopyFeatures_management("t1", os.path.join(arcpy.env.scratchGDB, "outFCPersistent"))

Be careful with the scratch workspace, as the behaviour is different between desktop and server. On desktop, you must set the scratch workspace, but on server it is automatically created for each job. Trying to set it actually clears the value and causes a lot of problems.