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;
SET QUOTED_IDENTIFIER ON;
DROP TABLE [dbo].[JunkTable];
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];
ALTER TABLE [dbo].[JunkTable]
ADD CONSTRAINT [DF_JunkTable_Column15]
DEFAULT (SYSUTCDATETIME()) FOR [Column15];
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)
);
Please let me know when there is a fix available.
Thanks,
Tony
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.".
Refer also to the forum post "How to determine the version of an installed free tool?".