nageshit2011

Hi All, I have successfully configured CAS integration with JasperServer 5.6. CAS Configuration changes: Step-1: Copied "applicationContext-externalAuth-CAS-db-mt.xml" file from samples and placed in "WEB-INF" directory with few changes. <!-- ~ Copyright © 2005 - 2013 Jaspersoft Corporation. All rights reserved. ~ http://www.jaspersoft.com. ~ Licensed under commercial Jaspersoft Subscription License Agreement --><beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.1.xsd"> <!-- - Sample configuration of SSO via CAS Spring API. - Additional user details are extracted via an external database (externalDataSource) - An organization id query is used to find the user's organization id. --> <bean id="proxyAuthenticationProcessingFilter" class="com.jaspersoft.jasperserver.api.security.externalAuth.cas.JSCasProcessingFilter"> <property name="authenticationManager"> <ref local="casAuthenticationManager"/> </property> <property name="externalDataSynchronizer"> <ref local="externalDataSynchronizer"/> </property> <property name="sessionRegistry"> <ref bean="sessionRegistry"/> </property> <property name="internalAuthenticationFailureUrl" value="/login.html?error=1"/> <property name="defaultTargetUrl" value="/loginsuccess.html"/> <property name="invalidateSessionOnSuccessfulAuthentication" value="true"/> <property name="migrateInvalidatedSessionAttributes" value="true"/> <property name="filterProcessesUrl" value="/j_spring_security_check"/> <property name="authenticationDetailsSource"> <bean class="org.springframework.security.ui.AuthenticationDetailsSourceImpl"> <property name="clazz"> <value>com.jaspersoft.jasperserver.multipleTenancy.MTWebAuthenticationDetails</value> </property> </bean> </property> </bean> <bean id="proxyAuthenticationSoapProcessingFilter" class="com.jaspersoft.jasperserver.api.security.externalAuth.cas.JSSoapProcessingFilter"> <property name="authenticationManager" ref="casSoapAuthenticationManager"/> <property name="externalDataSynchronizer" ref="externalDataSynchronizer"/> <property name="invalidateSessionOnSuccessfulAuthentication" value="true"/> <property name="migrateInvalidatedSessionAttributes" value="true"/> <property name="filterProcessesUrl" value="/services"/> </bean> <bean id="proxyAuthenticationRestProcessingFilter" class="com.jaspersoft.jasperserver.api.security.externalAuth.cas.CasRestProcessingFilter"> <property name="authenticationManager" ref="casRestAuthenticationManager"/> <property name="externalDataSynchronizer" ref="externalDataSynchronizer"/> <property name="filterProcessesUrl" value="/rest/login"/> <property name="invalidateSessionOnSuccessfulAuthentication" value="true"/> <property name="migrateInvalidatedSessionAttributes" value="true"/> </bean> <bean id="proxyExceptionTranslationFilter" class="org.springframework.security.ui.ExceptionTranslationFilter" depends-on="externalAuthProperties"> <property name="authenticationEntryPoint"> <bean class="org.springframework.security.ui.cas.CasProcessingFilterEntryPoint"> <property name="loginUrl" value="#{externalAuthProperties.externalLoginUrl}"/> <property name="serviceProperties"> <ref local="casServiceProperties"/> </property> </bean> </property> <property name="accessDeniedHandler"> <bean class="com.jaspersoft.jasperserver.war.themes.ThemeAwareAccessDeniedHandlerImpl"> <property name="errorPage" value="/WEB-INF/jsp/modules/system/AccessDeniedPage.jsp"/> <property name="themeResolver" ref="themeResolver" /> <property name="themeSource" ref="themeSource" /> </bean> </property> </bean> <bean id="casAuthenticationManager" class="org.springframework.security.providers.ProviderManager"> <property name="providers"> <list> <ref local="casAuthenticationProvider"/> <ref bean="${bean.daoAuthenticationProvider}"/> <!-- anonymousAuthenticationProvider only needed if filterInvocationInterceptor.alwaysReauthenticate is set to true--> <ref bean="anonymousAuthenticationProvider"/> </list> </property> </bean> <bean id="casRestAuthenticationManager" class="org.springframework.security.providers.ProviderManager"> <property name="providers"> <list> <ref local="casRestAuthenticationProvider"/> <ref bean="${bean.daoAuthenticationProvider}"/> <!-- anonymousAuthenticationProvider only needed if filterInvocationInterceptor.alwaysReauthenticate is set to true--> <!--<ref bean="anonymousAuthenticationProvider"/>--> </list> </property> </bean> <bean id="casSoapAuthenticationManager" class="org.springframework.security.providers.ProviderManager"> <property name="providers"> <list> <ref local="casSoapAuthenticationProvider"/> <ref bean="${bean.daoAuthenticationProvider}"/> <!-- anonymousAuthenticationProvider only needed if filterInvocationInterceptor.alwaysReauthenticate is set to true--> <!--<ref bean="anonymousAuthenticationProvider"/>--> </list> </property> </bean> <bean id="casAuthenticationProvider" class="org.springframework.security.providers.cas.CasAuthenticationProvider" depends-on="externalAuthProperties"> <property name="userDetailsService"><ref local="casJDBCUserDetailsService"/></property> <property name="serviceProperties"> <ref local="casServiceProperties"/> </property> <property name="ticketValidator"> <bean class="org.jasig.cas.client.validation.Cas20ServiceTicketValidator"> <constructor-arg index="0" value="#{externalAuthProperties.ssoServerLocation}" /> </bean> </property> <property name="statelessTicketCache"> <bean class="org.springframework.security.providers.cas.cache.EhCacheBasedTicketCache"> <property name="cache"> <bean id="ticketCache" class="org.springframework.cache.ehcache.EhCacheFactoryBean"> <property name="cacheManager" ref="cacheManager"/> <property name="cacheName" value="casTicketCache"/> </bean> </property> </bean> </property> <property name="key" value="casCacheKey"/> </bean> <bean id="casRestAuthenticationProvider" class="org.springframework.security.providers.cas.CasAuthenticationProvider" depends-on="externalAuthProperties"> <property name="userDetailsService"><ref local="casJDBCUserDetailsService"/></property> <property name="serviceProperties"> <ref local="casRestServiceProperties"/> </property> <property name="ticketValidator"> <bean class="org.jasig.cas.client.validation.Cas20ServiceTicketValidator"> <constructor-arg index="0" value="#{externalAuthProperties.ssoServerLocation}" /> </bean> </property> <property name="statelessTicketCache"> <bean class="org.springframework.security.providers.cas.cache.EhCacheBasedTicketCache"> <property name="cache"> <bean id="ticketCache" class="org.springframework.cache.ehcache.EhCacheFactoryBean"> <property name="cacheManager" ref="cacheManager"/> <property name="cacheName" value="casTicketCache"/> </bean> </property> </bean> </property> <property name="key" value="casCacheKey"/> </bean> <bean id="casSoapAuthenticationProvider" class="org.springframework.security.providers.cas.CasAuthenticationProvider" depends-on="externalAuthProperties"> <property name="userDetailsService"><ref local="casJDBCUserDetailsService"/></property> <property name="serviceProperties"> <ref local="casSoapServiceProperties"/> </property> <property name="ticketValidator"> <bean class="org.jasig.cas.client.validation.Cas20ServiceTicketValidator"> <constructor-arg index="0" value="#{externalAuthProperties.ssoServerLocation}" /> </bean> </property> <property name="statelessTicketCache"> <bean class="org.springframework.security.providers.cas.cache.EhCacheBasedTicketCache"> <property name="cache"> <bean id="ticketCache" class="org.springframework.cache.ehcache.EhCacheFactoryBean"> <property name="cacheManager" ref="cacheManager"/> <property name="cacheName" value="casTicketCache"/> </bean> </property> </bean> </property> <property name="key" value="casCacheKey"/> </bean> <bean id="casJDBCUserDetailsService" class="com.jaspersoft.jasperserver.api.security.externalAuth.cas.CasJDBCUserDetailsService"> <property name="dataSource" ref="externalDataSource"/> <property name="usersByUsernameQuery" value="XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"/> <property name="authoritiesByUsernameQuery" value="XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"/> <property name="detailsQuery" value="XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"/> </bean> <bean id="casServiceProperties" class="org.springframework.security.ui.cas.ServiceProperties"> <property name="service" value="http://myserver:8080/kpi-server/j_spring_security_check"/> <property name="sendRenew" value="false"/> </bean> <!--we rely on the customer coming with a ticket that was issued to their system. this is where they need to specify the url--> <bean id="casRestServiceProperties" class="org.springframework.security.ui.cas.ServiceProperties"> <property name="service" value="http://myserver:8080/kpi-server/rest/login"/> <property name="sendRenew" value="false"/> </bean> <bean id="casSoapServiceProperties" class="org.springframework.security.ui.cas.ServiceProperties"> <property name="service" value="http://myserver:8080/kpi-server/services"/> <property name="sendRenew" value="false"/> </bean> <!-- ############ SSO auth ############ --> <!-- ############ Synchronizer ############ --> <bean id="externalDataSynchronizer" class="com.jaspersoft.jasperserver.api.security.externalAuth.ExternalDataSynchronizerImpl"> <property name="externalUserDetailsService"> <ref local="casJDBCUserDetailsService"/> </property> <property name="externalUserProcessors"> <list> <!--<ref local="externalTenantSetupProcessor"/>--> <ref local="mtExternalUserSetupProcessor"/> <!-- Example processor for creating user folder--> <!--<ref local="externalUserFolderProcessor"/>--> </list> </property> </bean> <bean id="abstractExternalProcessor" class="com.jaspersoft.jasperserver.api.security.externalAuth.processors.AbstractExternalUserProcessor" abstract="true"> <property name="repositoryService" ref="${bean.repositoryService}"/> <property name="userAuthorityService" ref="${bean.userAuthorityService}"/> <property name="tenantService" ref="${bean.tenantService}"/> <property name="profileAttributeService" ref="profileAttributeService"/> <property name="objectPermissionService" ref="objectPermissionService"/> </bean> <bean id="externalTenantSetupProcessor" class="com.jaspersoft.jasperserver.multipleTenancy.security.externalAuth.processors.MTExternalTenantSetupProcessor" parent="abstractExternalProcessor"> <property name="multiTenancyService"><ref bean="internalMultiTenancyService"/></property> <!--<property name="tenantIdNotSupportedSymbols" value="#{configurationBean.tenantIdNotSupportedSymbols}"/>--> <property name="defaultOrganization" value="organizations"/> </bean> <bean id="mtExternalUserSetupProcessor" class="com.jaspersoft.jasperserver.multipleTenancy.security.externalAuth.processors.MTExternalUserSetupProcessor" parent="abstractExternalProcessor"> <!--Default permitted role characters; others are removed. Change regular expression to allow other chars.--> <!--<property name="permittedExternalRoleNameRegex" value="[A-Za-z0-9_]+"/>--> <property name="organizationRoleMap"> <map> <!-- Example of mapping customer roles to JRS roles --> <!-- <entry> <key> <value>ROLE_ADMIN_EXTERNAL_ORGANIZATION</value> </key>--> <!-- JRS role that the <key> external role is mapped to--> <!--<value>ROLE_ADMINISTRATOR</value>--> <!-- <value>ROLE_ADMINISTRATOR|*</value> </entry>--> </map> </property> <property name="userAuthorityService"> <ref bean="${bean.internalUserAuthorityService}"/> </property> <!-- If the username is in adminUsernames list assign the user internal roles from defaultAdminRoles; - otherwise, assign the user all the roles from defaultInternalRoles list. --> <property name="adminUsernames"> <list> <value>myorgadmin</value> </list> </property> <property name="defaultAdminRoles"> <list> <value>ROLE_USER</value> <value>ROLE_ADMINISTRATOR</value> </list> </property> <property name="defaultInternalRoles"> <list> <value>ROLE_USER</value> <value>ROLE_ADMINISTRATOR</value> </list> </property> <property name="externalAuthProperties" ><ref local="externalAuthProperties"/></property> </bean> <!-- EXAMPLE Processor <bean id="externalUserFolderProcessor" class="com.jaspersoft.jasperserver.api.security.externalAuth.processors.ExternalUserFolderProcessor" parent="abstractExternalProcessor"> <property name="repositoryService" ref="${bean.unsecureRepositoryService}"/> </bean> --> <!-- ############ Synchronizer ############ --> <!-- ############## external dataSource: config in master.properties ############### --> <bean id="externalDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="${external.jdbc.driverClassName}"/> <property name="url" value="${external.jdbc.url}"/> <property name="username" value="${external.jdbc.username}"/> <property name="password" value="${external.jdbc.password}"/> </bean> <!-- ############## external dataSource ############### --> <bean id="externalAuthProperties" class="com.jaspersoft.jasperserver.api.security.externalAuth.ExternalAuthProperties"> <property name="externalLoginUrl" value="https://myserver:8443/snd-sso/login"/> <!-- external logout url. If specified, logout will redirect to that address. --> <property name="logoutUrl" value="https://myserver:8443/snd-sso/logout"/> <property name="ssoServerLocation" value="https://myserver:8443/snd-sso"/> </bean></beans>[/code] Step-2: Minimal changes on "applicationContext-security-web.xml" file in "WEB-INF" directory <bean id="filterChainProxy" class="org.springframework.security.util.FilterChainProxy"> <property name="filterInvocationDefinitionSource"> <value> CONVERT_URL_TO_LOWERCASE_BEFORE_COMPARISON PATTERN_TYPE_APACHE_ANT /xmla=httpSessionContextIntegrationFilter,${bean.loggingFilter},${bean.basicProcessingFilter},JIAuthenticationSynchronizer,anonymousProcessingFilter,basicAuthExceptionTranslationFilter,filterInvocationInterceptor /services/**=httpSessionContextIntegrationFilter,${bean.loggingFilter},delegatingPreAuthenticatedFilter,${bean.portletAuthenticationProcessingFilter},delegatingBasicProcessingFilter,${bean.passwordExpirationProcessingFilter},JIAuthenticationSynchronizer,anonymousProcessingFilter,wsBasicAuthExceptionTranslationFilter,filterInvocationInterceptor /rest/login=httpSessionContextIntegrationFilter,${bean.loggingFilter}, encryptionFilter,delegatingPreAuthenticatedFilter,delegatingAuthenticationRestProcessingFilter,JIAuthenticationSynchronizer,anonymousProcessingFilter,filterInvocationInterceptor /rest/**=httpSessionContextIntegrationFilter,${bean.loggingFilter},delegatingPreAuthenticatedFilter,delegatingAuthenticationRestProcessingFilter,${bean.portletAuthenticationProcessingFilter},delegatingBasicProcessingFilter,${bean.passwordExpirationProcessingFilter},JIAuthenticationSynchronizer,anonymousProcessingFilter,wsBasicAuthExceptionTranslationFilter,filterInvocationInterceptor /rest_v2/**=httpSessionContextIntegrationFilter,encryptionFilter,textOnlyResponseWebAppSecurityFilter,jsCsrfGuardFilter,${bean.loggingFilter},${bean.userPreferencesFilter},delegatingPreAuthenticatedFilter,delegatingAuthenticationRestProcessingFilter,${bean.userPreferencesFilter},delegatingBasicProcessingFilter,delegatingRequestParameterAuthenticationFilter,JIAuthenticationSynchronizer,anonymousProcessingFilter,restExceptionTranslationFilter,filterInvocationInterceptor /j_spring_security_check=httpSessionContextIntegrationFilter,delegatingAuthenticationProcessingFilter,anonymousProcessingFilter,exceptionTranslationFilter,filterInvocationInterceptor /**=httpSessionContextIntegrationFilter,encryptionFilter,multipartRequestWrapperFilter,webAppSecurityFilter,jsCsrfGuardFilter,${bean.loggingFilter},${bean.userPreferencesFilter},delegatingPreAuthenticatedFilter,delegatingAuthenticationProcessingFilter,${bean.userPreferencesFilter},delegatingBasicProcessingFilter,delegatingRequestParameterAuthenticationFilter,JIAuthenticationSynchronizer,anonymousProcessingFilter,delegatingExceptionTranslationFilter,filterInvocationInterceptor,switchUserProcessingFilter,iPadSupportFilter </value> </property> </bean> Step-4: Restart jasperserver, with the above changes, CAS working successfully. Now I have a small problem, while autheticating with "visualize.js". Exaplantion: Step-1: Visualize.js integration, to get the available resources from jasperserver [resource type : "adhocDataview"] visualize({ auth: { token : ticket }},function(v){ alert("Authentication Success ...!"); v.resourcesSearch({ folderUri:'/public/Samples/Ad_Hoc_Views/', recursive:true, success:listRepository, types: ["adhocDataView"], error:function (err) { alert(err); } }); }, function(err){ alert(err.message); });[/code] In the above code, "ticket" parameter passing dynamically from the application. Step-2: While Accessing from client side, it was invoking following code in the "visualize.js" var JrsAuthenticationExecutor = { login: function(properties, request){ var dfd = $.Deferred(); request({ url: properties.url + "/j_spring_security_check?forceDefaultRedirect=true&" + getParametersString(properties) }).done(function (result, a, b) { if (b.getResponseHeader("LoginRequested")) { dfd.reject(b); } else { dfd.resolve(result); } }).fail(function (xhr) { dfd.reject(xhr); }); return dfd; }, logout: function(properties, request){ return request({ url: properties.url + "/logout.html" }); } };[/code] After executing above code, I am getting authetication error. I think you people understand the configuration, what i have done. So kindly suggest me for the visualize.js integartion for token based authetication. Note: I am working on jasperserver since 2013, with in few days I am planning post my R &D points for the community people. Related points: Ad hoc view design with domain & topicJasper server InternationalizationRussian Langauge support for JasperserverEmbedding JasperServer in External ApplicationExternal DB authetication for jasperserverParameter passing from external Application domin level as well as topic levelBasic Examples in visualize.jsCAS integartion with jasperserverFew more... Thanks & Regards,Nagesh.

