Sage 100

 View Only
  • 1.  Migrating the database - Parallel migration wizar

    Posted 09-01-2017 20:31
      |   view attached
    Migrating the database - Parallel migration wizard. v5.1 Premium to v5.4 Premium. Getting the following error message during the parallel migration: ""Exclusive access could not be obtained because the database is in use."" I have tried stopping and restarting the SQL server service, rebooted the server. Ran the ALTER database command to put the MAS_MIN database in single user mode. Shut down every possible service I could find that could be accessing SQL. Any ideas?


  • 2.  RE: Migrating the database - Parallel migration wizar

    Posted 09-01-2017 20:43
    Integration engine??


  • 3.  RE: Migrating the database - Parallel migration wizar

    Posted 09-01-2017 20:45
    Not the integration engine. I shut down the service checked for programs in task manager. Ran a sp_who2 in sql and dont see anything.


  • 4.  RE: Migrating the database - Parallel migration wizar

    Posted 09-01-2017 21:25
    3rd party products accessing the db?


  • 5.  RE: Migrating the database - Parallel migration wizar

    Posted 09-01-2017 21:48
    This is solved.. Yes Moira. I believe it is/was. They have a lot of third party products and I thought everything was shut down... Alerts & Workflows, Websitepipeline, Scanforce, True Commerce, et al. When I did an sp_who2 in SQL query mgr there was something accessing the Sage db. I didnt know if it was the migration wizard or something else. The migration wizard went through after I shut down the ""WinHTTP Web Proxy Auto-Discovery Service"". I believe, but not positive, that this service is used by WSP. I believe this is a web service API. Just glad it worked!