How can we help you today? How can we help you today?

Error inserting into column type numeric(19,0)null

I keep receiving the error below when trying to generate data for a column of type numeric(19,0)null...

[dbo].[SqlDataGeneratorTest]
The given value of type SqlDecimal from the data source cannot be converted to type decimal of the specified
target column.
System.InvalidOperationException: The given value of type SqlDecimal from the data source cannot be converted
to type decimal of the specified target column. ---> System.InvalidOperationException: The given value of type
SqlDecimal from the data source cannot be converted to type decimal of the specified target column. --->
System.ArgumentException: Parameter value '2' is out of range. --- End of inner exception stack trace --- at
System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata) --- End of inner
exception stack trace --- at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData
metadata) at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal() at
System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount) at
System.Data.SqlClient.SqlBulkCopy.WriteToServer(IDataReader reader) at az.a(CancellableController , Int32 ,
Int32 , ConnectionProperties , GenerateAction , SqlConnection , SDGProject , GenerationReport )

It would appear that 1 is a valid entry but 2 is not. Distribution is set to Sequential. Set unique is checked. Min is set at 1, max at 9,999,999,999,999,999,999.
Any help is greatly appreciated.
Tim
jackson33
0

Comments

4 comments

Sort by
  • Brian Donahue
    Hi Tim,

    Sorry, this does seem to be a bug in Data Generator. The reference number with our development team is SDG-857, and it is being reviewed. There is no known workaround at this time, short of changing the column datatype to an integer.
    Brian Donahue
    0
  • jackson33
    Thanks for looking into Brian. Unfortunately I don't control the data type of that column. If I figure out any work arounds I'll post them up.
    jackson33
    0
  • paulj
    has this issue been resolved? how can I work around this without having to change the type to an integer?
    paulj
    0
  • paulj
    i figured out a work around. I had to write my own random decimal UDF and then use it in a sql statement for the random generated value for the specific columns that are of type decimal.

    talk about a pain in the butt. the tool isn't very useful if it's going to bomb on any decimal datatype column....
    paulj
    0

Add comment

Please sign in to leave a comment.