Unable to read Sqlite non-spatial with Data Interoperability

244
3
Jump to solution
10-04-2019 11:30 PM
SeanGrant1
New Contributor

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

  1. Add a new reader
  2. Choose sqlite non-spatial
  3. Select a database
  4. Click Parameters (since you have to because it is red)
  5. In the database dropdown, choose the only Sqlite option (Sqlite Spatial)
  6. 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

0 Kudos
1 Solution

Accepted Solutions
BruceHarold
Esri Regular Contributor

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.

View solution in original post

3 Replies
AdrianWelsh
MVP Notable Contributor

Tagging Bruce Harold‌ on this.

0 Kudos
BruceHarold
Esri Regular Contributor

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.

BruceHarold
Esri Regular Contributor

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.

View solution in original post