Issue Connection jasper report server

[sudip karmacharya]

Dear team,

Currently, We are facing a problem connecting with JasperServer.

I am follow up on this Install and Configure CA Business Intelligence JasperReports® Server Document.  

Please any help on this Issue?


Thank you,

------------------------------
Network and security Engineer technical associative
Cas Trading House
Putalisadak, KTM
------------------------------

[Nicole Goldstein]

Hi Sudip,

You need to ensure the following:

1. Copied your iam.jks and iam.properties files from your IDM server to your Jasper Server.  
2. Once those files are copied restart both tomcat and IDM. 
3. Confirm that your idmadmin user has access to the IAM organization within Jasper Server
4. Confirm that you imported the correct standard reports from your IDM server into your Jasper Sever. 
5. Confirm that you appropriately set permissions for the organization on the Jasper Server. 

You can review this integration guide here: https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/layer7-identity-and-access-management/identity-manager/14-3/installing/install-and-configure-ca-business-intelligence-jasperreports-server.html

Thank you,
Nicole

[sudip karmacharya]

Hi Nicole,

We have already configured the steps you have shown above but still no changes.
Is there anything else that we are missing out?

Regards,
Sudip

------------------------------
Network and security Engineer technical associative
Cas Trading House
Putalisadak, KTM
------------------------------

[Nicole Goldstein]

Hi Sudip,

You will want to ensure that the two servers can communicate with each other.  From your IDM server can you telnet over to your jasper server on port 8080?  From your IDM server, are you able to ping your jasper server?

Thank you,
Nicole

[sudip karmacharya]

Dear Nicole,

Yes, Communication also Fine with each other.
From IDM to Japser Server Telnet

From IDM to Japser Server Ping

Still, I am not able to do connection?

------------------------------
Network and security Engineer technical associative
Cas Trading House
Putalisadak, KTM
------------------------------

[Nicole Goldstein]

Hi Sudip,

Is this a production/non-production deployment with an external database or are you using embedded Oracle database?  If you are using the embedded Oracle database you need to add database_srv to your Jasper Server's host file. 

Thank you,
Nicole

[sudip karmacharya]

Hi Nicole,

This is for non-production. And we are using MSSQL as a database.

Regards,
Sudip

------------------------------
Network and security Engineer technical associative
Cas Trading House
Putalisadak, KTM
------------------------------

[Iyes Dendeni]

Hi Sudip,

In Jasper, Please make sure your organization is called IAM and not something else.
Also right-click on the datasource and choose edit or properties, and make sure you're using the driver for MSSQL, the correct server name and port, and the credentials are also correct. 

Thanks!

[sudip karmacharya]

Hi lyes,

Yes, All the information as your says configure still gets an issue.

Thank you

------------------------------
Network and security Engineer technical associative
Cas Trading House
Putalisadak, KTM
------------------------------

[Rinat Matityahu]

Few more ideas:
- Inspect tomcat logs for the error observed when IM is trying to test the connection
- Inspect IM server logs (in debug mode) when trying to test the connection
- Confirm the communication from Jasper to IM server is working (OS firewall etc)
- Edit the Report server URL and try testing with a trailing / at the end

Regards
Rinat Matityahu
Principal Support Engineer
Broadcom Technical Support - EMEA

[sudip karmacharya]

Dear Rinat,

yes, I found this type of error message.

2020-03-26 14:57:32,346 ERROR [com.ca.ims.jasperreporting.JasperUtils] (default task-7) Login faild.Http Status code 403

Thank you,

------------------------------
Network and security Engineer technical associative
Cas Trading House
Putalisadak, KTM
------------------------------

[Rinat Matityahu]

Hi Sudip
So - http 403 means user is not authorized.
Can you confirm you are able to open jasper console (the exact URL as entered in IM) and use idmadmin / password / IAM organization to successfully view IM Reports folder?
Please share the screenshot once logged in
Thank you
Rinat

[sudip karmacharya]

Dear Rinat,

Please find the below Screenshot.

Thank you,

------------------------------
Network and security Engineer technical associative
Cas Trading House
Putalisadak, KTM
------------------------------

[Herald Thomas]

Have you got the solution for this? I'm also facing the same issue.

[sudip karmacharya]

Dear Herald,

Yes, due to the version.
I am using Vapp 14.3 and jasper server 7.1.1.

To support this version either we need to update the cp1 patch in 14.3 or need to install below version of the jasper report server.

Thank you,

------------------------------
Network and security Engineer technical associative
Cas Trading House
Putalisadak, KTM
------------------------------

[sudip karmacharya]

Hi Rinat,

While view log I found this error message.

I enable Key generation On. Still, we faced the same error message.

# Turns request parameter validation on or off.
security.validation.input.on=true
# Turns CSRF attack guard on or off.
security.validation.csrf.on=true
# Turns sql validation on or off.
security.validation.sql.on=true

 

------------------------------
Network and security Engineer technical associative
Cas Trading House
Putalisadak, KTM
------------------------------

[Nicole Goldstein]

If you are receiving 403 error in the logs it may be you are trying to connect IDM 14.3 to Jasper Server 7.1.1. 

Please review this KB article: https://knowledge.broadcom.com/external/article?articleId=19239