salvaleonrp / di

1 stars 0 forks source link

GEODATABASE_FILE format writer fails - in QI and Spatial ETL - when the source is from a CSV read from a URL #3

Open salvaleonrp opened 2 years ago

salvaleonrp commented 2 years ago

Bruce found a regression on CSV files read from a URL. Can repro Bruce case in my environment too? I tested this with the FILEGDB writer and the error is not reproducible using the FGDB API format. In DI 2.9 we allow CSV read from a URL to be written in an FGDB using the File GDB ArcObjects writer format.

In DI 3.0 the translation fails with a Tool Execution error message in Quick Tools.

In the FME Workspace (Using a Spatial ETL tool), running the translation in the Workbench app, the translation fails onthe first point feature entering the writer,

and returns Error running translation.

Environment: No FME Desktop, Pro 30 and DI Pro 3.0 (Final builds) Repro steps: Option 1 (Using Workbench) Download the attached FMWT and run the translation using DI Workbench app.

Option 2. (Using Pro)

  1. Open a Pro project and launch Quick Import

  2. Configure source using the following input parameters: CSV Reader format: Dataset: https://data.sfgov.org/api/views/pyih-qa8i/rows.csv?accessType=DOWNLOAD Following screenshot below, use a custom schema generation: All rows, specific types and note the date scan on %m/%d/%Y %T %p

  3. Exit off the Input dialog and make sure that the output geodatabase is configured.

  4. Run the Quick Import tool

  5. Result: Tool returns with the error Failed to execute (QuickImport).

Reference: https://devtopia.esri.com/ArcGISPro/data-interop/issues/345

salvaleonrp commented 2 years ago

Hi Renato and Bruce

Nur’s duplicated the issue with Pro 3.0 and we both confirmed that it’s a regression against Pro 2.9. Nur’s gone a step further and demonstrated the issue also affects FME 2022.x, when running with Pro 3.0. Nur’s created FMEENGINE-73958 to track it and the next step will be for the CMD Team to debug the issue.

We will send an update as soon as we know more.

Thanks Fil