What are the challenges you face when working across database platforms? Take the survey

Error: The value '' cannot be inserted into column Col1

tkdennistkdennis 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 )


  • Options

    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

Sign In or Register to comment.