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

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 )

Comments

  • Options
    Hello,

    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
Sign In or Register to comment.