Hi All, I have implemented the Jasper Sever Dashboard using visualize.js, its working in local with floowing URLS http://127.0.0.1:8080/kpi-server/client/visualize.jshttp://<hostname>:8080/kpi-server/client/visualize.js ex:myserver.comBut it is not working with the IP address instead of hostname. And one more thing is currently we are using Jasper Server & our application in same domain, so I dont want to hard code the IP adress in JSP. If it is hard coded, again I have to take care when we are moving patch from one server to other. Current/Working Implementation: (jasperserver war file name : kpi-server(5.6 version)) <head> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <!-- Provide the URL to visualize.js --><script src="http://myserver.com:8080/kpi-server/client/visualize.js?logLevel=debug"></script> <script type="text/javascript">visualize({auth: {organization:"organizations",name : "superuser",password: "superuser"}},function(v){var report = v.report({resource: "/public/Samples/Reports/AccountList",container: "#container"});});</script> </head><body><!-- Provide a container for the report --><div id="container"></div></body>Expected Implementation: (jasperserver war file name : kpi-server(5.6 version)) <head> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <!-- Provide the URL to visualize.js --><script src="/kpi-server/client/visualize.js?logLevel=debug"></script> <!-- Since both are in same domain --> <script type="text/javascript">visualize({auth: {organization:"organizations",name : "superuser",password: "superuser"}},function(v){var report = v.report({resource: "/public/Samples/Reports/AccountList",container: "#container"});});</script> </head><body><!-- Provide a container for the report --><div id="container"></div> </body> Note: I have seen easyXDM documentation also, since visualize.js intergation done with easyXDM. It is working with IP address in same domain & different domain also. Kindly suggest me, if I have done wrong. Regards, VV Nagesh Bodapati.

