Jump to content

jasper upgradation problem from 4.x to 5.x


chandankr1501

Recommended Posts

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dbSecretStorage' defined in class path resource [com/jaspersoft/ji/license/ApplicationContextLicenseConfiguration.class]: Instantiation of bean failed; nested exception is org.springframework.beans.factory.BeanDefinitionStoreException: Factory method [public com.jp.protection.pub.SecretStorage com.jaspersoft.ji.license.ApplicationContextLicenseConfiguration.dbSecretStorage()] threw exception; nested exception is com.jaspersoft.jasperserver.api.JSExceptionWrapper: could not execute query; SQL [select this_.id as id3_0_, this_.version as version3_0_, this_.name as name3_0_, this_.parent_folder as parent4_3_0_, this_.childrenFolder as children5_3_0_, this_.label as label3_0_, this_.description as descript7_3_0_, this_.resourceType as resource8_3_0_, this_.creation_date as creation9_3_0_, this_.update_date as update10_3_0_, this_1_.catalog as catalog23_0_, this_1_.mondrianConnection as mondrian3_23_0_, this_2_.adhocStateId as adhocSta2_38_0_, this_3_.adhocStateId as adhocSta2_40_0_, this_3_.reportDataSource as reportDa3_40_0_, this_3_.promptcontrols as promptco4_40_0_, this_3_.controlslayout as controls5_40_0_, this_3_.controlrenderer as controlr6_40_0_, this_4_.options_name as options2_48_0_, this_4_.report_id as report3_48_0_, this_5_.schema_id as schema2_50_0_, this_5_.security_id as security3_50_0_, this_6_.type as type53_0_, this_6_.mandatory as mandatory53_0_, this_6_.readOnly as readOnly53_0_, this_6_.visible as visible53_0_, this_6_.data_type as data6_53_0_, this_6_.list_of_values as list7_53_0_, this_6_.list_query as list8_53_0_, this_6_.query_value_column as query9_53_0_, this_6_.defaultValue as default10_53_0_, this_7_.serviceClass as serviceC2_55_0_, this_8_.driver as driver57_0_, this_8_.password as password57_0_, this_8_.connectionUrl as connecti4_57_0_, this_8_.username as username57_0_, this_8_.timezone as timezone57_0_, this_9_.accessKey as accessKey58_0_, this_9_.secretKey as secretKey58_0_, this_9_.roleARN as roleARN58_0_, this_9_.region as region58_0_, this_9_.dbName as dbName58_0_, this_9_.dbInstanceIdentifier as dbInstan7_58_0_, this_9_.dbService as dbService58_0_, this_10_.jndiName as jndiName59_0_, this_10_.timezone as timezone59_0_, this_11_.type as type60_0_, this_11_.maxLength as maxLength60_0_, this_11_.decimals as decimals60_0_, this_11_.regularExpr as regularE5_60_0_, this_11_.minValue as minValue60_0_, this_11_.max_value as max7_60_0_, this_11_.strictMin as strictMin60_0_, this_11_.strictMax as strictMax60_0_, this_12_.beanName as beanName61_0_, this_12_.beanMethod as beanMethod61_0_, this_13_.file_type as file3_62_0_, this_15_.olapClientConnection as olapClie2_65_0_, this_15_.mdx_query as mdx3_65_0_, this_15_.view_options as view4_65_0_, this_16_.reportDataSource as reportDa2_66_0_, this_16_.query as query66_0_, this_16_.mainReport as mainReport66_0_, this_16_.controlrenderer as controlr5_66_0_, this_16_.reportrenderer as reportre6_66_0_, this_16_.promptcontrols as promptco7_66_0_, this_16_.controlslayout as controls8_66_0_, this_16_.data_snapshot_id as data9_66_0_, this_18_.adhocStateId as adhocSta2_70_0_, this_19_.dataSource as dataSource71_0_, this_19_.query_language as query3_71_0_, this_19_.sql_query as sql4_71_0_, this_20_.timezone as timezone72_0_, this_21_.data as data1_0_, this_21_.file_type as file3_1_0_, this_21_.reference as reference1_0_, this_23_.reportDataSource as reportDa2_75_0_, this_23_.mondrianSchema as mondrian3_75_0_, this_24_.catalog as catalog77_0_, this_24_.username as username77_0_, this_24_.password as password77_0_, this_24_.datasource as datasource77_0_, this_24_.uri as uri77_0_, case when this_9_.id is not null then 9 when this_17_.id is not null then 17 when this_18_.id is not null then 18 when this_23_.id is not null then 23 when this_24_.id is not null then 24 when this_1_.id is not null then 1 when this_2_.id is not null then 2 when this_3_.id is not null then 3 when this_4_.id is not null then 4 when this_5_.id is not null then 5 when this_6_.id is not null then 6 when this_7_.id is not null then 7 when this_8_.id is not null then 8 when this_10_.id is not null then 10 when this_11_.id is not null then 11 when this_12_.id is not null then 12 when this_13_.id is not null then 13 when this_14_.id is not null then 14 when this_15_.id is not null then 15 when this_16_.id is not null then 16 when this_19_.id is not null then 19 when this_20_.id is not null then 20 when this_21_.id is not null then 21 when this_22_.id is not null then 22 when this_.id is not null then 0 end as clazz_0_ from JIResource this_ left outer join JIMondrianXMLADefinition this_1_ on this_.id=this_1_.id left outer join JIDashboard this_2_ on this_.id=this_2_.id left outer join JIAdhocDataView this_3_ on this_.id=this_3_.id left outer join JIReportOptions this_4_ on this_.id=this_4_.id left outer join JIDomainDatasource this_5_ on this_.id=this_5_.id left outer join JIInputControl this_6_ on this_.id=this_6_.id left outer join JICustomDatasource this_7_ on this_.id=this_7_.id left outer join JIJdbcDatasource this_8_ on this_.id=this_8_.id left outer join JIAwsDatasource this_9_ on this_.id=this_9_.id left outer join JIJNDIJdbcDatasource this_10_ on this_.id=this_10_.id left outer join JIDataType this_11_ on this_.id=this_11_.id left outer join JIBeanDatasource this_12_ on this_.id=this_12_.id left outer join JIContentResource this_13_ on this_.id=this_13_.id left outer join JIListOfValues this_14_ on this_.id=this_14_.id left outer join JIOlapUnit this_15_ on this_.id=this_15_.id left outer join JIReportUnit this_16_ on this_.id=this_16_.id left outer join JIDataDefinerUnit this_17_ on this_.id=this_17_.id left outer join JIAdhocReportUnit this_18_ on this_.id=this_18_.id left outer join JIQuery this_19_ on this_.id=this_19_.id left outer join JIVirtualDatasource this_20_ on this_.id=this_20_.id left outer join JIFileResource this_21_ on this_.id=this_21_.id left outer join JIOlapClientConnection this_22_ on this_.id=this_22_.id left outer join JIMondrianConnection this_23_ on this_.id=this_23_.id left outer join JIXMLAConnection this_24_ on this_.id=this_24_.id where (this_.name=? and this_.parent_folder=?)]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
    at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:581)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1015)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:911)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:585)
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:913)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:464)
    at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:384)
    at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:283)
    at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)
    at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
    at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
    at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
    at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
    at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
    at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
    at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
    at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
    at org.apache.catalina.core.StandardService.start(StandardService.java:519)
    at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
    at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: org.springframework.beans.factory.BeanDefinitionStoreException: Factory method [public com.jp.protection.pub.SecretStorage com.jaspersoft.ji.license.ApplicationContextLicenseConfiguration.dbSecretStorage()] threw exception; nested exception is com.jaspersoft.jasperserver.api.JSExceptionWrapper: could not execute query; SQL [select this_.id as id3_0_, this_.version as version3_0_, this_.name as name3_0_, this_.parent_folder as parent4_3_0_, this_.childrenFolder as children5_3_0_, this_.label as label3_0_, this_.description as descript7_3_0_, this_.resourceType as resource8_3_0_, this_.creation_date as creation9_3_0_, this_.update_date as update10_3_0_, this_1_.catalog as catalog23_0_, this_1_.mondrianConnection as mondrian3_23_0_, this_2_.adhocStateId as adhocSta2_38_0_, this_3_.adhocStateId as adhocSta2_40_0_, this_3_.reportDataSource as reportDa3_40_0_, this_3_.promptcontrols as promptco4_40_0_, this_3_.controlslayout as controls5_40_0_, this_3_.controlrenderer as controlr6_40_0_, this_4_.options_name as options2_48_0_, this_4_.report_id as report3_48_0_, this_5_.schema_id as schema2_50_0_, this_5_.security_id as security3_50_0_, this_6_.type as type53_0_, this_6_.mandatory as mandatory53_0_, this_6_.readOnly as readOnly53_0_, this_6_.visible as visible53_0_, this_6_.data_type as data6_53_0_, this_6_.list_of_values as list7_53_0_, this_6_.list_query as list8_53_0_, this_6_.query_value_column as query9_53_0_, this_6_.defaultValue as default10_53_0_, this_7_.serviceClass as serviceC2_55_0_, this_8_.driver as driver57_0_, this_8_.password as password57_0_, this_8_.connectionUrl as connecti4_57_0_, this_8_.username as username57_0_, this_8_.timezone as timezone57_0_, this_9_.accessKey as accessKey58_0_, this_9_.secretKey as secretKey58_0_, this_9_.roleARN as roleARN58_0_, this_9_.region as region58_0_, this_9_.dbName as dbName58_0_, this_9_.dbInstanceIdentifier as dbInstan7_58_0_, this_9_.dbService as dbService58_0_, this_10_.jndiName as jndiName59_0_, this_10_.timezone as timezone59_0_, this_11_.type as type60_0_, this_11_.maxLength as maxLength60_0_, this_11_.decimals as decimals60_0_, this_11_.regularExpr as regularE5_60_0_, this_11_.minValue as minValue60_0_, this_11_.max_value as max7_60_0_, this_11_.strictMin as strictMin60_0_, this_11_.strictMax as strictMax60_0_, this_12_.beanName as beanName61_0_, this_12_.beanMethod as beanMethod61_0_, this_13_.file_type as file3_62_0_, this_15_.olapClientConnection as olapClie2_65_0_, this_15_.mdx_query as mdx3_65_0_, this_15_.view_options as view4_65_0_, this_16_.reportDataSource as reportDa2_66_0_, this_16_.query as query66_0_, this_16_.mainReport as mainReport66_0_, this_16_.controlrenderer as controlr5_66_0_, this_16_.reportrenderer as reportre6_66_0_, this_16_.promptcontrols as promptco7_66_0_, this_16_.controlslayout as controls8_66_0_, this_16_.data_snapshot_id as data9_66_0_, this_18_.adhocStateId as adhocSta2_70_0_, this_19_.dataSource as dataSource71_0_, this_19_.query_language as query3_71_0_, this_19_.sql_query as sql4_71_0_, this_20_.timezone as timezone72_0_, this_21_.data as data1_0_, this_21_.file_type as file3_1_0_, this_21_.reference as reference1_0_, this_23_.reportDataSource as reportDa2_75_0_, this_23_.mondrianSchema as mondrian3_75_0_, this_24_.catalog as catalog77_0_, this_24_.username as username77_0_, this_24_.password as password77_0_, this_24_.datasource as datasource77_0_, this_24_.uri as uri77_0_, case when this_9_.id is not null then 9 when this_17_.id is not null then 17 when this_18_.id is not null then 18 when this_23_.id is not null then 23 when this_24_.id is not null then 24 when this_1_.id is not null then 1 when this_2_.id is not null then 2 when this_3_.id is not null then 3 when this_4_.id is not null then 4 when this_5_.id is not null then 5 when this_6_.id is not null then 6 when this_7_.id is not null then 7 when this_8_.id is not null then 8 when this_10_.id is not null then 10 when this_11_.id is not null then 11 when this_12_.id is not null then 12 when this_13_.id is not null then 13 when this_14_.id is not null then 14 when this_15_.id is not null then 15 when this_16_.id is not null then 16 when this_19_.id is not null then 19 when this_20_.id is not null then 20 when this_21_.id is not null then 21 when this_22_.id is not null then 22 when this_.id is not null then 0 end as clazz_0_ from JIResource this_ left outer join JIMondrianXMLADefinition this_1_ on this_.id=this_1_.id left outer join JIDashboard this_2_ on this_.id=this_2_.id left outer join JIAdhocDataView this_3_ on this_.id=this_3_.id left outer join JIReportOptions this_4_ on this_.id=this_4_.id left outer join JIDomainDatasource this_5_ on this_.id=this_5_.id left outer join JIInputControl this_6_ on this_.id=this_6_.id left outer join JICustomDatasource this_7_ on this_.id=this_7_.id left outer join JIJdbcDatasource this_8_ on this_.id=this_8_.id left outer join JIAwsDatasource this_9_ on this_.id=this_9_.id left outer join JIJNDIJdbcDatasource this_10_ on this_.id=this_10_.id left outer join JIDataType this_11_ on this_.id=this_11_.id left outer join JIBeanDatasource this_12_ on this_.id=this_12_.id left outer join JIContentResource this_13_ on this_.id=this_13_.id left outer join JIListOfValues this_14_ on this_.id=this_14_.id left outer join JIOlapUnit this_15_ on this_.id=this_15_.id left outer join JIReportUnit this_16_ on this_.id=this_16_.id left outer join JIDataDefinerUnit this_17_ on this_.id=this_17_.id left outer join JIAdhocReportUnit this_18_ on this_.id=this_18_.id left outer join JIQuery this_19_ on this_.id=this_19_.id left outer join JIVirtualDatasource this_20_ on this_.id=this_20_.id left outer join JIFileResource this_21_ on this_.id=this_21_.id left outer join JIOlapClientConnection this_22_ on this_.id=this_22_.id left outer join JIMondrianConnection this_23_ on this_.id=this_23_.id left outer join JIXMLAConnection this_24_ on this_.id=this_24_.id where (this_.name=? and this_.parent_folder=?)]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
    at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:169)
    at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:570)
    ... 38 more
