Clarity

  • 1.  DB restore and Jaspersoft issue

    Posted 11-15-2016 10:21 PM

    Hi,  
    For our POC, we installed Jaspersoft as per the procedure provided by documents in Development environment.


    Now we are setting up the new server for DEV Jaspersoft reporting.   We restored the existing Clarity DB in dev from Production.

    FYI, there was no Jaspersoft in Production.

     

    Now When we try to check the DB in Clarity NSA(CSA), db shows as unavailable. When we try to save the Database page in Clarity NSA, it throws a Error

     "Failed to update properties on the Jaspersoft server. Could not login to http://jasper:8081/Jaspersoft with username ppmjasperadmin. Please make sure the server is available and that the login credentials are correct.

     

      When I checked the Reporting page in NSA, it shows the old details of Jaspersoft which we used for POC. We can't remove the details.  

     

    Is there a way we need to remove any Jasper details from NSA?

    Do we need to remove any Jasper related from Application server like Keystore?  A

     

    Also when I ran the health check, it shows the issue with DB server. But we were able to connect the DEV DB using SQL Developer.  Please do advice .

     

    Thanks 

    Sreeram



  • 2.  Re: DB restore and Jaspersoft issue

    Broadcom Employee
    Posted 11-16-2016 01:37 AM

    Hi Sreeram,

     

    The message you are getting is because CSA is trying to login to Jaspersoft server, however that is completely different from database unavailable. Are you able to connect the database though any client tool.

     

    Regards

    Suman Pramanik 



  • 3.  Re: DB restore and Jaspersoft issue
    Best Answer

    Posted 11-18-2016 07:07 AM

    Hi Suman,

    We've restored the db to lower version. This created the issue. So We've reinstalled the NSA again and still we had issues.

    Then we reset the password to restored db and tried. It worked.

    Thanks for your support. You can close the case.

    Thanks

    Sreeram