| Marc DESJARDINS 2006-12-01, 1:30 am |
| Hi, I’ve ran the Commerce Server 2007 Upgrade Wizard for the Transactions
Ressource.
I then compared the data from the 2002 tables and the newly created 2007
tables.
select count(*) between OrderGroup (2002) and PurchaseOrders (2007) is
matching.
select count(*) between OrderFormHeader (2002) and OrderForms (2007) is
matching.
But, select count(*) between OrderFormLineItems (2002) and LineItems (2007)
is NOT matching. I’ve got 164 rows for OrderFormLineItems and 33 rows for
LineItems
The wizard says “Resource 'Transactions' upgraded successfully”, the Main
Log shows “Resource 'Transactions' upgraded successfully” as well, the Orders
Error Log is empty meaning everything was migrated and the EventViewer
doesn’t show any errors.
I also re ran the Upgrade Wizard, but the migration for the Transactions
Ressource is not available anymore, it makes sense since it was ‘upgraded
successfully’.
I then compared the data in OrderFormLineItems (2002) between orders that
were transferred in the new table LineItems and those who were not, trying to
find out any patterns or anything else such suspicious data, everything looks
fine, actually there’s a match for any kind of data in both the upgraded data
and the lost LineItems.
Any idea why data was lost during the upgrade? And where should I now look?
Thanks in advance,
Marc DESJARDINS
|