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

jackson33

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

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.

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.

paulj

has this issue been resolved? how can I work around this without having to change the type to an integer?

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....