Unable to add CABI (6.4.3) as Data Source to CA Performance Center(3.7.10)

[Himanshu Patel]

Hi, 

I'm unable to add CABI as Data Source to CA Performance Center

CABI version is 6.4.3 and CAPM version is 3.7.10

During the adding into the Data source I'm using Username: superuser and Password: superuser.  

Any help will be appreciated. 

Thanks 

[Catalin Farcasanu]

Did you follow the install procedure? You have to download a reports file to CABI machine, run an installation where you specify the pc guid and then run the integration from PC.

------------------------------
Senior Consultant
SolvIT Networks
------------------------------

[Himanshu Patel]

Hi Catalin, 
Thank you for your response.
Yes, I've followed the install procedure.
I've downloaded the report file from CA PC and uploaded the on the CABI host into the installation folder and run the installation. (./install.sh).
Unfortunately, I'm encountering the error. ( Please find below the log file and error picture.)

Thank you

------------------------------
IT support
------------------------------

Attachment(s)

install.log   9 KB 1 version

[Catalin Farcasanu]

You should have a .log file in the folder from where you run the installation. The keystore errors are not the ones that generate the failure. It's normal to have them re-created.

------------------------------
Senior Consultant
SolvIT Networks
------------------------------

[Himanshu Patel]

Hi Catalin, 


Installation logs: 
********************************************************************************************************************************

.. Using /opt/CA/SharedComponents/CA Business Intelligence

javapath is /opt/CA/SharedComponents/CA Business Intelligence/jre/bin/java

Java has been found: /opt/CA/SharedComponents/CA Business Intelligence/jre/bin/java

Default Postgres database user is: postgres

Default Postgres database port is: 5432

Default Postgres database is already running

Tue 05/19/2020 14:10:06.200     logger initialized

Tue 05/19/2020 14:10:06.200     args.length=1

Tue 05/19/2020 14:10:06.200     args[0]=-checkReportAndDSExistence

Tue 05/19/2020 14:10:06.200     checkReportAndDSExistence(): DS - capm_da-1.3.0.zip

Tue 05/19/2020 14:10:06.200     checkReportAndDSExistence(): Report - capm_topn-1.3.0.zip

Tue 14:10:06 -  ... Stopping Tomcat server

Default Tomcat server port is HTTP/1.1

Default Tomcat server is already stopped

... Modifying reports

Tue 05/19/2020 14:10:06.309     logger initialized

Tue 05/19/2020 14:10:06.309     args.length=1

Tue 05/19/2020 14:10:06.309     args[0]=-modifyReportDS

Tue 05/19/2020 14:10:06.309     CAPC URL =http://10.0.0.91:8181/pc/center/webservice/datasources/performanceCenterGUID

Tue 05/19/2020 14:10:06.309     CA PC GUID is 36aef83d-136e-4bdf-ad4a-181498cbfdf4

Tue 05/19/2020 14:10:06.309     PC GUID = 36aef83d-136e-4bdf-ad4a-181498cbfdf4

Tue 05/19/2020 14:10:06.309     modifyReportDS(): host - 10.0.0.91

Tue 05/19/2020 14:10:06.309     modifyReportDS(): GUID - 36aef83d-136e-4bdf-ad4a-181498cbfdf4

Tue 05/19/2020 14:10:06.309     modifyReportDS(): port - 8181

Tue 05/19/2020 14:10:06.309     modifyReportDS(): schema  - http

Tue 05/19/2020 14:10:06.309     unzip(): file - /opt/CA/SharedComponents/CA Business Intelligence/capm_cabi_report/capm_topn-1.3.0.zip

Tue 05/19/2020 14:10:06.309     unzip(): output folder - /opt/CA/SharedComponents/CA Business Intelligence/capm_cabi_report

Tue 05/19/2020 14:10:06.309     Unzipping of /opt/CA/SharedComponents/CA Business Intelligence/capm_cabi_report/capm_topn-1.3.0.zip is done

Tue 05/19/2020 14:10:06.309     unzip(): file - /opt/CA/SharedComponents/CA Business Intelligence/capm_cabi_report/capm_topn.zip

Tue 05/19/2020 14:10:06.309     unzip(): output folder - tmp_capm_topn

Tue 05/19/2020 14:10:06.309     Unzipping of /opt/CA/SharedComponents/CA Business Intelligence/capm_cabi_report/capm_topn.zip is done

Tue 05/19/2020 14:10:06.309     replaceParams(): oldPath - tmp_capm_topn/resources/public/ca/pm/datasources/capm_data_source.xml

Tue 05/19/2020 14:10:06.309     replaceParams(): newPath - tmp_capm_topn/resources/public/ca/pm/datasources/capm_data_source.xml_tmp

Tue 05/19/2020 14:10:06.309     replaceParams(): before - <value>mycapchost.com</value>

Tue 05/19/2020 14:10:06.309     replaceParams(): after - <value>10.0.0.91</value>

Tue 05/19/2020 14:10:06.309     replaceParams(): before - <value>HTTP</value>

Tue 05/19/2020 14:10:06.309     replaceParams(): after - <value>http</value>

Tue 05/19/2020 14:10:06.309     replaceParams(): before - <value>8181</value>

Tue 05/19/2020 14:10:06.309     replaceParams(): after - <value>8181</value>

Tue 05/19/2020 14:10:06.309     replaceParams(): before - </customDataSource>

Tue 05/19/2020 14:10:06.309     replaceParams(): after - <property>

<key>field4pcID</key>

<value>36aef83d-136e-4bdf-ad4a-181498cbfdf4</value>

</property>

</customDataSource>

Tue 05/19/2020 14:10:06.309     zip(): zipfile - modified_topn.zip

Tue 05/19/2020 14:10:06.309     zip(): input folder - tmp_capm_topn

Tue 05/19/2020 14:10:06.309     Zipping of modified_topn.zip is done

Tue 05/19/2020 14:10:06.309     modifyReportDS is done

Reports have been succesfully modified

Tue 14:10:17 -  Keystore /opt/CA/SharedComponents/CA Business Intelligence/apache-tomcat/webapps/jasperserver-pro/WEB-INF/config/capm.jks is created

... Tomcat path is /opt/CA/SharedComponents/CA Business Intelligence/apache-tomcat/webapps/jasperserver-pro/

... Unzipping the data source

Tue 05/19/2020 14:10:18.64       logger initialized

Tue 05/19/2020 14:10:18.64       args.length=2

Tue 05/19/2020 14:10:18.64       args[0]=-deployDataSource

Tue 05/19/2020 14:10:18.64       args[1]=/opt/CA/SharedComponents/CA Business Intelligence/apache-tomcat/webapps/jasperserver-pro/

Tue 05/19/2020 14:10:18.64       deployDataSource(): - /opt/CA/SharedComponents/CA Business Intelligence/capm_cabi_report/capm_da-1.3.0.zip

Tue 05/19/2020 14:10:18.64       deployDataSource(): - /opt/CA/SharedComponents/CA Business Intelligence/apache-tomcat/webapps/jasperserver-pro/

Tue 05/19/2020 14:10:18.64       unzip(): file - /opt/CA/SharedComponents/CA Business Intelligence/capm_cabi_report/capm_da-1.3.0.zip

Tue 05/19/2020 14:10:18.64       unzip(): output folder - /opt/CA/SharedComponents/CA Business Intelligence/apache-tomcat/webapps/jasperserver-pro/

Tue 05/19/2020 14:10:18.64       Unzipping of /opt/CA/SharedComponents/CA Business Intelligence/capm_cabi_report/capm_da-1.3.0.zip is done

... buildomatic path is /opt/CA/SharedComponents/CA Business Intelligence/buildomatic

... using JAVA_HOME: /opt/CA/SharedComponents/CA Business Intelligence/java

Buildfile: /opt/CA/SharedComponents/CA Business Intelligence/buildomatic/build.xml

     [echo] Filtering properties (cleaning out blank spaces)

     [echo] chkIfPackageManagedTomcat: check if package managed tomcat

     [echo] Tomcat DBCP Factory: com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory

     [echo] chkAndSetLocaleDbSettings: dbType is postgresql

     [echo] chkAndSetLocaleDbSettings: db.set.lc_collate and db.set.lc_ctype are NOT both set

     [echo] chkAndSetLocaleDbSettings: parse: scripts.properties for db commands

     [echo] chkIfPackageManagedTomcat: check if package managed tomcat

     [echo] using settings file: /opt/CA/SharedComponents/CA Business Intelligence/buildomatic/build_conf/default/maven_settings.xml

 

