Issue with Jaspersoft Reports on CA PPM 14.4 ( fresh install )

[Ram Iyer]

Environment Details

CA PPM 14.4

Oracle 12.1.0.2.0

Clarity/Jasper soft are on a Windows 2012 R2 Standard

Installation Type for Jasper soft: Standalone

 

Issue Description

On trying to open any Jasper soft OOTB report, I am seeing the below error on the screen. I am logged in as admin and admin user has all global rights.

Detailed Jasper server error logs have been attached.

Please review and let me know if you have any thoughts.

 

 

2016-06-10 09:40:08,397 ERROR CustomTenantBuiltInParameterProvider,http-apr-8080-exec-4:138 - Error in decrypting attribute with name:dwhDBName_enc

javax.crypto.BadPaddingException: Given final block not properly padded

  at com.sun.crypto.provider.CipherCore.doFinal(CipherCore.java:966)

  at com.sun.crypto.provider.CipherCore.doFinal(CipherCore.java:824)

  at com.sun.crypto.provider.AESCipher.engineDoFinal(AESCipher.java:436)

  at javax.crypto.Cipher.doFinal(Cipher.java:2165)

  at com.ca.jasper.tenant.user.utils.EncryptionCipher.decrypt(EncryptionCipher.java:150)

  at com.ca.jasper.tenant.user.utils.EncryptionUtil.decrypt(EncryptionUtil.java:52)

  at com.ca.jasper.globalparam.CustomTenantBuiltInParameterProvider.getParameter(CustomTenantBuiltInParameterProvider.java:134)

  at com.ca.jasper.globalparam.CustomTenantBuiltInParameterProvider.getParameters(CustomTenantBuiltInParameterProvider.java:68)

  at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.setBuiltinParameters(EngineServiceImpl.java:2209)

  at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.getReportParameters(EngineServiceImpl.java:1350)

  at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.getReportInputControlsInformation(EngineServiceImpl.java:2514)

  at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.getReportInputControlsInformation(EngineServiceImpl.java:2484)

  at com.jaspersoft.ji.engine.ProEngineServiceImpl.getReportInputControlsInformationInternal(ProEngineServiceImpl.java:94)

  at com.jaspersoft.ji.engine.ProEngineServiceImpl.getReportInputControlsInformation(ProEngineServiceImpl.java:57)

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

  at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

  at java.lang.reflect.Method.invoke(Unknown Source)

  at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)

  at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)

  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

  at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91)

  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

  at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

  at com.sun.proxy.$Proxy67.getReportInputControlsInformation(Unknown Source)

  at com.jaspersoft.jasperserver.war.cascade.CachedEngineService.getReportInputControlsInformation(CachedEngineService.java:85)

  at com.jaspersoft.jasperserver.war.cascade.GenericInputControlLogic.getReportInputControlsInformation(GenericInputControlLogic.java:190)

  at com.jaspersoft.jasperserver.war.cascade.GenericInputControlLogic.getInputControlsStructure(GenericInputControlLogic.java:88)

  at com.jaspersoft.jasperserver.war.cascade.InputControlsLogicServiceImpl$3.callByContainer(InputControlsLogicServiceImpl.java:118)

  at com.jaspersoft.jasperserver.war.cascade.InputControlsLogicServiceImpl$3.callByContainer(InputControlsLogicServiceImpl.java:110)

  at com.jaspersoft.jasperserver.war.cascade.InputControlsLogicServiceImpl.callControlLogic(InputControlsLogicServiceImpl.java:248)

  at com.jaspersoft.jasperserver.war.cascade.InputControlsLogicServiceImpl.getInputControlsStructure(InputControlsLogicServiceImpl.java:110)

  at com.jaspersoft.jasperserver.war.cascade.InputControlsLogicServiceImpl.getInputControlsWithValues(InputControlsLogicServiceImpl.java:128)

  at com.jaspersoft.jasperserver.jaxrs.report.InputControlsJaxrsService$1.call(InputControlsJaxrsService.java:113)

  at com.jaspersoft.jasperserver.jaxrs.report.InputControlsJaxrsService$1.call(InputControlsJaxrsService.java:105)

  at com.jaspersoft.jasperserver.jaxrs.report.ReportsServiceCallTemplate.callRemoteService(ReportsServiceCallTemplate.java:49)

  at com.jaspersoft.jasperserver.remote.common.RemoteServiceWrapper.callRemoteService(RemoteServiceWrapper.java:44)

  at com.jaspersoft.jasperserver.jaxrs.report.InputControlsJaxrsService.internalGetReportInputParameters(InputControlsJaxrsService.java:105)

  at com.jaspersoft.jasperserver.jaxrs.report.InputControlsJaxrsService.getReportInputParametersViaPost(InputControlsJaxrsService.java:94)

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

  at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

  at java.lang.reflect.Method.invoke(Unknown Source)

Attachment(s)

jasperserver.log.zip   4 KB 1 version

jasperserver.log.1.zip   23 KB 1 version

[Suman Pramanik]

Have you applied the Jaspersoft patch, it is mandatory. Here are the instructions

 

http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec1763972.aspx

[venvzw]

Hi Suman,

 

We refreshed UAT with prod DB... i am able to access and run advacned reporting, but i am getting above 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

[Suman Pramanik]

The error looks like you Jaspersoft profile attribut is having the issues. So below are the steps

 

1. Login to Advance Reporting and Navigate to Users and look for user Jaspreadmin

2. Edit the user and delete all the profile attribute

3. Run the command admin update jasperParameters 

 

Then run the reports and check and also once the thread is resolved please open a new thread.

 

Regards

Suman Pramanik

[venvzw]

Hi Suman,

 

