kuzman

Hi I have used you database scripts. When I try to save the report I still have the java not defined error. I replaced the oid to bytea and after bigint but the problem is the same. Do not need to change the Applicationcontext.xml? Attached I send you the log files, the script files. (I have modified the password and the databbase owner) and the hibernate and context files. Thanks Post Edited by Kuzman Zsolt at 03/24/09 17:18

Hi To eliminate the postgre connection problem, I copyed the "postgresql-8.3-604.jdbc3" to the Apache-tomcat lib.

Hi I have reinstalled the JAsper and I can not connect to Postgres repository. I could not load the org.Postgres driver. Post Edited by Kuzman Zsolt at 03/24/09 17:18

Hi The datasource creation is completed succesfull. After I tried to create a report, when I saved the report a messagebox pop up: Ajaxerror is not defined , row:259 Thanks your help, Zsolt Code:The Jasperserver log is:10:50:24,800 WARN LoggerListener,http-8080-Processor23:55 - Authentication event AuthenticationFailureBadCredentialsEvent: jasperadmin; details: org.acegisecurity.ui.WebAuthenticationDetails@380f4: RemoteIpAddress: 127.0.0.1; SessionId: 9A9456BEE184AB77450C8C32C812E168; exception: Bad credentials10:50:33,144 WARN LoggerListener,http-8080-Processor25:55 - Authentication event AuthenticationSuccessEvent: jasperadmin; details: org.acegisecurity.ui.WebAuthenticationDetails@380f4: RemoteIpAddress: 127.0.0.1; SessionId: 9A9456BEE184AB77450C8C32C812E16810:50:33,160 WARN LoggerListener,http-8080-Processor25:55 - Authentication event InteractiveAuthenticationSuccessEvent: jasperadmin; details: org.acegisecurity.ui.WebAuthenticationDetails@380f4: RemoteIpAddress: 127.0.0.1; SessionId: 9A9456BEE184AB77450C8C32C812E16810:52:15,492 ERROR DefaultExtensionsRegistry,http-8080-Processor23:195 - Error instantiating extensions registry for fchartsorg.springframework.beans.factory.xml.XmlBeanDefinitionStoreException: Line 6 in XML document from URL [jar:file:/C:/Program%20Files/jasperserver-3.1/apache-tomcat/webapps/jasperserver/WEB-INF/lib/jasperreports-ofc-component-0.0.2.1.jar!/com/jaspersoft/sample/ofc/chart_beans.xml] is invalid; nested exception is org.xml.sax.SAXParseException: cvc-elt.1: Cannot find the declaration of element 'beans'.Caused by: org.xml.sax.SAXParseException: cvc-elt.1: Cannot find the declaration of element 'beans'. at org.apache.xerces.parsers.DOMParser.parse(Unknown Source) at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(Unknown Source) at org.springframework.beans.factory.xml.DefaultDocumentLoader.loadDocument(DefaultDocumentLoader.java:76) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:388) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:340) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:317) at org.springframework.beans.factory.xml.XmlBeanFactory.<init>(XmlBeanFactory.java:73) at org.springframework.beans.factory.xml.XmlBeanFactory.<init>(XmlBeanFactory.java:61) at net.sf.jasperreports.extensions.SpringExtensionsRegistryFactory.getBeanFactory(SpringExtensionsRegistryFactory.java:106) at net.sf.jasperreports.extensions.SpringExtensionsRegistryFactory.createRegistry(SpringExtensionsRegistryFactory.java:77) at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.instantiateRegistry(DefaultExtensionsRegistry.java:213) at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.loadRegistries(DefaultExtensionsRegistry.java:188) at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.loadRegistries(DefaultExtensionsRegistry.java:141) at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.getRegistries(DefaultExtensionsRegistry.java:127) at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.getExtensions(DefaultExtensionsRegistry.java:104) at net.sf.jasperreports.engine.component.ComponentsEnvironment.findComponentBundles(ComponentsEnvironment.java:94) at net.sf.jasperreports.engine.component.ComponentsEnvironment.getCachedComponentBundles(ComponentsEnvironment.java:82) at net.sf.jasperreports.engine.component.ComponentsEnvironment.getComponentBundles(ComponentsEnvironment.java:70) at net.sf.jasperreports.engine.xml.JRReportSaxParserFactory.getSchemaLocations(JRReportSaxParserFactory.java:162) at net.sf.jasperreports.engine.xml.JRReportSaxParserFactory.configureParser(JRReportSaxParserFactory.java:143) at net.sf.jasperreports.engine.xml.JRReportSaxParserFactory.createParser(JRReportSaxParserFactory.java:108) at net.sf.jasperreports.engine.xml.JRXmlDigesterFactory.createParser(JRXmlDigesterFactory.java:1132) at net.sf.jasperreports.engine.xml.JRXmlDigesterFactory.createDigester(JRXmlDigesterFactory.java:1107) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:203) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.ResourceCollector.getResources(ResourceCollector.java:79) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.getResources(EngineServiceImpl.java:720) at com.jaspersoft.jasperserver.war.action.ReportUnitAction.uploadJRXML(ReportUnitAction.java:291) 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:103) at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:136) at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:203) at org.springframework.webflow.engine.AnnotatedAction.execute(AnnotatedAction.java:142) at org.springframework.webflow.engine.ActionExecutor.execute(ActionExecutor.java:61) at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:180) at org.springframework.webflow.engine.State.enter(State.java:200) at org.springframework.webflow.engine.Transition.execute(Transition.java:229) at org.springframework.webflow.engine.TransitionableState.onEvent(TransitionableState.java:112) at org.springframework.webflow.engine.Flow.onEvent(Flow.java:572) at org.springframework.webflow.engine.impl.RequestControlContextImpl.signalEvent(RequestControlContextImpl.java:207) at org.springframework.webflow.engine.impl.FlowExecutionImpl.signalEvent(FlowExecutionImpl.java:214) at org.springframework.webflow.executor.FlowExecutorImpl.resume(FlowExecutorImpl.java:238) 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:281) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154) at org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210) at $Proxy13.resume(Unknown Source) at org.springframework.webflow.executor.support.FlowRequestHandler.handleFlowRequest(FlowRequestHandler.java:115) at org.springframework.webflow.executor.mvc.FlowController.handleRequestInternal(FlowController.java:170) 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:820) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:360) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) 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.doFilter(ApplicationFilterChain.java:173) at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:83) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:141) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595)10:52:34,274 ERROR JSErrorPage_jsp,http-8080-Processor23:329 - org.hibernate.HibernateException: I don't know how to map the type java.lang.String to a blob at com.jaspersoft.hibernate.ByteWrappingBlobType.get(ByteWrappingBlobType.java:61) 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:2046) at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1371) at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1299) at org.hibernate.loader.Loader.getRow(Loader.java:1197) at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:568) at org.hibernate.loader.Loader.doQuery(Loader.java:689) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) at org.hibernate.loader.Loader.loadEntity(Loader.java:1851) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48) at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42) at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:2992) at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:395) at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375) at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139) at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:98) at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878) at org.hibernate.impl.SessionImpl.immediateLoad(SessionImpl.java:836) at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:66) at org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:111) at org.hibernate.proxy.pojo.cglib.CGLIBLazyInitializer.invoke(CGLIBLazyInitializer.java:140) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource$$EnhancerByCGLIB$$87e45fb9.getParent(<generated>) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource.getClientReference(RepoResource.java:71) at com.jaspersoft.jasperserver.api.metadata.jasperreports.domain.impl.RepoReportUnit.copyTo(RepoReportUnit.java:215) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource.toClient(RepoResource.java:92) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoResource.toClient(RepoResource.java:83) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.loadResource(HibernateRepositoryServiceImpl.java:177) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl$1.execute(HibernateRepositoryServiceImpl.java:155) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeCallback(HibernateDaoImpl.java:58) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.getResourceUnsecure(HibernateRepositoryServiceImpl.java:153) at sun.reflect.GeneratedMethodAccessor67.invoke(Unknown Source) 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:281) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154) at org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210) at $Proxy1.getResourceUnsecure(Unknown Source) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.ObjectPermissionServiceImpl.lookup(ObjectPermissionServiceImpl.java:600) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.ObjectPermissionServiceImpl.getAcls(ObjectPermissionServiceImpl.java:276) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.ObjectPermissionServiceImpl.getAcls(ObjectPermissionServiceImpl.java:541) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.ObjectPermissionServiceImpl.getAcls(ObjectPermissionServiceImpl.java:573) at sun.reflect.GeneratedMethodAccessor70.invoke(Unknown Source) 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:281) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210) at $Proxy4.getAcls(Unknown Source) at org.acegisecurity.acl.AclProviderManager.getAcls(AclProviderManager.java:96) at org.acegisecurity.afterinvocation.BasicAclEntryAfterInvocationCollectionFilteringProvider.decide(BasicAclEntryAfterInvocationCollectionFilteringProvider.java:145) at org.acegisecurity.afterinvocation.AfterInvocationProviderManager.decide(AfterInvocationProviderManager.java:74) at org.acegisecurity.intercept.AbstractSecurityInterceptor.afterInvocation(AbstractSecurityInterceptor.java:150) at org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:68) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210) at $Proxy1.loadResourcesList(Unknown Source) at com.jaspersoft.jasperserver.war.model.impl.RepositoryExplorerTreeDataProviderImpl.processFolder(RepositoryExplorerTreeDataProviderImpl.java:123) at com.jaspersoft.jasperserver.war.model.impl.RepositoryExplorerTreeDataProviderImpl.getNode(RepositoryExplorerTreeDataProviderImpl.java:90) at com.jaspersoft.jasperserver.war.model.impl.RepositoryExplorerTreeDataProviderImpl.getChildren(RepositoryExplorerTreeDataProviderImpl.java:66) at com.jaspersoft.jasperserver.war.model.TreeHelper.processMiniNode(TreeHelper.java:138) at com.jaspersoft.jasperserver.war.model.TreeHelper.getSubtree(TreeHelper.java:100) at com.jaspersoft.jasperserver.war.action.tree.TreeAction.getNode(TreeAction.java:116) 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:103) at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:136) at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:203) at org.springframework.webflow.engine.AnnotatedAction.execute(AnnotatedAction.java:142) at org.springframework.webflow.engine.ActionExecutor.execute(ActionExecutor.java:61) at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:180) at org.springframework.webflow.engine.State.enter(State.java:200) at org.springframework.webflow.engine.Transition.execute(Transition.java:229) at org.springframework.webflow.engine.DecisionState.doEnter(DecisionState.java:58) at org.springframework.webflow.engine.State.enter(State.java:200) at org.springframework.webflow.engine.Flow.start(Flow.java:557) at org.springframework.webflow.engine.impl.RequestControlContextImpl.start(RequestControlContextImpl.java:195) at org.springframework.webflow.engine.impl.FlowExecutionImpl.start(FlowExecutionImpl.java:189) at org.springframework.webflow.executor.FlowExecutorImpl.launch(FlowExecutorImpl.java:206) at sun.reflect.GeneratedMethodAccessor111.invoke(Unknown Source) 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:281) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154) at org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210) at $Proxy13.launch(Unknown Source) at org.springframework.webflow.executor.support.FlowRequestHandler.handleFlowRequest(FlowRequestHandler.java:131) at org.springframework.webflow.executor.mvc.FlowController.handleRequestInternal(FlowController.java:170) 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:820) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755) 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.doFilter(ApplicationFilterChain.java:173) at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:141) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595)--------------------------------------The postgre log is:2009-03-23 10:50:09 CET LOG: loaded library "$libdir/plugins/plugin_debugger.dll"2009-03-23 10:50:09 CET LOG: loaded library "$libdir/plugins/plugin_debugger.dll"2009-03-23 10:50:13 CET LOG: loaded library "$libdir/plugins/plugin_debugger.dll"

