Page 1 of 1

duplicate values that don't exist.

Posted: Mon Jul 02, 2001 1:27 pm
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??

duplicate values that don't exist.

Posted: Mon Jul 02, 2001 2:35 pm
by John
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.

duplicate values that don't exist.

Posted: Mon Jul 02, 2001 2:56 pm
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.

duplicate values that don't exist.

Posted: Mon Jul 02, 2001 6:16 pm
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.