How to Upgrade the Remedy Smart Reporting Bundle Tomcat from 8 to 9 ?

This knowledge article may contain information that does not apply to version 21.05 or later which runs in a container environment. Please refer to Article Number 000385088 for more information about troubleshooting BMC products in containers.
 

1.  Download Tomcat zip file from below location

        3.  Stop Smart Reporting service.
         4. Backup the following folders or files and copy them to a safe location. You might need them if Tomcat upgrade process fails.

• <BMC Remedy Smart Reporting installation directory>\appserver\lib
• <BMC Remedy Smart Reporting installation directory>\appserver\bin
• <BMC Remedy Smart Reporting installation directory>\conf\server.xml 

5. For Windows Service only, copy the existing Java options from service.properties by performing following steps. For Linux service, skip the following steps (a-c).

1. Open the command prompt and change working directory to <BMC Remedy Smart Reporting installation directory>\appserver\bin.
2. To open service.properties window, run the following command:  

tomcat8w.exe //ES//BMCSmartReporting

3. Open Java Tab and copy everything from the Java Options box and paste it in a text file.

6.   In the <BMC Remedy Smart Reporting installation directory>\appserver\bin folder, if any of the files mention Tomcat version number, remove them. For example, tomcat8.exe, tomcat8.exe.x64, tomcat8w.exe.
7.   Remove all files from the <BMC Remedy Smart Reporting installation directory>\appserver\lib directory.
8.   From your downloaded Tomcat installer folder (mentioned in step 2), copy the contents of the \lib folder to your <BMC Remedy Smart Reporting installation directory>\appserver\lib directory.
9.   From your downloaded Tomcat installer\bin folder (mentioned in step 2),  copy all the .jar files and any files which have Tomcat version number (Tomcat9, Tomcat9w etc.), and place them in <BMC Remedy Smart Reporting installation directory>\appserver\bin. Replace any files with same name. 
10.     Open the <BMC Remedy Smart Reporting installation directory>\conf\server.xml file and perform the following tasks:

1. Remove the following lines, and save the file.

<!--Initialize Jasper prior to webapps are loaded. Documentation at /docs/jasper-howto.html -->
<Listener className="org.apache.catalina.core.JasperListener" />

2. In the server.xml,  update the protocol as follows:

“protocol="org.apache.coyote.http11.Http11NioProtocol”

11.     (Optional) Start BMC Remedy Smart Reporting service via startup.bat. Perform this step just to confirm that you can start BMC Remedy Smart Reporting service by using the startup files.
12.   After starting the BMC Remedy Smart Reporting service, navigate to http://<SR_Server>:<SR_Port>/info.jsp and check if the new tomcat version is updated.
13.     Stop BMC Remedy Smart Reporting service if started.
14.    To remove the current Smart Reporting Widows Service, open the command prompt and type the following command:

sc delete <Smart Reporting Service Name>

15.  From your downloaded Tomcat installer\bin folder (mentioned in step 2), copy the service.bat  file and place it in the <BMC Remedy Smart Reporting installation directory>\appserver\bin folder. The existing  service.bat  file in the <BMC Remedy Smart Reporting installation directory>\appserver\bin folder is replaced with the new one.
16.     From the <BMC Remedy Smart Reporting installation directory>\appserver\bin folder, open the service.bat and add in the following code above set "SELF=%~dp0%service.bat"

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

    rem Smart Reporting Options

    rem set JRE_HOME to value chosen in installer

    set JRE_HOME=C:\Program Files (x86)\Java\jre1.8.0_40

    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 2048

    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=256m

    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 ---------------------------------------------------------------------------

17.     Install the new Smart Reporting service by performing the following steps.

1. Open the command prompt. and navigate to <BMC Remedy Smart Reporting installation directory>\appserver\bin.
2. Run the command: service.bat install BMCSmartReporting
3. Check if the new Smart Reporting service is installed. The service name could be Apache Tomcat 9.X BMCSmartReporting.

1. Open the command prompt and change the working directory to <BMC Remedy Smart Reporting installation directory>\appserver\bin
2. To open the service.properties window, run the command – tomcat9w.exe //ES//BMCSmartReporting
3. Open Java Tab and paste the values (copied in step 5c) in the Java Options box.
4. Check the initial and maximum memory pool and modify values accordingly, these are memory heap size values.
5. Open the General Tab and change Display Name to BMC Smart Reporting and Description as BMC Reporting Application Server
6. Review the changes and Click on OK