x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 3 replies
  • Subscribers 76 subscribers
  • Views 2716 views
  • Users 0 members are here
Browse Forums
Announcements
78
topics
166
replies
General Discussion
5k
topics
16k
replies
Installation and Upgrades
978
topics
2k
replies
Inventory, Projects, and Departments
337
topics
1k
replies
Payables and Receivables
1k
topics
4k
replies
Payroll
1k
topics
3k
replies
Reconciliation and Banking
315
topics
992
replies
Reporting and Analytics
206
topics
397
replies
Soutien Technique - Français
625
topics
1k
replies
Year End Activities
223
topics
595
replies
Halsafar

Cannot upgrade database from Sage 2013 to Sage 2015

Posted By 
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

  • 0

    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

  • 0 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.

  • 0 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.

*Community Hub is the new name for Sage City