Caused by: com.jaspersoft.jasperserver.api.JSExceptionWrapper: could not execute query; SQL [select this_.id as id3_0_, this_.version as version3_0_, this_.name as name3_0_, this_.parent_folder as parent4_3_0_, this_.childrenFolder as children5_3_0_, this_.label as label3_0_, this_.description as descript7_3_0_, this_.resourceType as resource8_3_0_, this_.creation_date as creation9_3_0_, this_.update_date as update10_3_0_, this_1_.catalog as catalog23_0_, this_1_.mondrianConnection as mondrian3_23_0_, this_2_.adhocStateId as adhocSta2_38_0_, this_3_.adhocStateId as adhocSta2_40_0_, this_3_.reportDataSource as reportDa3_40_0_, this_3_.promptcontrols as promptco4_40_0_, this_3_.controlslayout as controls5_40_0_, this_3_.controlrenderer as controlr6_40_0_, this_4_.options_name as options2_48_0_, this_4_.report_id as report3_48_0_, this_5_.schema_id as schema2_50_0_, this_5_.security_id as security3_50_0_, this_6_.type as type53_0_, this_6_.mandatory as mandatory53_0_, this_6_.readOnly as readOnly53_0_, this_6_.visible as visible53_0_, this_6_.data_type as data6_53_0_, this_6_.list_of_values as list7_53_0_, this_6_.list_query as list8_53_0_, this_6_.query_value_column as query9_53_0_, this_6_.defaultValue as default10_53_0_, this_7_.serviceClass as serviceC2_55_0_, this_8_.driver as driver57_0_, this_8_.password as password57_0_, this_8_.connectionUrl as connecti4_57_0_, this_8_.username as username57_0_, this_8_.timezone as timezone57_0_, this_9_.accessKey as accessKey58_0_, this_9_.secretKey as secretKey58_0_, this_9_.roleARN as roleARN58_0_, this_9_.region as region58_0_, this_9_.dbName as dbName58_0_, this_9_.dbInstanceIdentifier as dbInstan7_58_0_, this_9_.dbService as dbService58_0_, this_10_.jndiName as jndiName59_0_, this_10_.timezone as timezone59_0_, this_11_.type as type60_0_, this_11_.maxLength as maxLength60_0_, this_11_.decimals as decimals60_0_, this_11_.regularExpr as regularE5_60_0_, this_11_.minValue as minValue60_0_, this_11_.max_value as max7_60_0_, this_11_.strictMin as strictMin60_0_, this_11_.strictMax as strictMax60_0_, this_12_.beanName as beanName61_0_, this_12_.beanMethod as beanMethod61_0_, this_13_.file_type as file3_62_0_, this_15_.olapClientConnection as olapClie2_65_0_, this_15_.mdx_query as mdx3_65_0_, this_15_.view_options as view4_65_0_, this_16_.reportDataSource as reportDa2_66_0_, this_16_.query as query66_0_, this_16_.mainReport as mainReport66_0_, this_16_.controlrenderer as controlr5_66_0_, this_16_.reportrenderer as reportre6_66_0_, this_16_.promptcontrols as promptco7_66_0_, this_16_.controlslayout as controls8_66_0_, this_16_.data_snapshot_id as data9_66_0_, this_18_.adhocStateId as adhocSta2_70_0_, this_19_.dataSource as dataSource71_0_, this_19_.query_language as query3_71_0_, this_19_.sql_query as sql4_71_0_, this_20_.timezone as timezone72_0_, this_21_.data as data1_0_, this_21_.file_type as file3_1_0_, this_21_.reference as reference1_0_, this_23_.reportDataSource as reportDa2_75_0_, this_23_.mondrianSchema as mondrian3_75_0_, this_24_.catalog as catalog77_0_, this_24_.username as username77_0_, this_24_.password as password77_0_, this_24_.datasource as datasource77_0_, this_24_.uri as uri77_0_, case when this_9_.id is not null then 9 when this_17_.id is not null then 17 when this_18_.id is not null then 18 when this_23_.id is not null then 23 when this_24_.id is not null then 24 when this_1_.id is not null then 1 when this_2_.id is not null then 2 when this_3_.id is not null then 3 when this_4_.id is not null then 4 when this_5_.id is not null then 5 when this_6_.id is not null then 6 when this_7_.id is not null then 7 when this_8_.id is not null then 8 when this_10_.id is not null then 10 when this_11_.id is not null then 11 when this_12_.id is not null then 12 when this_13_.id is not null then 13 when this_14_.id is not null then 14 when this_15_.id is not null then 15 when this_16_.id is not null then 16 when this_19_.id is not null then 19 when this_20_.id is not null then 20 when this_21_.id is not null then 21 when this_22_.id is not null then 22 when this_.id is not null then 0 end as clazz_0_ from JIResource this_ left outer join JIMondrianXMLADefinition this_1_ on this_.id=this_1_.id left outer join JIDashboard this_2_ on this_.id=this_2_.id left outer join JIAdhocDataView this_3_ on this_.id=this_3_.id left outer join JIReportOptions this_4_ on this_.id=this_4_.id left outer join JIDomainDatasource this_5_ on this_.id=this_5_.id left outer join JIInputControl this_6_ on this_.id=this_6_.id left outer join JICustomDatasource this_7_ on this_.id=this_7_.id left outer join JIJdbcDatasource this_8_ on this_.id=this_8_.id left outer join JIAwsDatasource this_9_ on this_.id=this_9_.id left outer join JIJNDIJdbcDatasource this_10_ on this_.id=this_10_.id left outer join JIDataType this_11_ on this_.id=this_11_.id left outer join JIBeanDatasource this_12_ on this_.id=this_12_.id left outer join JIContentResource this_13_ on this_.id=this_13_.id left outer join JIListOfValues this_14_ on this_.id=this_14_.id left outer join JIOlapUnit this_15_ on this_.id=this_15_.id left outer join JIReportUnit this_16_ on this_.id=this_16_.id left outer join JIDataDefinerUnit this_17_ on this_.id=this_17_.id left outer join JIAdhocReportUnit this_18_ on this_.id=this_18_.id left outer join JIQuery this_19_ on this_.id=this_19_.id left outer join JIVirtualDatasource this_20_ on this_.id=this_20_.id left outer join JIFileResource this_21_ on this_.id=this_21_.id left outer join JIOlapClientConnection this_22_ on this_.id=this_22_.id left outer join JIMondrianConnection this_23_ on this_.id=this_23_.id left outer join JIXMLAConnection this_24_ on this_.id=this_24_.id where (this_.name=? and this_.parent_folder=?)]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
    at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeCallback(HibernateDaoImpl.java:61)
    at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.getResourceUnsecure(HibernateRepositoryServiceImpl.java:250)
    at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.getResource(HibernateRepositoryServiceImpl.java:245)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
    at $Proxy28.getResource(Unknown Source)
    at com.jaspersoft.ji.license.StoragePropertiesManagementServiceImpl.reloadProperties(StoragePropertiesManagementServiceImpl.java:113)
    at com.jaspersoft.ji.license.DBSecretStorageImpl.load(DBSecretStorageImpl.java:41)
    at com.jaspersoft.ji.license.ApplicationContextLicenseConfiguration.dbSecretStorage(ApplicationContextLicenseConfiguration.java:307)
    at com.jaspersoft.ji.license.ApplicationContextLicenseConfiguration$$EnhancerByCGLIB$$53ce5788.CGLIB$dbSecretStorage$11(<generated>)
    at com.jaspersoft.ji.license.ApplicationContextLicenseConfiguration$$EnhancerByCGLIB$$53ce5788$$FastClassByCGLIB$$d5fb0cce.invoke(<generated>)
    at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:215)
    at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:280)
    at com.jaspersoft.ji.license.ApplicationContextLicenseConfiguration$$EnhancerByCGLIB$$53ce5788.dbSecretStorage(<generated>)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:149)
    ... 39 more
