Upgrading the Tomcat application

As a TrueSight Smart Reporting administrator, you can upgrade your Tomcat application.

The TrueSight Smart Reporting installer does not include a Tomcat upgrade. Ensure that you monitor and control Tomcat upgrades to mitigate security risks.

Do the following:

1. Download a Tomcat application to a 9.0.x version that is later than 9.0.30 from the following website:
   https://tomcat.apache.org/download-90.cgi

2. Extract the Tomcat files to a new location, and note the location.
3. Stop the TrueSightSmartReporting service.
4. Back up the following folders and file and save them in a safe location:
   • <install_directory>/appserver/lib
   • <install_directory>/appserver/bin
   • <install_directory>/appserver/conf/server.xml
5. (Windows) Remove any files from the <install_directory>/appserver/bin folder that have tomcatX in the file name, where X is the version of Tomcat.
   For example, tomcat7.exe, tomcat7.exe.x64, tomcat7w.exe.
6. Remove all files from the <install_directory>/appserver/lib directory.
7. Browse to the location where you extracted Tomcat and copy the contents of the /lib folder into the <install_directory>/appserver/lib directory.
8. Browse to the location where you extracted Tomcat.
9. From the /bin directory, copy the following files and paste them into the <install_directory>/appserver/bin folder:
   • All .jar files.
     If there are any files with the same name, replace them.
   • (Windows) All tomcatx executable files, where x is the version number.
     For example tomcat7.exe, tomcat7.exe.x64, and tomcat7w.exe
10. (Windows) Install the TrueSight Smart Reporting service. Complete the following steps:
    1. Delete the existing TrueSight Smart Reporting Windows service by running the following command:
       sc delete TrueSightSmartReporting
    2. Browse to the Tomcat folder that you extracted.
    3. From the /bin folder, copy the service.bat file and paste it in the <install_directory>/appserver/bin folder.
       If the file already exists in this folder, replace it.
    4. Go to the backup folder and open the <backup_directory>/appserver/bin/service.bat file.
    5. Copy all the lines between setlocal and set "SELF=%~dp0%service.bat.

    6. Paste the lines in the <install_directory>/appserver/bin/service.bat file, above the set "SELF=%~dp0%service.bat line.

       Example

       setlocal

       rem ---------------------------------------------------------------------------
       rem TrueSight Smart Reporting Options

       rem set JRE_HOME to value chosen in installer
       set JRE_HOME=C:\Program Files\Java\jre1.8.0_191

       rem Memory limits.
       rem Set JvmMs to minimum JVM stack size (in Mb)
       rem Set JvmMx to maximum JVM stack size (in Mb)
       set JAVA_OPTS=%JAVA_OPTS% --JvmMs 1024 --JvmMx 8192

       rem Fixes for JPivot compatibility with Axis and Java 1.6
       set JVM_OPTS=-Djavax.xml.soap.MessageFactory=org.apache.axis.soap.MessageFactoryImpl
       set JVM_OPTS=%JVM_OPTS%;-Djavax.xml.soap.SOAPConnectionFactory=org.apache.axis.soap.SOAPConnectionFactoryImpl
       set JVM_OPTS=%JVM_OPTS%;-Djavax.xml.soap.SOAPFactory=org.apache.axis.soap.SOAPFactoryImpl
       rem set JVM_OPTS=%JVM_OPTS%;-Djavax.xml.transform.TransformerFactory=org.apache.xalan.processor.TransformerFactoryImpl

       rem If you are experiencing "java.lang.OutOfMemoryError: PermGen space"
       rem errors, uncomment the following line:
       rem set JVM_OPTS=%JVM_OPTS%;-XX:PermSize=64m;-XX:MaxPermSize=1024m

       rem Uncomment these options if you are experiencing performance issues with OLAP data sources
       rem set JVM_OPTS=%JVM_OPTS%;-Dorg.olap4j.driver.xmla.XmlaOlap4jCube.lazyLoadMeasures=true
       rem set JVM_OPTS=%JVM_OPTS%;-Dorg.olap4j.driver.xmla.XmlaOlap4jCellSet.lazyMemberLookup=true

       rem Uncomment this line if connections to Microsoft SQL Server Azure hang when using the jTDS driver
       rem set JVM_OPTS=%JVM_OPTS%;-Djsse.enableCBCProtection=false

       rem ---------------------------------------------------------------------------

       set "SELF=%~dp0%service.bat
    7. Repeat the process for the following lines that are available below the "%EXECUTABLE%" //IS//%SERVICE_NAME% ^ line:
       • Description "The TrueSight Smart Reporting application server provides web-based access to view, analyze, and report on data from TrueSight solutions." ^
       • DisplayName "%DISPLAYNAME%" ^
11. Open the <install_direcotory>/appserver/conf/server.xml file.
12. Search for the Connector tag and add the following parameter at the end of the tag:
    server="Application Server"
    For example, see the following image:
    
    
    
13. Navigate to the <install_directory>/appserver/bin directory, and run the following command:
    Service install TrueSightSmartReporting
14. Start the TrueSightSmartReporting service.
15. Confirm that TrueSight Smart Reporting runs with the Tomcat version that you need.
16. Use the following URL for your application server details:
    https://<hostname>:<port>/info.jsp