Hi All, I have implemented the Jasper Sever Dashboard using visualize.js, its working in local with floowing URLS http://127.0.0.1:8080/kpi-server/client/visualize.jshttp://<hostname>:8080/kpi-server/client/visualize.js ex:myserver.comBut it is not working with the IP address instead of hostname. And one more thing is currently we are using Jasper Server & our application in same domain, so I dont want to hard code the IP adress in JSP. If it is hard coded, again I have to take care when we are moving patch from one server to other. Current/Working Implementation: (jasperserver war file name : kpi-server(5.6 version)) <head> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <!-- Provide the URL to visualize.js --><script src="http://myserver.com:8080/kpi-server/client/visualize.js?logLevel=debug"></script> <script type="text/javascript">visualize({auth: {organization:"organizations",name : "superuser",password: "superuser"}},function(v){var report = v.report({resource: "/public/Samples/Reports/AccountList",container: "#container"});});</script> </head><body><!-- Provide a container for the report --><div id="container"></div></body>Expected Implementation: (jasperserver war file name : kpi-server(5.6 version)) <head> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <!-- Provide the URL to visualize.js --><script src="/kpi-server/client/visualize.js?logLevel=debug"></script> <!-- Since both are in same domain --> <script type="text/javascript">visualize({auth: {organization:"organizations",name : "superuser",password: "superuser"}},function(v){var report = v.report({resource: "/public/Samples/Reports/AccountList",container: "#container"});});</script> </head><body><!-- Provide a container for the report --><div id="container"></div> </body> Note: I have seen easyXDM documentation also, since visualize.js intergation done with easyXDM. It is working with IP address in same domain & different domain also. Kindly suggest me, if I have done wrong. Regards, VV Nagesh Bodapati.

