L'outil GP Quick Import (Data Interoperability) a échoué après publication sur le serveur (10.81) en tant qu'outil web

Question

Développement d'un script python pour convertir un fichier KML en classe d'entités en utilisant arcpy.interop.QuickImport().Le script fonctionne comme prévu lors de l'exécution dans ArcGIS Pro et Jupyter notebook mais échoue après publication sur le serveur (10.81) en tant qu'outil web avec le message d'erreur suivant. Merci de m'aider à identifier et suggérer des solutions.. Merci d'avance Message d'erreur : Soumis.Exécution...Heure de début : maanantai 6. toukokuuta 2024 12.04.16Heure de début : maanantai 6. toukokuuta 2024 12.04.16D: \arcgisserver\directories\arcgisjobs\qitest_gpserver\j8f5cd54b4eb34e0a8a556eb1653c6d9f\scratch\Klippan.kmlD: \arcgisserver\directories\arcgisjobs\qitest_gpserver\j8f5cd54b4eb34e0a8a556eb1653c6d9f\scratch\scratch.gdbÉchec du script QiTest... Traceback (most recent call last): Fichier "D:\arcgisserver\directories\arcgissystem\arcgisinput\QiTest.GPServer\extracted\cd\glint\qi_test.tbx#QiTest_qitest.py", ligne 16, dans < div > Fichier "d:\arcgis\server\framework untime\arcgis\Resources\arcpy\arcpy\interop.py" , ligne 103 , dans QuickImport < div > raise e < div > Fichier "d:\a d:arcgisserver directories a cgissystem a untime a esources a cpy a cpy i terop.py", line 100, in QuickImport retval = convertArcObjectToPythonObject(gp.QuickImport_interop(*gp_fixargs((Input, Output), True))) File "d:\arcgisserver\directories\arcgisjobs\qitest_gpserver\j8f5cd54b4eb34e0a8a556eb1653c6d9f\scratch\scratch.gdb" Failed script QiTest... Traceback (most recent call last): File "D:\arcgisserver\directories\arcgisjobs\qitest_gpserver\j8f5cd54b4eb34e0a8a556eb1653c6d9f\scratch\Klippan.kml", line 16, in File "d:\arcgisserver\framework untime\arcgis esources\arcpy\interop.py", line 103, in QuickImport raise e File "d:\arcgisserver\framework untime\arcgis esources\arcpy\interop.py", line 100, in QuickImport retval = convertArcObjectToPythonObject(gp.QuickImport_interop(*gp_fixargs((Input, Output), True))) File "d:\arcgisserver\framework untime\arcgis esources\arcpy\geoprocessing_base.py", line 511, in return lambda *args: val(*gp_fixargs(args, True)) arcgisscripting.ExecuteError: ERROR 999999: Quelque chose d'inattendu a causé l'échec de l'outil. Contactez le support technique Esri (http://esriurl.com/support) pour signaler un bug et consultez l'aide sur l'erreur pour des solutions ou contournements potentiels. Échec de l'exécution (QuickImport). Script : # Nom : QuickImport_Ex_01.py # Exigences : Aucune # Description : Importe un fichier KML dans une géodatabase # Importer les modules système import arcpy arcpy.env.overwriteOutput = True # Vérifier l'extension Data Interoperability arcpy.CheckOutExtension("DataInteroperability") # Définir les variables locales kmlPath = arcpy.GetParameterAsText(0) #r"C:\Users\xchebrapp_\Documents\ArcGIS\Projects\Glint\Hult.kml" output_gdb = arcpy.env.scratchGDB arcpy.AddMessage(str(kmlPath)) arcpy.AddMessage(str(output_gdb)) # Exécuter Quick Import res= arcpy.interop.QuickImport(kmlPath, output_gdb) print(res) arcpy.AddMessage(str(res))

TommiTerävä1 · Answer

The root cause seems to be version incompatibility between ArcGIS Pro and the ArcGIS Enterprise environment where the tool is published. The code provided above works without issues in a more recent AE environment.

TommiTerävä1 · Answer

