Automic Workload Automation

  • 1.  Upgrade from 10.4 to 11.2 - Advice Wanted

    Posted Aug 02, 2017 11:40 AM
    Current AE server runs on Windows 2008 R2, current DB MSSQL 2008 R2 10.50.  New windows server 2016 stood up for AE but using same version of MSSQL for DB.

    What is the best approach to upgrading from 10.4 to 11.2 under this scenario.  Can I copy AE 10.4 from old windows to new windows, then do an upgrade install for AE and DB?  Can I do a new install for AE on new server, but do upgrade install on the DB?  what is the best approach?


  • 2.  Upgrade from 10.4 to 11.2 - Advice Wanted

    Posted Aug 02, 2017 12:11 PM
    When we moved from V9 to V11.2, we did a full cutover to a new server with the latest windows and the latest SQLServer.  We hired an Automic services person to help us who knew how.  In fact he was instrumental in helping us decide what the "best" way to upgrade might be.  Hiring an expert saved us a lot of time and a lot of trial-and-error.

    The cutover steps included;
    1. build a new server and standing up a new AE on it.
    2. bring across client 0000 modifications. (e.g. templates)
    3. manually review and update all custom settings, including addressing some brand new system options.
    4. stand up parallel agents on our remote servers so the old and new AEs can run in parallel.
    5. for each client, use transportcase to bring across all USER and USER_GROUP objects. (prerequisite of next step)
    6. for each client, use transportcase to bring across all other objects.

    A drawback of doing a cut-over was not having much run history in the primary system.  But that is a short term problem.

    By doing a cut-over we avoided any lengthy downtime for database conversion, and we had higher confidence that the new system we were cutting over to was ready to rock and roll.


  • 3.  Upgrade from 10.4 to 11.2 - Advice Wanted

    Posted Aug 02, 2017 11:14 PM
    FYI: AE 11.2 only support some DB Server as below: 
    • IBM DB2 10.5 
    • IBM DB2 11.1 
    • Microsoft SQL Server 2012 (Manufacturer End Of Life since 2017-07-11)
    • Microsoft SQL Server 2014 
    • Microsoft SQL Server 2016 
    • Oracle Oracle 11g (Manufacturer End Of Life since 2015-01-15)
    • Oracle Oracle 12c 
    As Pete mentions, I would suggest you upgrade MSSQL to the newest version also.
     
    https://docs.automic.com/tools/compatibility_matrix?compatibility-mode=component&offering_version_id=1478682368945&lifecycle_entity_id=1409143059253&component_id=1409731986667&version_id=1478682352880 


  • 4.  Upgrade from 10.4 to 11.2 - Advice Wanted

    Posted Sep 18, 2017 03:01 PM
    petwirGood information there. I don't understand at which point your AE objects would have been upgraded, though. In your source AE system, they were version 9, and in your destination system, they need to be 11.2. At what point do they get the necessary schema upgrade changes, which is the step that takes the most time during an upgrade? Did you have a step "7" that was essentially upgrading the newly stood up AE from v9 to v11.2 once all the objects had been copied over, during which time your existing source AE was still running in parallel, executing jobs on their schedules and such?


  • 5.  Upgrade from 10.4 to 11.2 - Advice Wanted

    Posted Sep 18, 2017 05:20 PM
    The upgrade was automatic with the use of transportcase to migrate the code from V9 to V11.2.