Sage 100

 View Only

  • 1.  Sage 100 v2020 Premium data migration error - Operating system error 2(The system cannot find the file specified).

    Posted 07-18-2020 03:48

    Hi,

     

    I am running into the error below while attempting to migrate company data from Sage 100 Premium v2015 to v2020 using the SQL Parallel Migration Wizard.

     

    Unhandled Exception
    Error Number: 0x80040E14

    Description: Cannot open backup device

    'E:\MSSQL12.DefaultInstance\MSSQL\DATA\MAS_XXX.bak'

    Operating system error 2(The system cannot find the file specified).

    Setup will now terminate.

     

    Ran into the same error while migrating the data during the test upgrade but solved the error after utilizing a domain admin account to run the SQL Server services (both instances).

     

    Details:

    • Using two different SQL instances on the same SQL server as original SQL server is no longer available.
    • Restored SQL databases to SQL INSTANCE2 and migrating to the SQL Default Instance on the same server.
    • Ran a SQL Profiler trace and see the error below while attempting the restore:

     

    RESTORE DATABASE MAS_XXX FROM DISK='E:\MSSQL13.DetaultInstance\MSSQL\DATA\MAS_XXX.bak' WITH FILE = 1, MOVE 'MAS_301' TO 'E:\MSSQL13.DefaultInstance\MSSQL\DATA\MAS_XXX.mdf', MOVE 'MAS_301_LOG' TO 'E:\MSSQL13.DefaultInstance\MSSQL\DATA\MAS_301_LOG.LDF', REPLACE

    Cannot open backup device 'E:\MSSQL13.DefatultInstance\MSSQL\DATA\MAS_XXX.bak'. Operating system error 2(The system cannot find the file specified.).

     

    • The file MAS_XXX.bak does not exist on the E:\MSSQL13.DetaultInstance\MSSQL\DATA\ path, but it does exist in the E:\MSSQL13.Instance2\MSSQL\DATA\ folder.
    • Went through the Sage KB articles below and have tried with Local System Account as well but same issue.
    • Tried adding Windows account for session and SQL Service account to the MSSQL\Data and MSSQL\Backup folders but same error.
    • Ran the Parallel Migration Wizard as regular user and as Administrator but same error.
    • Tried deleting one of the company databases (through Company Maintenance) on target SQL Default Instance but same error.
    • No administrative shares on any of the paths.
    • MAS90 folder resides on C:\Temp but don't believe that is a factor at this point.

    How to upgrade to Sage 100 Premium 2015 or higher
    https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=62630&sliceId=1&docLink=true&languageId=&isDocLink=true&currentmsID=MS_Customer&cmd=&openedFromDocument=true&ViewedDocsListHelper=com.kanisa.apps.common.BaseViewedDocsListHelperImpl

    During Parallel Migration where Sage 100 Premium is on one server and SQL Server is on a different server, multiple messages occur ending in "Error Number : 0x80040e14 Description: Access Denied 5 or Access Denied 2 Setup will now terminate"

    https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=76993&sliceId=1&docLink=true&languageId=&isDocLink=true&currentmsID=MS_Customer&cmd=&openedFromDocument=true&ViewedDocsListHelper=com.kanisa.apps.common.BaseViewedDocsListHelperImpl

    Any suggestions are welcome.



     

     

     

    Thanks,

     

    César Varela | Sage 100 ERP Consultant

    O: 949.583.9500 x1194 | C: 949.338.3611

    cvarela@blytheco.com | www.blytheco.com
    Blytheco | Transforming Companies

     

    Join my conference:
    949-268-2850
    Access code:
    *0710276
    Screen sharing:
    https://micollab.blytheco.com/call/0710276

     



  • 2.  RE: Sage 100 v2020 Premium data migration error - Operating system error 2(The system cannot find the file specified).

    Posted 07-18-2020 15:21
    Found a workaround on the Install guide. Copied the bak files manually to the destination SQL\DATA folder and the migration and conversion completed properly.

    If local security settings prevent the wizard from migrating the databases, use SQL Server Management Studio to back up the MAS_System and company databases that you want to migrate. Then copy the .BAK files to the ..\MSSQL\Data folder on the server where the Sage 100 2020 SQL Server instance is installed.

    ------------------------------
    Cesar Varela
    Blytheco LLC
    ------------------------------



  • 3.  RE: Sage 100 v2020 Premium data migration error - Operating system error 2(The system cannot find the file specified).

    Posted 07-20-2020 04:29
    I ran into something similar. In my case it was a new SQL server and I wasn’t able to browse using \\servername despite using a domain admin account to install.

    IT had to add the ability to browse that share. Once they did I could migrate ( in my case manually backing up + copying didn’t work )

    ---------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ---------------------------------



    Original Message


  • 4.  RE: Sage 100 v2020 Premium data migration error - Operating system error 2(The system cannot find the file specified).

    Posted 07-20-2020 10:38

    Thanks Wayne.

     

     

     

    Thanks,

     

    César Varela | Sage 100 ERP Consultant

    O: 949.583.9500 x1194 | C: 949.338.3611

    cvarela@blytheco.com | www.blytheco.com
    Blytheco | Transforming Companies

     




    Original Message


  • 5.  RE: Sage 100 v2020 Premium data migration error - Operating system error 2(The system cannot find the file specified).

    Posted 07-20-2020 10:49
    Always use SQL authentication for the migration wizard, never Windows... that forces the backup / restore processes to run under the SQL Service account, which should have the access (if you set it up using a domain account with local admin access to both servers).
    For Wayne's issue, I think I used IP addresses to bypass that once.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 6.  RE: Sage 100 v2020 Premium data migration error - Operating system error 2(The system cannot find the file specified).

    Posted 07-20-2020 10:54

    Thanks Kevin. The Premium Parallel Migration Utility only gives you the option to authenticate via SQL, not Windows.

    I used the SA SQL login throughout.

     

     

     

    Thanks,

     

    César Varela | Sage 100 ERP Consultant

    O: 949.583.9500 x1194 | C: 949.338.3611

    cvarela@blytheco.com | www.blytheco.com
    Blytheco | Transforming Companies

     

    Join my conference:
    949-268-2850
    Access code:
    *0710276
    Screen sharing:
    https://micollab.blytheco.com/call/0710276

     

     




    Original Message


  • 7.  RE: Sage 100 v2020 Premium data migration error - Operating system error 2(The system cannot find the file specified).

    Posted 07-20-2020 11:12
    That must be new in v2020... because previously you had a choice.


    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


  • 8.  RE: Sage 100 v2020 Premium data migration error - Operating system error 2(The system cannot find the file specified).

    Posted 07-20-2020 11:23
    I just did a migration and I think it only prompted for SQL Authentication ( as Cesar notes ). I've also performed an upgrade for one larger customer with sophisticated IT and they were very reluctant to use their SA credentials because they also had critical SQL databases on the same SQL server.

    98% of the time ( maybe 99 ) this doesn't matter as the customer won't have a sophisticated IT department.

    However,  for any customer with a large and sophisticated IT they could push back against sharing SA and other forms of administrative credentials. For this, I've found it best to address right at the planning stage so my project doesn't stall 25% of the way through.

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------

    Original Message


Related Content