DX NetOps

Hello,

We have recently upgraded CAPM from 3.1 to 3.6 and running into a problem when trying to launch any report via CABI, 

Current version of CAPM: 3.6

Current version of CABI: 6.3

Screen shot is shown below:

We have successfully added the CABI as a data source within CAPC:

You can see the OOTB reports available under Reports à CABI reports via CAPC:

However, there seems to be some issue with the browser compatibility as when we click on any report, the page is not getting displayed properly:

As per the KB article mentioned below, there seems to be some issue with CABI 6.4.2 and CAPM 3.5 or older, but that is not the case for us.

Jasper reporting for CAPM failed - CA Knowledge 

I would appreciate your help on this.

Thanks

Darshan

Darshan,

I took a look into the case that the KB you referenced was based off of and as you say the problem is not identical to yours but it may be beneficial to check on a few things checked in the prior case.  Note: The case was for a Linux based CABI system.

1. Is postgres running?

         ps -ef | grep postgres

This is the line you are looking for:

/opt/CA/SharedComponents/CA Business Intelligence/postgresql/bin/postgres -D postgresql/data

2. What are the postgres data folder permissions.  If they are 777 you may wanna set them to 700

ls -al "/opt/CA/SharedComponents/CA Business Intelligence/postgresql/"

total 44
drwxrwxrwx 11 root root 4096 Jul 11 12:39 .
drwxrwxr-x 14 root root 4096 Jul 25 15:24 ..
drwxrwxrwx 2 root root 4096 Jul 11 12:39 bin
drwx------ 18 postgres postgres 4096 Jul 12 11:36 data
drwxrwxrwx 3 root root 4096 Jul 11 12:39 doc
drwxrwxrwx 10 root root 4096 Jul 11 12:39 include
drwxrwxrwx 4 root root 4096 Jul 11 12:39 lib
drwxrwxrwx 2 root root 4096 Jul 11 13:33 logs
drwxrwxrwx 5 root root 4096 Jul 11 12:39 pgAdmin3
drwxrwxrwx 4 root root 4096 Jul 11 12:39 share
drwxrwxrwx 4 root root 4096 Jul 11 12:39 stackbuilder

Troy

Hi Troy,

This is a Windows CABI system. We still verified services and processes were running fine and even restarted Tomcat and Postgresql. After that, we are getting following error:

Good afternoon friend!
One doubts the report you are trying to generate and the Spectrum or CAPM report.

In my environment, I was with some reports with a problem I did re-deploy both in Spectrum and CAPC.

If I'm not mistaken, it should have a newer version for CABI, have you thought about updating?

CA Business Intelligence - Home - CA Business Intelligence JasperReports® Server - 6.4.3 - CA Technologies Documentation 

In the case of CAPM, you have to perform a reporting procedure on Jasper!

https://docops.ca.com/ca-performance-management/3-6/en/integrating/integrate-ca-business-intelligence