Jump to content
Changes to the Jaspersoft community edition download ×

JI with PostgreSQL Loginsuccess but has few errors


sure919

Recommended Posts

Hi,

I have tried the PostgreSQL patch that was posted on the forum "JasperIntelligence-1[1].0.1-postgreSQL.zip "

 

Ive followed the instructions that were mentioned and was able to get the JI Login page without errors. Thanks for the Patch

 

But whenever i am trying to Create/ Add andy OLAP Schema I am getting the following errors. Any Updates on this would be of great help. Thanks in advance

Error message:

org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@16a7c99 targetAction = com.jaspersoft.jasperserver.war.action.RepoAdminAction@156f14c, attributes = map[[empty]]] in state 'initAction' of flow 'repoAdminFlow'; nested exception is org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select this_.id as id0_1_, this_.version as version0_1_, this_.name as name0_1_, this_.parent_folder as parent4_0_1_, this_.childrenFolder as children5_0_1_, this_.label as label0_1_, this_.description as descript7_0_1_, this_.creation_date as creation8_0_1_, this_1_.type as type1_1_, this_1_.maxLength as maxLength1_1_, this_1_.decimals as decimals1_1_, this_1_.regularExpr as regularE5_1_1_, this_1_.minValue as minValue1_1_, this_1_.maxValue as maxValue1_1_, this_1_.strictMin as strictMin1_1_, this_1_.strictMax as strictMax1_1_, this_2_.data as data2_1_, this_2_.file_type as file3_2_1_, this_3_.data as data3_1_, this_3_.file_type as file3_3_1_, this_3_.reference as reference3_1_, this_4_.type as type4_1_, this_4_.mandatory as mandatory4_1_, this_4_.readOnly as readOnly4_1_, this_4_.data_type as data5_4_1_, this_4_.list_of_values as list6_4_1_, this_4_.list_query as list7_4_1_, this_4_.query_value_column as query8_4_1_, this_4_.defaultValue as defaultV9_4_1_, this_6_.sql_query as sql2_8_1_, this_7_.reportDataSource as reportDa2_9_1_, this_7_.query as query9_1_, this_7_.mainReport as mainReport9_1_, this_8_.olapClientConnection as olapClie2_12_1_, this_8_.mdx_query as mdx3_12_1_, this_10_.reportDataSource as reportDa2_14_1_, this_10_.mondrianSchema as mondrian3_14_1_, this_11_.catalog as catalog15_1_, this_11_.username as username15_1_, this_11_.password as password15_1_, this_11_.datasource as datasource15_1_, this_11_.uri as uri15_1_, this_12_.catalog as catalog16_1_, this_12_.mondrianConnection as mondrian3_16_1_, this_14_.driver as driver18_1_, this_14_.password as password18_1_, this_14_.connectionUrl as connecti4_18_1_, this_14_.username as username18_1_, this_15_.jndiName as jndiName19_1_, this_16_.beanName as beanName20_1_, this_16_.beanMethod as beanMethod20_1_, case when this_10_.id is not null then 10 when this_11_.id is not null then 11 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_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_12_.id is not null then 12 when this_13_.id is not null then 13 when this_.id is not null then 0 end as clazz_1_, parent1_.id as id21_0_, parent1_.version as version21_0_, parent1_.uri as uri21_0_, parent1_.hidden as hidden21_0_, parent1_.name as name21_0_, parent1_.label as label21_0_, parent1_.description as descript7_21_0_, parent1_.parent_folder as parent8_21_0_, parent1_.creation_date as creation9_21_0_ from JIResource this_ left outer join JIDataType this_1_ on this_.id=this_1_.id left outer join JIContentResource this_2_ on this_.id=this_2_.id left outer join JIFileResource this_3_ on this_.id=this_3_.id left outer join JIInputControl this_4_ on this_.id=this_4_.id left outer join JIListOfValues 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 JIOlapUnit this_8_ on this_.id=this_8_.id left outer join JIOlapClientConnection this_9_ on this_.id=this_9_.id left outer join JIMondrianConnection this_10_ on this_.id=this_10_.id left outer join JIXMLAConnection this_11_ on this_.id=this_11_.id left outer join JIMondrianXMLADefinition this_12_ on this_.id=this_12_.id left outer join JIReportDataSource this_13_ on this_.id=this_13_.id left outer join JIJdbcDatasource this_14_ on this_.id=this_14_.id left outer join JIJNDIJdbcDatasource this_15_ on this_.id=this_15_.id left outer join JIBeanDatasource this_16_ on this_.id=this_16_.id inner join JIResourceFolder parent1_ on this_.parent_folder=parent1_.id where parent1_.hidden=? and (parent1_.uri=?) order by parent1_.uri asc, this_.name asc]; SQL state [25P01]; error code [0]; Large Objects may not be used in auto-commit mode.; nested exception is org.postgresql.util.PSQLException: Large Objects may not be used in auto-commit mode.

