The value '' cannot be inserted into column IctHeaderId Erro

aharbathaharbath Posts: 4
I am evaluating the Data Generator tool and I am getting this error when with one of the tables I am loading. Any ideas on why this is appearing. Additional details are below:

The value '' cannot be inserted into column IctHeaderId
RedGate.SQLDataGenerator.Engine.DataGeneration.InvalidColumnDataException: The value '' cannot be inserted
into column IctHeaderId at u.c() at u.Read() at
RedGate.SQLDataGenerator.Engine.DataGeneration.TypeTranslationDataReader.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 az.a(CancellableController , Int32 ,
Int32 , ConnectionProperties , GenerateAction , SqlConnection , SDGProject , GenerationReport )


  • Hi aharbath,

    Are you populating this table from another Database/Table by any chance? It looks as though SQL Data Generator might be trying to put blank data into a column which doesn't allow blank data. If this is from an existing Database/Table can you check to see if it has any blank rows for that column?

    Matthew Flatt
    Redgate Foundry
  • I am not populating the data from another table. I am letting Data Generator do its' thing. The column IctHeaderId does not allow nulls and in the generator parameters for the IctHeaderId colmun the Allow Null Values checkbox is not checked.
  • Hi again,

    Do you think it would be possible to provide us with a binary schema snapshot of the database so we can try to recreate here? You can use SQL Compare or the tool here to take your snapshot. If you could then e-mail it to [email protected] with reference number F0028994 that would be great.
    Matthew Flatt
    Redgate Foundry
  • I was eventually able to get the table populated with the number of records that I needed. It just took restarting the load a number of times. A little annoying but got me where I needed to be.
  • Thank you for the update, if you want to send over the schema to help us try to track down the problem anyway that would be great.
    Matthew Flatt
    Redgate Foundry
Sign In or Register to comment.