# World Map Kit Data Extractor error

**URL:** <https://community.thinkgeo.com/t/world-map-kit-data-extractor-error/8225>\
**Category:** World Map Kit\
**Created:** [October 8, 2016, 8:14pm UTC](https://community.thinkgeo.com/t/world-map-kit-data-extractor-error/8225 "2016-10-08T20:14:33Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Eric\_Bowen](https://community.thinkgeo.com/letter_avatar_proxy/v4/letter/e/ecc23a/32.png) [@Eric\_Bowen](https://community.thinkgeo.com/u/Eric_Bowen)\
**Post date:** [October 8, 2016, 8:14pm UTC](https://community.thinkgeo.com/t/world-map-kit-data-extractor-error/8225/1 "2016-10-08T20:14:33Z")

</div>

Hi,  
I have not been able to get this tool to run. Here are the step I have taken, along with the errors I’ve run into. Pls advise. Thanks

1. Download the evealuation database using Product Center (lasvegas3857.sqllite)

2. Download the OSM World Map Kit Extractor (version: 2016-07-28) from: [ThinkGeo Docs](http://wiki.thinkgeo.com/wiki/map_suite_world_map_kit_sdk_all_samples#osm_world_map_kit_extractor)

3. Build error. Updating System.Data.SQLite.Core to current version (1.0.103) resolved the error.

4. Build error: Missing ref OsmWorldMapKitLayer. Resovled by removing the reference then adding it back from: C:\Program Files (x86)\ThinkGeo\Map Suite 9.0\Map Suite World Map Kit SDK\Current Version\Managed Assemblies\OsmWorldMapKitLayer.dll

5. Build succeeded, Execute Fail: Extractor.cs, Ln#457 (“requested value ‘numeric’ not found”)- - columnName = “scalerank”  
 → tried to work around by adding “scalerank” to Ln#442 (if (!(columnName.Equals(“scalerank”) || … )

6. Execute Fail: Extractor.cs, Ln#183 (An exception of type ‘System.Data.SQLite.SQLiteException’ occurred in System.Data.SQLite.dll but was not handled in user code.  
Additional information: SQL logic error or missing database. duplicate column name: name

Thesea are my settings:

 ![](https://community.thinkgeo.com/uploads/default/original/3X/b/9/b94438488793739dcb2112c195b34c79532b7f3c.png)

---

<div class="post-metadata">

**Author:** ![Ethan](https://community.thinkgeo.com/user_avatar/community.thinkgeo.com/ethan/32/19964_2.png) [@Ethan](https://community.thinkgeo.com/u/Ethan)\
**Post date:** [October 9, 2016, 3:40am UTC](https://community.thinkgeo.com/t/world-map-kit-data-extractor-error/8225/2 "2016-10-09T03:40:30Z")

</div>

Hi Eric,

It looks somebody else met this issue last month.

I think you can try something like this,

Find GetTables function in Extractor.cs, see whether the SqliteColumnType contains Numeric item like this screen shot shows:

 ![](https://community.thinkgeo.com/uploads/default/original/3X/3/c/3cfb4f7dd1c1509d8337845ab42ba38ca2b76294.png)

If it don’t contains that, please download latest development version 9.0.x.0 dlls.

My test version for MapSuiteCore is 9.0.379.0.

Wish that’s helpful.

Regards,

Don

---

<div class="post-metadata">

**Author:** ![Eric\_Bowen](https://community.thinkgeo.com/letter_avatar_proxy/v4/letter/e/ecc23a/32.png) [@Eric\_Bowen](https://community.thinkgeo.com/u/Eric_Bowen)\
**Post date:** [October 9, 2016, 1:54pm UTC](https://community.thinkgeo.com/t/world-map-kit-data-extractor-error/8225/3 "2016-10-09T13:54:53Z")

</div>

Thanks Don, that fixed it.

---

<div class="post-metadata">

**Author:** ![Ethan](https://community.thinkgeo.com/user_avatar/community.thinkgeo.com/ethan/32/19964_2.png) [@Ethan](https://community.thinkgeo.com/u/Ethan)\
**Post date:** [October 10, 2016, 1:30am UTC](https://community.thinkgeo.com/t/world-map-kit-data-extractor-error/8225/4 "2016-10-10T01:30:20Z")

</div>

Hi Eric,

I am glad to hear that works.

Regards,

Don