Cannot upgrade database from Sage 2013 to Sage 2015

Posted By Halsafar over 9 years ago

I have a client I do some IT work.  They just upgraded their Sage 2013 to Sage 2015 and whenever they try and perform the database upgrade step they get the following error.

I have tried a few things to no avail.  Sage 2013 fails when trying to Repair The Database (same error).

I manually opened the database upgrader and attempted to use it.  Same error.

Any advice?    Should I contact technical support?  Can they fix the files?

Silent Mode: False
Advanced Mode: True
Password Provided: True
Database Path: H:\Sage 50\Simply\CompanyName.SAI

********** BEGIN **********
Creating folder: \\Programs\UserShares\User1\My
Documents\Simply\DbVerifier\Backups\CompanyName_0
Copying file "H:\Sage 50\Simply\CompanyName.SAI" to "\\Programs\UserShares\User1\My
Documents\Simply\DbVerifier\Backups\CompanyName_0\CompanyName.SAI"
Copying folder "H:\Sage 50\Simply\CompanyName.SAJ" to "\\Programs\UserShares\User1\My
Documents\Simply\DbVerifier\Backups\CompanyName_0\CompanyName.SAJ"
\\Programs\UserShares\User1\My
Documents\Simply\DbVerifier\Backups\CompanyName_0\CompanyName.SAI:20202:Country_EnglishCanada
#HY000View 'simply.projectdata_21' references invalid table(s) or column(s) or
function(s) or definer/invoker of view lack rights to use them
Repairing database:\\Programs\UserShares\User1\My
Documents\Simply\DbVerifier\Backups\CompanyName_0\CompanyName.SAI
Begin: Attempting repair...
End: Attempting repair...
#HY000View 'simply.projectdata_21' references invalid table(s) or column(s) or
function(s) or definer/invoker of view lack rights to use them
Removing folder: \\Programs\UserShares\User1\My
Documents\Simply\DbVerifier\Backups\CompanyName_0

Parents

0 Patrick S over 9 years ago

Hello there,

From the log it seem like there is a redirection of Windows user folders. Will you be able to perform advanced database check from 2013 version when the file is local on the C drive for example? Also if possible disable any redirection of folder for the user.

If the file opens fine in 2013 then Sage will most likely take it in for repair and convert to 2015. Though you will have to go through some troubleshooting steps found on the below article:

https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=10493

If you can open the file in 2013 version then call support 1-888-522-2722 for steps to get the file in for repair.

Hope this helps
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Patrick S over 9 years ago

Hello there,

From the log it seem like there is a redirection of Windows user folders. Will you be able to perform advanced database check from 2013 version when the file is local on the C drive for example? Also if possible disable any redirection of folder for the user.

If the file opens fine in 2013 then Sage will most likely take it in for repair and convert to 2015. Though you will have to go through some troubleshooting steps found on the below article:

https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=10493

If you can open the file in 2013 version then call support 1-888-522-2722 for steps to get the file in for repair.

Hope this helps
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 Halsafar over 9 years ago in reply to Patrick S

So I attempted this. I tried a few things. I first tried copying their company files/folders to C: and opening them there, that worked but the upgrade still failed, same error.

Then I created a backup CAB. Moved the CAB to the C: drive. Attempted a restore from Backup and then check the database, fails.

I then tried restoring that backup in Sage 2015, it is happy to accept the backup from as soon as it starts to upgrade it fails.

This might be important:

When I try to restore the backup to another computer I get "missing data file" error when trying to open it. Maybe that is a clue.

Thanks for any help.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Patrick S over 9 years ago in reply to Halsafar

So when restoring a backup file (*.cab) and your are going through the restore process from within Sage 50 and have “missing data file” then there was an issue with the backup itself as the original can save a backup from 2013 version.

Another test will be to attempt converting 2013 version Sample Company to 2015. You can see here where is the Sample Company file located for Sage Simply Accounting 2013 version. If that conversion succeeds from 2013 to 2015 then you have an issue with the file you are trying to convert. In that case please call tech support for conversion. If you cannot convert Sample from 2013 to 2015 then there is an environmental issue on the computer blocking the conversion.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 50 Canada

Cannot upgrade database from Sage 2013 to Sage 2015

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING