vseerla

thank you...

i got a solution for this query, we need chage in the HQL query.... select mo.currentTask, count(*) from MasterOrder mo where mo.createdDate between '01-DEC-2010' and '30-DEC-2011' and lower(mo.status) in('in_effect','cancel_completed','completed') group by mo.currenttask

Hi, i am trying to generate a report using hibernate the following query is in the JRXM file... select mo.currentTask, count(*) from MasterOrder mo where mo.createdDate between '01-DEC-2010' and '30-DEC-2011' and lower(mo.status) in('in_effect','cancel_completed','completed') group by mo.currenttask after excecuting the report in IReport or jasperserver ... i am getting the following exception net.sf.jasperreports.engine.JRRuntimeException : Unknown HQL return alias "currentTask" Post Edited by vseerla at 06/10/2011 13:28

Hi i am trying to generate a report using hibernate... i wrote a HQL query in the JRXML is ... select mo.currentTask, count(*) from MasterOrder mo where mo.createdDate between '01-DEC-2010' and '30-DEC-2010' and lower(mo.status) in ('in_effect','cancel_Completed','completed') group by mo.currentTask after executing the report i am getting the following exception net.sf.jasperreports.engie.JRRuntimeException:Unknown HQL return alias "currentTask"

purukante Wrote: Jaspersoft Team, Can you please guide us . Thanks inadvance, Thanks, Puru if i remove the # under template directory (#login.jsp,#saveAs.jsp etc..) i can able to view login page, but it won't load the themes....

i am trying to generate a report using HQL with Ireport tool... i wrote a HQL query in JRXML ... select mo.currentTask, count(mo) from MaterOrder mo where mo.createdDate between $P{fromDate} and $P{toDate} and lower(mo.status) in ('in_effect','cancel_completed','completed') group by mo.currentTask i have design the template using Ireport after than click on the preview button on the IReport tool... it is givin error UNKNOWN HQL RETURN ALIAS .... Please help me out... Thanks in advance... venkat Post Edited by vseerla at 05/27/2011 06:21

I have deployed jasperserver.war under apache-tomcat server.. i am getting the following error after hitting the url... 011-05-21 18:17:15,829 WARN LoggerListener,http-8080-1:60 - Authentication event AuthenticationSuccessEvent: jasperadmin; details: org.springframework.security.ui.WebA thenticationDetails@fffe9938: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: C24E97CDCCF1AF174A4EC61A30972226 011-05-21 18:17:15,835 WARN LoggerListener,http-8080-1:60 - Authentication event InteractiveAuthenticationSuccessEvent: jasperadmin; details: org.springframework.secur ty.ui.WebAuthenticationDetails@fffe9938: RemoteIpAddress: 0:0:0:0:0:0:0:1; SessionId: C24E97CDCCF1AF174A4EC61A30972226 011-05-21 18:17:22,224 ERROR errorPage_jsp,http-8080-1:342 - stack trace of exception that redirected to errorPage.jsp org.springframework.orm.hibernate3.HibernateSystemException: Unknown entity: com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibermate.RepoRole; nested excepti org.springframework.orm.hibernate3.HibernateSystemException: Unknown entity: com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibermate.RepoRole; nested excepti on is org.hibernate.MappingException: Unknown entity: com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibermate.RepoRole at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:676) at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424) at org.springframework.orm.hibernate3.HibernateTemplate.executeFind(HibernateTemplate.java:343) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.ObjectPermissionServiceImpl.getRepoObjectPermissions(ObjectPermissionServiceImpl.java:890) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.ObjectPermissionServiceImpl.getObjectPermissionsForObject(ObjectPermissionServiceImpl.java:954) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.ObjectPermissionServiceImpl.lookup(ObjectPermissionServiceImpl.java:611) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.ObjectPermissionServiceImpl.getAcls(ObjectPermissionServiceImpl.java:272) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.ObjectPermissionServiceImpl.getAcls(ObjectPermissionServiceImpl.java:543) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.ObjectPermissionServiceImpl.getAcls(ObjectPermissionServiceImpl.java:561) 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:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy4.getAcls(Unknown Source) at org.springframework.security.acl.AclProviderManager.getAcls(AclProviderManager.java:97) at com.jaspersoft.jasperserver.api.metadata.security.ContextSensitiveAclEntryVoter.vote(ContextSensitiveAclEntryVoter.java:146) at org.springframework.security.vote.AffirmativeBased.decide(AffirmativeBased.java:51) at org.springframework.security.intercept.AbstractSecurityInterceptor.beforeInvocation(AbstractSecurityInterceptor.java:262) at org.springframework.security.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:63) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy5.getResource(Unknown Source) at com.jaspersoft.jasperserver.war.model.impl.RepositoryExplorerTreeDataProviderImpl.getNode(RepositoryExplorerTreeDataProviderImpl.java:115) at com.jaspersoft.jasperserver.war.model.TreeHelper.getSubtree(TreeHelper.java:63) at com.jaspersoft.jasperserver.war.action.tree.TreeAction.getNode(TreeAction.java:121) 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.webflow.action.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:98) at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:123) at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188) at org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51) at org.springframework.webflow.action.EvaluateAction.doExecute(EvaluateAction.java:79) at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188) at org.springframework.webflow.execution.AnnotatedAction.execute(AnnotatedAction.java:145) at org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51) at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:101) at org.springframework.webflow.engine.State.enter(State.java:194) at org.springframework.webflow.engine.Transition.execute(Transition.java:227) at org.springframework.webflow.engine.DecisionState.doEnter(DecisionState.java:51) at org.springframework.webflow.engine.State.enter(State.java:194) at org.springframework.webflow.engine.Flow.start(Flow.java:535) at org.springframework.webflow.engine.impl.FlowExecutionImpl.start(FlowExecutionImpl.java:364) at org.springframework.webflow.engine.impl.FlowExecutionImpl.start(FlowExecutionImpl.java:222) at org.springframework.webflow.executor.FlowExecutorImpl.launchExecution(FlowExecutorImpl.java:140) 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:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.security.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy17.launchExecution(Unknown Source) at org.springframework.webflow.mvc.servlet.FlowHandlerAdapter.handle(FlowHandlerAdapter.java:193) at org.springframework.webflow.mvc.servlet.FlowController.handleRequest(FlowController.java:174) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501) 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:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:83) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at com.jaspersoft.jasperserver.war.security.JSSwitchUserProcessingFilter.doFilterHttp(JSSwitchUserProcessingFilter.java:154) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:139) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:184) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:277) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:184) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:619)Caused by: org.hibernate.MappingException: Unknown entity: com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibermate.RepoRole at org.hibernate.impl.SessionFactoryImpl.getEntityPersister(SessionFactoryImpl.java:628) at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:91) at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:906) at org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:874) at org.hibernate.type.AnyType.resolveAny(AnyType.java:134) at org.hibernate.type.AnyType.resolve(AnyType.java:124) at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:139) at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:877) at org.hibernate.loader.Loader.doQuery(Loader.java:752) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259) at org.hibernate.loader.Loader.doList(Loader.java:2232) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129) at org.hibernate.loader.Loader.list(Loader.java:2124) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363) at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1149) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.ObjectPermissionServiceImpl$4.doInHibernate(ObjectPermissionServiceImpl.java:894) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419) ... 129 more Post Edited by vseerla at 05/23/2011 05:08

