none
Data profiling failed. Conversion Overflows

    Question

  • Hi,

    I was able to run Profiling task with the previous table. However, after that I tried with a huge table and it showed below error msg.

    [Data Profiling Task] Error: Error occurred when profiling the data. The error message is: System.OverflowException:

    Conversion overflows.
       at System.Data.SqlClient.SqlBuffer.get_Decimal()

       at System.Data.SqlClient.SqlBuffer.get_Value()

       at System.Data.SqlClient.SqlDataReader.GetValueInternal(Int32 i)

       at System.Data.SqlClient.SqlDataReader.GetValue(Int32 i)

       at System.Data.SqlClient.SqlDataReader.get_Item(Int32 i)

       at Microsoft.DataDebugger.DataProfiling.NullAndStatisticsWorkItem.ProcessReader(SortedList`2 results, IDataReader reader)

       at Microsoft.DataDebugger.DataProfiling.NullAndStatisticsWorkItem.DoWork()

       at Microsoft.DataDebugger.DataProfiling.TablePartitionedBatch.ComputeProfiles()

       at Microsoft.DataDebugger.DataProfiling.BuiltInProfiler.Profile().

    Then, I tried the small table again, but the error still exists.

    Can anyone give me a clue for this?

    Thanks.

    Saturday, July 13, 2013 8:57 AM

Answers