Clarity

Expand all | Collapse all

Problem with Jaspersoft server upgrade

Jump to Best Answer
  • 1.  Problem with Jaspersoft server upgrade

    Posted 05-02-2018 12:49 AM

    For clarity Upgrade 14.4, I have downloaded the files from CA Support.

    For Jaspersoft server upgrade it contains below files:
    ca_ppm_jaspersoft_6.4.2_5.4.2.15.zip
    ca_ppm_jaspersoft_patch_6.2.1_5.2.1.4.33.zip


    But in Upgrade document its asking to download Jaspersoft 6.1.0 installer and then install cumulative patch ca_ppm_jaspersoft_patch_6.1.0_5.1.0.2.31.zip

     

    Also the jaspersoft upgrade 6.4.2 required  tomcat8 where as jaspersoft 6.1.0 require tomcat7.

     

    Can you please let me know how should I proceed?

    Do i need to install Jaspersoft 6.1.0 and cumulative patch 6.1.0_5.1.0.2.31 OR I can install Jaspersoft Jaspersoft  6.4.2 and patch 6.2.1_5.2.1.4.33 (patch is of lower version than actual)?

    Will clarity 14.4 will support Jaspersoft 6.4.2?

     

    Thanks for your help.

     

     



  • 2.  Re: Problem with Jaspersoft server upgrade

    Posted 05-02-2018 02:32 AM

    Hi Amruta

     

    We have given option of Jaspersoft upgrade only from Jaspersoft 6.2.1 to Jaspersoft 6.4.2, but not from Jaspersoft 6.1.0. If you are on 14.4 you are supported to use Jaspersoft 6.4.2

     

    However I would like to let you know that at present we have 15.4 as the latest release and would request you to consider decision to take up 15.4 and not 14.4 

     

    Regards

    Suman Pramanik 



  • 3.  Re: Problem with Jaspersoft server upgrade

    Posted 05-02-2018 03:30 AM

    Hi Suman,

     

    We have upgraded Clarity to 14.4 but our current Jasper soft report server is 5.6.1 which we have to upgrade.

    So I can we directly upgrade to 6.4.2 or we need to upgrade 6.1.0 first?

    In case we need to upgrade to 6.1.0, I am not able to find any downloads for this on ca support site.(By following path given in upgrade document)

    Can you please let me know how can I get this installable?

    Thank you.



  • 4.  Re: Problem with Jaspersoft server upgrade

    Posted 05-02-2018 03:35 AM

    Hi Amruta,

     

    You need to install Jaspersoft 6.4.2 and export the organization from Jaspersoft 5.6.1 and import to Jaspersoft 6.4.2

     

    There is no in place support of Jaspersoft from 5.6.1 to Jaspersoft 6.4.2

     

    Export, Import, or Migrate Advanced Reporting Content - CA PPM - 15.4 - CA Technologies Documentation 

     

    Regards

    Suman Pramanik 



  • 5.  Re: Problem with Jaspersoft server upgrade

    Posted 05-02-2018 04:52 AM

    And is there any need to install below patch after Jasper soft 6.4.2 which is also part of installable:

     

    ca_ppm_jaspersoft_patch_6.1.0_5.1.0.2.31.zip



  • 6.  Re: Problem with Jaspersoft server upgrade

    Posted 05-02-2018 05:20 AM

    HI Amruta

     

    if you install Jaspersoft 6.4.2 there is no need for any patch. That patch was when we used to support Jaspersoft 6.1 

     

    Regards

    Suman Pramanik



  • 7.  Re: Problem with Jaspersoft server upgrade

    Posted 05-02-2018 07:58 AM

    I am getting error while I am trying to upgrade to jasper soft 6.4.2. log file attached.

    I am trying to run upgrade on previously configured db/user.

    Please let me know what is going wrong?



  • 8.  Re: Problem with Jaspersoft server upgrade

    Posted 05-02-2018 08:03 AM
    E:\Jaspersoft\jaspersoft_64254215>install.bat
    E:\Jaspersoft\jaspersoft_64254215>ECHO Off
    Buildfile: E:\Jaspersoft\jaspersoft_64254215\install.xml
    Trying to override old definition of task java
    init:
    Updating property file: E:\Jaspersoft\jaspersoft_64254215\buildomatic\default_ma
    ster.properties
    checkOS:
    startInstall:
    -------------------------------------------------------------
    PLATFORM SUPPORT FOR JASPERSOFT 6.4.2:
    - Java                  : JDK 1.8 (64-bit)
    - Application Server    : Apache Tomcat 8.5.20 or higher.
    - Oracle RDBMS          : 11g R2 or 12c R2
    - Microsoft SQL Server  : 2014
    -------------------------------------------------------------
    Select Installation Type
     1) Fresh Installation
     2) Upgrade
    Choose option [1]:
    2
    Log File: E:\Jaspersoft\jaspersoft_64254215\install_0182/5/_130522.log
    Installation Type selected: upgrade

    Select Upgrade Method
     1) New DB Upgrade - New Jaspersoft Report Server database will be used for upgr
    ading to v6.4.2
     2) Same DB (In-place) Upgrade - Existing Jaspersoft Report Server database will
     be upgraded to v6.4.2
    Choose option [1]:
    2
    Trying to override old definition of task java
    reloadProps:
    checkOS:
    getAppServerInfo:
    Enter Apache Tomcat 8.5 Directory [E:\Jaspersoft\apache-tomcat-8.5.23] :

    Enter Jaspersoft Web App Name [reportservice] :

    Enter Jaspersoft Web App Port [8080] :
    Do you wish to configure Email? (y, [n])
    n
    Updating property file: E:\Jaspersoft\jaspersoft_64254215\buildomatic\default_ma
    ster.properties
    getDataBaseInfo:
    Select Installation Mode
     1) Standalone
     2) Cluster
    Choose option [1]:
    Updating property file: E:\Jaspersoft\jaspersoft_64254215\buildomatic\default_ma
    ster.properties
    Select Database Type
     1) Oracle
     2) MSSQL
    Choose option [1]:

    Select Oracle Database Type
     1) Oracle Standalone
     2) Oracle Cluster(RAC)
    Choose option [1]:

    Enter Oracle Database Hostname [****] :

    Enter Oracle Database Port Number [1521] :
    ***
    Enter Jaspersoft Database Username :
    ***
    Enter Jaspersoft Database Password :
    ***
    Enter Oracle SID Name :
    ****
    Validating Jaspersoft Database Connection....
    Jaspersoft Database Connected Successfully.
    Validating Jaspersoft Database Version....
    Jaspersoft Database Version is Oracle 12.1.0.2.0
    Updating property file: E:\Jaspersoft\jaspersoft_64254215\buildomatic\default_ma
    ster.properties
    Updating property file: E:\Jaspersoft\jaspersoft_64254215\buildomatic\default_ma
    ster.properties
    upgradeInfo:

    -------------------------------------------------------------
    INFORMATION:
    This will result in Upgrade to Jaspersoft 6.4.2
    Before starting, please do the following:
    - Take backup of existing Jaspersoft content.
    - Take Backup of existing Jaspersoft instance (webapp) and database (Database/Sc
    hema).
    -------------------------------------------------------------

    Do you want to continue the upgrade? (y, n)
    y
    checkDefaultValues:
    upgrade:
    Updating property file: E:\Jaspersoft\jaspersoft_64254215\buildomatic\default_ma
    ster.properties
    BUILD FAILED
    E:\Jaspersoft\jaspersoft_64254215\install.xml:305: The following error occurred
    while executing this line:
    E:\Jaspersoft\jaspersoft_64254215\install.xml:1017: java.io.FileNotFoundExceptio
    n: E:\Jaspersoft\jaspersoft_64254215\install_0182\5\_130522.log (The system cann
    ot find the path specified)
            at java.io.FileOutputStream.open0(Native Method)
            at java.io.FileOutputStream.open(FileOutputStream.java:270)
            at java.io.FileOutputStream.<init>(FileOutputStream.java:213)
            at java.io.FileOutputStream.<init>(FileOutputStream.java:162)
            at org.apache.tools.ant.taskdefs.optional.EchoProperties.execute(EchoPro
    perties.java:353)
            at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)
            at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
    sorImpl.java:43)
            at java.lang.reflect.Method.invoke(Method.java:498)
            at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.jav
    a:106)
            at org.apache.tools.ant.Task.perform(Task.java:348)
            at org.apache.tools.ant.Target.execute(Target.java:435)
            at org.apache.tools.ant.Target.performTasks(Target.java:456)
            at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1393)
            at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(Single
    CheckExecutor.java:38)
            at org.apache.tools.ant.Project.executeTargets(Project.java:1248)
            at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:441)
            at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)
            at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)
            at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
    sorImpl.java:43)
            at java.lang.reflect.Method.invoke(Method.java:498)
            at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.jav
    a:106)
            at org.apache.tools.ant.Task.perform(Task.java:348)
            at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:68)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
    java:62)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
    sorImpl.java:43)
            at java.lang.reflect.Method.invoke(Method.java:498)
            at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.jav
    a:106)
            at org.apache.tools.ant.Task.perform(Task.java:348)
            at com.niku.tools.taskdefs.ChooseTask.execute(Unknown Source)
            at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292)
            at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
    sorImpl.java:43)
            at java.lang.reflect.Method.invoke(Method.java:498)
            at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.jav
    a:106)
            at org.apache.tools.ant.Task.perform(Task.java:348)
            at org.apache.tools.ant.Target.execute(Target.java:435)
            at org.apache.tools.ant.Target.performTasks(Target.java:456)
            at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1393)
            at org.apache.tools.ant.Project.executeTarget(Project.java:1364)
            at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExe
    cutor.java:41)
            at org.apache.tools.ant.Project.executeTargets(Project.java:1248)
            at org.apache.tools.ant.Main.runBuild(Main.java:851)
            at org.apache.tools.ant.Main.startAnt(Main.java:235)
            at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280)
            at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109)
    Total time: 1 minute 12 seconds
    DONE


  • 9.  Re: Problem with Jaspersoft server upgrade

    Posted 05-02-2018 08:34 AM

    Hi Amruta

     

    From which version you are upgrading Jaspersoft, from the discusssion it looks you were on 5.6.1 and there is no inplace upgrade support from that version.

     

    Regards

    Suman Pramanik 



  • 10.  Re: Problem with Jaspersoft server upgrade

    Posted 05-02-2018 08:40 AM

    Hi Suman,

     

    Even if I try with Installation Type as Fresh installation. Its giving me same error.

    I am using old database user for this installation.

    Can it be the reason behind this failure?

    Thank you.



  • 11.  Re: Problem with Jaspersoft server upgrade

    Posted 05-02-2018 08:56 AM

    Did you drop the database and created the user again. Once an installation is failed you need to drop the same and create the database user and start fresh 



  • 12.  Re: Problem with Jaspersoft server upgrade

    Posted 05-03-2018 06:54 AM

    Yes I have created new users with blank schema, extracted tomcat and jaspersoft again but still its giving same error:

    E:\Jaspersoft\jaspersoft_64254215\install.xml:1017: java.io.FileNotFoundException: E:\Jaspersoft\jaspersoft_64254215\install_0182\5\_130522.log (The system cannot find the path specified)

    install_0185 folder is not present in myjaspersoft directory.

    Do you have any idea what could be the reason?



  • 13.  Re: Problem with Jaspersoft server upgrade

    Posted 05-03-2018 09:05 AM

    Amruta,

    Are you running the installer from that "E:\Jaspersoft..." directory?  Or is the installer actually somewhere else, and thats just the directory you are telling it to install into?  Also have you copied the install files to a local directory at the root of a drive?

    I have come across some odd issues with the jasper installer over the past few years, so generally what I do now is copy the entire contents of the install media into a folder on the root of an actual drive, such as "C:\jspr" - and then I edit the properties file there etc, then kick off the installer from that folder.  I have had pretty good luck with doing it that way.  

    Just a thought... let us know.

    Also, can you share your properties file with us?

    Thanks,

    Jon



  • 14.  Re: Problem with Jaspersoft server upgrade

    Posted 05-03-2018 10:00 AM

    There is a case being worked and the suspect is multiple java in the server and once its sorted we will update the same. 



  • 15.  Re: Problem with Jaspersoft server upgrade

    Posted 05-03-2018 10:36 AM

    Hi Jon,

    We have kept all the paths short, tried uninstalling/installing java still we are facing the same issue.

    Please find below the system variables:

    ALLUSERSPROFILE=C:\ProgramData
    APPDATA=C:\Users\Administrator\AppData\Roaming
    AppRoot=C:\PROGRA~2
    CLIENTNAME=WPH00147
    CommonProgramFiles=C:\Program Files\Common Files
    CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files
    CommonProgramW6432=C:\Program Files\Common Files
    COMPUTERNAME=*****
    ComSpec=C:\Windows\system32\cmd.exe
    COPYCMD=/Y
    Country=BE
    CV_Instance001=C:\Program Files\simpana-BUCV\Base
    DataRoot=D:\Data
    DEFLOGDIR=C:\ProgramData\McAfee\DesktopProtection
    Environment=XBOW
    FP_NO_HOST_CHECK=NO
    GlobalRegRoot=SOFTWARE\Fortis
    HOMEDRIVE=C:
    HOMEPATH=\Users\Administrator
    HostName=*****
    JAVA_HOME=C:\Java
    JRE_HOME=C:\jre8
    LOCALAPPDATA=C:\Users\Administrator\AppData\Local
    LOGONSERVER=\\******
    LogRoot=C:\LogFiles
    NLSPATH=C:\Program Files\IBM\SCM\msg\%L\%N.cat;C:\Program Files\IBM\SCM\msg\C\%N
    .cat
    NUMBER_OF_PROCESSORS=2
    OS=Windows_NT
    OSType=W8S
    Path=C:\ProgramData\Oracle\Java\javapath;C:\Java\bin;C:\jre8\bin;C:\OracleBaseCl
    ient12\Ora12\bin;C:\Oracle\Ora11\bin;C:\Windows\system32;C:\Program Files (x86)\
    Installation Engine-IPST;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32
    \WindowsPowerShell\v1.0\;C:\Tools\SysTools;C:\Tools\PubTools;C:\Program Files (x
    86)\NTRK;C:\Program Files\SupportTools;C:\Program Files (x86)\Runtime\;C:\Progra
    m Files (x86)\Perl\site\bin;C:\Program Files (x86)\Perl\bin
    PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
    PROCESSOR_ARCHITECTURE=AMD64
    PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 63 Stepping 2, GenuineIntel
    PROCESSOR_LEVEL=6
    PROCESSOR_REVISION=3f02
    ProfileRoot=C:\Users
    ProgramData=C:\ProgramData
    ProgramFiles=C:\Program Files
    ProgramFiles(x86)=C:\Program Files (x86)
    ProgramW6432=C:\Program Files
    PROMPT=$P$G
    PSModulePath=C:\Windows\system32\WindowsPowerShell\v1.0\Modules\
    PUBLIC=C:\Users\Public
    PubTools=C:\Tools\PubTools
    SCM_CLIENT_INST_DIR=C:\Program Files\IBM\SCM\client
    SCM_HOME=C:\Program Files\IBM\SCM
    SESSIONNAME=RDP-Tcp#0
    SystemDrive=C:
    SystemRoot=C:\Windows
    SysTools=C:\Tools\SysTools
    TEMP=C:\TEMP\2
    TISDIR=C:\Program Files\IBM\SCM\codeset
    TMP=C:\TEMP\2
    ToolsRoot=C:\Tools
    UATDATA=C:\Windows\CCM\UATData\D9F8C395-CAB8-491d-B8AC-179A1FE1BE77
    USERDOMAIN=STAW0685
    USERDOMAIN_ROAMINGPROFILE=STAW0685
    USERNAME=Administrator
    USERPROFILE=C:\Users\Administrator
    VSEDEFLOGDIR=C:\ProgramData\McAfee\DesktopProtection
    windir=C:\Windows
    windows_tracing_flags=3
    windows_tracing_logfile=C:\BVTBin\Tests\installpackage\csilogfile.log
    XbowEnvironment=T

    Please let me know if you find anything troublesome.

    thanks for your reply.



  • 16.  Re: Problem with Jaspersoft server upgrade

    Posted 05-04-2018 07:09 AM

    The problem appears to be environmental. Perhaps the effect of the previous java versions still installed on the machine (6,7) or the previously installed jaspersoft 5.6 service that is registered on windows. Let's have these cleanly uninstalled, since windows need a registry cleanup etc. Java 8 and the current jaspersoft install directories looks shortened enough. 

     

    i.e.JAVA_HOME=C:\Java
    JRE_HOME=C:\jre8

     

    But adjust the path variable so that %JAVA_HOME%\bin;%JRE_HOME%\bin is added. 

     

    Also the following excerpt from google search on how to deal with the FileNotFoundException in java:

    • If the message of the exception claims that there is no such file or directory, then you must verify that the specified is correct and actually points to a file or directory that exists in your system.
    • If the message of the exception claims that permission is denied then, you must first check if the permissions of the file are correct and second, if the file is currently being used by another application.
    • If the message of the exception claims that the specified file is a directory, then you must either alter the name of the file or delete the existing directory (if the directory is not being used by an application).


  • 17.  Re: Problem with Jaspersoft server upgrade

    Posted 05-04-2018 08:11 AM

    Thanks Sanish - thats a great find!!

    @Amruta23  - did that help?



  • 18.  Re: Problem with Jaspersoft server upgrade
    Best Answer

    Posted 05-07-2018 05:17 AM

    Thanks Sanish.

     

    I have created the folder path in which it was trying to find file and then the installation got completed successfully.



  • 19.  Re: Problem with Jaspersoft server upgrade

    Posted 05-07-2018 06:34 AM

    After successful installation I have run the command : admin content csk

    and then : admin content-jaspersoft csk -userName superuser -password superuser -retryCount 50

    But now i am getting error:

    Data Warehouse Bean DS URL : jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=))(CONNECT_DATA=(SID=)(SERVER=dedicated)))
    ERROR 07-05 12:16:22,742 - Exception on initialization of encryption service-
    java.io.IOException: Keystore was tampered with, or password was incorrect.

    I have correctly updated organization name "BNPPF"and done the keystore replace.

    Can you please tell me what could be the problem?

    Note: Previously the keystore files were created as bnppf.jks/bnppf.properties

    This time they are BNPPF.jks/properties