Clarity

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.

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 

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.

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 

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

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

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?

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 

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.

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 

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?

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

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

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.

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

Thanks Sanish - thats a great find!!

@Amruta23  - did that help?

Thanks Sanish.

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

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