Skip to main content
Solved

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

jelle
Contributor
Forum|alt.badge.img+16
  • jelleContributor
  • Contributor

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/

View original
Did this help you find an answer to your question?

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+16
  • jelleContributor
  • Author
  • Contributor
  • March 13, 2019
markatsafe wrote:

@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
markatsafe wrote:

@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


Helpful Members This Week

Community Stats

31,340
Posts
118,850
Replies
38,929
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
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.