Hi team, While upgrading jasper from 5.0 to 6.1 im encountering the below error , Please suggest and help ASAP. 2015-10-28 19:27:23,969 ERROR JDBCExceptionReporter,Thread-2:101 - ERROR: relation "jiawsdatasource" does not exist Position: 4111 2015-10-28 19:27:23,981 ERROR ContextLoader,Thread-2:331 - Context initialization failed com.jaspersoft.jasperserver.api.JSExceptionWrapper: at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:635) at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:412) at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:375) at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1047) at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1040) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.findByName(HibernateRepositoryServiceImpl.java:1137) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.findByURI(HibernateRepositoryServiceImpl.java:1112) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.loadResource(HibernateRepositoryServiceImpl.java:359) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.loadResource(HibernateRepositoryServiceImpl.java:352) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl$2.execute(HibernateRepositoryServiceImpl.java:256) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeCallback(HibernateDaoImpl.java:63) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.getResourceUnsecure(HibernateRepositoryServiceImpl.java:254) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.getResource(HibernateRepositoryServiceImpl.java:249) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) 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.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy15.getResource(Unknown Source) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.GlobalPropertiesListUpgradeExecutor.upgrade(GlobalPropertiesListUpgradeExecutor.java:54) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.GlobalPropertiesListUpgradeExecutor$$FastClassBySpringCGLIB$$5da9f7d2.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:700) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:633) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.GlobalPropertiesListUpgradeExecutor$$EnhancerBySpringCGLIB$$cfa44d58.upgrade(<generated>) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.GlobalPropertiesListUpgradeListener.onApplicationEvent(GlobalPropertiesListUpgradeListener.java:41) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.GlobalPropertiesListUpgradeListener.onApplicationEvent(GlobalPropertiesListUpgradeListener.java:33) at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:96) at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:334) at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:950) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482) at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:410) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4723) at org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5226) at org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5221) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) 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:1057) at org.springframework.orm.hibernate3.HibernateTemplate$36.doInHibernate(HibernateTemplate.java:1047) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:407) ... 51 more Caused by: org.postgresql.util.PSQLException: ERROR: relation "jiawsdatasource" does not exist Position: 4111 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302) 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) ... 59 more 2015-10-28 19:27:23,997 ERROR JNDIResourceProvider,Thread-2:75 - error closing context javax.naming.NamingException: Context is read only at org.apache.naming.NamingContext.checkWritable(NamingContext.java:941) at org.apache.naming.NamingContext.close(NamingContext.java:747) at com.tonbeller.tbutils.res.JNDIResourceProvider.close(JNDIResourceProvider.java:72) at com.tonbeller.tbutils.res.CompositeResourceProvider.close(CompositeResourceProvider.java:56) at com.tonbeller.tbutils.res.ResourcesFactory.initialize(ResourcesFactory.java:163) at com.tonbeller.tbutils.res.ResourcesFactory.<init>(ResourcesFactory.java:92) at com.tonbeller.tbutils.res.ResourcesFactory.<clinit>(ResourcesFactory.java:89) at com.tonbeller.tbutils.res.ResourcesFactoryContextListener.contextInitialized(ResourcesFactoryContextListener.java:23) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4723) at org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5226) at org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5221) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) SEVERE: Error listenerStart Oct 28, 2015 7:27:24 PM org.apache.catalina.core.StandardContext startInternal SEVERE: Context [/jasperserver] startup failed due to previous errors -- JasperServer: ProfileAttributeCacheImpl shutdown called. This normal shutdown operation. Oct 28, 2015 7:27:24 PM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc Oct 28, 2015 7:27:24 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads SEVERE: The web application [/jasperserver] appears to have started a thread named [Thread-3] but has failed to stop it. This is very likely to create a memory leak. Oct 28, 2015 7:27:24 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads SEVERE: The web application [/jasperserver] appears to have started a thread named [quartzScheduler_Worker-1] but has failed to stop it. This is very likely to create a memory leak. Oct 28, 2015 7:27:24 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads SEVERE: The web application [/jasperserver] appears to have started a thread named [quartzScheduler_Worker-2] but has failed to stop it. This is very likely to create a memory leak. Oct 28, 2015 7:27:24 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads SEVERE: The web application [/jasperserver] appears to have started a thread named [bitronix-task-scheduler] but has failed to stop it. This is very likely to create a memory leak. INFO: TLD skipped. URI: http://www.springframework.org/tags is already defined Oct 28, 2015 7:26:49 PM org.apache.catalina.startup.TaglibUriRule body INFO: TLD skipped. URI: http://www.springframework.org/tags is already defined 2015-10-28 19:27:23,969 ERROR JDBCExceptionReporter,Thread-2:101 - ERROR: relation "jiawsdatasource" does not exist Position: 4111 2015-10-28 19:27:23,981 ERROR ContextLoader,Thread-2:331 - Context initialization failed com.jaspersoft.jasperserver.api.JSExceptionWrapper: INFO: TLD skipped. URI: http://www.springframework.org/tags is already defined Oct 28, 2015 7:26:49 PM org.apache.catalina.startup.TaglibUriRule body INFO: TLD skipped. URI: http://www.springframework.org/tags is already defined 2015-10-28 19:27:23,969 ERROR JDBCExceptionReporter,Thread-2:101 - ERROR: relation "jiawsdatasource" does not exist Position: 4111 2015-10-28 19:27:23,981 ERROR ContextLoader,Thread-2:331 - Context initialization failed com.jaspersoft.jasperserver.api.JSExceptionWrapper: INFO: TLD skipped. URI: http://www.springframework.org/tags is already defined Oct 28, 2015 7:26:49 PM org.apache.catalina.startup.TaglibUriRule body INFO: TLD skipped. URI: http://www.springframework.org/tags is already defined 2015-10-28 19:27:23,969 ERROR JDBCExceptionReporter,Thread-2:101 - ERROR: relation "jiawsdatasource" does not exist Position: 4111 2015-10-28 19:27:23,981 ERROR ContextLoader,Thread-2:331 - Context initialization failed com.jaspersoft.jasperserver.api.JSExceptionWrapper: org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select this_.id as id6_0_, this_.version as version6_0_, this_.name as name6_0_, this_.parent_folder as parent4_6_0_, this_.childrenFolder as children5_6_0_, this_.label as label6_0_, this_.description as descript7_6_0_, this_.resourceType as resource8_6_0_, this_.creation_date as creation9_6_0_, this_.update_date as update10_6_0_, this_1_.catalog as catalog26_0_, this_1_.mondrianConnection as mondrian3_26_0_, this_2_.file_type as file3_4_0_, this_2_.reference as reference4_0_, this_3_.dataSource as dataSource32_0_, this_3_.query_language as query3_32_0_, this_3_.sql_query as sql4_32_0_, this_4_.file_type as file3_33_0_, this_5_.olapClientConnection as olapClie2_34_0_, this_5_.mdx_query as mdx3_34_0_, this_5_.view_options as view4_34_0_, this_6_.type as type35_0_, this_6_.maxLength as maxLength35_0_, this_6_.decimals as decimals35_0_, this_6_.regularExpr as regularE5_35_0_, this_6_.minValue as minValue35_0_, this_6_.max_value as max7_35_0_, this_6_.strictMin as strictMin35_0_, this_6_.strictMax as strictMax35_0_, this_7_.type as type36_0_, this_7_.mandatory as mandatory36_0_, this_7_.readOnly as readOnly36_0_, this_7_.visible as visible36_0_, this_7_.data_type as data6_36_0_, this_7_.list_of_values as list7_36_0_, this_7_.list_query as list8_36_0_, this_7_.query_value_column as query9_36_0_, this_7_.defaultValue as default10_36_0_, this_8_.reportDataSource as reportDa2_38_0_, this_8_.query as query38_0_, this_8_.mainReport as mainReport38_0_, this_8_.controlrenderer as controlr5_38_0_, this_8_.reportrenderer as reportre6_38_0_, this_8_.promptcontrols as promptco7_38_0_, this_8_.controlslayout as controls8_38_0_, this_8_.data_snapshot_id as data9_38_0_, this_9_.timezone as timezone41_0_, this_10_.serviceClass as serviceC2_43_0_, this_12_.driver as driver48_0_, this_12_.password as password48_0_, this_12_.connectionUrl as connecti4_48_0_, this_12_.username as username48_0_, this_12_.timezone as timezone48_0_, this_13_.accessKey as accessKey49_0_, this_13_.secretKey as secretKey49_0_, this_13_.roleARN as roleARN49_0_, this_13_.region as region49_0_, this_13_.dbName as dbName49_0_, this_13_.dbInstanceIdentifier as dbInstan7_49_0_, this_13_.dbService as dbService49_0_, this_14_.beanName as beanName50_0_, this_14_.beanMethod as beanMethod50_0_, this_15_.jndiName as jndiName51_0_, this_15_.timezone as timezone51_0_, this_17_.reportDataSource as reportDa2_53_0_, this_17_.mondrianSchema as mondrian3_53_0_, this_18_.catalog as catalog54_0_, this_18_.username as username54_0_, this_18_.password as password54_0_, this_18_.datasource as datasource54_0_, this_18_.uri as uri54_0_, case when this_13_.id is not null then 13 when this_17_.id is not null then 17 when this_18_.id is not null then 18 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_9_.id is not null then 9 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_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_.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 JIFileResource this_2_ on this_.id=this_2_.id left outer join JIQuery this_3_ on this_.id=this_3_.id left outer join JIContentResource this_4_ on this_.id=this_4_.id left outer join JIOlapUnit this_5_ on this_.id=this_5_.id left outer join JIDataType this_6_ on this_.id=this_6_.id left outer join JIInputControl this_7_ on this_.id=this_7_.id left outer join JIReportUnit this_8_ on this_.id=this_8_.id left outer join JIVirtualDatasource this_9_ on this_.id=this_9_.id left outer join JICustomDatasource this_10_ on this_.id=this_10_.id left outer join JIListOfValues this_11_ on this_.id=this_11_.id left outer join JIJdbcDatasource this_12_ on this_.id=this_12_.id left outer join JIAwsDatasource this_13_ on this_.id=this_13_.id left outer join JIBeanDatasource this_14_ on this_.id=this_14_.id left outer join JIJNDIJdbcDatasource this_15_ on this_.id=this_15_.id left outer join JIOlapClientConnection this_16_ on this_.id=this_16_.id left outer join JIMondrianConnection this_17_ on this_.id=this_17_.id left outer join JIXMLAConnection this_18_ on this_.id=this_18_.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:635) Thanks, Tahsin
