If you run into errors during the conversion or your computer locks up, we recommend that you reboot your computer. This will free up memory and avoid other errors.
Warning! Do not interrupt the conversion or close the Data Conversion wizard during a conversion process! If you do, you may damage your company data.
Known reasons for data conversion failures include the following:
Before you try the conversion again, you must restore the backup made prior to the conversion. In most cases data conversions are required when you install a product upgrade; in some cases, a product maintenance update requires data conversion. Rather than uninstall a Sage 50 upgrade or product update, you can restore your old company data in a new company folder.
Before you launch the Data Conversion wizard, there are some precautionary tasks you may want to perform. These include:
Note: Since the conversion process may take quite a while to complete, we recommend that you start the process before lunch or at the end of your business day, making sure you leave the computer running.
If you get the error message, “This transaction refers to a non-existing invoice for customer/vendor XXXX, reference XXXX” during conversion, please refer to Answer ID 7824 within the Sage 50 Knowledgebase at http://na.sage.com/us/support . This document gives detailed instructions for correcting the error. Then try the conversion once again.
If you are operating Sage 50 on a network and experience “Lock Table Full” errors, increase the maximum locks per connection on your network, then try the conversion process again. If this does not work or you are on a experiencing “Lock Table Full” errors on other networks when trying to convert data, copy your company data to a workstation and perform the operation directly on that workstation. When the process is complete, copy the data back to the network drive.
If you are unclear as to how to set the number of locks, refer to your network manual or see a network administrator. You can also visit the Sage 50 Knowledge Base at our Web site at http://na.sage.com/us/support for information correcting the error.
If you have an automatic backup routine enabled on your network and run the conversion or purge process overnight, you should disable this routine. It can be re-enabled after the purge or conversion process has completed.
If you have tried all the tips mentioned above and you still run into conversion errors, contact Sage Customer Support for further assistance. In rare cases, your company data may have been damaged in a prior release, and thus it cannot convert successfully. Sage 50 Customer Support may ask you to reinstall the prior version of Sage 50 so that they can help you repair the data, if necessary. As a last resort, you may have to restore an older backup of your company data and try the upgrade and conversion process again.