Clarity

Expand all | Collapse all

Create and Update Jasper Reports User job Failing

Jump to Best Answer
  • 1.  Create and Update Jasper Reports User job Failing

    Posted 11-23-2015 06:19 AM

    Hi,

     

    I've installed JasperReports Server over Clarity PPM v14.2. After generating keystore & importing the content, the status of reports server in CSA remains unavailable. User ppmjasperadmin gets created on clarity & report server as well. After importing the content I'm trying to run Create & Update Reports User job & getting following exception.

     

    Please let me with the below issue:

     

    SYS   2015-11-23 03:53:35,077 [Dispatch pool-4-thread-4 : bg@APSES2212 (tenant=clarity)] jaspersoft.ClarityJasperAdmin (clarity:PAGRAWA1:12966255__7AAE303B-814B-436F-8E3C-640E15BBCAA4:Create and Update Jaspersoft Users) User ppmjasperadmin not available in report server. Unauthorized code:401  parameter:

    ERROR 2015-11-23 03:53:35,077 [Dispatch pool-4-thread-4 : bg@APSES2212 (tenant=clarity)] jaspersoft.ClarityJasperAdmin (clarity:PAGRAWA1:12966255__7AAE303B-814B-436F-8E3C-640E15BBCAA4:Create and Update Jaspersoft Users) Login success, but Unauthorized access to http://apses3641.dmzmgmt.uhc.com/ppm_stg2 with username ppmjasperadmin

    ERROR 2015-11-23 03:53:35,077 [Dispatch pool-4-thread-4 : bg@APSES2212 (tenant=clarity)] jaspersoft.ClarityJasperAdmin (clarity:PAGRAWA1:12966255__7AAE303B-814B-436F-8E3C-640E15BBCAA4:Create and Update Jaspersoft Users) Could not login to http://apses3641.dmzmgmt.uhc.com/ppm_stg2 with username ppmjasperadmin

    ERROR 2015-11-23 03:53:35,077 [Dispatch pool-4-thread-4 : bg@APSES2212 (tenant=clarity)] jaspersoft (clarity:PAGRAWA1:12966255__7AAE303B-814B-436F-8E3C-640E15BBCAA4:Create and Update Jaspersoft Users) Failed to get an instance of ClarityJasperAdmin ::

    com.ca.jasper.restAdapter.JasperException: Unauthorized access to http://apses3641.dmzmgmt.uhc.com/ppm_stg2 with username ppmjasperadmin

    at com.niku.union.reporting.jaspersoft.ClarityJasperAdmin.login(ClarityJasperAdmin.java:243)

    at com.niku.union.reporting.jaspersoft.ClarityJasperAdmin.createInstance(ClarityJasperAdmin.java:139)

    at com.niku.reporting.jobs.jasper.ClarityJasperUserSyncJob.init(ClarityJasperUserSyncJob.java:46)

    at com.niku.reporting.jobs.jasper.ClarityJasperUserSyncJob.scheduledEventFired(ClarityJasperUserSyncJob.java:74)

    at com.niku.njs.Dispatcher$BGTask.run(Dispatcher.java:367)

    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

    at java.lang.Thread.run(Thread.java:745)

    ERROR 2015-11-23 03:53:35,078 [Dispatch pool-4-thread-4 : bg@APSES2212 (tenant=clarity)] common.BaseJobUtils (clarity:PAGRAWA1:12966255__7AAE303B-814B-436F-8E3C-640E15BBCAA4:Create and Update Jaspersoft Users) Failed to get an instance of ClarityJasperAdmin ::

    com.ca.jasper.restAdapter.JasperException: Unauthorized access to http://apses3641.dmzmgmt.uhc.com/ppm_stg2 with username ppmjasperadmin

    at com.niku.union.reporting.jaspersoft.ClarityJasperAdmin.login(ClarityJasperAdmin.java:243)

    at com.niku.union.reporting.jaspersoft.ClarityJasperAdmin.createInstance(ClarityJasperAdmin.java:139)

    at com.niku.reporting.jobs.jasper.ClarityJasperUserSyncJob.init(ClarityJasperUserSyncJob.java:46)

    at com.niku.reporting.jobs.jasper.ClarityJasperUserSyncJob.scheduledEventFired(ClarityJasperUserSyncJob.java:74)

    at com.niku.njs.Dispatcher$BGTask.run(Dispatcher.java:367)

    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

    at java.lang.Thread.run(Thread.java:745)

    ERROR 2015-11-23 03:53:35,086 [Dispatch pool-4-thread-4 : bg@APSES2212 (tenant=clarity)] niku.njs (clarity:PAGRAWA1:12966255__7AAE303B-814B-436F-8E3C-640E15BBCAA4:Create and Update Jaspersoft Users) Error executing job: 5821003

    com.ca.jasper.restAdapter.JasperException: Unauthorized access to http://apses3641.dmzmgmt.uhc.com/ppm_stg2 with username ppmjasperadmin

    at com.niku.union.reporting.jaspersoft.ClarityJasperAdmin.login(ClarityJasperAdmin.java:243)

    at com.niku.union.reporting.jaspersoft.ClarityJasperAdmin.createInstance(ClarityJasperAdmin.java:139)

    at com.niku.reporting.jobs.jasper.ClarityJasperUserSyncJob.init(ClarityJasperUserSyncJob.java:46)

    at com.niku.reporting.jobs.jasper.ClarityJasperUserSyncJob.scheduledEventFired(ClarityJasperUserSyncJob.java:74)

    at com.niku.njs.Dispatcher$BGTask.run(Dispatcher.java:367)

    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

    at java.lang.Thread.run(Thread.java:745)

     

    Regards,

    Divyanshu Dhyani



  • 2.  Re: Create and Update Jasper Reports User job Failing

    Posted 11-23-2015 08:13 AM

    Have you checked this ?

     

    Jaspersoft Installation - Create and Update Jaspersoft Users - failed

    https://communities.ca.com/message/241840326#241840326

     

    NJ



  • 3.  Re: Create and Update Jasper Reports User job Failing

    Posted 11-23-2015 08:15 AM

    And this ?

     

    Error Job Create and Update Jaspersoft Users.

    Re: Error Job Create and Update Jaspersoft Users.

     

     

    NJ



  • 4.  Re: Create and Update Jasper Reports User job Failing

    Posted 11-24-2015 01:16 AM

    Hi NJ,

     

    I tried steps provided in this link, but the job is still failing & reportserver status is Unavailable in CSA.

     



  • 5.  Re: Create and Update Jasper Reports User job Failing

    Posted 11-23-2015 08:33 AM

    Hi Divyanshu,

     

    Did you imported the jaspersoft content pack before you ran the job.

     

    Regards

    Suman Pramanik



  • 6.  Re: Create and Update Jasper Reports User job Failing

    Posted 11-23-2015 01:56 PM

    Yes I did as per the CA installation document.



  • 7.  Re: Create and Update Jasper Reports User job Failing

    Posted 11-23-2015 10:56 AM

    Hi Divyanshu,

     

    the message indicates that the user ppmjasperadmin is available (please make sure by looking in the list of inactive resources).

    The issue seems to be that the keystore has to be created and deployed in the Jaspersoft installation as described in the installation log:

    admin jasper keystore

    ...

     

    Regards

    Georg



  • 8.  Re: Create and Update Jasper Reports User job Failing

    Posted 11-23-2015 02:04 PM

    Hi Georg,

     

    I've already changed the status of ppmjasperadmin user from inactive to active.

     

    This user got created on Clarity & Jasper server after importing the Jaspersoft content.

     

    Command I used for generating key store is:

     

    admjn jasper keystore -key jasperkey -password jasperpwd



  • 9.  Re: Create and Update Jasper Reports User job Failing

    Posted 11-23-2015 02:28 PM

    Hi Divyanshu,

     

    You need not change he user from inactive to active, please delete the organization and reimport again. If you cannot delete the organization then try the below steps

     

     

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

     

    Regards

    Suman

     

     



  • 10.  Re: Create and Update Jasper Reports User job Failing

    Posted 11-24-2015 01:14 AM

    Hi Suman,

     

    I tried it but still job is failing. And, status of report server is still Unavailable in CSA.

     



  • 11.  Re: Create and Update Jasper Reports User job Failing

    Posted 11-24-2015 06:44 AM

    The job is bound to fail if the jasper soft server is unavailable. Can you check if the services of Jaspersoft is running.



  • 12.  Re: Create and Update Jasper Reports User job Failing

    Posted 11-24-2015 07:40 AM

    Yes, I've started Tomcat & can login to JasperReports Server using superuser. If I assign advanced reporting rights to a user in clarity, that user is getting created on report server as well.

     

    But CSA is showing reportserver as unavailable & job is failing as well.



  • 13.  Re: Create and Update Jasper Reports User job Failing

    Posted 11-24-2015 07:58 AM

    so the problem is from your application server its not able to communicate to jaspersoft server as its showing unavailable.



  • 14.  Re: Create and Update Jasper Reports User job Failing

    Posted 11-24-2015 08:02 AM

    Thanks Suman...

     

    So what would you suggest in this case.



  • 15.  Re: Create and Update Jasper Reports User job Failing

    Posted 11-24-2015 08:19 AM

    ensure the communication is successful from your app servers. Some sort of network investigation needs also to be done



  • 16.  Re: Create and Update Jasper Reports User job Failing

    Posted 11-24-2015 10:43 AM

    Hi Divyanshu,

     

    Have you specified the port as well in your CSA - Reporting - Web URL? From your error message it looks like you did not.


    The WebURL should look like this (replace servername with your exact servername, port 8081 with your exact port, and reportservice with the exact target you specified when installing Jaspersoft):
    http://SERVERNAME:8081/reportservice

     

    Then Save and see if it shows Available in CSA.

     

    Hope this helps.

     

    Kind Regards

    Nika Hadzhikidi
    CA Technologies
    Principal Support Engineer



  • 17.  Re: Create and Update Jasper Reports User job Failing

    Posted 11-26-2015 01:19 AM

    Thanks Nika...But issue still persists after providing the port details....Now, I've raised a Case with CA as we followed same steps in our Dev & Test servers & installed it successfully....



  • 18.  Re: Create and Update Jasper Reports User job Failing

    Posted 12-08-2015 03:37 AM

    Thanks everybody for your support....The issue got resolved now with the help of Suman Pramanik....



  • 19.  Re: Create and Update Jasper Reports User job Failing
    Best Answer

    Posted 12-08-2015 04:34 AM

    Thanks Divyanshu for letting us know.

     

    The problem was the connection details needed to be updated on the CSA where CSA was running but initially it was updated on the other servers.

     

    Regards

    Suman Pramanik



  • 20.  Re: Create and Update Jasper Reports User job Failing

    Posted 08-16-2017 05:00 PM

    Hi Suman,

     

    Could you please elaborate more on this one? We refreshed the UAT DB with prod DB and now we are getting this issue in UAT. the CSA has correct details. Can you please let me know what exactly needs to be changed?

     

    Best Regards,

    Venu



  • 21.  Re: Create and Update Jasper Reports User job Failing

    Posted 08-17-2017 06:00 AM

    Once you refresh the enviornment you need to run the below command to sync the keystore file

     

     admin jaspersoft syncPPMContext -userName superuser -password superuser (14.3,14.4,15.1,15.2)



  • 22.  Re: Create and Update Jasper Reports User job Failing

    Posted 08-17-2017 10:13 AM

    Hi Suman,

     

    Now we are able access the advanced Reporting, but i am getting below error for many reports. We are on Clarity 15.1 and Jasper 6.2.1.

     

    Caused by: javax.crypto.BadPaddingException: Given final block not properly padded
    at com.sun.crypto.provider.CipherCore.doFinal(CipherCore.java:989)
    at com.sun.crypto.provider.CipherCore.doFinal(CipherCore.java:845)
    at com.sun.crypto.provider.AESCipher.engineDoFinal(AESCipher.java:446)
    at javax.crypto.Cipher.doFinal(Cipher.java:2165)
    at com.ca.jasper.encryption.PPMEncryptor.decrypt(PPMEncryptor.java:224)
    at com.ca.jasper.encryption.PPMEncryptionService.decrypt(PPMEncryptionService.java:83)
    at com.ca.jasper.jdbc.JaaSProxyJDBCPoolDataSourceFactoryHelper.decryptAttributeValue(JaaSProxyJDBCPoolDataSourceFactoryHelper.java:841)
    at com.ca.jasper.jdbc.JaaSProxyJDBCPoolDataSourceFactoryHelper.populateJDBCDataSourceInfo(JaaSProxyJDBCPoolDataSourceFactoryHelper.java:92)
    ... 176 more
    2017-08-17 09:54:48,007 ERROR JaaSProxyJDBCPoolDataSourceFactoryHelper,http-bio-8080-exec-8:1237 [vzw|vennve9] - JaaSProxyJDBCPoolDataSourceFactoryHelper.createService(){Tenant=vzw,User=vennve9}-Error in decrypting attribute with name:emailValidDomains_enc and value=8a4Z5Eo3/pGkgK15pA4DEeXbYIs8Z0nD155HOIdC0SpQnQWOd6oiQohson0B4xNiLVJj5EPCO9D+K6syHbTINC0T5znX2lfv0Dk32RV0hQ0=::javax.crypto.BadPaddingException: Given final block not properly padded



  • 23.  Re: Create and Update Jasper Reports User job Failing

    Posted 08-17-2017 10:42 AM