Solved

Error when opening SQLite database: 'no such module: VirtualElementary'

  • 1 March 2019
  • 3 replies
  • 44 views

Badge +11

Dear FME'ers

I have a SpatiaLite file, which I can read with the SpatialLite reader in Workbench. However, there is one non-geometrical table, which does not pop up in the Feature Classes.

So, I thought, I read this table with the 'SQLite Non-Spatial' Format. I get following error:

SQLite 3 Reader: Opening `Z:\\Connector\\GPS2Sirius\\TC_NM_DataFileGPS_V6.sqlite' for read operation

SQLITE3 reader: Database query 'PRAGMA table_info("ElementaryGeometries");' failed. SQLite3 Engine error: 'no such module: VirtualElementary'

However, in the Data Inspecter, I can open the data with the same reader.

Does anyone have an explanation for this? The SpatiaLite database is filled in QGis, but I do not know how it was created initially.

icon

Best answer by markatsafe 4 March 2019, 17:44

View original

3 replies

Badge +2

@jelle We'd need to see the SQLite database to determine where this error is occurring. If you're not able to upload the database to this post, then please open a support case at https://www.safe.com/support/

Badge +11

@jelle We'd need to see the SQLite database to determine where this error is occurring. If you're not able to upload the database to this post, then please open a support case at https://www.safe.com/support/

Done: support case number is C143528

Badge +2

@jelle We'd need to see the SQLite database to determine where this error is occurring. If you're not able to upload the database to this post, then please open a support case at https://www.safe.com/support/

@jelle This issue has been fixed in FME 2019. A workaround for 2018 and earlier is to use the SQLCreator / SQLExecutor with the SpatialLite reader:

Reply