Hi I have finded sql scripts on the internet for JAsperserver 1.3 but I have 3.1 I tried to create a new database with this scripts. The login is working. It shows the root directory. I can add new DAtaSource to the repository. If I add a new report or image, it returned with not Ajax error definiation message. After that I can not use the JAsperserver. Only the hourglass is running and never stops. I send you attached the script: Sorry for the long post.. Code:CREATE TABLE qrtz_job_details ( JOB_NAME VARCHAR(80) NOT NULL, JOB_GROUP VARCHAR(80) NOT NULL, DESCRIPTION VARCHAR(120) NULL, JOB_CLASS_NAME VARCHAR(128) NOT NULL, IS_DURABLE boolean NOT NULL, IS_VOLATILE boolean NOT NULL, IS_STATEFUL boolean NOT NULL, REQUESTS_RECOVERY boolean NOT NULL, JOB_DATA bytea NULL, PRIMARY KEY (JOB_NAME,JOB_GROUP));CREATE TABLE qrtz_job_listeners ( JOB_NAME VARCHAR(80) NOT NULL, JOB_GROUP VARCHAR(80) NOT NULL, JOB_LISTENER VARCHAR(80) NOT NULL, PRIMARY KEY (JOB_NAME,JOB_GROUP,JOB_LISTENER), FOREIGN KEY (JOB_NAME,JOB_GROUP) REFERENCES QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP));CREATE TABLE qrtz_triggers ( TRIGGER_NAME VARCHAR(80) NOT NULL, TRIGGER_GROUP VARCHAR(80) NOT NULL, JOB_NAME VARCHAR(80) NOT NULL, JOB_GROUP VARCHAR(80) NOT NULL, IS_VOLATILE boolean NOT NULL, DESCRIPTION VARCHAR(120) NULL, NEXT_FIRE_TIME bigint NULL, PREV_FIRE_TIME bigint NULL, TRIGGER_STATE VARCHAR(16) NOT NULL, TRIGGER_TYPE VARCHAR(8) NOT NULL, START_TIME bigint NOT NULL, END_TIME bigint NULL, CALENDAR_NAME VARCHAR(80) NULL, MISFIRE_INSTR smallint NULL, JOB_DATA bytea NULL, PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP), FOREIGN KEY (JOB_NAME,JOB_GROUP) REFERENCES QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP) );CREATE TABLE qrtz_simple_triggers ( TRIGGER_NAME VARCHAR(80) NOT NULL, TRIGGER_GROUP VARCHAR(80) NOT NULL, REPEAT_COUNT integer NOT NULL, REPEAT_INTERVAL bigint NOT NULL, TIMES_TRIGGERED integer NOT NULL, PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP), FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP));CREATE TABLE qrtz_cron_triggers ( TRIGGER_NAME VARCHAR(80) NOT NULL, TRIGGER_GROUP VARCHAR(80) NOT NULL, CRON_EXPRESSION VARCHAR(80) NOT NULL, TIME_ZONE_ID VARCHAR(80), PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP), FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP));CREATE TABLE qrtz_blob_triggers ( TRIGGER_NAME VARCHAR(80) NOT NULL, TRIGGER_GROUP VARCHAR(80) NOT NULL, BLOB_DATA bytea NULL, PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP), FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP));CREATE TABLE qrtz_trigger_listeners ( TRIGGER_NAME VARCHAR(80) NOT NULL, TRIGGER_GROUP VARCHAR(80) NOT NULL, TRIGGER_LISTENER VARCHAR(80) NOT NULL, PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_LISTENER), FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP) REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP));CREATE TABLE qrtz_calendars ( CALENDAR_NAME VARCHAR(80) NOT NULL, CALENDAR bytea NOT NULL, PRIMARY KEY (CALENDAR_NAME));CREATE TABLE qrtz_paused_trigger_grps ( TRIGGER_GROUP VARCHAR(80) NOT NULL, PRIMARY KEY (TRIGGER_GROUP));CREATE TABLE qrtz_fired_triggers ( ENTRY_ID VARCHAR(95) NOT NULL, TRIGGER_NAME VARCHAR(80) NOT NULL, TRIGGER_GROUP VARCHAR(80) NOT NULL, IS_VOLATILE boolean NOT NULL, INSTANCE_NAME VARCHAR(80) NOT NULL, FIRED_TIME bigint NOT NULL, STATE VARCHAR(16) NOT NULL, JOB_NAME VARCHAR(80) NULL, JOB_GROUP VARCHAR(80) NULL, IS_STATEFUL boolean NULL, REQUESTS_RECOVERY boolean NULL, PRIMARY KEY (ENTRY_ID));CREATE TABLE qrtz_scheduler_state ( INSTANCE_NAME VARCHAR(80) NOT NULL, LAST_CHECKIN_TIME bigint NOT NULL, CHECKIN_INTERVAL bigint NOT NULL, RECOVERER VARCHAR(80) NULL, PRIMARY KEY (INSTANCE_NAME));CREATE TABLE qrtz_locks ( LOCK_NAME VARCHAR(40) NOT NULL, PRIMARY KEY (LOCK_NAME));INSERT INTO qrtz_locks values('TRIGGER_ACCESS');INSERT INTO qrtz_locks values('JOB_ACCESS');INSERT INTO qrtz_locks values('CALENDAR_ACCESS');INSERT INTO qrtz_locks values('STATE_ACCESS');INSERT INTO qrtz_locks values('MISFIRE_ACCESS');create index idx_qrtz_j_req_recovery on qrtz_job_details(REQUESTS_RECOVERY);create index idx_qrtz_t_next_fire_time on qrtz_triggers(NEXT_FIRE_TIME);create index idx_qrtz_t_state on qrtz_triggers(TRIGGER_STATE);create index idx_qrtz_t_nft_st on qrtz_triggers(NEXT_FIRE_TIME,TRIGGER_STATE);create index idx_qrtz_t_volatile on qrtz_triggers(IS_VOLATILE);create index idx_qrtz_ft_trig_name on qrtz_fired_triggers(TRIGGER_NAME);create index idx_qrtz_ft_trig_group on qrtz_fired_triggers(TRIGGER_GROUP);create index idx_qrtz_ft_trig_nm_gp on qrtz_fired_triggers(TRIGGER_NAME,TRIGGER_GROUP);create index idx_qrtz_ft_trig_volatile on qrtz_fired_triggers(IS_VOLATILE);create index idx_qrtz_ft_trig_inst_name on qrtz_fired_triggers(INSTANCE_NAME);create index idx_qrtz_ft_job_name on qrtz_fired_triggers(JOB_NAME);create index idx_qrtz_ft_job_group on qrtz_fired_triggers(JOB_GROUP);create index idx_qrtz_ft_job_stateful on qrtz_fired_triggers(IS_STATEFUL);create index idx_qrtz_ft_job_req_recovery on qrtz_fired_triggers(REQUESTS_RECOVERY);Create table jibeandatasource ( id Bigint NOT NULL, beanName Varchar(100) NOT NULL, beanMethod Varchar(100), Primary Key (id)) Without Oids;Create table jicontentresource ( id Bigint NOT NULL, "data" Char(20), file_type Varchar(20), Primary Key (id)) Without Oids;Create table jicustomdatasource ( id Bigint NOT NULL, serviceClass Varchar(250) NOT NULL, Primary Key (id)) Without Oids;Create table jicustomdatasourceproperty ( ds_id Bigint NOT NULL, name Varchar(100) NOT NULL, value Text, Primary Key (ds_id,name)) Without Oids;Create table jidatatype ( id Bigint NOT NULL, "type" Smallint, maxLength Integer, decimals Integer, regularExpr Varchar(255), minValue Bytea, maxValue Bytea, strictMin Boolean, strictMax Boolean, Primary Key (id)) Without Oids;Create table jifileresource ( id Bigint NOT NULL, "data" Char(20), file_type Varchar(20), reference Bigint, Primary Key (id)) Without Oids;Create table jiinputcontrol ( id Bigint NOT NULL, "type" Smallint, mandatory Boolean, readOnly Boolean, visible Boolean, data_type Bigint, list_of_values Bigint, list_query Bigint, query_value_column Varchar(200), defaultValue Bytea, Primary Key (id)) Without Oids;Create table jiinputcontrolquerycolumn ( input_control_id Bigint NOT NULL, column_index Integer NOT NULL, query_column Varchar(200) NOT NULL, Primary Key (input_control_id,column_index)) Without Oids;Create table jijdbcdatasource ( id Bigint NOT NULL, driver Varchar(100) NOT NULL, "password" Varchar(100), connectionUrl Text, "username" Varchar(100), timezone Varchar(100), Primary Key (id)) Without Oids;Create table jijndijdbcdatasource ( id Bigint NOT NULL, jndiName Varchar(100) NOT NULL, timezone Varchar(100), Primary Key (id)) Without Oids;Create table jilistofvalues ( id Bigint NOT NULL, Primary Key (id)) Without Oids;Create table jilistofvaluesitem ( id Bigint NOT NULL, idx Integer NOT NULL, label Varchar(255), value Bytea, Primary Key (id,idx)) Without Oids;Create table jilogevent ( id Bigint NOT NULL, occurrence_date Date NOT NULL, event_type Smallint NOT NULL, username Varchar(100), component Varchar(100), message Varchar(250) NOT NULL, resource_uri Varchar(250), event_text Text, event_data Bytea, event_state Smallint, Primary Key (id)) Without Oids;Create table jimondrianconnection ( id Bigint NOT NULL, reportDataSource Bigint, mondrianSchema Bigint, Primary Key (id)) Without Oids;Create table jimondrianxmladefinition ( id Bigint NOT NULL, catalog Varchar(100) NOT NULL, mondrianConnection Bigint, Primary Key (id)) Without Oids;Create table jiobjectpermission ( id Bigint NOT NULL, uri Varchar(255) NOT NULL, recipientobjectclass Varchar(100), recipientobjectid Bigint, permissionMask Integer NOT NULL, Primary Key (id)) Without Oids;Create table jiolapclientconnection ( id Bigint NOT NULL, Primary Key (id)) Without Oids;Create table jiolapunit ( id Bigint NOT NULL, olapClientConnection Bigint, mdx_query Text NOT NULL, view_options Char(20), Primary Key (id)) Without Oids;Create table jiprofileattribute ( id Bigint NOT NULL, attrName Varchar(255) NOT NULL, attrValue Varchar(255) NOT NULL, principalobjectclass Varchar(255) NOT NULL, principalobjectid Bigint NOT NULL, Primary Key (id)) Without Oids;Create table jiquery ( id Bigint NOT NULL, dataSource Bigint, query_language Varchar(40) NOT NULL, sql_query Text NOT NULL, Primary Key (id)) Without Oids;Create table jireportjob ( id Bigint NOT NULL, version Integer NOT NULL, username Varchar(100) NOT NULL, label Varchar(100) NOT NULL, description Text, report_unit_uri Varchar(200) NOT NULL, job_trigger Bigint NOT NULL, base_output_name Varchar(100) NOT NULL, output_locale Varchar(20), content_destination Bigint, mail_notification Bigint, Primary Key (id)) Without Oids;Create table jireportjobcalendartrigger ( id Bigint NOT NULL, minutes Varchar(200) NOT NULL, hours Varchar(80) NOT NULL, days_type Smallint NOT NULL, week_days Varchar(20), month_days Varchar(100), months Varchar(40) NOT NULL, Primary Key (id)) Without Oids;Create table jireportjobmail ( id Bigint NOT NULL, version Integer NOT NULL, subject Varchar(100) NOT NULL, message Text NOT NULL, send_type Smallint NOT NULL, skip_empty Boolean NOT NULL, Primary Key (id)) Without Oids;Create table jireportjobmailrecipient ( destination_id Bigint NOT NULL, recipient_idx Integer NOT NULL, recipient_type Smallint NOT NULL, address Varchar(100) NOT NULL, Primary Key (destination_id,recipient_idx)) Without Oids;Create table jireportjoboutputformat ( report_job_id Bigint NOT NULL, output_format Smallint NOT NULL, Primary Key (report_job_id,output_format)) Without Oids;Create table jireportjobparameter ( job_id Bigint NOT NULL, parameter_name Varchar(100) NOT NULL, parameter_value Bytea, Primary Key (job_id,parameter_name)) Without Oids;Create table jireportjobrepodest ( id Bigint NOT NULL, version Integer NOT NULL, folder_uri Varchar(200) NOT NULL, sequential_filenames Boolean NOT NULL, overwrite_files Boolean NOT NULL, output_description Varchar(100), timestamp_pattern Varchar(250), Primary Key (id)) Without Oids;Create table jireportjobsimpletrigger ( id Bigint NOT NULL, occurrence_count Integer NOT NULL, recurrence_interval Integer, recurrence_interval_unit Smallint, Primary Key (id)) Without Oids;Create table jireportjobtrigger ( id Bigint NOT NULL, version Integer NOT NULL, timezone Varchar(40), start_type Smallint NOT NULL, start_date Date, end_date Date, Primary Key (id)) Without Oids;Create table jireportunit ( id Bigint NOT NULL, reportDataSource Bigint, query Bigint, mainReport Bigint, controlrenderer Varchar(100), reportrenderer Varchar(100), promptcontrols Boolean, controlslayout Smallint, Primary Key (id)) Without Oids;Create table jireportunitinputcontrol ( report_unit_id Bigint NOT NULL, control_index Integer NOT NULL, input_control_id Bigint NOT NULL, Primary Key (report_unit_id,control_index)) Without Oids;Create table jireportunitresource ( report_unit_id Bigint NOT NULL, resource_index Integer NOT NULL, resource_id Bigint NOT NULL, Primary Key (report_unit_id,resource_index)) Without Oids;Create table jirepositorycache ( id Bigint NOT NULL, uri Varchar(200) NOT NULL, cache_name Varchar(20) NOT NULL, "data" Char(20), version Integer NOT NULL, version_date Date NOT NULL, item_reference Bigint, Primary Key (id)) Without Oids;Create table jiresource ( id Bigint NOT NULL, version Integer NOT NULL, name Varchar(100) NOT NULL, parent_folder Bigint NOT NULL, childrenFolder Bigint, label Varchar(100) NOT NULL, description Varchar(250), creation_date Date NOT NULL, Primary Key (id)) Without Oids;Create table jiresourcefolder ( id Bigint NOT NULL, version Integer NOT NULL, uri Varchar(250) NOT NULL, hidden Boolean, name Varchar(100) NOT NULL, label Varchar(100) NOT NULL, description Varchar(250), parent_folder Bigint, creation_date Date NOT NULL, Primary Key (id)) Without Oids;Create table jirole ( id Bigint NOT NULL, rolename Varchar(100) NOT NULL, externallyDefined Boolean, Primary Key (id)) Without Oids;Create table jiuser ( id Bigint NOT NULL, username Varchar(100) NOT NULL, fullname Varchar(100) NOT NULL, emailAddress Varchar(100), "password" Varchar(100), externallyDefined Boolean, enabled Boolean, previousPasswordChangeTime Date, Primary Key (id)) Without Oids;Create table jiuserrole ( userId Bigint NOT NULL, roleId Bigint NOT NULL, Primary Key (userId,roleId)) Without Oids;Create table jixmlaconnection ( id Bigint NOT NULL, catalog Varchar(100) NOT NULL, "username" Varchar(100) NOT NULL, "password" Varchar(100) NOT NULL, datasource Varchar(100) NOT NULL, uri Varchar(100) NOT NULL, Primary Key (id)) Without Oids;--Alter Table jirepositorycache add Constraint uri UNIQUE (uri,cache_name);Alter Table jiresource add Constraint name UNIQUE (name,parent_folder);Alter Table jiresourcefolder add Constraint uri UNIQUE (uri);Alter Table jirole add Constraint rolename UNIQUE (rolename);Alter Table jiuser add Constraint username UNIQUE (username);Create index FK674BF34A8BF376D on jibeandatasource using btree (id);Create index FKE466FC68A8BF376D on jicontentresource using btree (id);Create index FK2BBCEDF5A8BF376D on jicustomdatasource using btree (id);Create index FKB8A66AEA858A89D1 on jicustomdatasourceproperty using btree (ds_id);Create index FK533BCC63A8BF376D on jidatatype using btree (id);Create index FKF75B58895A0C539 on jifileresource using btree (reference);Create index FKF75B5889A8BF376D on jifileresource using btree (id);Create index FKCAC6A512120E06F7 on jiinputcontrol using btree (data_type);Create index FKCAC6A512B37DB6EB on jiinputcontrol using btree (list_query);Create index FKCAC6A51262A86F04 on jiinputcontrol using btree (list_of_values);Create index FKCAC6A512A8BF376D on jiinputcontrol using btree (id);Create index FKE436A5CCE7922149 on jiinputcontrolquerycolumn using btree (input_control_id);Create index FKC8BDFCBFA8BF376D on jijdbcdatasource using btree (id);Create index FK7F9DA248A8BF376D on jijndijdbcdatasource using btree (id);Create index FK4E86A776A8BF376D on jilistofvalues using btree (id);Create index FKD37CEBA993F0E1F6 on jilistofvaluesitem using btree (id);Create index FK4FF53B19C495A60B on jimondrianconnection using btree (mondrianSchema);Create index FK4FF53B19324CFECB on jimondrianconnection using btree (reportDataSource);Create index FK4FF53B191D51BFAD on jimondrianconnection using btree (id);Create index FK313B2AB8DC098B1 on jimondrianxmladefinition using btree (mondrianConnection);Create index FK313B2AB8A8BF376D on jimondrianxmladefinition using btree (id);Create index FK3CA3B7D4A8BF376D on jiolapclientconnection using btree (id);Create index FKF034DCCF8F542247 on jiolapunit using btree (olapClientConnection);Create index FKF034DCCFA8BF376D on jiolapunit using btree (id);Create index FKCBCB0EC92B329A97 on jiquery using btree (dataSource);Create index FKCBCB0EC9A8BF376D on jiquery using btree (id);Create index FK156F5F6AE4D73E35 on jireportjob using btree (mail_notification);Create index FK156F5F6A9EEC902C on jireportjob using btree (content_destination);Create index FK156F5F6A74D2696E on jireportjob using btree (job_trigger);Create index FKC374C7D0D2B2EB53 on jireportjobcalendartrigger using btree (id);Create index FKBB6DB6D880001AAE on jireportjobmailrecipient using btree (destination_id);Create index FKB42A5CE2C3389A8 on jireportjoboutputformat using btree (report_job_id);Create index FKEAC52B5F2EC643D on jireportjobparameter using btree (job_id);Create index FKB9337C5CD2B2EB53 on jireportjobsimpletrigger using btree (id);Create index FK98818B778FDA11CC on jireportunit using btree (query);Create index FK98818B77324CFECB on jireportunit using btree (reportDataSource);Create index FK98818B778C8DF21B on jireportunit using btree (mainReport);Create index FK98818B77A8BF376D on jireportunit using btree (id);Create index FK5FBE934AE7922149 on jireportunitinputcontrol using btree (input_control_id);Create index FK5FBE934AA6A48880 on jireportunitinputcontrol using btree (report_unit_id);Create index FK8B1C4CA5865B10DA on jireportunitresource using btree (resource_id);Create index FK8B1C4CA5A6A48880 on jireportunitresource using btree (report_unit_id);Create index FKE7338B19E7C5A6 on jirepositorycache using btree (item_reference);Create index FKD444826DA08E2155 on jiresource using btree (parent_folder);Create index FKD444826DA58002DF on jiresource using btree (childrenFolder);Create index FK7F24453BA08E2155 on jiresourcefolder using btree (parent_folder);Create index FKD8B5C14091865AF on jiuserrole using btree (userId);Create index FKD8B5C1403C31045 on jiuserrole using btree (roleId);Create index FK94C688A71D51BFAD on jixmlaconnection using btree (id);Alter table jicustomdatasourceproperty add Foreign Key (ds_id) references jicustomdatasource (id) on delete restrict on update restrict;Alter table jiinputcontrol add Foreign Key (data_type) references jidatatype (id) on delete restrict on update restrict;Alter table jifileresource add Foreign Key (reference) references jifileresource (id) on delete restrict on update restrict;Alter table jimondrianconnection add Foreign Key (mondrianSchema) references jifileresource (id) on delete restrict on update restrict;Alter table jireportunit add Foreign Key (mainReport) references jifileresource (id) on delete restrict on update restrict;Alter table jireportunitresource add Foreign Key (resource_id) references jifileresource (id) on delete restrict on update restrict;Alter table jiinputcontrolquerycolumn add Foreign Key (input_control_id) references jiinputcontrol (id) on delete restrict on update restrict;Alter table jireportunitinputcontrol add Foreign Key (input_control_id) references jiinputcontrol (id) on delete restrict on update restrict;Alter table jiinputcontrol add Foreign Key (list_of_values) references jilistofvalues (id) on delete restrict on update restrict;Alter table jilistofvaluesitem add Foreign Key (id) references jilistofvalues (id) on delete restrict on update restrict;Alter table jimondrianxmladefinition add Foreign Key (mondrianConnection) references jimondrianconnection (id) on delete restrict on update restrict;Alter table jimondrianconnection add Foreign Key (id) references jiolapclientconnection (id) on delete restrict on update restrict;Alter table jiolapunit add Foreign Key (olapClientConnection) references jiolapclientconnection (id) on delete restrict on update restrict;Alter table jixmlaconnection add Foreign Key (id) references jiolapclientconnection (id) on delete restrict on update restrict;Alter table jiinputcontrol add Foreign Key (list_query) references jiquery (id) on delete restrict on update restrict;Alter table jireportunit add Foreign Key (query) references jiquery (id) on delete restrict on update restrict;Alter table jireportjoboutputformat add Foreign Key (report_job_id) references jireportjob (id) on delete restrict on update restrict;Alter table jireportjobparameter add Foreign Key (job_id) references jireportjob (id) on delete restrict on update restrict;Alter table jireportjob add Foreign Key (mail_notification) references jireportjobmail (id) on delete restrict on update restrict;Alter table jireportjobmailrecipient add Foreign Key (destination_id) references jireportjobmail (id) on delete restrict on update restrict;Alter table jireportjob add Foreign Key (content_destination) references jireportjobrepodest (id) on delete restrict on update restrict;Alter table jireportjob add Foreign Key (job_trigger) references jireportjobtrigger (id) on delete restrict on update restrict;Alter table jireportjobcalendartrigger add Foreign Key (id) references jireportjobtrigger (id) on delete restrict on update restrict;Alter table jireportjobsimpletrigger add Foreign Key (id) references jireportjobtrigger (id) on delete restrict on update restrict;Alter table jireportunitinputcontrol add Foreign Key (report_unit_id) references jireportunit (id) on delete restrict on update restrict;Alter table jireportunitresource add Foreign Key (report_unit_id) references jireportunit (id) on delete restrict on update restrict;Alter table jirepositorycache add Foreign Key (item_reference) references jirepositorycache (id) on delete restrict on update restrict;Alter table jibeandatasource add Foreign Key (id) references jiresource (id) on delete restrict on update restrict;Alter table jicontentresource add Foreign Key (id) references jiresource (id) on delete restrict on update restrict;Alter table jicustomdatasource add Foreign Key (id) references jiresource (id) on delete restrict on update restrict;Alter table jidatatype add Foreign Key (id) references jiresource (id) on delete restrict on update restrict;Alter table jifileresource add Foreign Key (id) references jiresource (id) on delete restrict on update restrict;Alter table jiinputcontrol add Foreign Key (id) references jiresource (id) on delete restrict on update restrict;Alter table jijdbcdatasource add Foreign Key (id) references jiresource (id) on delete restrict on update restrict;Alter table jijndijdbcdatasource add Foreign Key (id) references jiresource (id) on delete restrict on update restrict;Alter table jilistofvalues add Foreign Key (id) references jiresource (id) on delete restrict on update restrict;Alter table jimondrianconnection add Foreign Key (reportDataSource) references jiresource (id) on delete restrict on update restrict;Alter table jimondrianxmladefinition add Foreign Key (id) references jiresource (id) on delete restrict on update restrict;Alter table jiolapclientconnection add Foreign Key (id) references jiresource (id) on delete restrict on update restrict;Alter table jiolapunit add Foreign Key (id) references jiresource (id) on delete restrict on update restrict;Alter table jiquery add Foreign Key (dataSource) references jiresource (id) on delete restrict on update restrict;Alter table jiquery add Foreign Key (id) references jiresource (id) on delete restrict on update restrict;Alter table jireportunit add Foreign Key (reportDataSource) references jiresource (id) on delete restrict on update restrict;Alter table jireportunit add Foreign Key (id) references jiresource (id) on delete restrict on update restrict;Alter table jiresource add Foreign Key (parent_folder) references jiresourcefolder (id) on delete restrict on update restrict;Alter table jiresource add Foreign Key (childrenFolder) references jiresourcefolder (id) on delete restrict on update restrict;Alter table jiresourcefolder add Foreign Key (parent_folder) references jiresourcefolder (id) on delete restrict on update restrict;Alter table jiuserrole add Foreign Key (roleId) references jirole (id) on delete restrict on update restrict;Alter table jiuserrole add Foreign Key (userId) references jiuser (id) on delete restrict on update restrict; create sequence hibernate_sequence; INSERT INTO JIRole (id, rolename,externallyDefined) VALUES (nextval('hibernate_sequence'), 'ROLE_USER',FALSE);INSERT INTO JIRole (id, rolename,externallyDefined) VALUES (nextval('hibernate_sequence'), 'ROLE_ADMINISTRATOR',FALSE);INSERT INTO JIRole (id, rolename,externallyDefined) VALUES (nextval('hibernate_sequence'), 'ROLE_ANONYMOUS',FALSE);INSERT INTO JIUser (id, username,fullname,emailAddress,password,externallyDefined,enabled) VALUES (nextval('hibernate_sequence'), 'anonymousUser','Anonymous User',NULL,'',FALSE,TRUE); INSERT INTO JIUserRole (userId,roleId) select u.id, r.id from JIUser u, JIRole r where u.username = 'anonymousUser' and r.roleName = 'ROLE_ANONYMOUS';INSERT INTO JIUser (id, username,fullname,emailAddress,password,externallyDefined,enabled) VALUES (nextval('hibernate_sequence'), 'jasperadmin','Jasper Administrator',NULL,'newPassword',FALSE,TRUE);INSERT INTO JIUserRole (userId,roleId)select u.id, r.id from JIUser u, JIRole r where u.username = 'jasperadmin' and r.roleName = 'ROLE_ADMINISTRATOR';INSERT INTO JIUserRole (userId,roleId)select u.id, r.id from JIUser u, JIRole r where u.username = 'jasperadmin' and r.roleName = 'ROLE_USER';INSERT INTO JIResourceFolder (id,version,uri,hidden,name,label,description,parent_folder,creation_date) VALUES (nextval('hibernate_sequence') ,0,'/',FALSE,'/','root','Root of the folder hierarchy',NULL,CURRENT_TIMESTAMP);INSERT INTO JIObjectPermission (id, uri,recipientobjectclass,permissionMask,recipientobjectid)select nextval('hibernate_sequence'), 'repo:/','com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoRole', 1, r.idfrom JIRole r where rolename = 'ROLE_ADMINISTRATOR';INSERT INTO JIObjectPermission (id, uri,recipientobjectclass,permissionMask,recipientobjectid)select nextval('hibernate_sequence'), 'repo:/','com.jaspersoft.jasperserver.api.metadata.user.domain.impl.hibernate.RepoRole', 2, r.idfrom JIRole r where rolename = 'ROLE_USER';

