CABI Import of data fails

Products

• Spectrum

Issue/Introduction

When trying to import a jasperserver backup (configuration export) the import is failing with the following:

"The Import failed due to an invalid encryption key. Please refer to the JasperReports Server Security Guide for more information."

Environment

Release : 22.2

Cause

Resolution

In place of using the UI to Export and Import the configuration data, Tibco suggested using the js-import.sh and js-export.sh scripts in the buildomatic folder.

Performed the following Steps

- Exported the Configuration data using the js-export.sh script as suggested by Tibco

   cd /opt/CA/SharedComponents/CABI/buildomatic/
   ./js-export.sh --everything --output-zip export03312023_7.9.1.zip --keyalias deprecatedImportExportEncSecret 

  ***Note*** We had to increase the memory in buildomatic/bin/js-import-export.sh from -Xmx512m to
                     -Xmx6144m  as the export was failing with OOM errors. Watching via top we had to increase
                     it a few times and saw it top out at 5.3g of memory

             export JAVA_OPTS="$JAVA_OPTS -Xms128m -Xmx6144m -Djava.net.preferIPv4Stack=true -noverify"

 

- Shutdown and removed CABI to cleanly install 7.9.2.1
      cd /opt/CA/SharedComponents/CABI/
      ./stopServers.sh

      cd /root
      rm -f .cabusinessintelligence

      cd /var
      rm -f .com.zerog.registry.xml

      cd /opt/CA
      rm -R SharedComponents

- Ran the installer for 7.9.2.1
    cd /tmp/installers/CABI_7.9.2.1/
    ./setup.sh -f install.properties -i silent

   Install completed ok

- Started CABI
      cd /opt/CA/SharedComponents/CABI/   
      ./startServers.bat

- Ran the spectrumconfiginstaller.jar
     cd /opt/CA/SharedComponents/CABI/java/bin/
     ./java -jar /opt/CA/installs/spectrumconfiginstaller.jar -install

- From OneClick Web
      Administration ~~> Report Manager ~~> Jasper Integration
      Clicked Save (information already populated)

- Proceeded with the Jasper Import

    cd /opt/CA/SharedComponents/CABI/buildomatic
    ./js-import.sh --input-zip export03312023_7.9.1.zip --keyalias deprecatedImportExportEncSecret

    **Note** Increased the memory in js-import-export.sh due to the size of the import file.

The IMPORT COMPLETED SUCCESSFULLY!!

Additional Information

• 
  
  At the time of export, please run the below command in the buildomatic of JRS 7.1.1:
  
  js-export.bat --everything --output-zip export111.zip --keyalias deprecatedImportExportEncSecret --> where export111.zip is the name of the zip file that will be generated after the export operation.
  
  
  At the time of import, please run the below command in the buildomatic of JRS 7.9.2:
  js-import.bat --input-zip export111.zip --keyalias deprecatedImportExportEncSecret    ---> This same file would be used at the time of import into JRS 7.9.2.

 

• You may see this message at the time of import

 

Unable to locate tools.jar. Expected to find it in /opt/CA/SharedComponents/CA_Business_Intelligence/java/lib/tools.jar

Result: 128

 

This can be safely ignored and is does not mean the import has failed.

 

• If you see below error during export / import ( this was observed on 7.1.1.1 release)

Option keyalias is not recognized.

Run the command again without the --keyalias deprecatedImportExportEncSecret:
js-export.bat --everything --output-zip export.zip