Skip to main content
Solved

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

  • March 1, 2019
  • 3 replies
  • 206 views
jelle
Contributor
Forum|alt.badge.img+22

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.

Best answer by markatsafe

@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/

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

M
Forum|alt.badge.img+2
  • markatsafe
  • Best Answer
  • March 4, 2019

@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
Contributor
Forum|alt.badge.img+22
  • jelleContributor
  • Author
  • Contributor
  • March 13, 2019

@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

M
Forum|alt.badge.img+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:

Community Stats

32,207
Posts
122,303
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.