I'm currently attempting to profile a deep and wide dataset using SQL Data Profiler; however we I choose the Text Profile Data Type Option the Profiling Process Fails. Providing me with an Error stating:
Arithmetic overflow error converting expression to data type int
Is there any way that I can work around this without changing the table I am wishing to profile? The file is very large 141 million rows and 46.5 GB in size
The data set being profiled resides on MS SQL Server 2014 that has been loaded from SAS and has not been assigned the most appropriate SQL Server data types.
This may be a bug that slipped through because we did not have access to such a large dataset with a sub-optimal assignment of data types. We are not aware of a workaround at this time. We added this bug to our issue tracking system.
Please change this:
CAST((@@CPU_BUSY + @@IO_BUSY + @@IDLE) AS BIGINT) as TotalCPU,
,CAST(@@CPU_BUSY AS BIGINT) + CAST(@@IO_BUSY AS BIGINT) + CAST(@@IDLE AS BIGINT) AS TotalCPU
and the error is gone.
Thank you. I added this fix to our issue tracking system for a potential future release.