Skip to main content
  • EN

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.

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

@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


Community Stats

30,108
Posts
114,295
Replies
37,744
Members
Terms & ConditionsCookie 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.