i had used a varable $v{Repot_count}%2==0. it is not applying the styles to rows .... could u please suggest me.... Thanks & Regards venkat

if u are getting undefined error add the the following proerties in the applicattionCotext.xml....

i am trying to generate a report using with hibernate annotaion pojo's the following query trying to execute... select mo.currentTask as currentTak,count(*) as total from MasterOrder mo where mo.createdDate between '01-DEC-2010' and '30-DEC-2010' and lower(mo.status) in ('in-effect','cancel-complete','complete') group by mo.curentTask but i am gettig Error:,expected in SELECT[select mo.currentTask as currentTak,count(*) as total from com.ngb.persist.entity.MasterOrder mo where mo.createdDate between '01-DEC-2010' and '30-DEC-2010' and lower(mo.status) in ('in-effect','cancel-complete','complete') group by mo.curentTask] please do the needful.... thanks in advance venkat

when i am providing dynamic values at runtime to generate a report .... in Jasperserver 3.7.1 Session Error popup message getting... in the log file : StatefulPersistanceContext.java Narrow Proxy to class com.jaspersoft.jasperserver.metadata.jasperreports.domain.impl.datasource.RepoJdbcDatasource-this operation Breaks CommonsLoggingOutput.java:75 A request has been denied as a potential CSRF attack. please help me out.... Thanks & Regards venkat Post Edited by vseerla at 04/27/2011 08:20 Post Edited by vseerla at 04/27/2011 09:25 Post Edited by vseerla at 04/27/2011 09:25

Hi, I am trying to deploy a jasperserver.war file under Weblogic10.3...Server but i am not able to getting login page.... after hitting the URL:http://locahost:7001/jasperserver/ the following error i am getting Error 500--Internal Server Error java.lang.ClassCastException:weblogic.jsp.internal.BinaryRoot can not be cast to weblogic.jsp.internal.SourceFile please help me out ... Thanks in advance... Venkat

when i am changing the permissions by user not by roe gettting the following error. com.jaspersoft.jasperserver.api.JSException:jsexception.null.uri Thanks in Advance venkat

i would like to generate reports using a single JRXML file using subreports we can generate multiple reports ...? please help me out on this... Thanks in Advance.. Venkat Seerla

i don't know exactly how to create a hibernate datasource ...in jasperserver ... i had selected hibernate Data Source then click on next button it is asking the following fields 1) name 2) lable 3)description 4) Session Factory Name: what is the session factory name? thanks in advance...