Hi Moumita
Clarity integration with japsersoft cannot work in mixed mode, so even if you off load the user is always seeing an https URL because you have filled https only but since the request is coming from https you need to fill the https entry URL with the same URL you filled in http and it should work.
In order to connect to our support team in broadcom you need to raise a case and some one will work with you .However making that changes should fix it.
------------------------------
Thanks & Regards
Suman Pramanik
Sr. Principal Support Engineer | Customer Success & Support, Enterprise Software Division
Broadcom
------------------------------
Original Message:
Sent: 05-22-2020 06:31 AM
From: Moumita dutta
Subject: User is not able to download Jasper report
Hi Suman,
We offload SSL at load balancer. This means that the request from load balancer to the application server is HTTP. Hence we configured it as HTTP enabled and not HTTPS. Here is a link and see the underlined text in the below screen shot .
https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/business-management/clarity-project-and-portfolio-management-ppm-on-premise/14-2/administration/csa-ca-clarity-system-administration/csa-security-passwords-ldap-ssl-sso-xss-and-fips.html#concept.dita_d4bee3f1d49d7a9fb5dad6cc7536c1dc5340ea73_EnableSecureSocketsLayerSSLinApacheTomcat
Also this issue is faced by couple of users and not by everyone. Also, Is it possible for you to connect at IST time zone?
Original Message:
Sent: 05-21-2020 02:45 PM
From: Suman Pramanik
Subject: User is not able to download Jasper report
Hi Moumits
Thanks for the properties.xml, is see you have updated your https url in the http entry url in CSA and https entry URL is blank and also the port numbers are not correct. So when the Jaspersoft is getting the request from clarity its not trusting the domain and its blocking and you see CSRF token errors
<webServerInstance id="app" entryUrl="https://clarity.turner.com" sslEntryUrl="https://localhost:8043" port="80" enablePort="true" sslPort="8043" enableSSLPort="false" address="" connectorPort="8009" connectorAddress="" context="/niku" documentRoot="" useHttpOnlySessionCookie="false" useSecureSessionCookie="false" restContext="/ppm"/>
See this technical document https://knowledge.broadcom.com/external/article?articleId=4562
------------------------------
Thanks & Regards
Suman Pramanik
Sr. Principal Support Engineer | Customer Success & Support, Enterprise Software Division
Broadcom
Original Message:
Sent: 05-21-2020 03:09 AM
From: Moumita dutta
Subject: User is not able to download Jasper report
Hi Suman,
Thanks for your help. I have attached all the properties files from the server.
Please let me know if you find anything.
Original Message:
Sent: 05-19-2020 09:57 AM
From: Suman Pramanik
Subject: User is not able to download Jasper report
Hi Moumita
You need to use the create jaspersoft job, however the error indicates the session is getting blocked because the token passed by clarity is not reaching the jaspersoft server. Can you share the properties.xml from all your severs by masking the password and I can take a look and see
------------------------------
Thanks & Regards
Suman Pramanik
Sr. Principal Support Engineer | Customer Success & Support, Enterprise Software Division
Broadcom
Original Message:
Sent: 05-19-2020 08:13 AM
From: Moumita dutta
Subject: User is not able to download Jasper report
Hi Suman,
Thanks for you suggestion, but we do not use these Job.
Also,below error i noticed for the user, is it something that can cause this issue?
ERROR CsrfGuard,http-apr-8080-exec-2:44 - potential cross-site request forgery (CSRF) attack thwarted (user:<anonymous>, ip:10.118.0.10, method:POST, uri:/reportservice/flow.html/flowFile/report_name.xls, error:required token is missing from the request)
Original Message:
Sent: 04-30-2020 06:02 AM
From: Suman Pramanik
Subject: User is not able to download Jasper report
Are you running the load DWH rights job. Please run the job and ensure it to complete and then ask the user to export.
------------------------------
Thanks & Regards
Suman Pramanik
Sr. Principal Support Engineer | Customer Success & Support, Enterprise Software Division
Broadcom
Original Message:
Sent: 04-29-2020 01:26 AM
From: Moumita dutta
Subject: User is not able to download Jasper report
Error 401 - User not registered
This is error user is getting when they run the report and tries to export the data.
But I am able to export the report using user's login.
Original Message:
Sent: 04-28-2020 03:07 PM
From: Suman Pramanik
Subject: User is not able to download Jasper report
What error you are getting it?
------------------------------
Thanks & Regards
Suman Pramanik
Sr. Principal Support Engineer | Customer Success & Support, Enterprise Software Division
Broadcom
Original Message:
Sent: 04-28-2020 12:55 PM
From: Moumita dutta
Subject: User is not able to download Jasper report
Hi,
User is able to run the report through advance reporting but NOT able to download it.
They can schedule it as well, and can receive an email with the report attachment.
Does anybody has any idea on it?
Original Message:
Sent: 03-12-2020 08:30 AM
From: Suman Pramanik
Subject: User is not able to download Jasper report
Hi Moumita,
When you run a report from Clarity Reports and Jobs it actually schedules the reports and then output is generated. So you will need additional rights. Here is the document on the same
https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/business-management/clarity-project-and-portfolio-management-ppm-on-premise/15-7-1/Using-Classic-Clarity-PPM/personalize-clarity-ppm-change-password-account-settings-notifications-export-to-excel/run-schedule-and-share-reports.html
Can you also check if the same user can go to Advance reporting can the user schedule the report from Advance Reporting
------------------------------
Thanks & Regards
Suman Pramanik
Sr. Principal Support Engineer | Customer Success & Support, Enterprise Software Division
Broadcom
Original Message:
Sent: 03-10-2020 03:32 AM
From: Moumita dutta
Subject: User is not able to download Jasper report
Thanks for your response..
I have already tried the changes you have suggested, but it did not worked.
Original Message:
Sent: 03-09-2020 04:03 PM
From: Lupe Montalvo
Subject: User is not able to download Jasper report
I have a user that is having the same issue. This is the information I received from Broadcom. See if this resolves your issue. It did not resolve the resources issue because our users do not have admin right to change setting in Chrome.
Resolution https://ca-broadcomcsm.wolkenservicedesk.com/wolken/esd/knowledgebase_search?articleId=107977
Open Chrome and then:
- Click on the Tab upper right corner " Customize and control Google Chrome"
- Click on Setting from the Drop Down Menu
- Click on "Advance / Content Settings"
- Click on PDF Documents
- Enable the the option "Download PDF Files instead of automatically opening them in Chrome"
------------------------------
System Administrator
State of Michigan
Original Message:
Sent: 03-06-2020 07:20 AM
From: Moumita dutta
Subject: User is not able to download Jasper report
User is able to Run report , but when trying to download Jaspersoft Report in any format,they gets below error:
"error 401 user is not registered on the reporting server."
all the users who reported this issue were using MAC. Below are the versions of their OS and browser.
Google Chrome version 80.0.3987.122 She is using a MAC 10.14.6
I went through the below threads and followed instructions given in the link but nothing works
https://community.broadcom.com/communities/community-home/digestviewer/viewthread?MID=807752
https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=107977
However It works perfectly fine when the same user uses a window OS.They are able to download the report.
so it seems the issue is with MAC users.
It also works perfectly fine when I Login as that user and download the report.
But why it is showing error at the application level that 'User is not registerred'.
Can anyone advise what is wrong here.
Thanks in advance
Moumita Dutta