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

The simplest way to populate your database with test data.

Moderators: David Atkinson, Anu Deshpande, Lionel

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

Postby tkdennis » Sat May 17, 2008 5:50 am

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 )
Posts: 75
Joined: Fri Feb 29, 2008 1:13 am

Postby benhall » Mon May 19, 2008 11:35 am


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

Posts: 69
Joined: Fri Dec 14, 2007 11:15 am

Return to SQL Data Generator 1

Who is online

Users browsing this forum: No registered users and 1 guest