Installing Harweb on the Windows platform with SQL Server database

Products

• CA Harvest Software Change Manager
• CA Harvest Software Change Manager - OpenMake Meister

Issue/Introduction

What is the procedure for installing Harweb on a Windows server?

Environment

CA Harvest SCM all versions

Resolution

The first thing to do when preparing to install Harweb on a Windows server is to check the Release Notes - Supportability Matrix page for the supported versions of Tomcat and Java.  For SCM 14.5, this is the link: CA Harvest SCM 14.5 - Supportability Matrix - Web Application Servers

The prerequisites you will need before installing Harweb are:

• Harvest SCM Client software - be sure the versions of the SCM Client and Harweb are the same
• Web Application Server - for example, Tomcat or JBoss.  Be sure to consult the Supportability Matrix for supported versions.
• Java - Be sure to consult the Supportability Matrix and the documentation for your Web Application Server for supported versions.  You will need the JDK instead of the JRE

Note: All of these components must be at the same bit level for a successful installation.  For example, if you install the 32-bit SCM Client, the Web Application Server software and Java must also be 32-bit.  Or, if one of the components is 64-bit, all must be 64-bit.

Note: For Harweb v14.5, download links for the needed components are at the bottom of this article.

After installing the prerequisites, ensure the following environment variables are properly set in your environment:

• CA_SCM_HOME=<Installation folder for Harvest SCM Client>
• CA_SCM_LOCALHOME=<Installation folder for Harvest SCM Client>
• HARVESTHOME=<Installation folder for Harvest SCM Client>
• JAVA_HOME=<Installation folder for Java>
• RTHOME=<installation folder for PEC>
• PATH (should include)
  • %JAVA_HOME%\bin
  • %RTHOME%\bin
  • %CA_SCM_HOME%\x86
  • %CA_SCM_HOME%

To begin the Harweb installation,

1. Copy the "Harweb" folder from your installation DVD image to your local computer, for example, to the C:\Installs folder.
   
   
2. Open a command prompt window, navigate to the place where you copied the Harweb folder, and execute "HarwebInstall.bat"
    
   
   
   1. Accept the license agreement by scrolling to the bottom of the license and clicking "I agree"
      
      
      
   2. Select the "New Installation" radio button and click "Next"
      
      
      
   3. Provide the broker name for your Harvest SCM Server installation and click "Next"
      
      
      
   4. Select the "Internal" authentication mode radio button and click "Next"
      
      
      
   5. Select the radio button type of Application Server you installed and click "Next" (in this example, we installed Tomcat)
      
      
      
   6. Provide the installation folder for your Application Server and click "Next"
      
      
      
   7. Select the radio button corresponding to the type of database that is hosting Harvest (in this example, we are using SQL Server)
      
      
      
   8. Provide the connection details that will allow Harweb to connect to your database.  When specifying the JDBC driver, navigate to the JDBC jar file you want to use and select that.  When ready, click "Next"
      
      
      
   9. Provide the login credentials for connection to the Harvest database and click "Next"
      
      
      
   10. Provide the path to a folder you want the Harweb installer to use for temporary files or accept the default setting and click "Next"
       
       
       
   11. Review your inputs on the Confirmation window.  If any changes are needed, use the "<Back" button to navigate back through the wizard and make any changes.  Otherwise, click "Finish" to begin the installation.
       
       
       
   12. You will see "Processing ended." on the "Wizard - Status" window when installation is complete.  At this point, click the "Close" button to exit the wizard.
       
       
       
3. Start Tomcat again.
   
   
   
4. Once Tomcat has restarted, navigate with your browser to the Harweb home page at "http://localhost:8080/harweb"
   
   
   

Troubleshooting:

Instead of the CA Harvest Software Change Manager login page, you might see something like this instead:

This is a very generic error that could have many different causes.  To gather more information about the problem, the first place to check is the Application Server log files.  For Tomcat, navigate to the <Tomcat installation folder>\log folder and review the *catalina*.log and the *stderr*.log.  You will find more information about the problem there.  Once you have identified a more specific error message, search our knowledge base or contact support for further assistance.

Additional Information

Tomcat 9 download:  https://tomcat.apache.org/download-90.cgi
Get: 32-bit/64-bit Windows Service Installer (pgp, sha512)

AdoptOpenJDK 11 download: https://adoptium.net/temurin/releases/?version=11&os=windows&arch=x64&package=jdk
Get the .msi

JDBC Driver for SQL Server: https://learn.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver15
Get: Download Microsoft JDBC Driver 12.6 for SQL Server (zip)