Clarity

I successfully completed jaspersfot setup, however users are not able to run the report.

When I run the report as superuser I get Null Pointer exception

Debug Log trace

2015-11-30 15:42:25,580 DEBUG EngineServiceImpl,http-bio-9880-exec-7:2261 - Setting report parameter LoggedInUser to MetadataUserDetails: superuser

2015-11-30 15:42:25,589 DEBUG RepositoryConnection,http-bio-9880-exec-7:92 - Loading resource "/ca_ppm/resources/localization/CSK_Report_Resource_Bundle.properties" from repository

2015-11-30 15:42:26,015 DEBUG RepositoryUtil,http-bio-9880-exec-7:42 - set repository context to context with path /ca_ppm/reports/resource_management/CSK_RES_CapVsAllocByOBS_files

2015-11-30 15:42:26,017 DEBUG RepositoryUtil,http-bio-9880-exec-7:42 - set repository context to null

2015-11-30 15:42:26,242 ERROR JDBCProxyDataSourcePool,http-bio-9880-exec-7:157 - ::org.apache.jasper.JasperException: Dynamic Proxy Data Source Pool can only be used at a Tenant Level context.. Null Data Source will be returned.

        at com.ca.jasper.jdbc.JDBCProxyDataSourcePool.createService(JDBCProxyDataSourcePool.java:153)

        at com.ca.jasper.jdbc.JDBCProxyDataSourcePool.createService(JDBCProxyDataSourcePool.java:791)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

2015-11-30 15:42:26,245 DEBUG EngineServiceImpl,http-bio-9880-exec-7:2261 - Setting report parameter LoggedInUser to MetadataUserDetails: superuser

2015-11-30 15:42:26,247 DEBUG EngineServiceImpl,http-bio-9880-exec-7:2261 - Setting report parameter LoggedInUsername to superuser

2015-11-30 15:42:26,249 DEBUG EngineServiceImpl,http-bio-9880-exec-7:2261 - Setting report parameter LoggedInUserLocale to en_US

2015-11-30 15:42:26,250 DEBUG EngineServiceImpl,http-bio-9880-exec-7:2261 - Setting report parameter LoggedInUserLocaleCode to en_US

2015-11-30 15:42:26,252 ERROR GenericExceptionMapper,http-bio-9880-exec-7:47 - Unexpected error occurs

java.lang.NullPointerException

        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeQuery(EngineServiceImpl.java:2146)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

Hi Suhas,

I just reviewed your issue and this seems to be normal behavior.

You cannot run the report as superuser, since this user is not assigned to any tenant : that's why you get the message:

Dynamic Proxy Data Source Pool can only be used at a Tenant Level context.. Null Data Source will be returned.

Please use the users created in Clarity PPM with the Create Jaspersoft Users job to run the reports and see how this works for you.

If you need an account for Jaspersoft Studio or other non-Clarity PPM account, please create a new user directly on Jaspersoft UI Console, ensuring it's a user belonging to your organization tenant.
Then please assign the permissions needed and you should not have any issues.

Kind Regards

Nika Hadzhikidi
CA Technologies
Principal Support Engineer

ok. Got it , however the users created are not able to see the report. it does not show anything upon clicking the report link.

It is shows everything on JS server but the report.

Upon clicking link browser shows error

Hi Suhas,

Please ensure that your properties.xml is correctly configured, your entry URL should be the same as the one you are trying connecting to Clarity PPM. For example (make sure you replace servername and 8080 with the correct values):

<webServerInstance id="app" entryUrl=http://SERVERNAME:8080

And http://SERVERNAME:8080 would be the exact URL you use to connect to Clarity.

Once you set this up, restart Clarity PPM Services and retry running the report.
If you still have an issue please confirm your exact Clarity version, and ensure you run different reports to check.

Kind Regards

Nika Hadzhikidi
CA Technologies
Principal Support Engineer

The Instance URL is exactly same. Still the issue.

