Greetings,
We're in the process of upgrading our ancient Sage 4.50 to Sage 2018. Ran into a strange issue with regards to rebuilding the key files prior to migration.
All the files were able to be rebuilt and optimized without any issue except for one file. This file fails the verification test, however it will rebuild / optimize without any errors.
After the file has been rebuilt / optimized it still won't pass the verification test though.
See below for output from the verification test.
IM_ItemCustomerHistoryByPeriod.M4T
The read test failed. Error #11: Record not found or Duplicate key on write
Here is the output if we uncheck the verification test.
IM_ItemCustomerHistoryByPeriod.M4T
Record count indicates all records were recovered.
Keys from the old file are being compared to the new file.
No discrepancies have been found.
I went ahead with the migration, and then converted the data from 4.50 to version 6.00. When I perform a verification test on this file it still fails the read test. We're not seeing any errors generated in Sage 100 either.
I've talked to Sage support and they don't have any idea about this. One individual even suggested we ignore the issue. It was suggested that I post on the forum here and see if anyone else had a clue.
Is this something we need to be concerned about?
Thanks for any help you can offer.