Import fails to read node data

Aug 2, 2012 at 8:29 AM
Edited Aug 2, 2012 at 8:30 AM

Hi,

I am having a problem getting the import unitility to work. The error I get is 

 System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.Types, Version=11.0.0.0

 I have updated the server and sql to the latest updates available.  MS-SQL 2008R2 SP2 with .Net 4

I have installed Microsoft SQL Server 2008 R2 System CLR Types  

Following is the log file.

What do I try from here?


8/2/2012 3:07:52 AM - -----------------------------------------
8/2/2012 3:07:52 AM -
8/2/2012 3:07:52 AM -
8/2/2012 3:07:52 AM - - Logging started . . .
8/2/2012 3:07:52 AM - 
8/2/2012 3:07:52 AM - 
8/2/2012 3:07:52 AM - -----------------------------------------
8/2/2012 3:08:04 AM - Starting Task: Creates the database structure
8/2/2012 3:08:06 AM - Finished Task: Creates the database structure8/2/2012 3:08:06 AM - Starting Task: Read all node from OSM to the database
8/2/2012 3:08:06 AM - Starting Task: Read all ways from OSM to the database
8/2/2012 3:08:06 AM - System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.Types, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.File name: 'Microsoft.SqlServer.Types, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'   at osm2mssql.Importer.Tasks.TaskNodeReader.DoTaskWork(String osmFile)   at osm2mssql.Importer.Tasks.TaskBase.RunTask(SqlConnectionStringBuilder connection, String osmFile)

WRN: Assembly binding logging is turned OFF.To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.Note: There is some performance penalty associated with assembly bind failure logging.To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

Sep 10, 2012 at 10:13 AM

Hi,

I downloaded Poland.osm from cloudmade and was trying to import into my local db. I am also having a problem with getting this "Reading nodes into db" to work. It fails on my MS SQL Server 2008. Here is the log.

10-09-2012 14:40:57 - -----------------------------------------

10-09-2012 14:40:57 - 

10-09-2012 14:40:57 -

 10-09-2012 14:40:57 - - Logging started . . .

10-09-2012 14:40:57 - 

10-09-2012 14:40:57 - 

10-09-2012 14:40:57 - -----------------------------------------

10-09-2012 14:41:01 - Starting Task: Creates the database structure10-09-2012 14:41:12 - Finished Task: Creates the database structure10-09-2012 14:41:12 - Starting Task: Read all node from OSM to the database10-09-2012 14:41:12 - Starting Task: Read all ways from OSM to the database10-09-2012 14:41:12 - System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.Types, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.File name: 'Microsoft.SqlServer.Types, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'   at osm2mssql.Importer.Tasks.TaskNodeReader.DoTaskWork(String osmFile)   at osm2mssql.Importer.Tasks.TaskBase.RunTask(SqlConnectionStringBuilder connection, String osmFile)
WRN: Assembly binding logging is turned OFF.To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.Note: There is some performance penalty associated with assembly bind failure logging.To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].
10-09-2012 14:41:32 - Task is waiting until all running tasks finish...10-09-2012 14:41:32 - All tasks are finished10-09-2012 14:41:32 - Finished Task: Read all ways from OSM to the database

Sep 10, 2012 at 10:21 AM

Hi!

Sorry, currently there are some mistakes in connection with SQL Server 2008 R2, because i´m always developing with 2012 already and i´m the only developer of osm2mssql. 

A quick solution for you: use an older version - compile it on your own 
Currently i do not know when i catch the time for investigate the problem - sorry.

greets from Austria

Christian

Sep 10, 2012 at 8:24 PM
Hi Christian, Greeting from Australia. Yes I worked out that I need to use 2012 so I updated my server and all worked fine. Thanks Glen Jobson + Technology Director p : +61 2 9979 9918 m : 0433 222 270 e : glen@tiltandco.com w : www.tiltandco.com On 10/09/2012, at 7:13 PM, "msharanbabu" wrote: > From: msharanbabu > > Hi, > > I downloaded Poland.osm from cloudmade and was trying to import into my local db. I am also having a problem with getting this "Reading nodes into db" to work. It fails on my MS SQL Server 2008. Here is the log. > > 10-09-2012 14:40:57 - ----------------------------------------- > > 10-09-2012 14:40:57 - > > 10-09-2012 14:40:57 - > > 10-09-2012 14:40:57 - - Logging started . . . > > 10-09-2012 14:40:57 - > > 10-09-2012 14:40:57 - > > 10-09-2012 14:40:57 - ----------------------------------------- > > 10-09-2012 14:41:01 - Starting Task: Creates the database structure10-09-2012 14:41:12 - Finished Task: Creates the database structure10-09-2012 14:41:12 - Starting Task: Read all node from OSM to the database10-09-2012 14:41:12 - Starting Task: Read all ways from OSM to the database10-09-2012 14:41:12 - System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.Types, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.File name: 'Microsoft.SqlServer.Types, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' at osm2mssql.Importer.Tasks.TaskNodeReader.DoTaskWork(String osmFile) at osm2mssql.Importer.Tasks.TaskBase.RunTask(SqlConnectionStringBuilder connection, String osmFile) > WRN: Assembly binding logging is turned OFF.To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.Note: There is some performance penalty associated with assembly bind failure logging.To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog]. > 10-09-2012 14:41:32 - Task is waiting until all running tasks finish...10-09-2012 14:41:32 - All tasks are finished10-09-2012 14:41:32 - Finished Task: Read all ways from OSM to the database > > Read the full discussion online. > > To add a post to this discussion, reply to this email (osm2mssql@discussions.codeplex.com) > > To start a new discussion for this project, email osm2mssql@discussions.codeplex.com > > You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe on CodePlex.com. > > Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at CodePlex.com > Hi Christian,

Greeting from Australia.

Yes I worked out that I need to use 2012 so I updated my server and all worked fine.

Thanks

Glen Jobson
+ Technology Director

p : +61 2 9979 9918
m : 0433 222 270
e : glen@tiltandco.com
w : www.tiltandco.com


On 10/09/2012, at 7:13 PM, "msharanbabu" <notifications@codeplex.com> wrote:

From: msharanbabu

Hi,

I downloaded Poland.osm from cloudmade and was trying to import into my local db. I am also having a problem with getting this "Reading nodes into db" to work. It fails on my MS SQL Server 2008. Here is the log.

10-09-2012 14:40:57 - -----------------------------------------

10-09-2012 14:40:57 -

10-09-2012 14:40:57 -

10-09-2012 14:40:57 - - Logging started . . .

10-09-2012 14:40:57 -

10-09-2012 14:40:57 -

10-09-2012 14:40:57 - -----------------------------------------

10-09-2012 14:41:01 - Starting Task: Creates the database structure10-09-2012 14:41:12 - Finished Task: Creates the database structure10-09-2012 14:41:12 - Starting Task: Read all node from OSM to the database10-09-2012 14:41:12 - Starting Task: Read all ways from OSM to the database10-09-2012 14:41:12 - System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.Types, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.File name: 'Microsoft.SqlServer.Types, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' at osm2mssql.Importer.Tasks.TaskNodeReader.DoTaskWork(String osmFile) at osm2mssql.Importer.Tasks.TaskBase.RunTask(SqlConnectionStringBuilder connection, String osmFile)
WRN: Assembly binding logging is turned OFF.To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.Note: There is some performance penalty associated with assembly bind failure logging.To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].
10-09-2012 14:41:32 - Task is waiting until all running tasks finish...10-09-2012 14:41:32 - All tasks are finished10-09-2012 14:41:32 - Finished Task: Read all ways from OSM to the database