Clarity

Expand all | Collapse all

Cannot create dashboards in jasper server from topic

Jump to Best Answer
  • 1.  Cannot create dashboards in jasper server from topic

    Posted 08-18-2016 07:26 AM

    Hi experts.

    We are unable to create dashboards on advanced reporting from an adhoc view that created from a topic.

    it is showing "an unexpected error has occured"

    there is no errors on jasper logs

    and the same view is running successfully when selecting it individually.

     

    Note:- it is possible if you are creating the view directly from domain.but as a topic it is not working

     

    please advice

     

    Thankyou

    Harun Prasu



  • 2.  Re: Cannot create dashboards in jasper server from topic

    Posted 08-18-2016 09:29 AM

    Hi Harun,

     

    What version of PPM you are running, I am testing the same using 14.4 and it does work?

     

    Regards

    Suman Pramanik



  • 3.  Re: Cannot create dashboards in jasper server from topic

    Posted 08-18-2016 10:05 AM

    Hi SumanPramanik,

    I am using CA PPM 14.3 .

     

    Let me explain what am doing.

    I am login to advanced reporting using a user which having the following roles.

     

    CF_Portfolio_Mgr(Custom role),

    ROLE_ADHOC_DESIGNER,

    ROLE_DASHBOARD_DESIGNER,

    ROLE_REPORT_DESIGNER,

    ROLE_USER

     

     

    1.created adhoc report using home--> create adhoc view

    2.selected the in build FInancial Management domain and chose the required fields.

    3.Navigate to Save as topic

    4.Saved the topic under "MyOrganization"-->"My OrganizationViews"-->"Financial Management"-->"Topic"-->TestTopic

    5.Created the view according to this topic--->TestView

    6.Topic Saved.

    7.Navigate to HOME-->Create Dashboards-->Drag "Test view" to it ..

    Getting the below error :-

     

    errorin dashboard.jpg

     

     

    couldn't find any logs for this error in the back end

     

    Thank You

    Harun Prasu



  • 4.  Re: Cannot create dashboards in jasper server from topic

    Posted 08-18-2016 10:16 AM

    Hi Harun,

     

    Thanks for the step and I could reproduce it and I got the below error

     

    2016-08-18 10:15:10,501 ERROR HibernateDaoImpl,http-apr-8080-exec-8:112 - ************** HibernateDaoImpl.executeWriteCallback EXCEPTION **********

    com.jaspersoft.jasperserver.api.metadata.common.service.JSResourceNotFoundException: jsexception.resource.of.type.not.found

      at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.findByURI(HibernateRepositoryServiceImpl.java:1089)

      at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.getReference(HibernateRepositoryServiceImpl.java:1256)

      at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource.getReference(Unknown Source)

     

    However I would like to know why you would want to save a topic and create a view and use that view in dashboard?

     

    Regards

    Suman Pramanik



  • 5.  Re: Cannot create dashboards in jasper server from topic

    Posted 08-18-2016 10:24 AM

    Hi Harun,

     

    I did another test, created a view saved it and used the same view in dashboard and it works.

     

    Regards

    Suman Pramanik



  • 6.  Re: Cannot create dashboards in jasper server from topic

    Posted 08-18-2016 10:34 AM

    SumanPramanik,

     

    On the right side navigation panel of "Create Dashboard ".There listed all the views the users is access to.

    So while drag and drop that views to dashboard the user doesn't know whetherit is created from a domain or topic.

    whether it's directly from a domain or topic it should work right??that's why

     

     

    Thank You

    Harun Prasu



  • 7.  Re: Cannot create dashboards in jasper server from topic

    Posted 08-18-2016 10:37 AM

    Agreed it looks buggy, if you create a view from Topic and use in dashboard it breaks. Stay tuned I will work with Jaspersoft and come back to you.



  • 8.  Re: Cannot create dashboards in jasper server from topic

    Posted 08-18-2016 10:41 AM

    SumanPramanik

    Ok sure. Thanks a lot!!

     

    Harun Prasu



  • 9.  Re: Cannot create dashboards in jasper server from topic

    Posted 08-22-2016 06:27 AM

    SumanPramanik Hi

    any update on this??

     

    Thank you



  • 10.  Re: Cannot create dashboards in jasper server from topic

    Posted 08-22-2016 06:36 AM

    Hi Harun,

     

    I am working with Jaspersoft and it certainly looks like a bug and I don't have a workaround yet.

     

    Regards

    Suman Pramanik



  • 11.  Re: Cannot create dashboards in jasper server from topic
    Best Answer

    Posted 08-25-2016 05:53 PM

    Hi Harun,

     

    I created a bug  CLRT-81070  Dashboard cannot be created from adhoc views created from Topic and once I find the fix will update you. 

     

    The cause behind the same is we are hiding the default topic folder from the organization created, so we need to re evaluate. 

     

    Regards

    Suman Pramanik



  • 12.  Re: Cannot create dashboards in jasper server from topic

    Posted 08-26-2016 05:35 AM

    SumanPramanik

     

    Thanks a lot ...appreciate your effort !!

     

    Harun Prasu