topic Unable to read Sqlite non-spatial with Data Interoperability in CAD/GIS Data Integration Questions

Unable to read Sqlite non-spatial with Data Interoperability

SeanGrant1 — Sat, 05 Oct 2019 06:30:58 GMT

How come the Sqlite non-spatial reader in Data Interop requires a database connection that doesn't let you specify sqllite non-spatial? If you choose the only sqlite option (spatial) , the connection remains red and doesnt let you read data.

Steps to repro

Add a new reader
Choose sqlite non-spatial
Select a database
Click Parameters (since you have to because it is red)
In the database dropdown, choose the only Sqlite option (Sqlite Spatial)
Give it a name and specify database

If you test it will say it isn't licensed. I do not see any way sqlite non spatial db can be read

ArcGIS Pro 2.4.1

Re: Unable to read Sqlite non-spatial with Data Interoperability

AdrianWelsh — Thu, 10 Oct 2019 18:59:13 GMT

Tagging Bruce Harold‌ on this.

Re: Unable to read Sqlite non-spatial with Data Interoperability

BruceHarold — Thu, 10 Oct 2019 19:09:36 GMT

Hi Sean

This looks like a UI bug.

I can copy-paste a reader into a workspace so I'll share that with you, but I'm on Pro 2.5 so the FME Engine will be 2019.1.2, if this causes the SQLITE3 reader to not arrive let me know.

Re: Unable to read Sqlite non-spatial with Data Interoperability

BruceHarold — Wed, 16 Oct 2019 13:22:37 GMT

Hello All

We found the issue, you can fix it for Pro by renaming this file (don't delete it, see below):

C:\Program Files\ArcGIS\Data Interoperability for ArcGIS Pro\formatsinfo\sqlite3.db

This action will need to be undone when installing Pro 2.5.

The issue will still be found in ArcMap/Catalog until ArcGIS 10.8.