SQL Data Profiler - Profiling Failed

Hi,

I created a table with the following definition below and when I attempt to profile it I get the following error message:

 

The profiling of table JunkTable of database Junk failed.

Arithmetic overflow error converting expression to data type money.

 

USE [Junk];

GO

 SET ANSI_NULLS ON;

GO

SET QUOTED_IDENTIFIER ON;

GO

DROP TABLE [dbo].[JunkTable];

GO

 

CREATE TABLE [dbo].[JunkTable]

(

    [Column01] [UNIQUEIDENTIFIER] NOT NULL,

    [Column02] [TINYINT] NULL,

    [Column03] [DATETIME] NOT NULL,

    [Column04] [DATETIME] NULL,

    [Column05] [INT] NOT NULL,

    [Column06] [INT] NOT NULL,

    [Column07] [DATETIME] NOT NULL,

    [Column08] [INT] NOT NULL,

    [Column09] [UNIQUEIDENTIFIER] NOT NULL,

    [Column10] [UNIQUEIDENTIFIER] NOT NULL,

    [Column11] [UNIQUEIDENTIFIER] NOT NULL,

    [Column12] [INT] NOT NULL,

    [Column13] [UNIQUEIDENTIFIER] NOT NULL,

    [Column14] [BIGINT] IDENTITY(-9223372036854775808, 1) NOT NULL,

    [Column15] [DATETIME2](7) NOT NULL

) ON [PRIMARY];

GO

ALTER TABLE [dbo].[JunkTable]

ADD CONSTRAINT [DF_JunkTable_Column15]

    DEFAULT (SYSUTCDATETIME()) FOR [Column15];

GO

 

INSERT INTO [dbo].[JunkTable]

(

    [Column01],

    [Column02],

    [Column03],

    [Column04],

    [Column05],

    [Column06],

    [Column07],

    [Column08],

    [Column09],

    [Column10],

    [Column11],

    [Column12],

    [Column13],

    [Column15]

)

VALUES

(   NEWID(),      -- Column01 - uniqueidentifier

    0,            -- Column02 - tinyint

    GETDATE(),    -- Column03 - datetime

    GETDATE(),    -- Column04 - datetime

    0,            -- Column05 - int

    0,            -- Column06 - int

    GETDATE(),    -- Column07 - datetime

    0,            -- Column08 - int

    NEWID(),      -- Column09 - uniqueidentifier

    NEWID(),      -- Column10 - uniqueidentifier

    NEWID(),      -- Column11 - uniqueidentifier

    0,            -- Column12 - int

    NEWID(),      -- Column13 - uniqueidentifier

    SYSDATETIME() -- Column15 - datetime2(7)

);

GO

 

Please let me know when there is a fix available.

 

Thanks,

Tony

  • I apologize for any inconvenience. We are currently investigating this issue.
  • In reply to Peter V.:

    You can now download SQL Data Profiler v1.0.195.1950 which should fix the issues with "Profiling Failed: The profiling of table [table] of database [database] failed. Arithmetic overflow error converting expression to data type money." and "Profiling Failed: The profiling of table [table] of database [database] failed. The conversion of the nvarchar value of [value] overflowed an int column.".