Clarity PPM1

Expand all | Collapse all

getting error message in importing advance reporting content in Jaspersoft installation

Jump to Best Answer

Agin03-08-2016 11:24 AM

  • 1.  getting error message in importing advance reporting content in Jaspersoft installation

    Posted 03-08-2016 03:04 AM

    Hi All,

    I am doing Jaspersoft installation 6.1.0 in our PPM14.3. (Not upgrade). Made changes in CSA as per the organization name in jasper console. Then created keystore and placed in the Tomcat folder.

    Then i imported the content using the command admin content-jaspersoft csk -userName superuser -password <password>

    But am getting below error.

    3/7/16 7:52 AM (admin) Setting theme permissions..

    3/7/16 7:52 AM (admin) Setting global permissions..

    3/7/16 7:52 AM (admin) Error in updating permission

    com.ca.jasper.restAdapter.JasperException: Resource /organizations/organization_1/users not found.

            at com.ca.jasper.restAdapter.services.RestServiceBase.setJSErrorMesage(RestServiceBase.java:270)

            at com.ca.jasper.restAdapter.services.RestServiceBase.setMetaInfo(RestServiceBase.java:284)

            at com.ca.jasper.restAdapter.services.RestServiceBase.restServicePut(RestServiceBase.java:383)

            at com.ca.jasper.restAdapter.services.RestServiceBase.restServicePut(RestServiceBase.java:370)

            at com.ca.jasper.restAdapter.services.PermissionService.updateSinglePermission(PermissionService.java:301)

            at com.niku.reporting.jasper.ClarityJasperAdmin.updatePermission(ClarityJasperAdmin.java:2327)

            at com.niku.reporting.jasper.ClarityJasperAdmin.setPermissionUsersFolder(ClarityJasperAdmin.java:2621)

            at com.niku.reporting.jasper.ClarityJasperAdmin.jasperContent(ClarityJasperAdmin.java:806)

            at com.niku.nsa.service.AdminManager.doJasperReports(AdminManager.java:811)

            at com.niku.nsa.service.AdminManager.invokeAction(AdminManager.java:289)

            at com.niku.nsa.service.AdminManager.execute(AdminManager.java:188)

            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:497)

            at com.werken.forehead.Forehead.run(Forehead.java:551)

            at com.werken.forehead.Forehead.main(Forehead.java:581)

    3/7/16 7:52 AM (admin) Error in updating permission

    com.ca.jasper.restAdapter.JasperException: Resource /organizations/organization_1/users not found.

            at com.ca.jasper.restAdapter.services.RestServiceBase.setJSErrorMesage(RestServiceBase.java:270)

            at com.ca.jasper.restAdapter.services.RestServiceBase.setMetaInfo(RestServiceBase.java:284)

            at com.ca.jasper.restAdapter.services.RestServiceBase.restServicePut(RestServiceBase.java:383)

            at com.ca.jasper.restAdapter.services.RestServiceBase.restServicePut(RestServiceBase.java:370)

            at com.ca.jasper.restAdapter.services.PermissionService.updateSinglePermission(PermissionService.java:301)

            at com.niku.reporting.jasper.ClarityJasperAdmin.updatePermission(ClarityJasperAdmin.java:2327)

            at com.niku.reporting.jasper.ClarityJasperAdmin.setPermissionUsersFolder(ClarityJasperAdmin.java:2623)

            at com.niku.reporting.jasper.ClarityJasperAdmin.jasperContent(ClarityJasperAdmin.java:806)

            at com.niku.nsa.service.AdminManager.doJasperReports(AdminManager.java:811)

            at com.niku.nsa.service.AdminManager.invokeAction(AdminManager.java:289)

            at com.niku.nsa.service.AdminManager.execute(AdminManager.java:188)

            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:497)

            at com.werken.forehead.Forehead.run(Forehead.java:551)

            at com.werken.forehead.Forehead.main(Forehead.java:581)

    3/7/16 7:52 AM (admin) Importing content completed..

     

    Can anyone help me. why am getting this error? How i can sort out the issue?

     

    Thanks in advance,

    Agin



  • 2.  Re: getting error message in importing advance reporting content in Jaspersoft installation

    Posted 03-08-2016 03:19 AM


  • 3.  Re: getting error message in importing advance reporting content in Jaspersoft installation

    Posted 03-08-2016 11:24 AM

    Thanks NJ.



  • 4.  Re: getting error message in importing advance reporting content in Jaspersoft installation

    Posted 03-08-2016 04:11 AM

    Hi Agin,

     

    Did you had any organization before in jasper console, was the keystore creation was successful.

     

    Regards

    Suman Pramanik



  • 5.  Re: getting error message in importing advance reporting content in Jaspersoft installation

    Posted 03-08-2016 11:23 AM

    It was showing a default organization name: 'Organization' in the jasper console. Hence I edited the organization name to my client name.

     

    I have changed the organization name in the console by:

    Manage --> Organizations  then click on Edit button and changed the name. Then save the same.

     

    Keystore creation was successful and placed those file in Jaspersoft Tomcat folder also.

     

    Thanks Suman for your continuous support on this.

    Thanks,

    Agin



  • 6.  Re: getting error message in importing advance reporting content in Jaspersoft installation

    Posted 03-08-2016 11:27 AM

    Hi Agin,

     

    You should never edit the organization name in Jasper console, can you delete the organization name from Jasperconsole, delete the key store. Now key in the organization name in CSA and generate the key store and then import the content.

     

    Regards

    Suman Pramanik



  • 7.  Re: getting error message in importing advance reporting content in Jaspersoft installation

    Posted 03-09-2016 06:54 AM

    Thanks Suman

    I have deleted the organization name from the console. then followed steps you mentioned. But while importing. I am getting below error

    $./admin content-jaspersoft csk -userName superuser -password superuser

    Content File Name  jaspersoft_csk.zip

    Logging into server ... http://***********************/reportservice

    Getting tenant information... organizations

    Creating new tenant... organizations

    Tenant already exists code:tenant.already.exists  parameter:organizations

    Content import failed..

     

    Jaspersoft console page.png

    After deleting the organization, Jaspersoft console page look like this.

     

    How to remove tenant? Can you help me on this?

     

    Thanks,

    Agin



  • 8.  Re: getting error message in importing advance reporting content in Jaspersoft installation

    Posted 03-09-2016 09:07 AM

    Hi Agin,

    The problem is happening because jaspersoft was already installed and reference is left at database

     

    go to cmn_install_history and delete the row where install_id = contentPack::csk::jaspersoft

    and then import again



  • 9.  Re: getting error message in importing advance reporting content in Jaspersoft installation

    Posted 03-09-2016 10:05 AM

    Thanks Suman.

    But i have already deleted the reference by running this sql code: delete from cmn_install_history where install_id = 'contentPack::csk::jaspersoft'. before recreating the keystore.

     

    Thanks,

    Agin



  • 10.  Re: getting error message in importing advance reporting content in Jaspersoft installation

    Posted 03-09-2016 10:30 AM

    Hi Agin,

     

    Looks like the way your renamed the organization caused the problem, try below steps

     

    1. Delete the organization from jasper console

    2. Delete the key store

    3. Delete from cmn_install table

    4. Fill in the organization name in CSA

    5. Generate the key store

    6. Copy the keystore to jasper server

    7. Import the content.

     

    Let me know how it goes


    Regards

     

     

    Suman Pramanik



  • 11.  Re: getting error message in importing advance reporting content in Jaspersoft installation

    Posted 03-09-2016 11:25 AM

    Hi Suman,

     

    I have already executed the above  steps. After deletion of the organization, in jasperconsole am getting the root. (attached screenshot in the above post).

    Then deleted the keystore from Application server and jasper reporting server.

    Then executed the sql code to delete the table content using (delete from cmn_install_history where install_id = 'contentPack::csk::jaspersoft')

    Filled the organization name as 'root' and organization id as 'organizations' (can be seen in the screenshot).

    Then i generated keystore in Application server.then copied the .jks and .properties files to reporting server tomcat folder.

    After that i imported the content. At that time, i got the error.

     

    Thanks,

    Agin.



  • 12.  Re: getting error message in importing advance reporting content in Jaspersoft installation

    Posted 03-09-2016 11:40 AM

    Hi Agin,

     

    I would request you to raise a case and we can go with you over web ex and help you out. Those are the only steps required to get it working

     

    Regards

    Suman Pramanik



  • 13.  Re: getting error message in importing advance reporting content in Jaspersoft installation

    Posted 03-10-2016 09:10 AM

    Thanks Suman ..Have created a case on CA Support (00332214)



  • 14.  Re: getting error message in importing advance reporting content in Jaspersoft installation
    Best Answer

    Posted 03-16-2016 08:53 AM

    This problem is now resolved.

    The organization name trying to be used was: organizations.

     

    Suggested using a different name, since that parameter existed in Jaspersoft

     

    ***

    $./admin content-jaspersoft csk -userName superuser -password superuser

    Content File Name  jaspersoft_csk.zip

    Logging into server ... http://***********************/reportservice

    Getting tenant information... organizations

    Creating new tenant... organizations

    Tenant already exists code:tenant.already.exists  parameter:organizations

    Content import failed..

    ***

     

    Jaspersoft was at the end reinstalled.



  • 15.  Re: getting error message in importing advance reporting content in Jaspersoft installation

    Posted 03-16-2016 08:58 AM