Jump to content
We've recently updated our Privacy Statement, available here ×

jamessinton

Members
  • Posts

    6
  • Joined

  • Last visited

jamessinton's Achievements

Rookie

Rookie (2/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Conversation Starter Rare

Recent Badges

0

Reputation

  1. Do you know where the embed.zip can be downloaded from? It looks like the attachments may have been removed.
  2. I'm trying to do an export of Jasper Repository from PostgresSQL. I'm trying to upgrade from 4.5 to 4.7. I need to do this export so that I don't loose my existing repo. My output is below. Thanks in advance. ./js-export.sh --everything --output-zip /apps/jasperdb.zipUsing CE setupCreating ActionModelService object.Creating action model infrastructure.Exporting tenant organizations (/)Exporting user jasperadminExporting user anonymousUserExporting user joeuserExporting user ims-testExporting user mkunftExporting user pedrichExporting user reportExporting role ROLE_ADMINISTRATORExporting role ROLE_USERExporting role ROLE_ANONYMOUSERROR: column this_.resourcetype does not exist Position: 222Hibernate DataAccessExceptionorg.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_3_.type as type30_0_, this_3_.maxLength as maxLength30_0_, this_3_.decimals as decimals30_0_, this_3_.regularExpr as regularE5_30_0_, this_3_.minValue as minValue30_0_, this_3_.max_value as max7_30_0_, this_3_.strictMin as strictMin30_0_, this_3_.strictMax as strictMax30_0_, this_5_.serviceClass as serviceC2_32_0_, this_6_.dataSource as dataSource34_0_, this_6_.query_language as query3_34_0_, this_6_.sql_query as sql4_34_0_, this_7_.reportDataSource as reportDa2_35_0_, this_7_.query as query35_0_, this_7_.mainReport as mainReport35_0_, this_7_.controlrenderer as controlr5_35_0_, this_7_.reportrenderer as reportre6_35_0_, this_7_.promptcontrols as promptco7_35_0_, this_7_.controlslayout as controls8_35_0_, this_7_.data_snapshot_id as data9_35_0_, this_8_.catalog as catalog38_0_, this_8_.username as username38_0_, this_8_.password as password38_0_, this_8_.datasource as datasource38_0_, this_8_.uri as uri38_0_, this_9_.driver as driver39_0_, this_9_.password as password39_0_, this_9_.connectionUrl as connecti4_39_0_, this_9_.username as username39_0_, this_9_.timezone as timezone39_0_, this_10_.reportDataSource as reportDa2_40_0_, this_10_.mondrianSchema as mondrian3_40_0_, this_11_.file_type as file3_41_0_, this_12_.type as type42_0_, this_12_.mandatory as mandatory42_0_, this_12_.readOnly as readOnly42_0_, this_12_.visible as visible42_0_, this_12_.data_type as data6_42_0_, this_12_.list_of_values as list7_42_0_, this_12_.list_query as list8_42_0_, this_12_.query_value_column as query9_42_0_, this_12_.defaultValue as default10_42_0_, this_13_.beanName as beanName44_0_, this_13_.beanMethod as beanMethod44_0_, this_14_.data as data1_0_, this_14_.file_type as file3_1_0_, this_14_.reference as reference1_0_, this_15_.jndiName as jndiName45_0_, this_15_.timezone as timezone45_0_, this_16_.olapClientConnection as olapClie2_46_0_, this_16_.mdx_query as mdx3_46_0_, this_16_.view_options as view4_46_0_, case when this_8_.id is not null then 8 when this_10_.id is not null then 10 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_9_.id is not null then 9 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_.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 JIListOfValues this_2_ on this_.id=this_2_.id left outer join JIDataType this_3_ on this_.id=this_3_.id left outer join JIOlapClientConnection this_4_ on this_.id=this_4_.id left outer join JICustomDatasource this_5_ on this_.id=this_5_.id left outer join JIQuery this_6_ on this_.id=this_6_.id left outer join JIReportUnit this_7_ on this_.id=this_7_.id left outer join JIXMLAConnection this_8_ on this_.id=this_8_.id left outer join JIJdbcDatasource this_9_ on this_.id=this_9_.id left outer join JIMondrianConnection this_10_ on this_.id=this_10_.id left outer join JIContentResource this_11_ on this_.id=this_11_.id left outer join JIInputControl this_12_ on this_.id=this_12_.id left outer join JIBeanDatasource this_13_ on this_.id=this_13_.id left outer join JIFileResource this_14_ on this_.id=this_14_.id left outer join JIJNDIJdbcDatasource this_15_ on this_.id=this_15_.id left outer join JIOlapUnit this_16_ on this_.id=this_16_.id where (this_.name=? and this_.parent_folder=?)]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute queryat 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:1011)at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.findByURI(HibernateRepositoryServiceImpl.java:987)at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.loadResource(HibernateRepositoryServiceImpl.java:293)at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.loadResource(HibernateRepositoryServiceImpl.java:286)at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl$1.execute(HibernateRepositoryServiceImpl.java:190)at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeCallback(HibernateDaoImpl.java:55)at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.getResourceUnsecure(HibernateRepositoryServiceImpl.java:188)at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.getResource(HibernateRepositoryServiceImpl.java:183)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:616)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 $Proxy9.getResource(Unknown Source)at com.jaspersoft.jasperserver.export.modules.repository.ResourceExporter.processUri(ResourceExporter.java:184)at com.jaspersoft.jasperserver.export.modules.repository.ResourceExporter.process(ResourceExporter.java:157)at com.jaspersoft.jasperserver.export.ExporterImpl.invokeModules(ExporterImpl.java:182)at com.jaspersoft.jasperserver.export.ExporterImpl.process(ExporterImpl.java:143)at com.jaspersoft.jasperserver.export.ExporterImpl.performExport(ExporterImpl.java:119)at com.jaspersoft.jasperserver.export.ExportCommandImpl.process(ExportCommandImpl.java:57)at com.jaspersoft.jasperserver.export.BaseExportImportCommand.process(BaseExportImportCommand.java:95)at com.jaspersoft.jasperserver.export.ExportCommand.main(ExportCommand.java:43)Caused by: org.hibernate.exception.SQLGrammarException: could not execute queryat 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.listIgnoreQueryCache(Loader.java:2129)at org.hibernate.loader.Loader.list(Loader.java:2124)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)... 30 moreCaused by: org.postgresql.util.PSQLException: ERROR: column this_.resourcetype does not exist Position: 222at 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.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)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)... 38 morecom.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_3_.type as type30_0_, this_3_.maxLength as maxLength30_0_, this_3_.decimals as decimals30_0_, this_3_.regularExpr as regularE5_30_0_, this_3_.minValue as minValue30_0_, this_3_.max_value as max7_30_0_, this_3_.strictMin as strictMin30_0_, this_3_.strictMax as strictMax30_0_, this_5_.serviceClass as serviceC2_32_0_, this_6_.dataSource as dataSource34_0_, this_6_.query_language as query3_34_0_, this_6_.sql_query as sql4_34_0_, this_7_.reportDataSource as reportDa2_35_0_, this_7_.query as query35_0_, this_7_.mainReport as mainReport35_0_, this_7_.controlrenderer as controlr5_35_0_, this_7_.reportrenderer as reportre6_35_0_, this_7_.promptcontrols as promptco7_35_0_, this_7_.controlslayout as controls8_35_0_, this_7_.data_snapshot_id as data9_35_0_, this_8_.catalog as catalog38_0_, this_8_.username as username38_0_, this_8_.password as password38_0_, this_8_.datasource as datasource38_0_, this_8_.uri as uri38_0_, this_9_.driver as driver39_0_, this_9_.password as password39_0_, this_9_.connectionUrl as connecti4_39_0_, this_9_.username as username39_0_, this_9_.timezone as timezone39_0_, this_10_.reportDataSource as reportDa2_40_0_, this_10_.mondrianSchema as mondrian3_40_0_, this_11_.file_type as file3_41_0_, this_12_.type as type42_0_, this_12_.mandatory as mandatory42_0_, this_12_.readOnly as readOnly42_0_, this_12_.visible as visible42_0_, this_12_.data_type as data6_42_0_, this_12_.list_of_values as list7_42_0_, this_12_.list_query as list8_42_0_, this_12_.query_value_column as query9_42_0_, this_12_.defaultValue as default10_42_0_, this_13_.beanName as beanName44_0_, this_13_.beanMethod as beanMethod44_0_, this_14_.data as data1_0_, this_14_.file_type as file3_1_0_, this_14_.reference as reference1_0_, this_15_.jndiName as jndiName45_0_, this_15_.timezone as timezone45_0_, this_16_.olapClientConnection as olapClie2_46_0_, this_16_.mdx_query as mdx3_46_0_, this_16_.view_options as view4_46_0_, case when this_8_.id is not null then 8 when this_10_.id is not null then 10 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_9_.id is not null then 9 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_.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 JIListOfValues this_2_ on this_.id=this_2_.id left outer join JIDataType this_3_ on this_.id=this_3_.id left outer join JIOlapClientConnection this_4_ on this_.id=this_4_.id left outer join JICustomDatasource this_5_ on this_.id=this_5_.id left outer join JIQuery this_6_ on this_.id=this_6_.id left outer join JIReportUnit this_7_ on this_.id=this_7_.id left outer join JIXMLAConnection this_8_ on this_.id=this_8_.id left outer join JIJdbcDatasource this_9_ on this_.id=this_9_.id left outer join JIMondrianConnection this_10_ on this_.id=this_10_.id left outer join JIContentResource this_11_ on this_.id=this_11_.id left outer join JIInputControl this_12_ on this_.id=this_12_.id left outer join JIBeanDatasource this_13_ on this_.id=this_13_.id left outer join JIFileResource this_14_ on this_.id=this_14_.id left outer join JIJNDIJdbcDatasource this_15_ on this_.id=this_15_.id left outer join JIOlapUnit this_16_ on this_.id=this_16_.id where (this_.name=? and this_.parent_folder=?)]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute querycom.jaspersoft.jasperserver.api.JSExceptionWrapper: 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_3_.type as type30_0_, this_3_.maxLength as maxLength30_0_, this_3_.decimals as decimals30_0_, this_3_.regularExpr as regularE5_30_0_, this_3_.minValue as minValue30_0_, this_3_.max_value as max7_30_0_, this_3_.strictMin as strictMin30_0_, this_3_.strictMax as strictMax30_0_, this_5_.serviceClass as serviceC2_32_0_, this_6_.dataSource as dataSource34_0_, this_6_.query_language as query3_34_0_, this_6_.sql_query as sql4_34_0_, this_7_.reportDataSource as reportDa2_35_0_, this_7_.query as query35_0_, this_7_.mainReport as mainReport35_0_, this_7_.controlrenderer as controlr5_35_0_, this_7_.reportrenderer as reportre6_35_0_, this_7_.promptcontrols as promptco7_35_0_, this_7_.controlslayout as controls8_35_0_, this_7_.data_snapshot_id as data9_35_0_, this_8_.catalog as catalog38_0_, this_8_.username as username38_0_, this_8_.password as password38_0_, this_8_.datasource as datasource38_0_, this_8_.uri as uri38_0_, this_9_.driver as driver39_0_, this_9_.password as password39_0_, this_9_.connectionUrl as connecti4_39_0_, this_9_.username as username39_0_, this_9_.timezone as timezone39_0_, this_10_.reportDataSource as reportDa2_40_0_, this_10_.mondrianSchema as mondrian3_40_0_, this_11_.file_type as file3_41_0_, this_12_.type as type42_0_, this_12_.mandatory as mandatory42_0_, this_12_.readOnly as readOnly42_0_, this_12_.visible as visible42_0_, this_12_.data_type as data6_42_0_, this_12_.list_of_values as list7_42_0_, this_12_.list_query as list8_42_0_, this_12_.query_value_column as query9_42_0_, this_12_.defaultValue as default10_42_0_, this_13_.beanName as beanName44_0_, this_13_.beanMethod as beanMethod44_0_, this_14_.data as data1_0_, this_14_.file_type as file3_1_0_, this_14_.reference as reference1_0_, this_15_.jndiName as jndiName45_0_, this_15_.timezone as timezone45_0_, this_16_.olapClientConnection as olapClie2_46_0_, this_16_.mdx_query as mdx3_46_0_, this_16_.view_options as view4_46_0_, case when this_8_.id is not null then 8 when this_10_.id is not null then 10 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_9_.id is not null then 9 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_.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 JIListOfValues this_2_ on this_.id=this_2_.id left outer join JIDataType this_3_ on this_.id=this_3_.id left outer join JIOlapClientConnection this_4_ on this_.id=this_4_.id left outer join JICustomDatasource this_5_ on this_.id=this_5_.id left outer join JIQuery this_6_ on this_.id=this_6_.id left outer join JIReportUnit this_7_ on this_.id=this_7_.id left outer join JIXMLAConnection this_8_ on this_.id=this_8_.id left outer join JIJdbcDatasource this_9_ on this_.id=this_9_.id left outer join JIMondrianConnection this_10_ on this_.id=this_10_.id left outer join JIContentResource this_11_ on this_.id=this_11_.id left outer join JIInputControl this_12_ on this_.id=this_12_.id left outer join JIBeanDatasource this_13_ on this_.id=this_13_.id left outer join JIFileResource this_14_ on this_.id=this_14_.id left outer join JIJNDIJdbcDatasource this_15_ on this_.id=this_15_.id left outer join JIOlapUnit this_16_ on this_.id=this_16_.id where (this_.name=? and this_.parent_folder=?)]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute queryat 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:1011)at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.findByURI(HibernateRepositoryServiceImpl.java:987)at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.loadResource(HibernateRepositoryServiceImpl.java:293)at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.loadResource(HibernateRepositoryServiceImpl.java:286)at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl$1.execute(HibernateRepositoryServiceImpl.java:190)at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeCallback(HibernateDaoImpl.java:55)at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.getResourceUnsecure(HibernateRepositoryServiceImpl.java:188)at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.getResource(HibernateRepositoryServiceImpl.java:183)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:616)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 $Proxy9.getResource(Unknown Source)at com.jaspersoft.jasperserver.export.modules.repository.ResourceExporter.processUri(ResourceExporter.java:184)at com.jaspersoft.jasperserver.export.modules.repository.ResourceExporter.process(ResourceExporter.java:157)at com.jaspersoft.jasperserver.export.ExporterImpl.invokeModules(ExporterImpl.java:182)at com.jaspersoft.jasperserver.export.ExporterImpl.process(ExporterImpl.java:143)at com.jaspersoft.jasperserver.export.ExporterImpl.performExport(ExporterImpl.java:119)at com.jaspersoft.jasperserver.export.ExportCommandImpl.process(ExportCommandImpl.java:57)at com.jaspersoft.jasperserver.export.BaseExportImportCommand.process(BaseExportImportCommand.java:95)at com.jaspersoft.jasperserver.export.ExportCommand.main(ExportCommand.java:43)Caused by: org.hibernate.exception.SQLGrammarException: could not execute queryat 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.listIgnoreQueryCache(Loader.java:2129)at org.hibernate.loader.Loader.list(Loader.java:2124)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)... 30 moreCaused by: org.postgresql.util.PSQLException: ERROR: column this_.resourcetype does not exist Position: 222at 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.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)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)... 38 more
  3. Hi, I'm trying to add a role with execute only permissions. After adding the permission I can't run any reports in from the repository despite the role having execute only permissions at every level on the repository. I've tried adding a few other roles as well giving them all different permissions. None of these work either. Existing roles such as ROLE_USER all work fine. I'm making sure that the user that I'm testing with exists only in on role at a time. Thanks in advance. We're using Jasper Server CP4.5
  4. Does anyone know if there is a way to get the community server to use Oracle as its repository DB? By the look of it only MySQL and PostgreSQL are supported. I can see that the commercial version does support Oracle as a Repo DB. Thanks in advance
  5. Hi, I'm pretty new to Jasper Reports and I'm still learning the application. I'm using Ireport 4.6 and JasperServer 4.5. I cannot get Page Headers and Page Footers to appear after the first page. This sounds really simple but I cannot see where you can set a property to force the page header and or footer to be repeated. Thanks in advance. James
×
×
  • Create New...