Thanks for you response! Tried the same but still getting same error.

 

CA PPM BEAN and DWH BEAN are not showing connected..

 

 

com.jaspersoft.jasperserver.api.JSExceptionWrapper: java.lang.reflect.InvocationTargetException 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.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.BeanReportDataSourceServiceFactory.createService(BeanReportDataSourceServiceFactory.java:94) 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 org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:91) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.ProfileAttributesResolverAspect.resolveDataSourceAttributes(ProfileAttributesResolverAspect.java:50) 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 org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:65) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy88.createService(Unknown Source) at com.jaspersoft.jasperserver.remote.connection.BeanConnectionStrategy.createConnection(BeanConnectionStrategy.java:60) at com.jaspersoft.jasperserver.remote.connection.BeanConnectionStrategy.createConnection(BeanConnectionStrategy.java:42) at com.jaspersoft.jasperserver.remote.connection.ConnectionsManager.createConnection(ConnectionsManager.java:72) at com.jaspersoft.jasperserver.jaxrs.connection.ConnectionsJaxrsService.createConnection(ConnectionsJaxrsService.java:84) 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.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205) at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302) at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1483) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1414) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1363) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1353) at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:414) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:537) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:708) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.ji.jaxrs.diagnostic.DiagnosticLoggingFilterPRO.doFilter(DiagnosticLoggingFilterPRO.java:43) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:143) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.multipleTenancy.MTBasicProcessingFilter.doFilter(MTBasicProcessingFilter.java:194) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:217) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.ca.jasper.ext.filter.TenantIdLoggingFilter.doFilter(TenantIdLoggingFilter.java:94) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.ca.jasper.authentication.JaaSProxyAuthenticationFilter.doFilter(JaaSProxyAuthenticationFilter.java:190) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.NullFilter.doFilter(NullFilter.java:43) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.ca.jasper.ext.filter.ExternalAuthenticationProxyFilter.doFilter(ExternalAuthenticationProxyFilter.java:109) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:217) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:57) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.api.security.JSCsrfGuardFilter.doFilter(JSCsrfGuardFilter.java:83) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.api.security.WebAppSecurityFilter.doFilter(WebAppSecurityFilter.java:80) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.war.NullFilter.doFilter(NullFilter.java:43) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.jasperserver.api.security.encryption.EncryptionFilter.doFilter(EncryptionFilter.java:150) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:86) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.jaspersoft.jasperserver.war.util.SessionDecoratorFilter.doFilter(SessionDecoratorFilter.java:63) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.jaspersoft.jasperserver.war.httpheaders.ResourceHTTPHeadersFilter.doFilter(ResourceHTTPHeadersFilter.java:77) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.jaspersoft.jasperserver.war.P3PFilter.doFilter(P3PFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:614) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: com.jaspersoft.jasperserver.api.JSExceptionWrapper: Given final block not properly padded Arguments: at com.ca.jasper.jdbc.JaaSProxyJDBCPoolDataSourceFactory.createService(JaaSProxyJDBCPoolDataSourceFactory.java:425) at com.ca.jasper.jdbc.JaaSProxyJDBCPoolDataSourceFactory.createService(JaaSProxyJDBCPoolDataSourceFactory.java:149) ... 147 more Caused by: com.jaspersoft.jasperserver.api.JSExceptionWrapper: Given final block not properly padded Arguments: at com.ca.jasper.jdbc.JaaSProxyJDBCPoolDataSourceFactoryHelper.populateJDBCDataSourceInfo(JaaSProxyJDBCPoolDataSourceFactoryHelper.java:826) at com.ca.jasper.jdbc.JaaSProxyJDBCPoolDataSourceFactory.createService(JaaSProxyJDBCPoolDataSourceFactory.java:238) ... 148 more 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) ... 149 more

[Suman Pramanik]

Can you generate the keystore again. I hope you refreshed jsut PPM and not Jaspersoft?

[venvzw]

Hi Suman,

 

Generated the keystore again and updated Jasper parameters but it did not help.

 

Is it possible have a screen share with me, may it would help figure out the issue. 

Really appreciate the help 

[Suman Pramanik]

Hi Venu,

 

Community is not a place for screen share. Please raise a support case and we will have our team take a look at it.

 

Regards

Suman Pramanik

[venvzw]

No worries Suman! Thanks for your help...

 

I raised a CA support ticket.

[Suman Pramanik]

Thank you for your understanding Venu

[Khushboo Kumari]

Hi Venu,

Could you please share what was the final solution to the issue which you were facing even after generating the keystore again .

[venvzw]

I remember, Navigating to Manage ---> users ---> Jasperadmin or ppmjasperadmin edit properties and removing the attributes one by one and regenerating the keystore and applying jasper properties again

[Khushboo Kumari]

Thankyou Venu

[PPM Consulting Pawel Krystosiak]

Thanks Suman!

 

in my case it helped (after upgrading the JasperSoft to 6.4.2_5.4.2.15 and re-generating the keystore files.

It took a few hours of my life away before I found your solution...

 

Pawel

[Suman Pramanik]

Happy to hear that you found but it took longer

[Ram Iyer]

Thanks Suman it worked fine after applying the patch

[Sarmistha_Purkayastha]

Hello Ram,

 

Our documentation on installing and configuring advanced reporting with Jaspersoft includes information about applying the cumulative patch.

Check out the appropriate link below corresponding to your CA PPM version:

 

Installing and Configuring Advanced Reporting with Jaspersoft (CA PPM 14.2)

Installing and Configuring Advanced Reporting with Jaspersoft (CA PPM 14.3)

Installing and Configuring Advanced Reporting with Jaspersoft (CA PPM 14.4)

 

 

Regards, Sarmistha