duplicate values that don't exist.

Post Reply
MiniMe
Posts: 210
Joined: Thu Mar 15, 2001 4:30 pm

duplicate values that don't exist.

Post by MiniMe »

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??
MiniMe
Posts: 210
Joined: Thu Mar 15, 2001 4:30 pm

duplicate values that don't exist.

Post by MiniMe »

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
Posts: 210
Joined: Thu Mar 15, 2001 4:30 pm

duplicate values that don't exist.

Post by MiniMe »

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