I looked into this and I've narrowed down the problem. I think the parameters somehow get mangled when inputted into the tool by gp_fixargs. Here's a very basic python tool to test this issue: # -*- coding: utf-8 -*- import arcpy import os import traceback from pathlib import Path class Toolbox(object): def __init__(self): self.label = "Toolbox" self.alias = "toolbox" # List of tool classes associated with this toolbox self.tools = [Tool] class Tool(object): def __init__(self): self.label = "Tool" self.description = "" self.canRunInBackground = False def getParameterInfo(self): params = [ arcpy.Parameter( displayName="Input file", name="input_file", direction="Input", parameterType="Required", datatype="DEFile" ) ] return params def isLicensed(self): return True def updateParameters(self, parameters): return def updateMessages(self, parameters): return def execute(self, parameters, messages): arcpy.env.overwriteOutput = True ext_status = arcpy.CheckExtension("DataInteroperability") if ext_status != "Available": arcpy.AddError(f"Data Interoperability status: {ext_status}") else: arcpy.AddMessage("Data interoperability available") arcpy.CheckOutExtension("DataInteroperability") kmlPath = parameters[0].valueAsText arcpy.AddMessage(f"Input file: {kmlPath}") if not os.path.exists(kmlPath): arcpy.AddMessage("Source file doesn't exist") return arcpy.AddMessage("File contents:") with open(kmlPath, 'r') as file: for row in file.readlines(): arcpy.AddMessage(row) arcpy.AddMessage("") output_dir = arcpy.env.scratchFolder if not os.path.exists(output_dir): arcpy.AddMessage("Creating destination folder") Path(output_dir).mkdir(parents=True, exist_ok=True) output_gdb = os.path.join(output_dir, "export.gdb") arcpy.AddMessage(f"Output gdb: {output_gdb}") try: res = arcpy.interop.QuickImport( Input=kmlPath, Output=output_gdb ) arcpy.AddMessage(str(res)) except Exception as e: arcpy.AddMessage(traceback.format_exc()) def postExecute(self, parameters): return And here's a very simple test file to reproduce the error with (test.geojson): { "type": "Feature", "geometry": { "type": "Point", "coordinates": [125.6, 10.1] }, "properties": { "name": "Dinagat Islands" } } Parameters used to publish webtool: Messages when running locally: Data interoperability available Input file: C:\Users\_____\_____\Documents\ArcGIS\Projects\QuickImport est.geojson File contents: { "type": "Feature", "geometry": { "type": "Point", "coordinates": [125.6, 10.1] }, "properties": { "name": "Dinagat Islands" } } Output gdb: C:\Users\_____\_____\Documents\ArcGIS\Projects\QuickImport\scratch\export.gdb C:\Users\_____\_____\Documents\ArcGIS\Projects\QuickImport\scratch\export.gdb Messages when running published as Web Tool: Data interoperability available Input file: D:\arcgisserver\directories\arcgisjobs\quickimporttesttool_gpserver\ja6af2726b46a455296ce7e438a7d2492\scratch est.geojson File contents: { "type": "Feature", "geometry": { "type": "Point", "coordinates": [125.6, 10.1] }, "properties": { "name": "Dinagat Islands" } } Output gdb: D:\arcgisserver\directories\arcgisjobs\quickimporttesttool_gpserver\ja6af2726b46a455296ce7e438a7d2492\scratch\export.gdb Traceback (most recent call last): File "", line 84, in execute File "d:\arcgis\server\framework untime\arcgis\Resources\arcpy\arcpy\interop.py", line 103, in QuickImport raise e File "d:\arcgis\server\framework untime\arcgis\Resources\arcpy\arcpy\interop.py", line 100, in QuickImport retval = convertArcObjectToPythonObject(gp.QuickImport_interop(*gp_fixargs((Input, Output), True))) File "d:\arcgis\server\framework untime\arcgis\Resources\arcpy\arcpy\geoprocessing\_base.py", line 511, in return lambda *args: val(*gp_fixargs(args, True)) arcgisscripting.ExecuteError: ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds. Failed to execute (QuickImport).

bharold · Answer

My guess is Quick Import's input data type is not supported in the geoprocessing framework so you can try making an embedded Spatial ETL tool that accepts a file input.  However a workspace (geodatabase) output is not supported by server side geoprocessing, so you will need to write to a zipped file geodatabase and make its path an output.