org.springframework.webflow.ActionExecutionException: Exception thrown executing [AnnotatedAction@16a7c99 targetAction = com.jaspersoft.jasperserver.war.action.RepoAdminAction@156f14c, attributes = map[[empty]]] in state 'initAction' of flow 'repoAdminFlow'; nested exception is org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select this_.id as id0_1_, this_.version as version0_1_, this_.name as name0_1_, this_.parent_folder as parent4_0_1_, this_.childrenFolder as children5_0_1_, this_.label as label0_1_, this_.description as descript7_0_1_, this_.creation_date as creation8_0_1_, this_1_.type as type1_1_, this_1_.maxLength as maxLength1_1_, this_1_.decimals as decimals1_1_, this_1_.regularExpr as regularE5_1_1_, this_1_.minValue as minValue1_1_, this_1_.maxValue as maxValue1_1_, this_1_.strictMin as strictMin1_1_, this_1_.strictMax as strictMax1_1_, this_2_.data as data2_1_, this_2_.file_type as file3_2_1_, this_3_.data as data3_1_, this_3_.file_type as file3_3_1_, this_3_.reference as reference3_1_, this_4_.type as type4_1_, this_4_.mandatory as mandatory4_1_, this_4_.readOnly as readOnly4_1_, this_4_.data_type as data5_4_1_, this_4_.list_of_values as list6_4_1_, this_4_.list_query as list7_4_1_, this_4_.query_value_column as query8_4_1_, this_4_.defaultValue as defaultV9_4_1_, this_6_.sql_query as sql2_8_1_, this_7_.reportDataSource as reportDa2_9_1_, this_7_.query as query9_1_, this_7_.mainReport as mainReport9_1_, this_8_.olapClientConnection as olapClie2_12_1_, this_8_.mdx_query as mdx3_12_1_, this_10_.reportDataSource as reportDa2_14_1_, this_10_.mondrianSchema as mondrian3_14_1_, this_11_.catalog as catalog15_1_, this_11_.username as username15_1_, this_11_.password as password15_1_, this_11_.datasource as datasource15_1_, this_11_.uri as uri15_1_, this_12_.catalog as catalog16_1_, this_12_.mondrianConnection as mondrian3_16_1_, this_14_.driver as driver18_1_, this_14_.password as password18_1_, this_14_.connectionUrl as connecti4_18_1_, this_14_.username as username18_1_, this_15_.jndiName as jndiName19_1_, this_16_.beanName as beanName20_1_, this_16_.beanMethod as beanMethod20_1_, case when this_10_.id is not null then 10 when this_11_.id is not null then 11 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_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_12_.id is not null then 12 when this_13_.id is not null then 13 when this_.id is not null then 0 end as clazz_1_, parent1_.id as id21_0_, parent1_.version as version21_0_, parent1_.uri as uri21_0_, parent1_.hidden as hidden21_0_, parent1_.name as name21_0_, parent1_.label as label21_0_, parent1_.description as descript7_21_0_, parent1_.parent_folder as parent8_21_0_, parent1_.creation_date as creation9_21_0_ from JIResource this_ left outer join JIDataType this_1_ on this_.id=this_1_.id left outer join JIContentResource this_2_ on this_.id=this_2_.id left outer join JIFileResource this_3_ on this_.id=this_3_.id left outer join JIInputControl this_4_ on this_.id=this_4_.id left outer join JIListOfValues 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 JIOlapUnit this_8_ on this_.id=this_8_.id left outer join JIOlapClientConnection this_9_ on this_.id=this_9_.id left outer join JIMondrianConnection this_10_ on this_.id=this_10_.id left outer join JIXMLAConnection this_11_ on this_.id=this_11_.id left outer join JIMondrianXMLADefinition this_12_ on this_.id=this_12_.id left outer join JIReportDataSource this_13_ on this_.id=this_13_.id left outer join JIJdbcDatasource this_14_ on this_.id=this_14_.id left outer join JIJNDIJdbcDatasource this_15_ on this_.id=this_15_.id left outer join JIBeanDatasource this_16_ on this_.id=this_16_.id inner join JIResourceFolder parent1_ on this_.parent_folder=parent1_.id where parent1_.hidden=? and (parent1_.uri=?) order by parent1_.uri asc, this_.name asc]; SQL state [25P01]; error code [0]; Large Objects may not be used in auto-commit mode.; nested exception is org.postgresql.util.PSQLException: Large Objects may not be used in auto-commit mode.

