Clarity

Expand all | Collapse all

Advance reporting link navigates to blank page in Jaspersoft installation

  • 1.  Advance reporting link navigates to blank page in Jaspersoft installation

    Posted 03-23-2016 01:25 AM

    Hi All,

     

    I have installed jaspersoft in our server and configured the CSA (didnt create any organization, using default organization ). Then generate keystre file and place the same file in the tomcat folder of jaspersoft server. Imported the content also.

    I am able to login to jasper console. Added the necessary right to admin user and ran the create and update  jaspersoft user job also.

     

    When i click on the advanced reporting, am getting blank page only. i am attaching jasper console page and CSA reporting subtab page for your reference.

     

    Please help me on this.

     

    Thanks,

    Agin



  • 2.  Re: Advance reporting link navigates to blank page in Jaspersoft installation

    Posted 03-23-2016 01:46 AM

    Hi Agin,

     

    That shouldn't be an issue, if you do browser level tracing using F12 do you see any errors or blocking?

     

    Regards

    Suman Pramanik



  • 3.  Re: Advance reporting link navigates to blank page in Jaspersoft installation

    Posted 03-23-2016 02:59 AM

    Thanks Suman.

     

    Getting some declaration dropped errors.

    am copying the errors below.

    Error in parsing value for 'background'.  Declaration dropped. nu:8:14

    Error in parsing value for 'background'.  Declaration dropped. nu:89:14

    Error in parsing value for 'background'.  Declaration dropped. nu:178:14

    Expected color but found 'center'.  Error in parsing value for 'background'.  Declaration dropped. nu:180:30

    Error in parsing value for 'background'.  Declaration dropped. nu:181:14

    Error in parsing value for 'background'.  Declaration dropped. nu:187:14

    Expected color but found 'center'.  Error in parsing value for 'background'.  Declaration dropped. nu:189:30

    Error in parsing value for 'background'.  Declaration dropped. nu:190:14

    Error in parsing value for 'background'.  Declaration dropped. nu:199:14

    Expected 'none', URL, or filter function but found 'progid'.  Error in parsing value for 'filter'.  Declaration dropped. nu:200:10

    Error in parsing value for 'background'.  Declaration dropped. nu:207:14

    Expected 'none', URL, or filter function but found 'progid'.  Error in parsing value for 'filter'.  Declaration dropped. nu:209:10

    Error in parsing value for 'background'.  Declaration dropped. nu:245:14

    Error in parsing value for 'background'.  Declaration dropped. nu:255:14

    Error in parsing value for 'background'.  Declaration dropped. nu:273:14

    Error in parsing value for 'background'.  Declaration dropped. nu:351:14

    Unknown property '-moz-border-radius'.  Declaration dropped. nu:356:20

    Unknown property 'behavior'.  Declaration dropped. nu:358:10

    Error in parsing value for 'background'.  Declaration dropped. nu:408:14

    Unknown property '-moz-border-radius'.  Declaration dropped. nu:413:20

    Unknown property 'behavior'.  Declaration dropped. nu:415:10

    Unknown property 'text-wrap'.  Declaration dropped. nu:445:11

    processAction (Area: LegacyClientImpl): 2610.51ms clarity_main_min.js:210

    onResponseReceived (Area: RenderRequestCallback): timer started clarity_main_min.js:209

    Error in parsing value for 'background'.  Declaration dropped. nu:8:14

    Error in parsing value for 'background'.  Declaration dropped. nu:89:14

    Error in parsing value for 'background'.  Declaration dropped. nu:178:14

    Expected color but found 'center'.  Error in parsing value for 'background'.  Declaration dropped. nu:180:30

    Error in parsing value for 'background'.  Declaration dropped. nu:181:14

    Error in parsing value for 'background'.  Declaration dropped. nu:187:14

    Expected color but found 'center'.  Error in parsing value for 'background'.  Declaration dropped. nu:189:30

    Error in parsing value for 'background'.  Declaration dropped. nu:190:14

    Error in parsing value for 'background'.  Declaration dropped. nu:199:14

    Expected 'none', URL, or filter function but found 'progid'.  Error in parsing value for 'filter'.  Declaration dropped. nu:200:10

    Error in parsing value for 'background'.  Declaration dropped. nu:207:14

    Expected 'none', URL, or filter function but found 'progid'.  Error in parsing value for 'filter'.  Declaration dropped. nu:209:10

    Error in parsing value for 'background'.  Declaration dropped. nu:245:14

    Error in parsing value for 'background'.  Declaration dropped. nu:255:14

    Error in parsing value for 'background'.  Declaration dropped. nu:273:14

    Error in parsing value for 'background'.  Declaration dropped. nu:351:14

    Unknown property '-moz-border-radius'.  Declaration dropped. nu:356:20

    Unknown property 'behavior'.  Declaration dropped. nu:358:10

    Error in parsing value for 'background'.  Declaration dropped. nu:408:14

    Unknown property '-moz-border-radius'.  Declaration dropped. nu:413:20

    Unknown property 'behavior'.  Declaration dropped. nu:415:10

    Unknown property 'text-wrap'.  Declaration dropped. nu:445:11

     

    Thanks,

    Agin



  • 4.  Re: Advance reporting link navigates to blank page in Jaspersoft installation

    Posted 03-23-2016 03:02 AM

    Hi Suman,

     

    One more question regarding the DWH configuration in CSA. We are using oracle db as backend. In CSA, its asking for Login Name and Password.

    What is this login name ? Is this is the DWH schema name and password we have to give here.

     

    Thanks,

    Agin



  • 5.  Re: Advance reporting link navigates to blank page in Jaspersoft installation

    Posted 03-23-2016 03:06 AM

    Hi Agin,

     

    The errors are very vague to troubleshoot without seeing the environment. Regarding your DWH login name it is the schema user name and password. Please see the details in the case.

     

    Regards

    Suman Pramanik 



  • 6.  Re: Advance reporting link navigates to blank page in Jaspersoft installation

    Posted 03-23-2016 03:43 AM

    Thanks Suman for the details.

     

    Am pasting the entire content of the console for your reference. I have replaced my organization name with xxxx in urls.

     

    onResponseReceived (Area: RenderRequestCallback): timer started clarity_main_min.js:209

    render (Area: pageShell): timer started clarity_main_min.js:209

    render (Area: pageShell): 9160.56ms clarity_main_min.js:210

    onResponseReceived (Area: RenderRequestCallback): 9296.79ms clarity_main_min.js:210

    processAction (Area: LegacyClientImpl): timer started clarity_main_min.js:209

    onResponseReceived (Area: RenderRequestCallback): timer started clarity_main_min.js:209

    render (Area: pageShell): timer started clarity_main_min.js:209

    render (Area: pageShell): 3085.16ms clarity_main_min.js:210

    onResponseReceived (Area: RenderRequestCallback): 3106.97ms clarity_main_min.js:210

    processAction (Area: LegacyClientImpl): 4632.96ms clarity_main_min.js:210

    processAction (Area: LegacyClientImpl): timer started clarity_main_min.js:209

    onResponseReceived (Area: RenderRequestCallback): timer started clarity_main_min.js:209

    render (Area: pageShell): timer started clarity_main_min.js:209

    render (Area: pageShell): 62.23ms clarity_main_min.js:210

    onResponseReceived (Area: RenderRequestCallback): 71.9ms clarity_main_min.js:210

    processAction (Area: LegacyClientImpl): 1047.36ms clarity_main_min.js:210

    processAction (Area: LegacyClientImpl): timer started clarity_main_min.js:209

    onResponseReceived (Area: RenderRequestCallback): timer started clarity_main_min.js:209

    render (Area: pageShell): timer started clarity_main_min.js:209

    render (Area: pageShell): 55.07ms clarity_main_min.js:210

    onResponseReceived (Area: RenderRequestCallback): 81.6ms clarity_main_min.js:210

    processAction (Area: LegacyClientImpl): 1259.05ms clarity_main_min.js:210

    processAction (Area: LegacyClientImpl): timer started clarity_main_min.js:209

    onResponseReceived (Area: RenderRequestCallback): timer started clarity_main_min.js:209

    render (Area: pageShell): timer started clarity_main_min.js:209

    render (Area: pageShell): 277.54ms clarity_main_min.js:210

    onResponseReceived (Area: RenderRequestCallback): 347.99ms clarity_main_min.js:210

    processAction (Area: LegacyClientImpl): 1849.9ms clarity_main_min.js:210

    processAction (Area: LegacyClientImpl): timer started clarity_main_min.js:209

    onResponseReceived (Area: RenderRequestCallback): timer started clarity_main_min.js:209

    render (Area: pageShell): timer started clarity_main_min.js:209

    render (Area: pageShell): 206.38ms clarity_main_min.js:210

    onResponseReceived (Area: RenderRequestCallback): 242.3ms clarity_main_min.js:210

    processAction (Area: LegacyClientImpl): 1221.14ms clarity_main_min.js:210

    processAction (Area: LegacyClientImpl): timer started clarity_main_min.js:209

    Error in parsing value for 'background'.  Declaration dropped. nu:8:14

    Error in parsing value for 'background'.  Declaration dropped. nu:89:14

    Error in parsing value for 'background'.  Declaration dropped. nu:178:14

    Expected color but found 'center'.  Error in parsing value for 'background'.  Declaration dropped. nu:180:30

    Error in parsing value for 'background'.  Declaration dropped. nu:181:14

    Error in parsing value for 'background'.  Declaration dropped. nu:187:14

    Expected color but found 'center'.  Error in parsing value for 'background'.  Declaration dropped. nu:189:30

    Error in parsing value for 'background'.  Declaration dropped. nu:190:14

    Error in parsing value for 'background'.  Declaration dropped. nu:199:14

    Expected 'none', URL, or filter function but found 'progid'.  Error in parsing value for 'filter'.  Declaration dropped. nu:200:10

    Error in parsing value for 'background'.  Declaration dropped. nu:207:14

    Expected 'none', URL, or filter function but found 'progid'.  Error in parsing value for 'filter'.  Declaration dropped. nu:209:10

    Error in parsing value for 'background'.  Declaration dropped. nu:245:14

    Error in parsing value for 'background'.  Declaration dropped. nu:255:14

    Error in parsing value for 'background'.  Declaration dropped. nu:273:14

    Error in parsing value for 'background'.  Declaration dropped. nu:351:14

    Unknown property '-moz-border-radius'.  Declaration dropped. nu:356:20

    Unknown property 'behavior'.  Declaration dropped. nu:358:10

    Error in parsing value for 'background'.  Declaration dropped. nu:408:14

    Unknown property '-moz-border-radius'.  Declaration dropped. nu:413:20

    Unknown property 'behavior'.  Declaration dropped. nu:415:10

    Unknown property 'text-wrap'.  Declaration dropped. nu:445:11

    processAction (Area: LegacyClientImpl): 2610.51ms clarity_main_min.js:210

    onResponseReceived (Area: RenderRequestCallback): timer started clarity_main_min.js:209

    Error in parsing value for 'background'.  Declaration dropped. nu:8:14

    Error in parsing value for 'background'.  Declaration dropped. nu:89:14

    Error in parsing value for 'background'.  Declaration dropped. nu:178:14

    Expected color but found 'center'.  Error in parsing value for 'background'.  Declaration dropped. nu:180:30

    Error in parsing value for 'background'.  Declaration dropped. nu:181:14

    Error in parsing value for 'background'.  Declaration dropped. nu:187:14

    Expected color but found 'center'.  Error in parsing value for 'background'.  Declaration dropped. nu:189:30

    Error in parsing value for 'background'.  Declaration dropped. nu:190:14

    Error in parsing value for 'background'.  Declaration dropped. nu:199:14

    Expected 'none', URL, or filter function but found 'progid'.  Error in parsing value for 'filter'.  Declaration dropped. nu:200:10

    Error in parsing value for 'background'.  Declaration dropped. nu:207:14

    Expected 'none', URL, or filter function but found 'progid'.  Error in parsing value for 'filter'.  Declaration dropped. nu:209:10

    Error in parsing value for 'background'.  Declaration dropped. nu:245:14

    Error in parsing value for 'background'.  Declaration dropped. nu:255:14

    Error in parsing value for 'background'.  Declaration dropped. nu:273:14

    Error in parsing value for 'background'.  Declaration dropped. nu:351:14

    Unknown property '-moz-border-radius'.  Declaration dropped. nu:356:20

    Unknown property 'behavior'.  Declaration dropped. nu:358:10

    Error in parsing value for 'background'.  Declaration dropped. nu:408:14

    Unknown property '-moz-border-radius'.  Declaration dropped. nu:413:20

    Unknown property 'behavior'.  Declaration dropped. nu:415:10

    Unknown property 'text-wrap'.  Declaration dropped. nu:445:11

    render (Area: pageShell): timer started clarity_main_min.js:209

    render (Area: pageShell): 41.04ms clarity_main_min.js:210

    onResponseReceived (Area: RenderRequestCallback): 50.23ms clarity_main_min.js:210

    processAction (Area: LegacyClientImpl): timer started clarity_main_min.js:209

    onResponseReceived (Area: RenderRequestCallback): timer started clarity_main_min.js:209

    render (Area: pageShell): timer started clarity_main_min.js:209

    render (Area: pageShell): 19.41ms clarity_main_min.js:210

    onResponseReceived (Area: RenderRequestCallback): 24.04ms clarity_main_min.js:210

    processAction (Area: LegacyClientImpl): 368.87ms clarity_main_min.js:210

    processAction (Area: LegacyClientImpl): timer started clarity_main_min.js:209

    POST

    XHR

    https://pww.dev.clarity.xxxx.com/niku/nu [HTTP/1.1 200 OK 349ms]

    onResponseReceived (Area: RenderRequestCallback): timer started clarity_main_min.js:209

    render (Area: pageShell): timer started clarity_main_min.js:209

    render (Area: pageShell): 39.04ms clarity_main_min.js:210

    onResponseReceived (Area: RenderRequestCallback): 58.77ms clarity_main_min.js:210

    processAction (Area: LegacyClientImpl): 537.02ms clarity_main_min.js:210

    GET

    https://pww.dev.clarity.xxxx.com/reportservice/flow.html [HTTP/1.1 200 OK 183ms]

    POST

    XHR

    https://pww.dev.clarity.xxxx.com/niku/nu [HTTP/1.1 200 OK 453ms]

    processAction (Area: LegacyClientImpl): timer started clarity_main_min.js:209

    POST

    XHR

    https://pww.dev.clarity.xxxx.com/niku/nu [HTTP/1.1 200 OK 342ms]

    onResponseReceived (Area: RenderRequestCallback): timer started clarity_main_min.js:209

    render (Area: pageShell): timer started clarity_main_min.js:209

    render (Area: pageShell): 44.07ms clarity_main_min.js:210

    onResponseReceived (Area: RenderRequestCallback): 55.91ms clarity_main_min.js:210

    processAction (Area: LegacyClientImpl): 410.47ms clarity_main_min.js:210

    GET

    https://pww.dev.clarity.xxxx.com/reportservice/flow.html [HTTP/1.1 200 OK 188ms]

    POST

    XHR

    https://pww.dev.clarity.xxxx.com/niku/nu [HTTP/1.1 200 OK 333ms]

     

    Hope this helps you!

     

    Thanks,

    Agin



  • 7.  Re: Advance reporting link navigates to blank page in Jaspersoft installation

    Posted 03-23-2016 04:54 AM

    Looks like you have HTTPS connection to CA PPM, do you have HTTPS set up in Jaspersoft. What is the CA PPM version, and what is the SSL setting you have



  • 8.  Re: Advance reporting link navigates to blank page in Jaspersoft installation

    Posted 03-23-2016 05:47 AM

    Thanks Suman.

     

    We are using CA PPM 14.3 and jaspersoft version is going to use is 6.1.0. 

     

    We are using HTTPS connection to CA PPM load balancer. Loadbalancer to  App server are communicating with http protocol.

    For jaspersoft, we are using http protocol to communicate (link for jaspersoft console:http://pww.dev.bo.clarity.xxxx.com:8080/reportservice  )

     

    Thanks,

    Agin



  • 9.  Re: Advance reporting link navigates to blank page in Jaspersoft installation

    Posted 03-23-2016 06:00 AM

    There is a known bug in CA PPM where browser thinks when you navigate from htttps to http it thinks vulnerable and stops it. Can you apply patch 5 of 14.3 and test.

     

    CLRT-79397: "SSL is used but processed externally" setting in the NSA breaks the ability to run a report in Advanced Reporting.

    (TEC1021234)



  • 10.  Re: Advance reporting link navigates to blank page in Jaspersoft installation

    Posted 03-23-2016 09:42 AM

    Thanks Suman.

     

    I will share this information with the team and make the changes and let you know about the status.

     

    Thanks,

    Agin



  • 11.  Re: Advance reporting link navigates to blank page in Jaspersoft installation

    Posted 04-05-2016 01:16 PM

    Hi All,

     

    We have updated our application with patch 5 (now version is 14.3.0.298.05) After patching we have done this steps also

     

         a)  From <install_dir>/bin directory command prompt, enter the following command to upgrade the report content:

    admin content-jaspersoft csk -userName <superuser> -password <password> upgrade -retryCount 50

     

         b) Restart all PPM services.

     

         c) Run the Load Data Warehouse Access Rights job.

     

    Still we are getting the same error. I am attaching the browser console for your reference.

     

    clarity_main_min.js:209 'console.markTimeline' is deprecated. Please use 'console.timeStamp' instead.

    clarity_main_min.js:210 render (Area: pageShell): 553.972ms

    clarity_main_min.js:210 onResponseReceived (Area: RenderRequestCallback): 567.136ms

     

    Please help me. how i fix this issue.

     

    Thanks,

    Agin



  • 12.  Re: Advance reporting link navigates to blank page in Jaspersoft installation

    Posted 05-06-2016 12:38 PM

    Hi Suman,

     

    Regarding the Clarity Bug CLRT-79397, We have installed Patch 5 and it does not work as intended in a load balanced environment.

    When the HTTPS is enabled at load balancer level, and communication happens b/w LB and App server in HTTP Protocol, in that case patch 5 does not give expected result and still throws the Mixed Content issue in Chrome.

     

    We have 2 app servers which are load balanced.

     

    Although this patch works amazingly well in our lower environments where there is no load balancing.

     

    Note : Our CSA has correct setting, SSL is used but processed externally.



  • 13.  Re: Advance reporting link navigates to blank page in Jaspersoft installation

    Posted 05-08-2016 03:31 PM

    Hi Nirbhay,

     

    if you have HTTPS enabled in load balancer then ideally your communication should be HTTPS end to end, what you can do to eliminate the load balancer is install HTTPS on the app server and then hit the URL and see how it goes.

     

    Regards

    Suman Pramanik



  • 14.  Re: Advance reporting link navigates to blank page in Jaspersoft installation

    Posted 05-09-2016 07:14 AM

    Hi Suman,

     

     

    "if you have HTTPS enabled in load balancer then ideally your communication should be HTTPS end to end"

         I cannot understand it, a load balancer can very well have an HTTP connection with underlying web servers but can present the same to other networks as HTTPS connection. That is the way to avoid implementing SSL on every single app server.

     

    "what you can do to eliminate the load balancer is install HTTPS on the app server and then hit the URL and see how it goes."

         This is a production environment and I cannot try anything like this that too when theoretically this patch fix was supposedly developed to resolve this issue. Also, if having an HTTPS load balancer means to have every other app server to have HTTPS too then what is the point of having 'SSL Used but processed Externally' option in CSA.

     

    I believe it is requirement miss or lack of testing at CA part before they released the patch.



  • 15.  Re: Advance reporting link navigates to blank page in Jaspersoft installation

    Posted 05-09-2016 08:16 AM

    Hi Nirbhay,

     

    It is the problem with load balancer, we do have customers running in our own ondemand and we are using the same set up and it does run quite well.

     

     

    Regards

    Suman Pramanik



  • 16.  RE: Re: Advance reporting link navigates to blank page in Jaspersoft installation

    Posted 06-18-2019 07:50 AM
    Hi Suman, We are having the same issue with Clarity 15.6 and Jaspersoft 7.1 . Is there any suggestion around this?

    Thanks,
    Ritesh


  • 17.  Re: Advance reporting link navigates to blank page in Jaspersoft installation

    Posted 03-23-2016 06:03 AM

    Suman,

     

    One more question regarding DWH.

     

    Our DB team has created DWH schema, table spaces and DB link also. We tested DB link using this query from DWH schema ( SELECT count(1) FROM SRM_RESOURCES@PPMDBLINK) we are getting output.

     

    in CSA status of datawarehouse is showing as available...But when we configure CSA  datawarehouse tab, we are getting the error "NSA-0125 Database link does not exit.

     

     

    Thanks,

    Agin



  • 18.  Re: Advance reporting link navigates to blank page in Jaspersoft installation

    Posted 03-23-2016 08:51 AM

    If you have created the DB link at database then you need to keep the field checked Custom Database Link( Leave the field unchecked to create a database link. Check the value if you have already created a database link in the database. )



  • 19.  Re: Advance reporting link navigates to blank page in Jaspersoft installation

    Posted 03-23-2016 09:48 AM

    Thanks Suman.

    I have followed the same step only. But getting the error.

     

    One more question regarding the DWH is Import the Data Warehouse Oracle Database Backup Image (Oracle)

    Could you please let me know what is the significance of this step for a fresh installation?

     

    Thanks

    Agin



  • 20.  Re: Advance reporting link navigates to blank page in Jaspersoft installation

    Posted 03-23-2016 11:43 AM

    Hi Agin,

     

    This provides the fresh schema structure for DWH database

     

    Regards

    Suman Pramanik



  • 21.  Re: Advance reporting link navigates to blank page in Jaspersoft installation

    Posted 03-29-2016 08:59 AM

    Thanks Suman.

     

    I have doubt in Import the Data Warehouse Oracle Database Backup Image (Oracle).

     

    1. 1.    In the CA PPM installation media, locate the Oracle PPM_DWH database image in the <root>/database folder.

    This step refers to the application server dwhschema in the root/database folder. correct me, if am wrong.

    how i can locate the file? is it is the xml files are mentioned as image in the folders like view, table, procedure, packagebody etc.

     

    Thanks,

    Agin



  • 22.  Re: Advance reporting link navigates to blank page in Jaspersoft installation

    Posted 03-29-2016 09:01 AM

    Hi Agin,

     

    The DWH is a database where data is copied from PPM to DWH, this schema is nothing to do with application server.

     

    Regards

    Suman Pramanik



  • 23.  Re: Advance reporting link navigates to blank page in Jaspersoft installation

    Posted 03-29-2016 09:06 AM

    Thanks for the quick reply Suman. So PPM_DWH database image will be available in the Database. Am i correct? Am little bit confused about the Oracle PPM_DWH database image.

    For this image backup i have to look in DB server. Am i right?

     

    Thanks,

    Agin



  • 24.  RE: Re: Advance reporting link navigates to blank page in Jaspersoft installation

    Posted 06-18-2019 07:51 AM
    Hi Suman, We are facing the same issue with Clarity 15.6 and Jaspersoft 7.1. Any suggestion around this?

    Thanks,
    Ritesh


  • 25.  RE: Re: Advance reporting link navigates to blank page in Jaspersoft installation

    Posted 06-18-2019 08:24 AM
    Hi Ritesh

    We need to check what error you are seeing this on app ca log as well as jasper log in order to know what problem you are facing.

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