Error: The value '' cannot be inserted into column Col1
tkdennis
Posts: 114
This error is happening intermittently on different tables. Sometimes it runs the whole project without any of these errors. The columns are Foreign Key Generators on tinyint columns.
RedGate.SQLDataGenerator.Engine.DataGeneration.InvalidColumnDataException: The value '' cannot be inserted
into column Col1 at t.c() at t.Read() at System.Data.SqlClient.SqlBulkCopy.ReadFromRowSource()
at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal() at
System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount) at
System.Data.SqlClient.SqlBulkCopy.WriteToServer(IDataReader reader) at aw.a(CancellableController , Int32 ,
Int32 , ConnectionProperties , GenerateAction , SqlConnection , SDGProject , GenerationReport )
RedGate.SQLDataGenerator.Engine.DataGeneration.InvalidColumnDataException: The value '' cannot be inserted
into column Col1 at t.c() at t.Read() at System.Data.SqlClient.SqlBulkCopy.ReadFromRowSource()
at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal() at
System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount) at
System.Data.SqlClient.SqlBulkCopy.WriteToServer(IDataReader reader) at aw.a(CancellableController , Int32 ,
Int32 , ConnectionProperties , GenerateAction , SqlConnection , SDGProject , GenerationReport )
Comments
As I mentioned in my previous post, I'm sorry you have encountered an error with the application. If you could send us as much information as possible then that would be great!
Thank you
Ben