Caused by: org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select this_.id as id3_0_, this_.version as version3_0_, this_.name as name3_0_, this_.parent_folder as parent4_3_0_, this_.childrenFolder as children5_3_0_, this_.label as label3_0_, this_.description as descript7_3_0_, this_.resourceType as resource8_3_0_, this_.creation_date as creation9_3_0_, this_.update_date as update10_3_0_, this_1_.catalog as catalog23_0_, this_1_.mondrianConnection as mondrian3_23_0_, this_2_.adhocStateId as adhocSta2_38_0_, this_3_.adhocStateId as adhocSta2_40_0_, this_3_.reportDataSource as reportDa3_40_0_, this_3_.promptcontrols as promptco4_40_0_, this_3_.controlslayout as controls5_40_0_, this_3_.controlrenderer as controlr6_40_0_, this_4_.options_name as options2_48_0_, this_4_.report_id as report3_48_0_, this_5_.schema_id as schema2_50_0_, this_5_.security_id as security3_50_0_, this_6_.type as type53_0_, this_6_.mandatory as mandatory53_0_, this_6_.readOnly as readOnly53_0_, this_6_.visible as visible53_0_, this_6_.data_type as data6_53_0_, this_6_.list_of_values as list7_53_0_, this_6_.list_query as list8_53_0_, this_6_.query_value_column as query9_53_0_, this_6_.defaultValue as default10_53_0_, this_7_.serviceClass as serviceC2_55_0_, this_8_.driver as driver57_0_, this_8_.password as password57_0_, this_8_.connectionUrl as connecti4_57_0_, this_8_.username as username57_0_, this_8_.timezone as timezone57_0_, this_9_.accessKey as accessKey58_0_, this_9_.secretKey as secretKey58_0_, this_9_.roleARN as roleARN58_0_, this_9_.region as region58_0_, this_9_.dbName as dbName58_0_, this_9_.dbInstanceIdentifier as dbInstan7_58_0_, this_9_.dbService as dbService58_0_, this_10_.jndiName as jndiName59_0_, this_10_.timezone as timezone59_0_, this_11_.type as type60_0_, this_11_.maxLength as maxLength60_0_, this_11_.decimals as decimals60_0_, this_11_.regularExpr as regularE5_60_0_, this_11_.minValue as minValue60_0_, this_11_.max_value as max7_60_0_, this_11_.strictMin as strictMin60_0_, this_11_.strictMax as strictMax60_0_, this_12_.beanName as beanName61_0_, this_12_.beanMethod as beanMethod61_0_, this_13_.file_type as file3_62_0_, this_15_.olapClientConnection as olapClie2_65_0_, this_15_.mdx_query as mdx3_65_0_, this_15_.view_options as view4_65_0_, this_16_.reportDataSource as reportDa2_66_0_, this_16_.query as query66_0_, this_16_.mainReport as mainReport66_0_, this_16_.controlrenderer as controlr5_66_0_, this_16_.reportrenderer as reportre6_66_0_, this_16_.promptcontrols as promptco7_66_0_, this_16_.controlslayout as controls8_66_0_, this_16_.data_snapshot_id as data9_66_0_, this_18_.adhocStateId as adhocSta2_70_0_, this_19_.dataSource as dataSource71_0_, this_19_.query_language as query3_71_0_, this_19_.sql_query as sql4_71_0_, this_20_.timezone as timezone72_0_, this_21_.data as data1_0_, this_21_.file_type as file3_1_0_, this_21_.reference as reference1_0_, this_23_.reportDataSource as reportDa2_75_0_, this_23_.mondrianSchema as mondrian3_75_0_, this_24_.catalog as catalog77_0_, this_24_.username as username77_0_, this_24_.password as password77_0_, this_24_.datasource as datasource77_0_, this_24_.uri as uri77_0_, case when this_9_.id is not null then 9 when this_17_.id is not null then 17 when this_18_.id is not null then 18 when this_23_.id is not null then 23 when this_24_.id is not null then 24 when this_1_.id is not null then 1 when this_2_.id is not null then 2 when this_3_.id is not null then 3 when this_4_.id is not null then 4 when this_5_.id is not null then 5 when this_6_.id is not null then 6 when this_7_.id is not null then 7 when this_8_.id is not null then 8 when this_10_.id is not null then 10 when this_11_.id is not null then 11 when this_12_.id is not null then 12 when this_13_.id is not null then 13 when this_14_.id is not null then 14 when this_15_.id is not null then 15 when this_16_.id is not null then 16 when this_19_.id is not null then 19 when this_20_.id is not null then 20 when this_21_.id is not null then 21 when this_22_.id is not null then 22 when this_.id is not null then 0 end as clazz_0_ from JIResource this_ left outer join JIMondrianXMLADefinition this_1_ on this_.id=this_1_.id left outer join JIDashboard this_2_ on this_.id=this_2_.id left outer join JIAdhocDataView this_3_ on this_.id=this_3_.id left outer join JIReportOptions this_4_ on this_.id=this_4_.id left outer join JIDomainDatasource this_5_ on this_.id=this_5_.id left outer join JIInputControl this_6_ on this_.id=this_6_.id left outer join JICustomDatasource this_7_ on this_.id=this_7_.id left outer join JIJdbcDatasource this_8_ on this_.id=this_8_.id left outer join JIAwsDatasource this_9_ on this_.id=this_9_.id left outer join JIJNDIJdbcDatasource this_10_ on this_.id=this_10_.id left outer join JIDataType this_11_ on this_.id=this_11_.id left outer join JIBeanDatasource this_12_ on this_.id=this_12_.id left outer join JIContentResource this_13_ on this_.id=this_13_.id left outer join JIListOfValues this_14_ on this_.id=this_14_.id left outer join JIOlapUnit this_15_ on this_.id=this_15_.id left outer join JIReportUnit this_16_ on this_.id=this_16_.id left outer join JIDataDefinerUnit this_17_ on this_.id=this_17_.id left outer join JIAdhocReportUnit this_18_ on this_.id=this_18_.id left outer join JIQuery this_19_ on this_.id=this_19_.id left outer join JIVirtualDatasource this_20_ on this_.id=this_20_.id left outer join JIFileResource this_21_ on this_.id=this_21_.id left outer join JIOlapClientConnection this_22_ on this_.id=this_22_.id left outer join JIMondrianConnection this_23_ on this_.id=this_23_.id left outer join JIXMLAConnection this_24_ on this_.id=this_24_.id where (this_.name=? and this_.parent_folder=?)]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
    at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:633)
    at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
    at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
    at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
    at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1046)
    at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1039)
    at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.findByName(HibernateRepositoryServiceImpl.java:1088)
    at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.findByURI(HibernateRepositoryServiceImpl.java:1063)
    at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.loadResource(HibernateRepositoryServiceImpl.java:355)
    at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.loadResource(HibernateRepositoryServiceImpl.java:348)
    at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl$2.execute(HibernateRepositoryServiceImpl.java:252)
    at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeCallback(HibernateDaoImpl.java:55)
    ... 65 more
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
    at org.hibernate.loader.Loader.doList(Loader.java:2235)
    at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2161)
    at org.hibernate.loader.Loader.list(Loader.java:2121)
    at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:118)
    at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1597)
    at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
    at org.springframework.orm.hibernate3.HibernateTemplate$36.doInHibernate(HibernateTemplate.java:1056)
    at org.springframework.orm.hibernate3.HibernateTemplate$36.doInHibernate(HibernateTemplate.java:1)
    at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
    ... 74 more
Caused by: org.postgresql.util.PSQLException: ERROR: permission denied for relation jiadhocdataview
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
    at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
    at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
    at org.hibernate.loader.Loader.getResultSet(Loader.java:1812)
    at org.hibernate.loader.Loader.doQuery(Loader.java:697)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
    at org.hibernate.loader.Loader.doList(Loader.java:2232)
    ... 82 more
Exception in thread "olapCache" java.lang.NullPointerException
    at org.slf4j.impl.Log4jLoggerAdapter.debug(Log4jLoggerAdapter.java:209)
    at net.sf.ehcache.util.UpdateChecker.checkForUpdate(UpdateChecker.java:63)
    at net.sf.ehcache.util.UpdateChecker.run(UpdateChecker.java:51)
    at java.util.TimerThread.mainLoop(Timer.java:512)
    at java.util.TimerThread.run(Timer.java:462)

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...