HI,
I am continuously getting the following error when i try to open any report. The setup is new. I am able to browse through the repository and also run user jasper sync jobs from clarity application successfully. But when i try to open any report i get the following error;
2022-08-14T19:37:23,516 ERROR SecureExceptionHandlerImpl,http-nio-8060-exec-2:116 [seec|admin] - null
2022-08-14T19:37:52,019 ERROR JaaSProxyJDBCPoolDataSourceFactoryHelper,pool-7-thread-9:1470 [] - JaaSProxyJDBCPoolDataSourceFactoryHelper.createService(){Tenant=seec,User=admin}-Error in decrypting attribute with name:dwhDBServerURL_enc and value=CUmxrOmNcsNPCZZwOUxo3EpPpc5aqfDJQgzgGjfk8kn2Hui+9fUYpWMQ17mJ2eDl::javax.crypto.BadPaddingException: Given final block not properly padded. Such issues can arise if a bad key is used during decryption.
at java.base/com.sun.crypto.provider.CipherCore.unpad(CipherCore.java:975)
at java.base/com.sun.crypto.provider.CipherCore.fillOutputBuffer(CipherCore.java:1056)
at java.base/com.sun.crypto.provider.CipherCore.doFinal(CipherCore.java:853)
at java.base/com.sun.crypto.provider.AESCipher.engineDoFinal(AESCipher.java:446)
at java.base/javax.crypto.Cipher.doFinal(Cipher.java:2202)
at com.ca.jasper.encryption.PPMCachedEncryptor.decrypt(PPMCachedEncryptor.java:189)
at com.ca.jasper.encryption.PPMCachedEncryptionService.decrypt(PPMCachedEncryptionService.java:292)
at com.ca.jasper.jdbc.JaaSProxyJDBCPoolDataSourceFactoryHelper.decryptAttributeValue(JaaSProxyJDBCPoolDataSourceFactoryHelper.java:996)
at com.ca.jasper.jdbc.JaaSProxyJDBCPoolDataSourceFactoryHelper.populateJDBCDataSourceInfo(JaaSProxyJDBCPoolDataSourceFactoryHelper.java:120)
at com.ca.jasper.jdbc.JaaSProxyJDBCPoolDataSourceFactory.createService(JaaSProxyJDBCPoolDataSourceFactory.java:251)
at com.ca.jasper.jdbc.JaaSProxyJDBCPoolDataSourceFactory.createService(JaaSProxyJDBCPoolDataSourceFactory.java:162)
at jdk.internal.reflect.GeneratedMethodAccessor879.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.BeanReportDataSourceServiceFactory.createService(BeanReportDataSourceServiceFactory.java:94)
at com.jaspersoft.jasperserver.api.metadata.jasperreports.service.ReportDataSourceServiceFactory.createService(ReportDataSourceServiceFactory.java:55)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:96)
at com.jaspersoft.jasperserver.api.metadata.user.service.impl.ProfileAttributesResolverAspect.resolveDataSourceAttributes(ProfileAttributesResolverAspect.java:56)
at jdk.internal.reflect.GeneratedMethodAccessor877.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616)
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
at com.sun.proxy.$Proxy169.createService(Unknown Source)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.createDataSourceService(EngineServiceImpl.java:2039)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1839)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1162)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1103)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:981)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:834)
2022-08-14T19:37:52,023 ERROR SecureExceptionHandlerImpl,http-nio-8060-exec-4:116 [seec|admin] - null
Please can anyone advise.
Thanks and Regards,
SAmad Abdul Aleem