duplicate values that don't exist.

MiniMe · Post by **MiniMe** » Mon Jul 02, 2001 1:27 pm

I started with a new database with no tables in it. I then ran 'timport -s books.sch data.txt'

This then loaded 16 million records, all verified unique. I then ran 'tsql "create unique index xbooknum on books(BOOKNUM)"'

Texis reported back that there were duplicate values.

178 Trying to insert duplicate value (8011153038) in index (temp RAM DBF)
100 Creating Unique index on Non-unique data
178 Trying to insert duplicate value (8011153040) in index (temp RAM DBF)
178 Trying to insert duplicate value (8011153041) in index (temp RAM DBF)
178 Trying to insert duplicate value (8011153042) in index (temp RAM DBF)
178 Trying to insert duplicate value (8011153043) in index (temp RAM DBF)
178 Trying to insert duplicate value (8011153035) in index (temp RAM DBF)
178 Trying to insert duplicate value (8011153037) in index (temp RAM DBF)
178 Trying to insert duplicate value (8011153039) in index (temp RAM DBF)
178 Trying to insert duplicate value (7291973774) in index (temp RAM DBF)
178 Trying to insert duplicate value (7291973775) in index (temp RAM DBF)
178 Trying to insert duplicate value (7291973836) in index (temp RAM DBF)
178 Trying to insert duplicate value (7294037185) in index (temp RAM DBF)
178 Trying to insert duplicate value (8000750220) in index (temp RAM DBF)
178 Trying to insert duplicate value (7291972829) in index (temp RAM DBF)

there were 924 instances like these, however there are no duplicates of these values in the original text data. What could have caused this??

Post by **John** » Mon Jul 02, 2001 2:35 pm

You're certain that there is no duplication of values? Did you get any other messages? You might try creating the table and index first, and then importing, and see if you still get the same messages.

MiniMe · Post by **MiniMe** » Mon Jul 02, 2001 2:56 pm

yes.. I grepped several of the values and they only showed up in the file only once. I also checked the source database where the file came from and they only had unique values. Ill try what you suggest and see what happens.

MiniMe · Post by **MiniMe** » Mon Jul 02, 2001 6:16 pm

I did this and did not get the same affect.. Should I be concerned about the fact that it happened to begin with.