Finally I have got the solution. Now i am able to see the information based on the logged in user.

Hi, Find the below code, public class LiferayUserProfileBuiltInParameterProvider implements BuiltInParameterProvider{ private static final String LOGGED_IN_USER_PARAMETER_PREFIX = "LiferayUser"; private static final String[] LOGGED_IN_USER_STANDARD_PARAMETERS = {LOGGED_IN_USER_PARAMETER_PREFIX}; @SuppressWarnings("unchecked") public List<Object[]> getParameters(ExecutionContext context, List jrParameters, Map parameters) { List userProfileParameters = new ArrayList(); for (String parameterName : LOGGED_IN_USER_STANDARD_PARAMETERS) { Object[] result = getParameter(context, jrParameters, parameters, parameterName); if (result != null) {userProfileParameters.add(result); } } return userProfileParameters; } @SuppressWarnings("unchecked") public Object[] getParameter(ExecutionContext context, List jrParameters, Map parameters, String name) { if ((name == null) || (!name.toLowerCase().startsWith("LiferayUser".toLowerCase()))) { return null; } try { Authentication auth = SecurityContextHolder.getContext().getAuthentication(); if ((auth == null) || (!(auth.getPrincipal() instanceof MetadataUserDetails))) { return null; } MetadataUserDetails userDetails = (MetadataUserDetails)auth.getPrincipal(); String userName = userDetails.getUsername(); return new Object[] { JRQueryExecuterAdapter.makeParameter(name, LiferayUser.class), liferayUser }; } catch(Exception exception) { System.out.println("Exception Occured in LiferayUserProfileBuiltInParameterProvider - "+exception.getMessage()); } return null; } public String getLiferayUserParameterPrefix() { return LOGGED_IN_USER_PARAMETER_PREFIX; }}

