View Only
  • 1.  Jaspersoft and failover cluster not working

    Posted Sep 19, 2017 02:28 AM

    Dear all,


    the configuration of a failover cluster with oracle works for CA PPM itself, but not for Jaspersoft, i.e. the admin update jasperParameters throws a NullPointerException when trying to update the database connection on the Jaspersoft side:


    (admin) Failed to update: jasperParameters
    at java.util.Hashtable.put(
    at com.niku.reporting.jasper.ClarityJasperAdmin.populateDBProperties(
    at com.niku.reporting.jasper.ClarityJasperAdmin.updatePPMAttrsForBeanDS(
    at com.niku.reporting.jasper.ClarityJasperAdmin.updateUserProfileAttrsForBeanDS(
    at com.niku.reporting.jasper.ClarityJasperAdmin.updateUserProfileAttrsForBeanDS(
    at com.niku.nsa.service.AdminManager.doUpdate(
    at com.niku.nsa.service.AdminManager.invokeAction(
    at com.niku.nsa.service.AdminManager.execute(
    at com.niku.nsa.service.Admin.main(
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(
    at java.lang.reflect.Method.invoke(
    at com.werken.forehead.Forehead.main(


    This is the setup of the database URLs:


    Please note that CA PPM is running fine using the configured URL, so I suspect that the update jasperParameters command is not able to correctly parse the URL.


    Has anyone already used a failover database cluster with CA PPM and Jaspersoft?
    Any hints are highly welcome!



  • 2.  Re: Jaspersoft and failover cluster not working

    Broadcom Employee
    Posted Sep 20, 2017 03:15 AM

    Hi George,


    Can you check what connection properties is defined in context.xml i.e.  \Tomcat\webapps\reportservice\META-INF\content.xml


    Also see this thread and it might help you Change of Jaspersoft Database Connection String of PPM_JASPERSOFT 



    Suman Pramanik

  • 3.  Re: Jaspersoft and failover cluster not working

    Posted Sep 20, 2017 07:15 AM

    Hi Suman,


    thank you very much for your hint.

    In fact, we have already changed the context.xml and it works -> Jaspersoft would start up.


    Still, the jasperParameters command uses the properties.xml so I guess we have to change something there.




  • 4.  Re: Jaspersoft and failover cluster not working

    Broadcom Employee
    Posted Sep 20, 2017 07:50 AM

    Thanks Georg  update command reads from properties.xml