Follow

How to Install TX DWA or Upgrade to a Newer Version

Introduction

This document will outline the steps necessary to install TX DWA or upgrade your production environment to use a new version of TX DWA. It will cover the download and installation of the software, upgrading the project repository (if upgrading), and ensuring that the TX DWA Scheduler service for the new version is up and running. Note that the same procedure applies to tX2012 and TX2014.

Please see the separate TX DWA Prerequisites article for information on the settings and software you need to have on the machine to install TX DWA.

Step by Step

Download and Installation

If you are installing TX DWA for the first time, i.e. not upgrading from a earlier version, you can ignore steps 6-8.

  1. Download the latest version of TX DWA in the edition and bit-version you need.
  2. When the file has been downloaded, unzip the installation package and run Setup.exe.

    If all prerequisites has been met, you should be able to install using the .msi file in the downloaded archive. Using setup.exe is recommended, however, since it checks for the required version of the .NET Framework and installs it if necessary.
  3. On the welcome page, click Next.


  4. On the End-User License Agreement page, review the license agreement and select I accept the terms in the License Agreement if you do. Click Next.


  5. On the Choose Setup Type page, select Typical and click Next.


  6. On the Ready to Install page, click Install. Windows might ask you to confirm that you wish to make changes to the computer. If so, click Install the software. Wait for the installation to finish.


  7. Once the installation is completed, click Finish to close the setup program.


  8. Start TX DWA. There will be an icon on the desktop for TX DWA that you can doubleclick to launch the program. The first time TX DWA is opened it will prompt you for an activation code. Select Internet – I have a license code.


  9. On the following screen paste or type in your organization's activation code and click Send. This will synchronize with our licensing server and enable all your licensed features of TX DWA. upgrade2.png

  10. After activating the software, you will receive a warning  that the project repository settings are invalid.
    upgrade3.png

    Click OK to dismiss the warning, and on the next screen type in the server name that your current project repository resides on. Click the drop down arrow for the Database and select your current project repository. Click OK.


  11. If you are upgrading, TX DWA will recognize the old repository and prompt that it needs to be upgraded to be compatible with the new version of TX DWA. Click the Upgrade button. upgrade5.png

  12. You will then be prompted for the upgrade method. Select Web service. upgrade6.png

    The upgrade scripts will be downloaded and processed. TX DWA has now been installed and the project repository has been upgraded to be compatible with the new version of the software.
  13. Deploy and execute your project(s) using the new version to have the upgrade reflected in the actual project code. Validate the results before letting your end-users perform reporting on the upgraded projects data warehouse and/or cubes.

Setting Up the Scheduler Service

During the installation of TX DWA Server, a service is installed on the local machine that controls the execution packages. These execution packages handle the regular updates made to the data warehouse and the cubes. 

The service needs to be run by a user with sufficient user rights and configured to use the correct repository database. This can either be the same account that you use to develop your projects or a different service account (recommended). 

Follow the steps below to set up a new user account for use with the scheduler service. You can skip this if you are using the account you use for development or if you are upgrading and already have a user account set up with the correct repository settings.

  1. Make sure that the account has sufficient permissions.
    • On Analysis Services, Administrator rights (if you use OLAP Cubes).
    • On the msdb database, membership of the db_ssisadmin role.
    • On repository, staging and data warehouse databases, membership of the db_owner role.
  2. Log in with the user account, open and set up the repository database that contains the project you wish to schedule. This creates the necessary configuration files for the scheduler to run correctly.

With the user account configured, you are ready to set the service to start automatically with the correct username and password.

  1. Press the Windows button to bring up the start menu/start screen, type "services.msc" and press enter. This brings up a overview of Windows Services. upgrade7.png

  2. Right click the TX DWA Server Scheduler service and select "Properties".
  3. On the General tab the Startup Type should be set to "Automatic (Delayed Start)". If your version of Windows does not support this, select "Automatic" instead. upgrade8.png

  4. On the Log On tab a service account should be used. You can refer to the original TX DWA Scheduler service to determine which account was previously used. The password is required. upgrade9.png

  5. Click OK to save your changes and close the window.
  6. Right click on the TX DWA Server Scheduler service and click "Start".
  7. If you receive a message that the service started and then stopped the most common cause is that the TX DWA configuration files have not been created for the service account that was specified to start the service. The proper solution is to log on to the server using this service account, open TX DWA, and point to the project repository when prompted. This will create the configuration files required by the service account. You can now log off and log back on as the original user. You should now be able to properly start the service.

Uninstalling the Old Version

If you are upgrading from an earlier version, you can uninstall the old version of TX DWA once all of the previous steps have been successfully completed.


This article applies to: tX2012, TX2014, TX DWA.

Was this article helpful?
3 out of 3 found this helpful
Have more questions? Submit a request