org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select this_.id as id0_1_, this_.version as version0_1_, this_.name as name0_1_, this_.parent_folder as parent4_0_1_, this_.childrenFolder as children5_0_1_, this_.label as label0_1_, this_.description as descript7_0_1_, this_.creation_date as creation8_0_1_, this_1_.type as type1_1_, this_1_.maxLength as maxLength1_1_, this_1_.decimals as decimals1_1_, this_1_.regularExpr as regularE5_1_1_, this_1_.minValue as minValue1_1_, this_1_.maxValue as maxValue1_1_, this_1_.strictMin as strictMin1_1_, this_1_.strictMax as strictMax1_1_, this_2_.data as data2_1_, this_2_.file_type as file3_2_1_, this_3_.data as data3_1_, this_3_.file_type as file3_3_1_, this_3_.reference as reference3_1_, this_4_.type as type4_1_, this_4_.mandatory as mandatory4_1_, this_4_.readOnly as readOnly4_1_, this_4_.data_type as data5_4_1_, this_4_.list_of_values as list6_4_1_, this_4_.list_query as list7_4_1_, this_4_.query_value_column as query8_4_1_, this_4_.defaultValue as defaultV9_4_1_, this_6_.sql_query as sql2_8_1_, this_7_.reportDataSource as reportDa2_9_1_, this_7_.query as query9_1_, this_7_.mainReport as mainReport9_1_, this_8_.olapClientConnection as olapClie2_12_1_, this_8_.mdx_query as mdx3_12_1_, this_10_.reportDataSource as reportDa2_14_1_, this_10_.mondrianSchema as mondrian3_14_1_, this_11_.catalog as catalog15_1_, this_11_.username as username15_1_, this_11_.password as password15_1_, this_11_.datasource as datasource15_1_, this_11_.uri as uri15_1_, this_12_.catalog as catalog16_1_, this_12_.mondrianConnection as mondrian3_16_1_, this_14_.driver as driver18_1_, this_14_.password as password18_1_, this_14_.connectionUrl as connecti4_18_1_, this_14_.username as username18_1_, this_15_.jndiName as jndiName19_1_, this_16_.beanName as beanName20_1_, this_16_.beanMethod as beanMethod20_1_, case when this_10_.id is not null then 10 when this_11_.id is not null then 11 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_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_12_.id is not null then 12 when this_13_.id is not null then 13 when this_.id is not null then 0 end as clazz_1_, parent1_.id as id21_0_, parent1_.version as version21_0_, parent1_.uri as uri21_0_, parent1_.hidden as hidden21_0_, parent1_.name as name21_0_, parent1_.label as label21_0_, parent1_.description as descript7_21_0_, parent1_.parent_folder as parent8_21_0_, parent1_.creation_date as creation9_21_0_ from JIResource this_ left outer join JIDataType this_1_ on this_.id=this_1_.id left outer join JIContentResource this_2_ on this_.id=this_2_.id left outer join JIFileResource this_3_ on this_.id=this_3_.id left outer join JIInputControl this_4_ on this_.id=this_4_.id left outer join JIListOfValues 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 JIOlapUnit this_8_ on this_.id=this_8_.id left outer join JIOlapClientConnection this_9_ on this_.id=this_9_.id left outer join JIMondrianConnection this_10_ on this_.id=this_10_.id left outer join JIXMLAConnection this_11_ on this_.id=this_11_.id left outer join JIMondrianXMLADefinition this_12_ on this_.id=this_12_.id left outer join JIReportDataSource this_13_ on this_.id=this_13_.id left outer join JIJdbcDatasource this_14_ on this_.id=this_14_.id left outer join JIJNDIJdbcDatasource this_15_ on this_.id=this_15_.id left outer join JIBeanDatasource this_16_ on this_.id=this_16_.id inner join JIResourceFolder parent1_ on this_.parent_folder=parent1_.id where parent1_.hidden=? and (parent1_.uri=?) order by parent1_.uri asc, this_.name asc]; SQL state [25P01]; error code [0]; Large Objects may not be used in auto-commit mode.; nested exception is org.postgresql.util.PSQLException: Large Objects may not be used in auto-commit mode.

