Unable to read Sqlite non-spatial with Data Interoperability

[SeanGrant1]

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

[AdrianWelsh]

Tagging Bruce Harold‌ on this.

[BruceHarold]

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 · Accepted solution]

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.