How can we help you today? How can we help you today?

The value '' cannot be inserted into column IctHeaderId Erro

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 )
aharbath
0

Comments

5 comments

Sort by
  • Matthew Flatt
    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?

    Thanks,
    Matthew Flatt
    0
  • aharbath
    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.
    aharbath
    0
  • Matthew Flatt
    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 support@red-gate.com with reference number F0028994 that would be great.
    Matthew Flatt
    0
  • aharbath
    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.
    aharbath
    0
  • Matthew Flatt
    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
    0

Add comment

Please sign in to leave a comment.