Hi, I have created a base ad hoc view for all the users of my application in jasperserver.Now we have a requirement like, " userA is log's in and he done some changes on the base ad hoc view, but these changes will available for only userA. If the userB is log's in he is able see the base ad hoc view"

Hi , I have integrated the Jasperserver 5.2 in my application.Now we have a requirement like, UserA --> Login and he will do the changes in the ad hoc view UserB --> Login and he will do the changes in the ad hoc view If UserA is logged in he is able to see his changes but not UserB chnages. If UserB is logged in he is able to see his changes but not UserA chnages. Can u anybody help to implement this scenario.

Hi, Currently i am trying to upgrade jasperserver-pro 5.2 to jasperserver-pro 5.5.So i imported all the ad hoc view & dash boards from 5.2 to 5.5.while accessing the ad hoc view, i am getting following error. Kindly guide me to fix this problem. Error log: Error Message java.lang.RuntimeException: exception initting query Error Trace java.lang.RuntimeException: exception initting query at com.jaspersoft.ji.adhoc.strategy.DataStrategyUnroller.unrollDDS(DataStrategyUnroller.java:60) at com.jaspersoft.ji.adhoc.strategy.DataStrategyUnroller.wrap(DataStrategyUnroller.java:31) at com.jaspersoft.ji.adhoc.strategy.DataStrategyServiceImpl.getDataStrategy(DataStrategyServiceImpl.java:78) at com.jaspersoft.ji.adhoc.strategy.DataStrategyServiceImpl.getDataStrategy(DataStrategyServiceImpl.java:27) at com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl.getDataStrategy(AdhocEngineServiceImpl.java:396) at com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl.getDataStrategy(AdhocEngineServiceImpl.java:425) at com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl.resolveAdhocParameters(AdhocEngineServiceImpl.java:2866) at com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl$$FastClassByCGLIB$$74ede881.invoke(<generated>) at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191) at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622) at com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl$$EnhancerByCGLIB$$83f13dd7.resolveAdhocParameters(<generated>) at com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl$$FastClassByCGLIB$$74ede881.invoke(<generated>) at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191) at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622) at com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl$$EnhancerByCGLIB$$8741ad88.resolveAdhocParameters(<generated>) at com.jaspersoft.ji.adhoc.action.AdhocAction.initParameters(AdhocAction.java:1045) at com.jaspersoft.ji.adhoc.action.AdhocAction.initInteractiveEngine(AdhocAction.java:732) at com.jaspersoft.ji.adhoc.action.AdhocAction.initForExistingReport(AdhocAction.java:485) at sun.reflect.GeneratedMethodAccessor1665.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) 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:77) 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.impl.FlowExecutionImpl.execute(FlowExecutionImpl.java:393) at org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:214) at org.springframework.webflow.engine.TransitionableState.handleEvent(TransitionableState.java:119) at org.springframework.webflow.engine.Flow.handleEvent(Flow.java:555) at org.springframework.webflow.engine.impl.FlowExecutionImpl.handleEvent(FlowExecutionImpl.java:388) at org.springframework.webflow.engine.impl.RequestControlContextImpl.handleEvent(RequestControlContextImpl.java:210) at org.springframework.webflow.engine.ViewState.handleEvent(ViewState.java:232) at org.springframework.webflow.engine.ViewState.resume(ViewState.java:196) at org.springframework.webflow.engine.Flow.resume(Flow.java:545) at org.springframework.webflow.engine.impl.FlowExecutionImpl.resume(FlowExecutionImpl.java:261) at org.springframework.webflow.executor.FlowExecutorImpl.resumeExecution(FlowExecutorImpl.java:169) at sun.reflect.GeneratedMethodAccessor554.invoke(Unknown Source) 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:318) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.security.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at com.sun.proxy.$Proxy154.resumeExecution(Unknown Source) at org.springframework.webflow.mvc.servlet.FlowHandlerAdapter.handle(FlowHandlerAdapter.java:183) 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:900) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:827) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778) at javax.servlet.http.HttpServlet.service(HttpServlet.java:621) at javax.servlet.http.HttpServlet.service(HttpServlet.java:728) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.jaspersoft.jasperserver.war.StaticFilesCacheControlFilter.doFilter(StaticFilesCacheControlFilter.java:137) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:399) at com.jaspersoft.jasperserver.api.security.IPadSupportFilter.doFilter(IPadSupportFilter.java:67) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.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:411) 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:411) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) 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:411) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:152) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:94) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.multipleTenancy.MTBasicProcessingFilter.doFilterHttp(MTBasicProcessingFilter.java:179) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:209) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.ji.license.LicenseCheckFilter.doFilter(LicenseCheckFilter.java:103) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:70) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:209) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.JSCsrfGuardFilter.doFilter(JSCsrfGuardFilter.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.WebAppSecurityFilter.doFilter(WebAppSecurityFilter.java:76) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.MultipartRequestWrapperFilter.doFilter(MultipartRequestWrapperFilter.java:90) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.encryption.EncryptionFilter.doFilter(EncryptionFilter.java:130) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) 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:411) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:188) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.jasig.cas.client.session.SingleSignOutFilter.doFilter(SingleSignOutFilter.java:104) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.jaspersoft.jasperserver.war.util.SessionDecoratorFilter.doFilter(SessionDecoratorFilter.java:43) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.jaspersoft.jasperserver.war.P3PFilter.doFilter(P3PFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:611) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312) 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:724) Caused by: java.lang.RuntimeException: overwriting expression 'null' with '[sale Value]' on field 'Sale Value' at com.jaspersoft.ji.adhoc.strategy.calc.HybridCalculation.applyToBaseQuery(HybridCalculation.java:145) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.createQuery(CommonDomainDataStrategy.java:813) at com.jaspersoft.ji.adhoc.strategy.DataStrategyUnroller.unrollDDS(DataStrategyUnroller.java:58) ... 163 more Error Message java.lang.RuntimeException: overwriting expression 'null' with '[sale Value]' on field 'Sale Value' Error Trace java.lang.RuntimeException: overwriting expression 'null' with '[sale Value]' on field 'Sale Value' at com.jaspersoft.ji.adhoc.strategy.calc.HybridCalculation.applyToBaseQuery(HybridCalculation.java:145) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.createQuery(CommonDomainDataStrategy.java:813) at com.jaspersoft.ji.adhoc.strategy.DataStrategyUnroller.unrollDDS(DataStrategyUnroller.java:58) at com.jaspersoft.ji.adhoc.strategy.DataStrategyUnroller.wrap(DataStrategyUnroller.java:31) at com.jaspersoft.ji.adhoc.strategy.DataStrategyServiceImpl.getDataStrategy(DataStrategyServiceImpl.java:78) at com.jaspersoft.ji.adhoc.strategy.DataStrategyServiceImpl.getDataStrategy(DataStrategyServiceImpl.java:27) at com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl.getDataStrategy(AdhocEngineServiceImpl.java:396) at com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl.getDataStrategy(AdhocEngineServiceImpl.java:425) at com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl.resolveAdhocParameters(AdhocEngineServiceImpl.java:2866) at com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl$$FastClassByCGLIB$$74ede881.invoke(<generated>) at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191) at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622) at com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl$$EnhancerByCGLIB$$83f13dd7.resolveAdhocParameters(<generated>) at com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl$$FastClassByCGLIB$$74ede881.invoke(<generated>) at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191) at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622) at com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl$$EnhancerByCGLIB$$8741ad88.resolveAdhocParameters(<generated>) at com.jaspersoft.ji.adhoc.action.AdhocAction.initParameters(AdhocAction.java:1045) at com.jaspersoft.ji.adhoc.action.AdhocAction.initInteractiveEngine(AdhocAction.java:732) at com.jaspersoft.ji.adhoc.action.AdhocAction.initForExistingReport(AdhocAction.java:485) at sun.reflect.GeneratedMethodAccessor1665.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) 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:77) 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.impl.FlowExecutionImpl.execute(FlowExecutionImpl.java:393) at org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:214) at org.springframework.webflow.engine.TransitionableState.handleEvent(TransitionableState.java:119) at org.springframework.webflow.engine.Flow.handleEvent(Flow.java:555) at org.springframework.webflow.engine.impl.FlowExecutionImpl.handleEvent(FlowExecutionImpl.java:388) at org.springframework.webflow.engine.impl.RequestControlContextImpl.handleEvent(RequestControlContextImpl.java:210) at org.springframework.webflow.engine.ViewState.handleEvent(ViewState.java:232) at org.springframework.webflow.engine.ViewState.resume(ViewState.java:196) at org.springframework.webflow.engine.Flow.resume(Flow.java:545) at org.springframework.webflow.engine.impl.FlowExecutionImpl.resume(FlowExecutionImpl.java:261) at org.springframework.webflow.executor.FlowExecutorImpl.resumeExecution(FlowExecutorImpl.java:169) at sun.reflect.GeneratedMethodAccessor554.invoke(Unknown Source) 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:318) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.security.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at com.sun.proxy.$Proxy154.resumeExecution(Unknown Source) at org.springframework.webflow.mvc.servlet.FlowHandlerAdapter.handle(FlowHandlerAdapter.java:183) 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:900) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:827) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778) at javax.servlet.http.HttpServlet.service(HttpServlet.java:621) at javax.servlet.http.HttpServlet.service(HttpServlet.java:728) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.jaspersoft.jasperserver.war.StaticFilesCacheControlFilter.doFilter(StaticFilesCacheControlFilter.java:137) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:399) at com.jaspersoft.jasperserver.api.security.IPadSupportFilter.doFilter(IPadSupportFilter.java:67) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.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:411) 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:411) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) 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:411) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:152) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:94) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.multipleTenancy.MTBasicProcessingFilter.doFilterHttp(MTBasicProcessingFilter.java:179) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:209) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.ji.license.LicenseCheckFilter.doFilter(LicenseCheckFilter.java:103) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:70) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:209) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.JSCsrfGuardFilter.doFilter(JSCsrfGuardFilter.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.WebAppSecurityFilter.doFilter(WebAppSecurityFilter.java:76) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.MultipartRequestWrapperFilter.doFilter(MultipartRequestWrapperFilter.java:90) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.encryption.EncryptionFilter.doFilter(EncryptionFilter.java:130) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) 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:411) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:188) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.jasig.cas.client.session.SingleSignOutFilter.doFilter(SingleSignOutFilter.java:104) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.jaspersoft.jasperserver.war.util.SessionDecoratorFilter.doFilter(SessionDecoratorFilter.java:43) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at com.jaspersoft.jasperserver.war.P3PFilter.doFilter(P3PFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:611) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312) 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:724) About JasperReports Server Copyright © 2000-2013 Jaspersoft Corporation

