JasperServer integrate with CA IM

[William Cheang]

Hi Team,
CA Identity Suite 14.3 integrating JasperReportServer with CA IM.

I have setup the Jasper report server 6.4.3 on WIndows 2016.
By following the steps in the URL below
https://docops.ca.com/ca-identity-manager/14-3/EN/installing/install-and-configure-ca-business-intelligence-jasperreports-server
Report server is successfully installed.

But when i configure Report Server connection http:/x.x.x.x:8080/jasperserver-pro/
with UserID="idmadmin", then test connection. UI return an error "Report Folder does not exist".

When i check server.log, i saw the error ->
Exception occured while getting the Reports from a folder reports in JasperImpl.getReportListFormFolder(). ...
JasperException: idmadmin is Unauthorized to access resource.Full authentication is required to access this resource.


anyone have faced this issue before ?

regards,
William

[Nino Uziel]

Hi William,

Did you follow the section "Prerequisites for Using CA Business Intelligence JasperReports Server" ?
It states to create the IAM folder on the Jasper server and then create the relevant user and copy over the iam.jks and iam.properties file.
Did you follow these steps ?

[William Cheang]

Yes, i did create the IAM folder, created the idmadmin id & set the read+write+execute permission on the folder.
copied the iam.jks file from vapp to report server tomcat folder ./config and restarted tomcat.

[Nino Uziel]

what about the iam.properties ?

[William Cheang]

yes, i did copy the iam.properties. 
I even manually login on jasperreportserver with idmadmin and i able to see my IAM folder with standard reports.

[Durga Venkateswara Rao Atluri]

HI William,

Most of the times we will see this issue with the IAM.jks and IAM.properties files are not properly copied.

Can you also let me know which version of JDK you are using?

Regards,
Venkat Atluri

[William Cheang]

am using Oracle Java 1.8.0_211 64bit

[Durga Venkateswara Rao Atluri]

Can you try with the Same JDK version in both the VAPP and Jasper server, also please try to use below JDK 1.8.0_180 version.

[William Cheang]

Hi Durga, this issue is resolved. after we copy the correct iam.jks & properties from /opt/CA folder. Thanks.

[Durga Venkateswara Rao Atluri]

HI William,

Most of the times we will see this issue with IAM.jks & IAM.properties not matched correctly in IM and Jasper Server.

Also can you please let us know the JDK version which you are using in both jasper server and IM server?

Which Application server you used to deploy the Identity Manager?

Regards,
Venkat Atluri

[Lynn McMorrow]

I am actually experiencing this right now as well.  I found this tech doc, but it's specific to WAS, and I'm running Tomcat/vApp, so still searching.  Please update if you find a solution and I'll do the same!

[Scott Owens]

Hello Everyone,

Try the following

Open Jasper Report Server UI: (http://localhost:8080/jasperserver-pro)
Click View > Repository Right Click on IAM > Permissions > Users Tab >
Set the user that you are connecting with to Read Only and apply changes Right Click on IM folder under IAM > Permissions > Users Tab > Set the user that you are connecting with to Read Only.
Make sure you reselect the drop down and select read only and apply. Right click on DataSources folder under IM> Permissions > Users Tab > Set the user that you are connecting with to Read + Write and apply changes.
Stop Jasper Report Server and then Start the Jasper Report Server. Go back into the Jasper Report Server UI and confirm that all changes were made. Attempt to connect to the report server once more through IDM.

------------------------------
Best regards,

Scott Owens
Sr Support Engineer
Enterprise Software Division
Broadcom Inc.
------------------------------

[Enrique Torres]

I created the attached PDF following the instructions for CA Identity Manager 14.2 to integrate with IDM deployed on CA Identity Suite 14.2 Virtual Appliance.

Attachment(s)

Install and Configure CA CABI.pdf   3.80 MB 1 version

Install and Configure CA CABI_v2.pdf   6.59 MB 1 version

[Lynn McMorrow]

Thank you, Enrique!!

William et. al.  I seem to be beyond the "no reports folder" error.  The major changes I made are as follows:

1. I downgraded Java to 1.8.0u74  We had an issue with a customer who had u200-something and the fix was to use a lower version, so I figured it was worth a shot.

2. Per Enrique's documentation, I replaced the key files with the ones located on my vapp in /opt/CA/wildfly-idm/modules/com/ca/iam/cajasper/main.  The documentation specifies -          /opt/CA/IdentityManager/IAM_Suite/IdentityManager/tools/JasperKeyGen/keystore/ which is contradictory to what Enrique had in his doc, and the cajasper/main solution worked for me.

3. Rookie move, but I imported the Jasper roles & tasks in my IME.  

I'd be very interested to know if any of the above also works for you.  Thanks to all who contributed to this thread!

Lynn McMorrow
Solutions Architect

CA, A Broadcom Company

M: 516-754-2749

O: 631-342-2580

**Please update your contact list with my new e-mail address: [e-mail].  All phone info remains the same.

[William Cheang]

Hi Lynn, i copied the iam.jks & iam.properties from the path(/opt/CA/wildfly-idm/modules/com/ca/iam/cajasper/main)  u mentioned, restart jasper server
and it works !!!

Thanks Lynn !

[William Cheang]

Thanks Enrique, for the detail documentation.

[William Cheang]

Hi Scott, i have tried ur method, it did not solve the issue...still getting the same error

[William Cheang]

on vapp server, it is using java 1.8.0_71
We are using casuite with vapp that installed with IP,IM,Connector server & IG, Then we are using external database(MSSQL)
Report Server is another Windows Server 2016 machine.

[Durga Venkateswara Rao Atluri]

HI William,

If your setup is VAPP can you make sure the IAM.jks and IAM.properties files exists in /opt/CA/VirtualAppliance/custom/IdentityManager/keystore location also. and restart the IM.

Regards,
Venkat Atluri

[William Cheang]

Thanks Venkat, it seem like there are multiple copy of "iam.jks" and "iam.properties" in casuite vapp.

So far, i tested files in this path, is working for me.
/opt/CA/wildfly-idm/modules/com/ca/iam/cajasper/main

[Adrian Bullock]

Hi William,

You installed jasper 6.4.3 onto a windows 2016 server, which is actually an unsupported platform according to the documentation.

Did you get things to work smoothly in the end?

We need to implement Reporting in a 14.3 environment with WIndows 2016 servers, but if we install 6.4.3 then it will not be supported by Broadcom, so if we run into issues we will be in trouble.

Cheers,
Adrian

[William Cheang]

Hi Adrian,
After installed on Windows 2016, so far it is working fine.
We able to generate report from auditing source or snapshot database.

regards,
William

[Adrian Bullock]

Thanks William - I guess the only downside is that this configuration is not supported by Broadcom, but as long as it works ... fingers crossed!