We are on 14.2.0.237

Regards,

Suhas

Hi Suhas,

Thank you for confirming.
Could you please apply patch 2 or higher for 14.2.0? The latest one should be available under CA PPM Product Downloads as v14.2 Cumulative Patch 6 for CA PPM.

We did have issues with some specific Jaspersoft configurations where the port was different from 80. So at this point the best would be to apply it. Please note that the patch will also include important defect fixes for Clarity, so this will definitely be beneficial.

Please let me know how it goes.

Looking forward to hearing from you.

Kind Regards

Nika Hadzhikidi
CA Technologies
Principal Support Engineer

Oh, now I remember. Last time I applied patch 6 and it failed so I had to go back to 14.1 as I missed to backup current one. Now I will start by backing up

Sent from my Windows Phone

I applied pathc6 and it worked well started showing reports but now all the reports, I suppose PMO accelerator explicitely need to be installed so Installed it, did a clean jaspersoft install again. But it now fails at ./admin content-jaspersoft csk upgrade -userName superuser -password superuser with below error

SYS   2015-12-03 14:04:22,257  util.EchoLogger Getting tenant information... clarity

SYS   03-12 14:04:22,424 - Organization does not exist, exiting importing..

SYS   2015-12-03 14:04:22,424  util.EchoLogger Organization does not exist, exiting importing..

Regards,

Suhas

Hi Suhas

Glad to hear Jaspersoft embedded frame is now showing correctly.

Since you have you have just reinstalled Jaspersoft, we will have to do full import. Your upgrade command does not work likely because there is no organization matching the same name in Jaspersoft.

Please do the following:

Try running the command below( note this is not the command including "upgrade"):

./admin content-jaspersoft csk -userName superuser -password superuser -retryCount 50

This should work. If you still have an issue, follow the full steps below:

1. Connect to CSA - Reporting - Ensure the organization name is set up there properly. Note your tenant name
2. Save and restart Clarity services if you do any changes.
3. Now go to Jaspersoft, connect with superuser account
4. Go to Organizations - see if same tenant name is created there
5. Normally it won't be. If it's there, delete the organization (back up any custom content first in case you have some)
6. Once done, please run the command ( note this is not the command including "upgrade"):

./admin content-jaspersoft csk -userName superuser -password superuser -retryCount 50

Please let me know how it goes.

Kind Regards

Nika Hadzhikidi
CA Technologies
Principal Support Engineer

That worked! I did notice the “upgrade” parameter before but now I understand what it means.

I now receive the error when I run “Create and Update Jaspersoft users”

com.ca.jasper.restAdapter.JasperException: Unauthorized access to http://SVRNAME/reportservice with username ppmjasperadmin

Regards,

Suhas

Hi Suhas,

Please regenerate the keystore by running the command:

admin jasper keystore

Then place the keystore files on Jaspersoft server in the location indicated and restart Jaspersoft Tomcat

Once done, run the Create Jaspersoft Users job again, this should work.

Please let me know how it goes.

Kind Regards

Nika Hadzhikidi
CA Technologies
Principal Support Engineer

I did admin content-jasper with upgrade and force and it proceeded, now the sync is working fine. I will run the Load datawarehouse and let you know if reports work fine.

Some learnings which I would like to note are

Below command should be run when Jaspersoft is installed first time or when upgrade from 14.1 or lesser version is done

./admin content-jaspersoft csk -userName superuser -password superuser -retryCount 50

Below command needs to be run if “Keystore is recreated” or Unauthorized access to http://SVRNAME/reportservice with username ppmjasperadmin error is thrown (i.e. keystores need to be synced)

./admin content-jaspersoft upgrade csk -userName superuser -password superuser -retryCount 50

Jaspersoft installation should be done after PMO accelerator is installed (i.e. admin content csk)

Regards,

Suhas

It works fine after the executions I and Nika  mentioned above are completed.

Thanks a lot Nika!