Clarity

 View Only
Expand all | Collapse all

User is not able to download Jasper report

  • 1.  User is not able to download Jasper report

    Posted Mar 06, 2020 07:21 AM
    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


  • 2.  RE: User is not able to download Jasper report

    Posted Mar 09, 2020 04:03 PM
    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:

    1. Click on the Tab upper right corner " Customize and control Google Chrome"
    2. Click on Setting from the Drop Down Menu
    3. Click on "Advance / Content Settings"
    4. Click on PDF Documents
    5. Enable the the option "Download PDF Files instead of automatically opening them in Chrome"


    ------------------------------
    System Administrator
    State of Michigan
    ------------------------------



  • 3.  RE: User is not able to download Jasper report

    Posted Mar 10, 2020 03:33 AM
    Thanks for your response..

    I have already tried the changes you have suggested, but it did not worked.


  • 4.  RE: User is not able to download Jasper report
    Best Answer

    Broadcom Employee
    Posted Mar 12, 2020 08:30 AM
    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
    ------------------------------



  • 5.  RE: User is not able to download Jasper report

    Posted Apr 28, 2020 12:56 PM
    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?


  • 6.  RE: User is not able to download Jasper report

    Broadcom Employee
    Posted Apr 28, 2020 03:08 PM
    What error you are getting it?

    ------------------------------
    Thanks & Regards
    Suman Pramanik
    Sr. Principal Support Engineer | Customer Success & Support, Enterprise Software Division
    Broadcom
    ------------------------------



  • 7.  RE: User is not able to download Jasper report

    Posted Apr 29, 2020 01:27 AM

    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.




  • 8.  RE: User is not able to download Jasper report

    Broadcom Employee
    Posted Apr 30, 2020 06:03 AM
    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
    ------------------------------



  • 9.  RE: User is not able to download Jasper report

    Posted May 19, 2020 08:13 AM
    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)



  • 10.  RE: User is not able to download Jasper report

    Broadcom Employee
    Posted May 19, 2020 09:58 AM
    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
    ------------------------------



  • 11.  RE: User is not able to download Jasper report

    Posted May 21, 2020 03:10 AM
    Hi Suman,

    Thanks for your help. I have attached all the properties files from the server.

    Please let me know if you find anything.

    Attachment(s)

    xml
    1properties.xml   8 KB 1 version
    xml
    2properties.xml   8 KB 1 version
    xml
    3properties.xml   8 KB 1 version
    xml
    4properties.xml   8 KB 1 version


  • 12.  RE: User is not able to download Jasper report

    Broadcom Employee
    Posted May 21, 2020 02:45 PM
    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
    ------------------------------



  • 13.  RE: User is not able to download Jasper report

    Posted May 22, 2020 06:31 AM
    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?




  • 14.  RE: User is not able to download Jasper report

    Broadcom Employee
    Posted May 22, 2020 07:30 AM
    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
    ------------------------------