16 Comments

  • 0
    Avatar
    Kes

    Er det korrekt at opsætning af Multiple Environment skal foretages igen efter opgradering til TX DWA ??

  • 0
    Avatar
    Thomas Lørup Duun

    Allow me to translate your question to English.

    Q: Is it correct that you need to reconfigure multiple environments after upgrading to TX DWA?

    A: You need to configure the new TX DWA Server Service to use the same credentials as the old server service did. Then you have to login as that user, start TX DWA, point it to that environments repository database and upgrade the repository. Then start the service, and your multiple environments are back in business.

     

  • 0
    Avatar
    Chris Shelley

    Do you need to update the SSIS folder options post Upgrade? Currrently I get errors where the SSIS folerd cannot eb found as it has changed names between installs:

    Was: TX2014Server\DevTest

    Now: TX DWA Server\DevTest

  • 0
    Avatar
    Thomas Lørup Duun

    Hi Chris,

    You can change the SSIS Root folder on the Edit Project screen if you need to. When you deploy the project the new folders should be created automatically though - so I wonder if you did not deploy but just executed after the upgrade?

  • 0
    Avatar
    Chris Shelley

    Hi Thomas,

    You are correct I have not redeployed as I was not aware that it was required post upgrade. Do i need to redeploy all elements in the repository? If so that should I feel be in the upgrade instructions.

    Also if I just redeploy will I not end up with 2 SSIS folders and duplicated packages.

    Thanks

     

    Chris

     

  • 0
    Avatar
    Thomas Lørup Duun

    Hi Chris,

    It is the deployment that translates your project into SQL Server code, so if you do not deploy, then the upgrade will not be reflected in the code being executed. And you are correct in your assumption about ending up with duplicate packages. Feel free to delete the old ones, once the upgrade is completed successfully.

    We will add the important deployment step to the instructions. Thanks for pointing our attention to it!

  • 0
    Avatar
    Jörgen Peerik | Victa

    Hi Thomas,

    Thanks for the explanation.

    What about servers which don't have an internet connection. Then the server is not able to download the latest upgrade scripts and I have to click on the button 'Local Files' instead of 'Web Service'. 

    How can I make sure the upgrade is done by using the latest scripts?

     

    Greetings,

    Jörgen Peerik

  • 0
    Avatar
    Thomas Lørup Duun

    Hi Jörgen,

    If the server is not connected to the internet, then you should use local files. If there is an issue with the files distributed with the release, then we have announced it on the support site. Actually version 16.4.2 is missing an upgrade file, which we have announced and released 16.4.3 in order to fix it.

    Kind regards,

    Thomas

  • 0
    Avatar
    Nicolas Cosma

    Hi Thomas,

    I have ugraded the application, but at the moment of choosing "select upgrade methode" by "web service, I had an error, with the choice local file, No problem

    Is it ok ?

  • 0
    Avatar
    Nicolas Cosma

    Thanks :)

  • 0
    Avatar
    Thomas Lørup Duun

    Local files in the latest version (as with most versions) is OK!

     

  • 0
    Avatar
    Martin OLoughlin

    I am currently looking at upgrading from TX2014 to the current release. As part of the testing i have installed TX2017 on my local machine, which is working fine and has allowed me to build a functional model, i have exported a model from the live system with the idea of importing to a local environment to get a feel for the process and identify any pitfalls. 

    However i am getting an error message "the project xml for generated in TX DWA server 14.2.6 The project can not be imported." 

    Is there something that prevents an upgrade? Is there a work around, ie upgrading to tx2015-tx2016-tx2017? 

  • 0
    Avatar
    Thomas Lørup Duun

    Hi Martin,

    To upgrade your 14.2.6 project you need to point TX DWA to the repository. It is not possible to upgrade using an export / import. 

    In your scenario, you could restore a backup of the repository database from the live system on your local system and then have TX DWA upgrade it. 

    If you need further assistance on this, please contact support; support@timextender.com 

     

  • 0
    Avatar
    Thomas Idelot

    Hi Thomas,

    Do you have any plans on making future upgrades more easy to perform ?

    It's not that complicated but it takes a lot of time nevertheless, I would really like to be able to upgrade In Place, meaning just launch a setup, click next/next/next and be done with it ;)

  • 0
    Avatar
    Thomas Lørup Duun

    Hi Thomas,

    Upgrade is launch setup, click next, next, next, finish. Then start TX DWA and if will perform an upgrade of the repository. To put the upgrade into effect you ofcourse need to deploy and execute the project. I do not see how we could make this simpler while still giving you the option to run side-by-side versions and possibility to perform rollbacks. 

  • 0
    Avatar
    Thomas Idelot

    Hi, 

    Thanks for the answer, and you're right as I said it is not that complicated.

    Maybe that's more a feeling as my Deploy&Execute can take a very long time (and i don't need rollback capability as I do a snapshot before the upgrade).

    Anyway, keep up the good work, it's always nice to see your tool evolve in the right direction :)

     

     

Please sign in to leave a comment.