org.postgresql.util.PSQLException: Large Objects may not be used in auto-commit mode.

at org.postgresql.largeobject.LargeObjectManager.open(LargeObjectManager.java:172)

at org.postgresql.largeobject.LargeObjectManager.open(LargeObjectManager.java:158)

at org.postgresql.jdbc2.AbstractJdbc2BlobClob.(AbstractJdbc2BlobClob.java:39)

at org.postgresql.jdbc2.AbstractJdbc2Blob.(AbstractJdbc2Blob.java:23)

at org.postgresql.jdbc3.AbstractJdbc3Blob.(AbstractJdbc3Blob.java:22)

at org.postgresql.jdbc3.Jdbc3Blob.(Jdbc3Blob.java:20)

at org.postgresql.jdbc3.Jdbc3ResultSet.getBlob(Jdbc3ResultSet.java:54)

at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getBlob(AbstractJdbc2ResultSet.java:322)

at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getBlob(DelegatingResultSet.java:526)

at org.hibernate.type.BlobType.get(BlobType.java:57)

at org.hibernate.type.BlobType.nullSafeGet(BlobType.java:111)

at org.hibernate.type.AbstractType.hydrate(AbstractType.java:81)

at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:1899)

at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1372)

at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1300)

at org.hibernate.loader.Loader.getRow(Loader.java:1197)

at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:569)

at org.hibernate.loader.Loader.doQuery(Loader.java:689)

at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)

at org.hibernate.loader.Loader.doList(Loader.java:2145)

at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)

at org.hibernate.loader.Loader.list(Loader.java:2024)

at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)

at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1552)

at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)

at org.springframework.orm.hibernate3.HibernateTemplate$35.doInHibernate(HibernateTemplate.java:966)

at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)

at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:956)

at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:949)

at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.loadRepoResourceList(HibernateRepositoryServiceImpl.java:345)

at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.loadResourcesList(HibernateRepositoryServiceImpl.java:293)

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:585)

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

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

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

at org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66)

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

at org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66)

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

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:100)

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

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:100)

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

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

at $Proxy2.loadResourcesList(Unknown Source)

at com.jaspersoft.jasperserver.war.action.RepoAdminAction.initAction(RepoAdminAction.java:109)

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:585)

at org.springframework.webflow.util.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:231)

at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:141)

at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:67)

at org.springframework.webflow.AnnotatedAction.execute(AnnotatedAction.java:208)

at org.springframework.webflow.ActionExecutor.execute(ActionExecutor.java:54)

at org.springframework.webflow.ActionState.doEnter(ActionState.java:184)

at org.springframework.webflow.State.enter(State.java:201)

at org.springframework.webflow.Flow.start(Flow.java:531)

at org.springframework.webflow.execution.impl.FlowExecutionControlContextImpl.start(FlowExecutionControlContextImpl.java:187)

at org.springframework.webflow.execution.impl.FlowExecutionImpl.start(FlowExecutionImpl.java:175)

at org.springframework.webflow.executor.FlowExecutorImpl.launch(FlowExecutorImpl.java:155)

at org.springframework.webflow.executor.support.FlowRequestHandler.handleFlowRequest(FlowRequestHandler.java:117)

at org.springframework.webflow.executor.mvc.FlowController.handleRequestInternal(FlowController.java:198)

at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)

at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:45)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:792)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:726)

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396)

at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:350)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)

at org.apache.catalina.core.ApplicationFilterChain

---------------------

 

Thanks,

Sure

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Dear Sherman!!

Thanks for replying,

 

I was trying this option with suggestions mentioned in the developer guide.

configured maven settings.xml and all other files in Documents & Settings/../.m2

--------

While executing the mvn install, I am always getting Java heap error, (java.lang.OutOfMemeory error).

I have also sepcified MAVEM_OPTS=-Xmx1024m but with no success.

my machine as 1GB RAM.

I followed all the instructions mentioned in the developer guide.

 

Looking for your kind suggestions,

 

Thanks,

Sure

Link to comment
Share on other sites

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...