Thanks for your quick reply. I verified the links previously in jasper wikis.I tried all the scenarios i didn't get any performance change. 1) Is it possible remove jasper authentication completly? --> in our application we have authentication.So we don't want additional authentication. 2) Currently we are using mongoDb.To get data from mongodb, our quaries will be taking few milliseconds. But to opening the adhoc view its taking 10-20 seconds. Some times this time will be more. why? 3) I implemented custom authentication for Jasperserver.Is it possible to pass data from our application to jasperserver ad hoc views. Note: passing through URL i tried it will work only for dashboard & reports not adhoc views. 4) Is it Possible to hide the chat types in Dashboard? 5) Is it possible to implement cascading in ad hoc view filters? Once again thanks for your quick reply. The above information i need as early as possible. Now we are in production Phase, so we need fix it.

Hi All, Currently we are mplemented ad hoc views & Dash Boards in "JasperServer-pro-5.2". We have a huge performance problem. For each adhoc view its taking approx 10-20 sec. Anyone can you guide me please. Thanks, VV Nagesh Bodapati.

Thanks for your reply. Jasperserver URl is correct. same URL will be working before configuring external DB.

Thanks for your reply. Jasperserver URl is correct. same URL will be working before configuring external DB.Both will be running in same machine.

Hi, I done external Authentication from my Db in jasperserver. Now i am unable to connect jasperserver repository in iReport. Details: Jasperserver 5.2.war Ireport:4.7 . Error Message: Can you please help me.