validate-database:

     [echo] Validating JasperServer database connection at jdbc:postgresql://localhost:5432/jasperserver. Phase: [import-export-test]

     [echo] For JDBC driver the artifactId and version properties are set:

     [echo]   maven.jdbc.artifactId=postgresql

     [echo]   maven.jdbc.version=9.4-1210.jdbc41

     [echo]   Specified JDBC driver jar exists

[advanced-sql] Executing commands

[advanced-sql] 1 of 1 SQL statements executed successfully

     [echo] Connection OK

 

BUILD SUCCESSFUL

Total time: 0 seconds

Using Pro setup

Using Bundled version of Java

Java HotSpot(TM) 64-Bit Server VM warning: ignoring option PermSize=32m; support was removed in 8.0

Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=128m; support was removed in 8.0

Java HotSpot(TM) 64-Bit Server VM warning: ignoring option PermSize=32m; support was removed in 8.0

First resource path:/opt/CA/SharedComponents/CA Business Intelligence/buildomatic/conf_source/iePro/applicationContext.xml

Started to load resources

Resource name: applicationContext.xml

Resource name: applicationContext-MongoDbJDBCDataSource.xml

Resource name: applicationContext-adhoc.xml

Resource name: applicationContext-adhoc-dataStrategy.xml

Resource name: applicationContext-adhoc-repository.xml

Resource name: applicationContext-audit.xml

Resource name: applicationContext-azure-sql-datasource.xml

Resource name: applicationContext-cascade.xml

Resource name: applicationContext-cascading-pro.xml

Resource name: applicationContext-catFactory.xml

Resource name: applicationContext-data-snapshots.xml

Resource name: applicationContext-datarator.xml

Resource name: applicationContext-diagnosticCollectors-pro.xml

Resource name: applicationContext-el.xml

Resource name: applicationContext-el-operators.xml

Resource name: applicationContext-events-logging.xml

Resource name: applicationContext-export-config.xml

Resource name: applicationContext-export-import.xml

Resource name: applicationContext-export-import-audit.xml

Resource name: applicationContext-export-import-multi-tenancy.xml

Resource name: applicationContext-export-import-pro.xml

Resource name: applicationContext-export-import-report-options.xml

Resource name: applicationContext-formatting.xml

Resource name: applicationContext-jms.xml

Resource name: applicationContext-logging.xml

Resource name: applicationContext-messages-pro.xml

Resource name: applicationContext-multiTenancy.xml

Resource name: applicationContext-multiTenancy-security.xml

Resource name: applicationContext-olap-connection.xml

Resource name: applicationContext-pro-remote-services.xml

Resource name: applicationContext-profiling.xml

Resource name: applicationContext-propertyChangers.xml

Resource name: applicationContext-propertySettings.xml

Resource name: applicationContext-remote-services.xml

Resource name: applicationContext-report-options.xml

Resource name: applicationContext-report-scheduling.xml

Resource name: applicationContext-search.xml

Resource name: applicationContext-search-pro.xml

Resource name: applicationContext-security.xml

Resource name: applicationContext-semanticLayer.xml

Resource name: applicationContext-themes.xml

Resource name: applicationContext-themes-pro.xml

Resource name: applicationContext-virtual-data-source.xml

Resource name: applicationContext-virtual-data-source-query-service.xml

Parameter input-zip has multiple values.

 -- JasperServer:  EhCacheImpl shutdown called.  This normal shutdown operation.

 -- JasperServer:  EhCacheImpl calling cleanerTimer.cancel().  This normal shutdown operation.

 -- JasperServer:  ProfileAttributeCacheImpl shutdown called.  This normal shutdown operation.

Tue 14:10:39 -  Error during importing the report

Tue 14:10:39 -  Installation failed

**********************************************************************************************************************************************************************************

------------------------------
IT support
------------------------------