nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

GeoProcessing tool returning Table to Excel error: <empty>

JustinGleeson1

I have a GeoProcessing tool that develops a Census profile based on a user defined study area - the final output using Table to Excel.

The model operates perfectly in ArcGIS and produces the output that i require. It also publishes to Server without any errors or warnings. However, when I run the tool on ArcGIS Server I get an error saying that the .xls is <empty>.

Any ideas what could be happening here?

Image below of model and then error when I run the model

Thanks

Justin

Najděte více příspěvků označených jako

Accepted answers

All comments

DanPatterson_Retired

Do you want to move this to https://community.esri.com/community/gis/enterprise-gis/arcgis-for-server?sr=search&searchId=f1521c54-217b-4b2f-be2a-6b0aa9bb6fe8&searchIndex=0‌ Justin? When you enter the server realm, you have a whole different set of issues to content with. Or use the Share option at least.

JonathanQuinn

Do you want the user running the GP service to be able to download the .xls file? What is the output parameter file type? Can you try to set it to File if it isn't and republish the service? Can you also provide a screenshot of the error, or the final JSON response when monitoring the job status using Fiddler or the Dev tools?

JustinGleeson1

Hi Jonathan,

Yes, I want to be able to download an Excel file. This is set to 'file' so no problem there.

I have had a look at the logs on Server Manager and it seems that the problem may be with the parameter that I am taking from the DataPrep python script tool. The final table that I need to link to Table to Excel (essentially GeoProfile, the output parameter from the DataPrep script) seems to be inaccessible when I run on Server.

This is the error log that I get on Server Manager:

Error executing tool. Model2 Job ID: j91533738840043b48bf730482226e32e : ERROR 000732: Input Table: Dataset c:\arcgisserver\directories\arcgisjobs\geoprocessing_dev\airogeoprofile_roi_gpserver\j91533738840043b48bf730482226e32e\scratch\scratch.gdb\GeoProfile does not exist or is not supported Failed to execute (Table To Excel). Failed to execute (Model2). Failed to execute (GeoProfile_RoI_2).

This is a snippet of the last code in the script tool. There are a number of different things happening here such as joining other tables, deleting fields etc. The final table, in the order that I need is then called GeoProfile. I then tried to set this as the output parameter in the script tool so I can connect it to the Table to Excel tool within the main model.

arcpy.JoinField_management("ThemesIndicators_1", "IndCode", "PopSummaryS", "Indicators", ["IndCode","Census2011"])
arcpy.JoinField_management("ThemesIndicators_1", "Indicator", "ThemesIndicators_Comps_1", "Indicator", "State;Carlow;DCC;SDCC;Fingal;DLR;Kildare;Kilkenny;Laois;Longford;Louth;Meath;Offaly;Westmeath;Wexford;Wicklow;Clare;Cork_ City;Cork_Co;Kerry;Limerick;Tipperary;Waterford;Galway_City;Galway_Co;Leitrim;Mayo;Roscommon;Sligo;Cavan;Donegal;Monaghan")
arcpy.DeleteField_management("ThemesIndicators_1", ["IndCode"])
arcpy.Copy_management("ThemesIndicators_1", "GeoProfile")
arcpy.SetParameterAsText(0, "GeoProfile")

except:

pass

You may notice something incorrect here

Thanks for your help

Justin

JonathanQuinn

So "Geoprofile" is the Excel table?

c:\arcgisserver\directories\arcgisjobs\geoprocessing_dev\airogeoprofile_roi_gpserver\j91533738840043b48bf730482226e32e\scratch\scratch.gdb\GeoProfile

It's trying to write a to the scratch geodatabase, which won't work. I suggest you re-write the output location of the Excel file using the scratch folder:

Eg.

outTable = os.path.join(arcpy.env.scratchFolder,"GeoProfile.xls")

That way, you ensure the Excel table will be written to a folder.

JustinGleeson1

Hi Jonathan,

No, not quite.

GeoProfile is the final table that I want to export to an Excel file. GeoProfile is set as an output parameter in the script and I then connect GeoProfile to the Table to Excel tool in the main model. It seems that when operating on Server the Table to Excel tool is not finding 'GeoProfile' and then can't export the final Excel file.

Thanks

Justin

JustinGleeson1

Hi Jonathan,

Thanks for your comments on this! I've tried your suggestions but can't seem to get this to work.

My script tool makes a series of adjustments to "ThemesIndicators_1" with the last bit being DeleteField. At this point my table is fully processed and ready to be exported to excel in the way that I want it (if possible). I guess what I want to do is save ThemesIndicators_1 as ThemesIndicators_2 and make this available as an output parameter in my main model so I can proceed with the Table to Excel function.

This is the last part of my script:

arcpy.DeleteField_management("ThemesIndicators_1", ["IndCode"])
OutTable = os.path.join(arcpy.env.scratchGDB,"ThemesIndicators_2")
arcpy.CopyFeatures_management(ThemesIndicators_1, OutTable)
arcpy.SetParameterAsText(0, "ThemesIndicators_2")

After many different attempts I still can't get this to run on the server as ThemesIndicators_2 can't be found in the scratch gdb for it to work. Error here:

c:\arcgisserver\directories\arcgisjobs\geoprocessing_dev\airogeoprofile_roi_gpserver\j225cda15bd37482c85f1f67aaddb3270\scratch\scratch.gdb\ThemeIndicators_2 does not exist or is not supported Failed to execute (Table To Excel). Failed to execute (Model2). Failed to execute (GeoProfile_RoI_2).

JonathanQuinn

Hm, the first thing I would try is using SetParameter instead of SetParameterAsText, (you're not really returning text after all, you'll be returning a feature class). Make sure the output parameter type is a feature class as well. Then, try to update the arcpy.SetParameter() line to return the OutTable variable instead of the name of the output data:

That way, you're making sure that the output of the script is pointing to the path to the data you're looking to return.

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.