Sage 100

 View Only
  • 1.  Has anyone seen this error during data conversion,

    Posted 08-10-2014 09:53
      |   view attached
    Has anyone seen this error during data conversion, and know what to do about it? ""Create Table failed for c:\sage....SO_SalesHistory. Physical Update Abort...x of x records copied with 0 duplicate keys"".


  • 2.  RE: Has anyone seen this error during data conversion,

    Posted 08-10-2014 10:18
    Had one similar to that and had to rebuild the file.


  • 3.  RE: Has anyone seen this error during data conversion,

    Posted 08-10-2014 10:19
    My intuition said that might be the case, so it's rebuilding now. BIG files! I'll post back if that works. Thanks!


  • 4.  RE: Has anyone seen this error during data conversion,

    Posted 08-10-2014 10:19
    https://90minds-com.socialcast.com/messages/21301976?mini=true


  • 5.  RE: Has anyone seen this error during data conversion,

    Posted 08-10-2014 15:02
    The rebuild is still going, which isn't surprising, because the client has 1.6 million records in SO_SalesHistory. On a whim, I decided to try data conversion in 2014 again. When it errored this morning, it showed some modules converted to 4.50, while others were still at 4.40. The data conversion says it has completed and all modules are now at version 2014. Do you think this is true? Or should I migrate and convert again after the rebuild finishes?


  • 6.  RE: Has anyone seen this error during data conversion,

    Posted 08-10-2014 15:59
    I've been comparing reports between the two versions, and they are identical. So I guess the data conversion worked. Thank you, @DianeRuth for your insight.