Hi, I Implemeted my own "MYUserProfileBuiltInParameterProvider.java". I configured in "applicationContext.xml". But its triggering multiple times.Sometimes 3,5,8 etc. Can you please help me.

Error Log: 17:23:17,740 ERROR [stderr] (http-fin-release.enhancesys.com-192.168.2.241-8080-5) org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.postgresql.util.PSQLException: FATAL: invalid value for parameter "TimeZone": "IST"17:23:17,749 ERROR [stderr] (http-fin-release.enhancesys.com-192.168.2.241-8080-5) at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)17:23:17,755 ERROR [stderr] (http-fin-release.enhancesys.com-192.168.2.241-8080-5) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:573)17:23:17,760 ERROR [stderr] (http-fin-release.enhancesys.com-192.168.2.241-8080-5) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:637)17:23:17,765 ERROR [stderr] (http-fin-release.enhancesys.com-192.168.2.241-8080-5) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:662)17:23:17,770 ERROR [stderr] (http-fin-release.enhancesys.com-192.168.2.241-8080-5) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:702)17:23:17,775 ERROR [stderr] (http-fin-release.enhancesys.com-192.168.2.241-8080-5) at org.springframework.jdbc.object.SqlQuery.execute(SqlQuery.java:112) Finally i fixed it. postgres driver problem. Currently distribution contains 9.2 version. Now i chnaged to 9.1. its working fine.but i am unable to connect iwth ireport. while connecting with ireport i am getting soap related exception.if possible can you guide me.

