Resolving Error: [Connection] Reports Folder does not exist when integrating CA Business Intelligence JasperReports® Server to Identity Manager

book

Article ID: 135427

calendar_today

Updated On:

Products

CA Identity Manager CA Identity Suite

Issue/Introduction

This document details integration of Identity Manager 14.x to Jasper Server 6.4.3. 


Issue: In IDM when configuring report server connection the below is recieved


Error: [Connection] Reports Folder does not exist

Resolution



Integrate IDM 14.X with Jasper Report Server 6.4.3 (VApp) and Non VApp


Please Note: if you have already created the IAM organization, please delete it prior to beginning.

Note:  If the database is an embedded database within Vapp do the following:

Open the hosts file in Vapp (/etc) and copy the configuration for database_srv to the jasper server hosts file. If windows, this file is located at the following path: 

C:\Windows\System32\drivers\etc


If integrating IDM 14.2 with Jasper sever please run the CP4 update for Identity Manager

 

1.    CP-IMV-140200-0004 Download and download the patch file to the following location in Vapp: /home/config

2.       Log into Vapp via a Putty session and type screen and then enter

3.       Run the patch update by doing the following: Type patch_vapp CP-IMV-140200-0004.tar.gpg


Integrate your Jasper Server to Identity Manager

1.       Log into Jasper Server Web Portal and create the IAM organization

2.       Create a new user under the IAM organization

3.       Import the IM Standard Reports from the following location into your Jasper Server: 

/opt/CA/IdentityManager/IAM_Suite/IdentityManager/tools/imrexport/ReportDefinitions/IM Standard Reports/.  

Note: If your IDM database server is Oracle, import the Oracle reports.  If the Database is SQL, import the SQL reports.

4.       Once the reports are imported, grant your access to the IAM organization.

5.       Under View à Repository right click IAM and select permissions.

6.       Navigate to the user tab

7.       For the user you created, grant Read only access.  Click Apply and then okay.

8.       Navigate to IAM à IM à datasources.  Right click datasources and select permissions

9.       Navigate to the user tab

10.   For the user you created, grant Read + Write access. Click Apply and then okay.


Copy the Keystore from the IDM Server to the Jasper Server.  This will complete integration.

1.   Copy the keystore from the IDM Application Server
  • For Vapp - navigate to the following location /opt/CA/wildfly-idm/modules/com/ca/iam/cajasper/main
  • For Standalone - application_server_home\modules\com\ca\iam\cajasper\main.  For Example: C:\wildfly-8.2.0.IM\modules\com\ca\iam\cajasper\main

2.       Copy iam.jks and iam.properties to C:\Program Files\CA\SC\CA Business Intelligence\apache-tomcat\webapps\{webapp}\WEB-INF\config

For Example: C:\Program Files\CA\SC\CA Business Intelligence\apache-tomcat\webapps\jasperserver-pro\WEB-INF\config


Restart Services

1.  Restart IDM services.  If on virtual appliance, run restart_im

2.       On the Jasper Server 

restart the tomcat services. 

 
  1. If after all above steps you still get the same error, check in the Identity Manager application server log if you see the following exception upon clicking the Test Connection button.
  2. ERROR [com.ca.ims.jasperreporting.JasperUtils] (default task-21) Exception occoured while getting the Reports from a folder reports in  JasperImpl.getReportsListFromFolder(). Exception details are com.ca.ims.jasperreporting.JasperException: <jasperuser> is Unauthorized to access the resource.Full authentication is required to access this resource
  3. In this case, you may have copied a wrong iam.jks file into the Jasper Server machine.
  4. Run the following keytool command against the iam.jks, on both vApp machine (/opt/CA/wildfly-idm/modules/com/ca/iam/cajasper/main/iam.jks) and the Jasper Server machine (C:\Program Files\CA\SC\CA Business Intelligence\apache-tomcat\webapps\jasperserver-pro\WEB-INF\config\iam.jks) to compare and make sure they match including the Creation Date value of the Alias entry.
  5. keytool -list -v -keystore iam.jks -storetype jceks
  6. Note: Press Enter when you are prompted keystore password
  7. Example of above command result is as the following:
  8. Keystore type: JCEKS
    Keystore provider: SunJCE
  9. Your keystore contains 1 entry
  10. Alias name: ca85d78fa3-a121-4422-b40b-970f10ca2f43
    Creation date: Feb 11, 2019
    Entry type: SecretKeyEntry
  11. If they are different, copy /opt/CA/wildfly-idm/modules/com/ca/iam/cajasper/main/iam.jks on vApp to C:\Program Files\CA\SC\CA Business Intelligence\apache-tomcat\webapps\jasperserver-pro\WEB-INF\config\iam.jks on Jasper Server machine, and restart the tomcat services.

Additional Information

This process requires CP4 as described in step 1 above.