Clarity PPM

Expand all | Collapse all

Error when generating Keystore using content-jaspersoft csk -userName ***-password ***

Jump to Best Answer
  • 1.  Error when generating Keystore using content-jaspersoft csk -userName ***-password ***

    Posted 02-08-2018 11:12 AM

    I am trying to generate keystore  for jaspersoft and cappm integration. But for some reason i am getting the below error.

     

    Updating user profile attributes..
     Data Warehouse Bean DS URL : jdbc:sqlserver://servname:1433;databaseName=ppm_dwh
    Error in updating PPM Data Source dwhDBVendor_enc, value = mssql
    Failed to import content for tenant
    com.ca.jasper.restAdapter.JasperException: Invalid AES key length: 8 bytes
    at com.ca.jasper.restAdapter.services.AttributeService.encryptAttributeValue(AttributeService.java:2093)
    at com.ca.jasper.restAdapter.services.AttributeService.updateUserAttribute(AttributeService.java:398)
    at com.niku.reporting.jasper.ClarityJasperAdmin.updateProfileAttribute(ClarityJasperAdmin.java:1876)
    at com.niku.reporting.jasper.ClarityJasperAdmin.updateProfileAttribute(ClarityJasperAdmin.java:1851)
    at com.niku.reporting.jasper.ClarityJasperAdmin.updateDWHAttrsForBeanDS(ClarityJasperAdmin.java:1701)
    at com.niku.reporting.jasper.ClarityJasperAdmin.updateUserProfileAttrsForBeanDS(ClarityJasperAdmin.java:1992)
    at com.niku.reporting.jasper.ClarityJasperAdmin.jasperContent(ClarityJasperAdmin.java:846)
    at com.niku.nsa.service.AdminManager.doJasperReports(AdminManager.java:1008)
    at com.niku.nsa.service.AdminManager.invokeAction(AdminManager.java:298)
    at com.niku.nsa.service.AdminManager.execute(AdminManager.java:197)
    at com.niku.nsa.service.Admin.main(Admin.java:77)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at com.werken.forehead.Forehead.run(Forehead.java:551)
    at com.werken.forehead.Forehead.main(Forehead.java:581)

     

     PM Error executing command: content-jaspersoft csk -userName ****** -password ******
    com.ca.jasper.restAdapter.JasperException: Invalid AES key length: 8 bytes
    at com.ca.jasper.restAdapter.services.AttributeService.encryptAttributeValue(AttributeService.java:2093)
    at com.ca.jasper.restAdapter.services.AttributeService.updateUserAttribute(AttributeService.java:398)
    at com.niku.reporting.jasper.ClarityJasperAdmin.updateProfileAttribute(ClarityJasperAdmin.java:1876)
    at com.niku.reporting.jasper.ClarityJasperAdmin.updateProfileAttribute(ClarityJasperAdmin.java:1851)
    at com.niku.reporting.jasper.ClarityJasperAdmin.updateDWHAttrsForBeanDS(ClarityJasperAdmin.java:1701)
    at com.niku.reporting.jasper.ClarityJasperAdmin.updateUserProfileAttrsForBeanDS(ClarityJasperAdmin.java:1992)
    at com.niku.reporting.jasper.ClarityJasperAdmin.jasperContent(ClarityJasperAdmin.java:846)
    at com.niku.nsa.service.AdminManager.doJasperReports(AdminManager.java:1008)
    at com.niku.nsa.service.AdminManager.invokeAction(AdminManager.java:298)
    at com.niku.nsa.service.AdminManager.execute(AdminManager.java:197)
    at com.niku.nsa.service.Admin.main(Admin.java:77)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at com.werken.forehead.Forehead.run(Forehead.java:551)
    at com.werken.forehead.Forehead.main(Forehead.java:581)

     

     

    I have already tried to delete the Organisation Name from jaspersoft  and also deleted related values from table "CMN_INSTALL_HISTORY ", but still the issue continues to persist.

     

    Any suggestion will be appreciate.  I have installed jaspersoft 6.5.1. and my ca clarity version is 15.3. 



  • 2.  Re: Error when generating Keystore using content-jaspersoft csk -userName ***-password ***

    Posted 02-08-2018 11:44 AM

    Hi AEC-CA ,

     

    Can you try to execute the commands in sequence:

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

     

    admin jaspersoft keystore

     

    Let me know if it works for you.

     

    /Shubham



  • 3.  Re: Error when generating Keystore using content-jaspersoft csk -userName ***-password ***

    Posted 02-08-2018 12:07 PM

    I changed the Organisation name in the NSA and tried to run the command without upgrade switch. This time everything was successful. But for some reason the keystore was not generated.



  • 4.  Re: Error when generating Keystore using content-jaspersoft csk -userName ***-password ***

    Posted 02-08-2018 12:26 PM

    Try by executing the cmd with upgrade switch and then create keystore (admin jaspersoft keystore)

     

    If still the issue persists, let me know the error message.



  • 5.  Re: Error when generating Keystore using content-jaspersoft csk -userName ***-password ***
    Best Answer

    Posted 02-08-2018 12:36 PM

    In my last try after changing the name of the organisation, i did not run the command to create keystore (admin jaspersoft keystore). This time i did that it works like a charm. Thanks Shubham for your suggestions. Really appreciate your support.