4 Replies Latest reply on Feb 25, 2009 4:33 PM by skierjmh

    IPAM Beta Install Failed - Database Configuration Failed

    skierjmh

      Right after the CW runs, the services are checked, this is the result.

      Database configuration failed:   
          •  Error while executing script- Column or parameter #8: Cannot find data type xml.

       

      From the CW Log:

      2009-02-25 09:24:25,600 [1] INFO  ConfigurationProgressScene - Updating Orion database. Processing IPAMTables.dbConfig file ...
      2009-02-25 09:24:25,772 [6] ERROR DBConfigProcessor - Error while executing script - Column or parameter #8: Cannot find data type xml..
      2009-02-25 09:24:25,772 [6] ERROR DBConfigProcessor - Failing Sql command:

      --
      -- C:\source\IPAM-Current\Dev\Main\ipam\Src\config\SqlScripts\Tables\IPAM_AttrDefine.sql
      --
      IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[IPAM_AttrDefines]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
      BEGIN

      CREATE TABLE [dbo].[IPAM_AttrDefines](
          [AttrId] [int] IDENTITY(1,1) NOT NULL,
          [ColumnName] [nvarchar](128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
          [DisplayName] [nvarchar](128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
          [DisplayOrder] [int] NOT NULL CONSTRAINT [DF_IPAM_AttrDefines_DisplayOrder]  DEFAULT ((0)),
          [Description] [nvarchar](128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
          [ValueRtType] [varchar](80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
          [ValueDbType] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
          [ValueConstraint] [xml] NULL,
          [TableParticipants] [varchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
       )

      END

      2009-02-25 09:24:25,772 [6] ERROR ConfigurationProgressScene - Error while executing script- Column or parameter #8: Cannot find data type xml.