getting error message in importing advance reporting content in Jaspersoft installation

[Legacy User]

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

[navzjoshi00]

Can you check this ?

 

https://communities.ca.com/message/241864781#comment-241864781

 

NJ

[Legacy User]

Thanks NJ.

[Suman Pramanik]

Hi Agin,

 

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

 

Regards

Suman Pramanik

[Legacy User]

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

[Suman Pramanik]

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

[Legacy User]

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..

 

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

 

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

 

Thanks,

Agin

[Suman Pramanik]

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

[Legacy User]

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

[Suman Pramanik]

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

[Legacy User]

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.

[Suman Pramanik]

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

[Legacy User]

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

[Raul Montejano]

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.

[Suman Pramanik]

Thanks Raul_Montejano