Hi I would like to use Postgre database for Jasperserver instead of MYSQL. I converted the full MYSQL database to Postgre and it looks like same as the MYSql. I have modified the context.xml in the META-INF directory. It looks like the Jasperserver could not start...

Hi The computername should not have "_" character under IE.

Hi I have installed and configured Jasperserver 3.1. If I run the report from localhost:8080 works fine. (http://localhost:8080/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=/reports/ZsoltReport/evtlog_par&standAlone=true&ParentFolderUri=/reports/ZsoltReport) When I try to run cumputername:8080 .. does not work. (http://zskuzman:8080/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=/reports/ZsoltReport/evtlog_par&standAlone=true&ParentFolderUri=/reports/ZsoltReport)I have this only in IE. Error Message: Unable to complete request: your conversation may have ended, expired, or was otherwise invalidated. org.springframework.webflow.conversation.NoSuchConversationException: No conversation could be found with id '469F5503-5705-E3F2-61C9-EA9977C56661' -- perhaps this conversation has ended?org.springframework.webflow.conversation.NoSuchConversationException: No conversation could be found with id '46

Hi I have installed and configured Jasperserver 3.1. If I run the report from localhost:8080 works fine. (http://localhost:8080/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=/reports/ZsoltReport/evtlog_par&standAlone=true&ParentFolderUri=/reports/ZsoltReport) When I try to run cumputername:8080 .. does not work. (http://zskuzman:8080/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=/reports/ZsoltReport/evtlog_par&standAlone=true&ParentFolderUri=/reports/ZsoltReport)I have this only in IE. Error Message: Unable to complete request: your conversation may have ended, expired, or was otherwise invalidated. org.springframework.webflow.conversation.NoSuchConversationException: No conversation could be found with id '469F5503-5705-E3F2-61C9-EA9977C56661' -- perhaps this conversation has ended?org.springframework.webflow.conversation.NoSuchConversationException: No conversation could be found with id '46

Hi I have installed and configured Jasperserver 3.1. If I run the report from localhost:8080 works fine. (http://localhost:8080/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=/reports/ZsoltReport/evtlog_par&standAlone=true&ParentFolderUri=/reports/ZsoltReport) When I try to run cumputername:8080 .. does not work. (http://d_zskuzman:8080/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=/reports/ZsoltReport/evtlog_par&standAlone=true&ParentFolderUri=/reports/ZsoltReport)I have this only in IE. Error Message: Unable to complete request: your conversation may have ended, expired, or was otherwise invalidated. org.springframework.webflow.conversation.NoSuchConversationException: No conversation could be found with id '469F5503-5705-E3F2-61C9-EA9977C56661' -- perhaps this conversation has ended?org.springframework.webflow.conversation.NoSuchConversationException: No conversation could be found with id '46 Post Edited by Kuzman Zsolt at 03/10/09 15:15 Post Edited by Kuzman Zsolt at 03/11/09 12:23