The value '' cannot be inserted into column IctHeaderId Erro

aharbathaharbath Posts: 4
edited November 26, 2009 3:41PM in SQL Data Generator Previous Versions
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 )
· Share on Twitter

Comments

  • Matthew FlattMatthew Flatt Posts: 255 Bronze 5
    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
    Redgate Foundry
    · Share on Twitter
  • aharbathaharbath Posts: 4
    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.
    · Share on Twitter
  • Matthew FlattMatthew Flatt Posts: 255 Bronze 5
    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
    Redgate Foundry
    · Share on Twitter
  • aharbathaharbath Posts: 4
    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.
    · Share on Twitter
  • Matthew FlattMatthew Flatt Posts: 255 Bronze 5
    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
    · Share on Twitter
Sign In or Register to comment.