Quick Import（Data Interoperability）GPツールがサーバー（10.81）でWebツールとして公開後に失敗しました

Question

Pythonスクリプトを開発し、arcpy.interop.QuickImport()<\/I>を使用してKMLファイルをフィーチャクラスに変換しました。<\/DIV>このスクリプトはArcGIS ProおよびJupyterノートブックで実行すると期待通りに動作しますが、サーバー（10.81）でWebツールとして公開後に以下のエラーメッセージと共に失敗します。<\/DIV> <\/DIV>問題の特定と解決策の提案をお願いいたします。よろしくお願いします。<\/DIV> <\/DIV>エラーメッセージ:<\/STRONG><\/DIV> <\/DIV>送信済み。<\/DIV>実行中...<\/DIV>開始時間: maanantai <\/SPAN>6<\/SPAN>. toukokuuta <\/SPAN>2024<\/SPAN> 12.04<\/SPAN>.<\/SPAN>16<\/SPAN><\/DIV>開始時間: maanantai <\/SPAN>6<\/SPAN>. toukokuuta <\/SPAN>2024<\/SPAN> 12.04<\/SPAN>.<\/SPAN>16<\/SPAN><\/DIV>D: \arcgisserver\directories\arcgisjobs\qitest_gpserver\j<\/SPAN>8<\/SPAN>f<\/SPAN>5<\/SPAN>cd<\/SPAN>54<\/SPAN>b<\/SPAN>4<\/SPAN>eb<\/SPAN>34e0<\/SPAN>a<\/SPAN>8<\/SPAN>a<\/SPAN>556<\/SPAN>eb<\/SPAN>1653<\/SPAN>c<\/SPAN>6<\/SPAN>d<\/SPAN>9<\/SPAN>f\scratch\Klippan.kml<\/SPAN><\/DIV>D: \arcgisserver\directories\arcgisjobs\qitest_gpserver\j<\/SPAN>8<\/SPAN>f<\/SPAN>5<\/SPAN>cd<\/SPAN>54<\/SPAN>b<\/Span>4eb34e0a8a556eb1653c6d9f\scratch\scratch.gdb スクリプトQiTestが失敗しました... トレースバック（最新の呼び出しが最後）：ファイル "D:\arcgisserver\directories\arcgisjobs\qitest_gpserver\extracted\cd\glint\qi_test.tbx#QiTest_qitest.py"、16行目、モジュール内ファイル "d:\arcgis\server\framework\runtime\arcgis\Resources\arcpy\arcpy\interop.py"、103行目、QuickImport内例外を発生させるファイル "d:\arcgis\server\framework\runtime\arcgis\Resources\arcpy\arcpy\interop.py"、100行目、QuickImport内 retval = convertArcObjectToPythonObject(gp.QuickImport_interop(*gp_fixargs((Input, Output), True))) ファイル "d:\arcgis\server\framework\runtime\arcgis\Resources\arcpy\arcpy\geoprocessing_base.py"、511行目、内 return lambda *args: val(*gp_fixargs(args, True)) arcgisscripting.ExecuteError: ERROR 999999: 予期しない原因でツールが失敗しました。Esriテクニカルサポート(http://esriurl.com/support)にバグ報告を行い、エラーのヘルプを参照して解決策または回避策を確認してください。 (QuickImport)の実行に失敗しました。スクリプト: # 名前: QuickImport_Ex_01.py # 要件: なし # 説明: KMLファイルをジオデータベースにインポートする # システムモジュールのインポート import arcpy arcpy.env.overwriteOutput = True # Data Interoperability Extensionのチェックアウト arcpy.CheckOutExtension("DataInteroperability") # ローカル変数の設定 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)) # 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.