Hi, I done external database configuration in jasperserver 5.2 distribution war. Its working in window.But its not working in Linux. Can you please guide me.

Hi ilona, Thanks for your reply. jaspersoft 5.5 when it will release. And i am currently one problem like Jasperserver authentication with external db. i done the changes bsed on reference document but still its referring jasper db. can you please guide me.

For Dashboards & ireports its working fine. Only problem with adhocview-cross tabs. Any way thanks for ur reply. I have one more problem like "jasperserver 5.2 authentication with external DB". i done changes according to reference document but still it is referring jasper db.

Hi, I added the "applicationContext-customauth.xml" file from jasperserver sample to WEB-INF. But jasperserver still it is pointing to internal Database. Can u please help me. Thanks & Regards, VV NAgesh Bodapati.

Hi, I implemented ad hoc views & integrated in liferay using Iframe. Now i want to display data in the reports based on logged in user. So i implemented "CustomBuiltInUserParameterProvider.java". With hard coded "USER_ID" its working fine. Now i want to pass user data to "CustomBuiltInUserParameterProvider.java". But i dont have any idea, how to pass. Currently my data in liferay session. Can u please guide me. Its urgent requirement for us. Thanks & Regards, VV Nagesh Bodapati.

Hi mmflynn, As above mentioned, "Background: I have some customized acegi authentication mechanisms that authenticates and loads user info from another server once upon login and this info will be used in report generation for displaying and filtering of data. We are a reseller so company id and name are used to filter data appropriately and for displaying reports with company specific data. Also, these parameters should not be set or seen by the user to ensure user doesn't have access to another companies' data." I need to do same scenario can u explain how to do in jasperserver.

Hi anybody can u please guide me how to pass parameter to ad hoc view through URL. For normal reports its working. Only problem with ad hoc views.

Hi, In JasperServer, passing parameters to specific report through URL is working fine example: http://<host>:<port>/<context>/flow.html?_flowId=viewReportFlow&reportUnit=/supermart/Details/CustomerDashboard&customerID=4012 where as in adhoc view same scenario is not working. Please help me. VV Nagesh Bodapati

Hi All, I want to pass a parameter from URL to a query in ad hoc view. Or based on loggin user i want to show the records in the ad hoc view. Advance Thanks. VV Nagesh Bodapati.

Hi ilona, Thanks for your reply. Can u share any link to create ad hoc view with above scenario.