Using spatial index in SQL Server gets "Failed to open malformed assembly 'mscorlib'"

1

I'm having a bit of an issue with setting up a db in MSSQL where when I try to set up an index on a geography data typed column and it keeps spiting out an error of

Msg 6507, Level 16, State 2, Line 1 Failed to open malformed assembly 'mscorlib' with HRESULT 0x80070008.

here is the code

        /* do this last as everything is keyed to it */
        IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[place]') AND type in (N'U'))
        DROP TABLE [dbo].[place]
        GO
        IF  EXISTS (SELECT * FROM sysfulltextcatalogs ftc WHERE ftc.name = N'ft_placebyname')
        DROP FULLTEXT CATALOG [ft_placebyname]
        GO


        CREATE TABLE [dbo].[place](
            [place_id] [int] IDENTITY(1,1) NOT NULL,
            [prime_name] [nvarchar](max) NULL,
            [abbrev_name] [nchar](10) NULL,
            [street_address] [nvarchar](max) NULL,
            [creation_date] [datetime] NULL,
            [updated_date] [datetime] NULL,
            [coordinate] [geography] NULL,
            [plus_four_code] [tinyint] NULL
                CONSTRAINT [CK_plus_four_code_check] 
                CHECK ([plus_four_code] LIKE '[0-9][0-9][0-9][0-9]' AND [plus_four_code] NOT LIKE '0000'),

            CONSTRAINT [PK_place] PRIMARY KEY CLUSTERED 
            (
                [place_id] ASC
            )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
            ) ON [PRIMARY]
        GO
        /* create the indexing by long and lats */
        CREATE SPATIAL INDEX SIndx_place_geography_coordinate
           ON [place]([coordinate])
           USING GEOGRAPHY_GRID
           WITH (
            GRIDS =(LEVEL_1 = MEDIUM,LEVEL_2 = MEDIUM,LEVEL_3 = MEDIUM,LEVEL_4 = MEDIUM), 
            CELLS_PER_OBJECT = 64,
            PAD_INDEX  = ON,
            SORT_IN_TEMPDB = OFF,
            DROP_EXISTING = OFF,
            ALLOW_ROW_LOCKS  = ON,
            ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
        GO  

        /* create the indexing by primary name */
        CREATE UNIQUE INDEX ui_place_prime_name ON [place]([place_id]);
        CREATE FULLTEXT CATALOG ft_placebyname AS DEFAULT;
        CREATE FULLTEXT INDEX ON [place]([prime_name])
            KEY INDEX ui_place_prime_name 
            WITH STOPLIST = SYSTEM;
        GO
sql-server
sql-server-2008
spatial
spatial-index
asked on Stack Overflow Nov 16, 2011 by Quantum • edited Feb 7, 2012 by John Saunders

1 Answer

1

FWIW, SQL Server 2008 R2: Command(s) completed successfully.

A really quick google for this:

Not enough storage is available to process this command.

(Exception from HRESULT: 0x80070008) (mscorlib)

Any chance you're out of drive space?

And another post:

SqlServer process ran out of memory (HRESULT 0x80070008). I will file a DCR to make the error message better.

Seems like either a memory or drive space exhaustion issue?

answered on Stack Overflow Nov 16, 2011 by Lynn Crumbling • edited Nov 16, 2011 by Lynn Crumbling

User contributions licensed under CC BY-SA 3.0