thomas.frommelt

Use User: jasperadmin and Password: jasperadmin I don't no why but only this user works.

Use User: jasperadmin and Password: jasperadmin I don't no why but only this user works.

sorry but it doesn't work for me. My String: This is a report without any Parameters "jasper-srv:8080/jasperserver/rest_v2/reports/Bericht/VertriebAllgemein/Auftragseingang?j_username=thomas.frommelt&j_password=xxxxx" Jasperserver says: "The specified page was not found."

thanks for your answer. But the link doesn't work. Error "The specified page was not found.". We have the community version 6.0.1.

Is there any way to execute the report on jasperserver with paramaters through single url ? I am able to open the report but execution of the report don't start. http://jaspersrv:8080/jasperserver/flow.html?_flowId=viewReportFlow&standAlone=true&_flowId=viewReportFlow&ParentFolderUri=%2FBericht%2FVertriebAllgemein&reportUnit=%2FBericht%2FVertriebAllgemein%2FKundenmuster&P_KundenmusterKunde=Test Do I need to pass some more parameters ? Or some other way is there ?

Hello, after upgrading i get this error if i open a report: 2015-02-26 06:59:53,673 ERROR SystemErrorController,http-apr-8080-exec-7:81 - Internal server errororg.springframework.web.util.NestedServletException: Handler processing failed; nested exception is java.lang.NoClassDefFoundError: net/sf/jasperreports/extensions/ExtensionsRegistryFactoryat org.springframework.web.servlet.DispatcherServlet.triggerAfterCompletionWithError(DispatcherServlet.java:1260)at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:939)at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:851)at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:953)at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:844)at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:829)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:163)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)at com.jaspersoft.jasperserver.api.security.IPadSupportFilter.doFilter(IPadSupportFilter.java:67)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)at com.jaspersoft.jasperserver.war.common.JSSwitchUserProcessingFilter.doFilter(JSSwitchUserProcessingFilter.java:157)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:143)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:99)at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:210)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)at com.jaspersoft.jasperserver.war.NullFilter.doFilter(NullFilter.java:43)at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:210)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)at com.jaspersoft.jasperserver.api.security.JSCsrfGuardFilter.doFilter(JSCsrfGuardFilter.java:83)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)at com.jaspersoft.jasperserver.api.security.WebAppSecurityFilter.doFilter(WebAppSecurityFilter.java:80)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)at com.jaspersoft.jasperserver.war.MultipartRequestWrapperFilter.doFilter(MultipartRequestWrapperFilter.java:95)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)at com.jaspersoft.jasperserver.war.NullFilter.doFilter(NullFilter.java:43)at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)at com.jaspersoft.jasperserver.api.security.encryption.EncryptionFilter.doFilter(EncryptionFilter.java:150)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)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:63)at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)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:343)at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)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.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1852)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.NoClassDefFoundError: net/sf/jasperreports/extensions/ExtensionsRegistryFactoryat java.lang.ClassLoader.defineClass1(Native Method)at java.lang.ClassLoader.defineClass(ClassLoader.java:792)at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)at java.net.URLClassLoader.defineClass(URLClassLoader.java:449)at java.net.URLClassLoader.access$100(URLClassLoader.java:71)at java.net.URLClassLoader$1.run(URLClassLoader.java:361)at java.net.URLClassLoader$1.run(URLClassLoader.java:355)at java.security.AccessController.doPrivileged(Native Method)at java.net.URLClassLoader.findClass(URLClassLoader.java:354)at java.lang.ClassLoader.loadClass(ClassLoader.java:424)at java.lang.ClassLoader.loadClass(ClassLoader.java:357)at java.lang.Class.forName0(Native Method)at java.lang.Class.forName(Class.java:270)at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1701)at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1559)at java.lang.Class.forName0(Native Method)at java.lang.Class.forName(Class.java:270)at net.sf.jasperreports.engine.util.JRClassLoader.loadClassForRealName(JRClassLoader.java:157)at net.sf.jasperreports.engine.util.JRClassLoader.loadClassForName(JRClassLoader.java:115)at net.sf.jasperreports.engine.util.ClassUtils.instantiateClass(ClassUtils.java:53)at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.instantiateRegistry(DefaultExtensionsRegistry.java:237)at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.loadRegistries(DefaultExtensionsRegistry.java:214)at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.loadRegistries(DefaultExtensionsRegistry.java:162)at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.getRegistries(DefaultExtensionsRegistry.java:133)at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.getExtensions(DefaultExtensionsRegistry.java:105)at net.sf.jasperreports.engine.DefaultJasperReportsContext.getExtensions(DefaultJasperReportsContext.java:246)at net.sf.jasperreports.engine.SimpleJasperReportsContext.getExtensions(SimpleJasperReportsContext.java:134)at com.jaspersoft.jasperserver.war.action.ReportExecutionController.getRequirejsConfig(ReportExecutionController.java:440)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at java.lang.reflect.Method.invoke(Method.java:606)at org.springframework.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java:471)at org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java:408)at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:919)... 96 moreCaused by: java.lang.ClassNotFoundException: net.sf.jasperreports.extensions.ExtensionsRegistryFactoryat java.net.URLClassLoader$1.run(URLClassLoader.java:366)at java.net.URLClassLoader$1.run(URLClassLoader.java:355)at java.security.AccessController.doPrivileged(Native Method)at java.net.URLClassLoader.findClass(URLClassLoader.java:354)at java.lang.ClassLoader.loadClass(ClassLoader.java:424)at java.lang.ClassLoader.loadClass(ClassLoader.java:357)... 133 more

Thanks a lot for your help. I think thats a bug.

I have tryed both. But with the Calender control i get only time without seconds.

Thanks for your answer.Yes i have tested it with "00" for the time value?

Hello, thanks for your answers. But i have still the problems. I think my jasperser_config_de.properties are correct. My Login: # Used for parsing and formatting dates by serverdate.format=dd.MM.yyyydatetime.format=dd.MM.yyyy HH:mm:sstime.format=HH:mm:ss # Used for parsing and formatting dates by calendar component (UI).# Pattern for date should match appropriated pattern from server properties.# The format for calendar component can be combinations of the following:# d - day of month (no leading zero)# dd - day of month (two digit)# o - day of year (no leading zeros)# oo - day of year (three digit)# D - day name short# DD - day name long# m - month of year (no leading zero)# mm - month of year (two digit)# M - month name short# MM - month name long# y - year (two digit)# yy - year (four digit)calendar.date.format=dd.mm.yycalendar.datetime.format=dd.mm.yyyy HH:mm:sscalendar.time.format=HH:mm:ss# Current calendar component supports only patterns with time after date ("hh:mm M dd, yy" will not work)# The datetime component is configured by calendar.date.format and calendar.time.formatcalendar.datetime.separator=u0020 # Additional validation of dates in AdHoc filter and other parts of UIvalidation.date.pattern=/^\d{2}.\d{2}.\d{4}$/validation.datetime.pattern=/^\d{2}.\d{2}.\d{4}\s\d{2}:\d{2}:\d{2}$/validation.time.pattern=/^\d{2}:\d{2}:\d{2}$/ report.scheduling.output.format.1=pdfreport.scheduling.output.format.2=htmlreport.scheduling.output.format.3=xlsreport.scheduling.output.format.4=rtfreport.scheduling.output.format.5=csvreport.scheduling.output.format.6=odtreport.scheduling.output.format.7=txtreport.scheduling.output.format.8=docxreport.scheduling.output.format.9=odsreport.scheduling.output.format.10=xlsx # The substitution value being used in password input forms avoiding the real password appears in HTMLinput.password.substitution=~Wertersetzung~

Hi, i have Problems to schedule a job in the new Version 5.6.0. Any date in the Date Field, jasper throws an error. In Version 5.5 everything works fine. Can anyone help me?

Hello, is it possible to add a excel commtary in Jasperreports and export it to Excel? Thanks.

Hello, since we have jasperserver upgraded to Version 5.6 we have the problem that wen can't export Excel Files, becouse IE rename File like "_UTF-8_Q-AU=C3xxx.xls_". So i must rename the excel export to open it. Why does Jaspersoft do that. In compatibility modus i can't click anything! Thanks

i have found the problem. it's the intranet compatibility view! You should deselct it in the compatibility dialog of the ie.

Hello, we have the problem too with a complete new installation. Ui wouldn't work with IE11.

I have the same problem. iReport 5.5.1 and jasper community server 5.0.0. Can't connect to repository. What happend?

Hello all, i would like to export a Report to an Excel file with formula. The formula in the <propertyExpression name="net.sf.jasperreports.export.xls.formula"> Tag is "WENN(I2-L2=0,0,WENN(NETTOARBEITSTAGE($I2,$L2,Feiertage!B$1:B$14)<0,1,2))" The excel file cannot be opened. Becouse of the "<" less sign. If i type instead a "=" it works. So how can i get the formula working? Thanks

Thanks ajinkya!

how can i do this. Can you give me an example? Many thanks

Thanks for your answer. Unfortunately this didn't work. The value of the subreport_count is always 0. I think the "print when expression" of the group, was evaluatet befor the sub report starts. Do you habe any other idear.

Hello, in my report i have an sub report in a group. If this sub report ist empty, my group (where the subreport is in) in the main report should not printed on the report. Becouse i would like to avoid empty space on the report. How can i do this? Thanks

Has no one an idear?

Has no one an idear?

Hello, after running js-upgrade-samedb-ce.bat i get the following error. Why? ---------------------------------------------------------------------- Running JasperReports Server upgrade script at 2013-01-21_09-25 ---------------------------------------------------------------------- WARNING: JAVA_HOME environment variable not found [default] Running upgrade-minimal-ce Ant task ---------------------------------------------------------------------- Buildfile: C:tmpjasperreports-server-cp-5.0.0-binbuildomaticbuild.xml [echo] Filtering properties (cleaning out blank spaces) [echo] creating C:/tmp/jasperreports-server-cp-5.0.0-bin/buildomatic/build_conf/default [delete] Deleting directory C:tmpjasperreports-server-cp-5.0.0-binbuildomaticbuild_confdefault [mkdir] Created dir: C:tmpjasperreports-server-cp-5.0.0-binbuildomaticbuild_confdefault [copy] Copying 1 file to C:tmpjasperreports-server-cp-5.0.0-binbuildomaticbuild_confdefault [copy] Copying 1 file to C:tmpjasperreports-server-cp-5.0.0-binbuildomaticbuild_confdefault [copy] Copying 1 file to C:tmpjasperreports-server-cp-5.0.0-binbuildomaticbuild_confdefault [copy] Copying 1 file to C:tmpjasperreports-server-cp-5.0.0-binbuildomaticbuild_confdefault [copy] Copying 1 file to C:tmpjasperreports-server-cp-5.0.0-binbuildomaticbuild_confdefault [copy] Copying 29 files to C:tmpjasperreports-server-cp-5.0.0-binbuildomaticbuild_confdefault [copy] Copying 1 file to C:tmpjasperreports-server-cp-5.0.0-binbuildomaticbuild_confdefaultwebappWEB-INF [echo] chkIfPackageManagedTomcat: check if package managed tomcat [echo] using settings file: C:/tmp/jasperreports-server-cp-5.0.0-bin/buildomatic/build_conf/default/maven_settings.xml set-minimal-mode: gen-config: [echo] Regen config files if they have already been cleaned: [echo] currentConf= C:/tmp/jasperreports-server-cp-5.0.0-bin/buildomatic/build_conf/default test-ce-all-props: [echo] Checking properties: [echo] appServerType=tomcat6 [echo] appServerDir=C:Program Filesjasperreports-server-cp-4.2.1apache-tomcat [echo] dbType=postgresql [echo] dbHost=localhost [echo] dbUsername=postgres [echo] dbPassword=********** [echo] dbPort=5432 [echo] js.dbName=jasperserver [echo] sugarcrm.dbName=sugarcrm [echo] foodmart.dbName=foodmart [echo] webAppNameCE=jasperserver check-dbtype-for-upgrade-ce: do-install-upgrade-test: [echo] Checking DBMS host and port: [echo] About to validate host: localhost [echo] Host localhost is OK [echo] Done validating host: localhost [echo] About to validate port: localhost:5432 [echo] Port 5432 is OK [echo] Done validating port: localhost:5432 [echo] Validating administrative database connection at jdbc:postgresql://localhost:5432/postgres. Phase: [test] [echo] For JDBC driver the artifactId and version properties are set: [echo] maven.jdbc.artifactId=postgresql [echo] maven.jdbc.version=9.0-801.jdbc4 [echo] Specified JDBC driver jar exists [advanced-sql] Executing commands [advanced-sql] 1 of 1 SQL statements executed successfully [echo] Connection OK [echo] Validating JasperServer database connection at jdbc:postgresql://localhost:5432/jasperserver. Phase: [test] [echo] For JDBC driver the artifactId and version properties are set: [echo] maven.jdbc.artifactId=postgresql [echo] maven.jdbc.version=9.0-801.jdbc4 [echo] Specified JDBC driver jar exists [advanced-sql] Executing commands [advanced-sql] 1 of 1 SQL statements executed successfully [echo] Connection OK do-pre-upgrade-test: pre-upgrade-test-ce: upgrade-js-ce-db-minimal: upgrade-4.7-5.0-ce: [echo] [echo] currentSqlDir = C:/tmp/jasperreports-server-cp-5.0.0-bin/buildomatic/install_resources/sql/postgresql [echo] dbType = postgresql [echo] [echo] run script: C:/tmp/jasperreports-server-cp-5.0.0-bin/buildomatic/install_resources/sql/postgresql/upgrade-postgresql-4.7.0-5.0.0-ce.sql [echo] For JDBC driver the artifactId and version properties are set: [echo] maven.jdbc.artifactId=postgresql [echo] maven.jdbc.version=9.0-801.jdbc4 [echo] Specified JDBC driver jar exists [advanced-sql] Executing resource: C:tmpjasperreports-server-cp-5.0.0-binbuildomaticinstall_resourcessqlpostgresqlupgrade-postgresql-4.7.0-5.0.0-ce.sql [advanced-sql] 0 rows affected [advanced-sql] 0 rows affected [advanced-sql] 0 rows affected [advanced-sql] 0 rows affected [advanced-sql] 0 rows affected [advanced-sql] 5 of 5 SQL statements executed successfully import-minimal-for-upgrade-ce: [echo] [echo] Property values (in install.xml): [echo] archiveArg = --input-zip=C:/tmp/jasperreports-server-cp-5.0.0-bin/buildomatic/install_resources/export/js-catalog-minimal-ce.zip [echo] dbType = postgresql [echo] jdbcJar = postgresql-9.0-801.jdbc4.jar [echo] currentConf = C:/tmp/jasperreports-server-cp-5.0.0-bin/buildomatic/build_conf/default [echo] importExportConfig = C:/tmp/jasperreports-server-cp-5.0.0-bin/buildomatic/conf_source/ieCe [echo] [echo] Validating JasperServer database connection at jdbc:postgresql://localhost:5432/jasperserver. Phase: [import-export-test] [echo] For JDBC driver the artifactId and version properties are set: [echo] maven.jdbc.artifactId=postgresql [echo] maven.jdbc.version=9.0-801.jdbc4 [echo] Specified JDBC driver jar exists [advanced-sql] Executing commands [advanced-sql] 1 of 1 SQL statements executed successfully [echo] Connection OK [java] First resource path:C:tmpjasperreports-server-cp-5.0.0-binbuildomaticconf_sourceieCeapplicationContext-cascade.xml [java] Started to load resources [java] Resource name: applicationContext.xml [java] Resource name: applicationContext-cascade.xml [java] Resource name: applicationContext-data-snapshots.xml [java] Resource name: applicationContext-events-logging.xml [java] Resource name: applicationContext-export-config.xml [java] Resource name: applicationContext-export-import.xml [java] Resource name: applicationContext-logging.xml [java] Resource name: applicationContext-olap-connection.xml [java] Resource name: applicationContext-report-scheduling.xml [java] Resource name: applicationContext-search.xml [java] Resource name: applicationContext-security.xml [java] Resource name: applicationContext-themes.xml [java] Resource name: applicationContext-virtual-data-source.xml [java] Creating ActionModelService object. [java] Creating action model infrastructure. [java] Updated tenant organizations [java] Role ROLE_ADMINISTRATOR already exists, skipping. [java] Role ROLE_USER already exists, skipping. [java] Role ROLE_ANONYMOUS already exists, skipping. [java] User jasperadmin already exists, skipping. [java] User anonymousUser already exists, skipping. [java] Updating folder / [java] Updating folder /themes [java] Updating folder /themes/default [java] Updating folder /themes/pods_summer [java] Updating folder /themes/default/images [java] Updating folder /themes/pods_summer/images [java] FEHLER: Spalte this_.resourcetype existiert nicht [java] Position: 222 [java] com.jaspersoft.jasperserver.api.JSExceptionWrapper: could not execute query; SQL [select this_.id as id3_0_, this_.version as version3_0_, this_.name as name3_0_, this_.parent_folder as parent4_3_0_, this_.childrenFolder as children5_3_0_, this_.label as label3_0_, this_.description as descript7_3_0_, this_.resourceType as resource8_3_0_, this_.creation_date as creation9_3_0_, this_.update_date as update10_3_0_, this_1_.catalog as catalog23_0_, this_1_.mondrianConnection as mondrian3_23_0_, this_2_.type as type28_0_, this_2_.mandatory as mandatory28_0_, this_2_.readOnly as readOnly28_0_, this_2_.visible as visible28_0_, this_2_.data_type as data6_28_0_, this_2_.list_of_values as list7_28_0_, this_2_.list_query as list8_28_0_, this_2_.query_value_column as query9_28_0_, this_2_.defaultValue as default10_28_0_, this_3_.serviceClass as serviceC2_30_0_, this_4_.olapClientConnection as olapClie2_32_0_, this_4_.mdx_query as mdx3_32_0_, this_4_.view_options as view4_32_0_, this_5_.dataSource as dataSource33_0_, this_5_.query_language as query3_33_0_, this_5_.sql_query as sql4_33_0_, this_6_.beanName as beanName34_0_, this_6_.beanMethod as beanMethod34_0_, this_7_.driver as driver35_0_, this_7_.password as password35_0_, this_7_.connectionUrl as connecti4_35_0_, this_7_.username as username35_0_, this_7_.timezone as timezone35_0_, this_8_.type as type36_0_, this_8_.maxLength as maxLength36_0_, this_8_.decimals as decimals36_0_, this_8_.regularExpr as regularE5_36_0_, this_8_.minValue as minValue36_0_, this_8_.max_value as max7_36_0_, this_8_.strictMin as strictMin36_0_, this_8_.strictMax as strictMax36_0_, this_9_.reportDataSource as reportDa2_37_0_, this_9_.query as query37_0_, this_9_.mainReport as mainReport37_0_, this_9_.controlrenderer as controlr5_37_0_, this_9_.reportrenderer as reportre6_37_0_, this_9_.promptcontrols as promptco7_37_0_, this_9_.controlslayout as controls8_37_0_, this_9_.data_snapshot_id as data9_37_0_, this_10_.file_type as file3_40_0_, this_12_.jndiName as jndiName43_0_, this_12_.timezone as timezone43_0_, this_13_.data as data1_0_, this_13_.file_type as file3_1_0_, this_13_.reference as reference1_0_, this_14_.timezone as timezone44_0_, this_16_.reportDataSource as reportDa2_47_0_, this_16_.mondrianSchema as mondrian3_47_0_, this_17_.catalog as catalog48_0_, this_17_.username as username48_0_, this_17_.password as password48_0_, this_17_.datasource as datasource48_0_, this_17_.uri as uri48_0_, case when this_16_.id is not null then 16 when this_17_.id is not null then 17 when this_1_.id is not null then 1 when this_2_.id is not null then 2 when this_3_.id is not null then 3 when this_4_.id is not null then 4 when this_5_.id is not null then 5 when this_6_.id is not null then 6 when this_7_.id is not null then 7 when this_8_.id is not null then 8 when this_9_.id is not null then 9 when this_10_.id is not null then 10 when this_11_.id is not null then 11 when this_12_.id is not null then 12 when this_13_.id is not null then 13 when this_14_.id is not null then 14 when this_15_.id is not null then 15 when this_.id is not null then 0 end as clazz_0_ from JIResource this_ left outer join JIMondrianXMLADefinition this_1_ on this_.id=this_1_.id left outer join JIInputControl this_2_ on this_.id=this_2_.id left outer join JICustomDatasource this_3_ on this_.id=this_3_.id left outer join JIOlapUnit this_4_ on this_.id=this_4_.id left outer join JIQuery this_5_ on this_.id=this_5_.id left outer join JIBeanDatasource this_6_ on this_.id=this_6_.id left outer join JIJdbcDatasource this_7_ on this_.id=this_7_.id left outer join JIDataType this_8_ on this_.id=this_8_.id left outer join JIReportUnit this_9_ on this_.id=this_9_.id left outer join JIContentResource this_10_ on this_.id=this_10_.id left outer join JIListOfValues this_11_ on this_.id=this_11_.id left outer join JIJNDIJdbcDatasource this_12_ on this_.id=this_12_.id left outer join JIFileResource this_13_ on this_.id=this_13_.id left outer join JIVirtualDatasource this_14_ on this_.id=this_14_.id left outer join JIOlapClientConnection this_15_ on this_.id=this_15_.id left outer join JIMondrianConnection this_16_ on this_.id=this_16_.id left outer join JIXMLAConnection this_17_ on this_.id=this_17_.id where (this_.name=? and this_.parent_folder=?)]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query [java] com.jaspersoft.jasperserver.api.JSExceptionWrapper: org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select this_.id as id3_0_, this_.version as version3_0_, this_.name as name3_0_, this_.parent_folder as parent4_3_0_, this_.childrenFolder as children5_3_0_, this_.label as label3_0_, this_.description as descript7_3_0_, this_.resourceType as resource8_3_0_, this_.creation_date as creation9_3_0_, this_.update_date as update10_3_0_, this_1_.catalog as catalog23_0_, this_1_.mondrianConnection as mondrian3_23_0_, this_2_.type as type28_0_, this_2_.mandatory as mandatory28_0_, this_2_.readOnly as readOnly28_0_, this_2_.visible as visible28_0_, this_2_.data_type as data6_28_0_, this_2_.list_of_values as list7_28_0_, this_2_.list_query as list8_28_0_, this_2_.query_value_column as query9_28_0_, this_2_.defaultValue as default10_28_0_, this_3_.serviceClass as serviceC2_30_0_, this_4_.olapClientConnection as olapClie2_32_0_, this_4_.mdx_query as mdx3_32_0_, this_4_.view_options as view4_32_0_, this_5_.dataSource as dataSource33_0_, this_5_.query_language as query3_33_0_, this_5_.sql_query as sql4_33_0_, this_6_.beanName as beanName34_0_, this_6_.beanMethod as beanMethod34_0_, this_7_.driver as driver35_0_, this_7_.password as password35_0_, this_7_.connectionUrl as connecti4_35_0_, this_7_.username as username35_0_, this_7_.timezone as timezone35_0_, this_8_.type as type36_0_, this_8_.maxLength as maxLength36_0_, this_8_.decimals as decimals36_0_, this_8_.regularExpr as regularE5_36_0_, this_8_.minValue as minValue36_0_, this_8_.max_value as max7_36_0_, this_8_.strictMin as strictMin36_0_, this_8_.strictMax as strictMax36_0_, this_9_.reportDataSource as reportDa2_37_0_, this_9_.query as query37_0_, this_9_.mainReport as mainReport37_0_, this_9_.controlrenderer as controlr5_37_0_, this_9_.reportrenderer as reportre6_37_0_, this_9_.promptcontrols as promptco7_37_0_, this_9_.controlslayout as controls8_37_0_, this_9_.data_snapshot_id as data9_37_0_, this_10_.file_type as file3_40_0_, this_12_.jndiName as jndiName43_0_, this_12_.timezone as timezone43_0_, this_13_.data as data1_0_, this_13_.file_type as file3_1_0_, this_13_.reference as reference1_0_, this_14_.timezone as timezone44_0_, this_16_.reportDataSource as reportDa2_47_0_, this_16_.mondrianSchema as mondrian3_47_0_, this_17_.catalog as catalog48_0_, this_17_.username as username48_0_, this_17_.password as password48_0_, this_17_.datasource as datasource48_0_, this_17_.uri as uri48_0_, case when this_16_.id is not null then 16 when this_17_.id is not null then 17 when this_1_.id is not null then 1 when this_2_.id is not null then 2 when this_3_.id is not null then 3 when this_4_.id is not null then 4 when this_5_.id is not null then 5 when this_6_.id is not null then 6 when this_7_.id is not null then 7 when this_8_.id is not null then 8 when this_9_.id is not null then 9 when this_10_.id is not null then 10 when this_11_.id is not null then 11 when this_12_.id is not null then 12 when this_13_.id is not null then 13 when this_14_.id is not null then 14 when this_15_.id is not null then 15 when this_.id is not null then 0 end as clazz_0_ from JIResource this_ left outer join JIMondrianXMLADefinition this_1_ on this_.id=this_1_.id left outer join JIInputControl this_2_ on this_.id=this_2_.id left outer join JICustomDatasource this_3_ on this_.id=this_3_.id left outer join JIOlapUnit this_4_ on this_.id=this_4_.id left outer join JIQuery this_5_ on this_.id=this_5_.id left outer join JIBeanDatasource this_6_ on this_.id=this_6_.id left outer join JIJdbcDatasource this_7_ on this_.id=this_7_.id left outer join JIDataType this_8_ on this_.id=this_8_.id left outer join JIReportUnit this_9_ on this_.id=this_9_.id left outer join JIContentResource this_10_ on this_.id=this_10_.id left outer join JIListOfValues this_11_ on this_.id=this_11_.id left outer join JIJNDIJdbcDatasource this_12_ on this_.id=this_12_.id left outer join JIFileResource this_13_ on this_.id=this_13_.id left outer join JIVirtualDatasource this_14_ on this_.id=this_14_.id left outer join JIOlapClientConnection this_15_ on this_.id=this_15_.id left outer join JIMondrianConnection this_16_ on this_.id=this_16_.id left outer join JIXMLAConnection this_17_ on this_.id=this_17_.id where (this_.name=? and this_.parent_folder=?)]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query [java] at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:633) [java] at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412) [java] at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411) [java] at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374) [java] at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1046) [java] at org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1039) [java] at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.findByName(HibernateRepositoryServiceImpl.java:1012) [java] at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.findByURI(HibernateRepositoryServiceImpl.java:988) [java] at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.loadResource(HibernateRepositoryServiceImpl.java:294) [java] at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.loadResource(HibernateRepositoryServiceImpl.java:287) [java] at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl$1.execute(HibernateRepositoryServiceImpl.java:191) [java] at com.jaspersoft.jasperserver.api.metadata.common.service.impl.HibernateDaoImpl.executeCallback(HibernateDaoImpl.java:55) [java] at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.getResourceUnsecure(HibernateRepositoryServiceImpl.java:189) [java] at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryServiceImpl.getResource(HibernateRepositoryServiceImpl.java:184) [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [java] at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) [java] at java.lang.reflect.Method.invoke(Unknown Source) [java] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318) [java] at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) [java] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) [java] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) [java] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [java] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) [java] at $Proxy8.getResource(Unknown Source) [java] at com.jaspersoft.jasperserver.export.modules.repository.ResourceImporter.importResource(ResourceImporter.java:420) [java] at com.jaspersoft.jasperserver.export.modules.repository.ResourceImporter.process(ResourceImporter.java:148) [java] at com.jaspersoft.jasperserver.export.ImporterImpl.process(ImporterImpl.java:156) [java] at com.jaspersoft.jasperserver.export.ImporterImpl.performImport(ImporterImpl.java:98) [java] at com.jaspersoft.jasperserver.export.ImportCommandImpl.process(ImportCommandImpl.java:57) [java] at com.jaspersoft.jasperserver.export.BaseExportImportCommand.process(BaseExportImportCommand.java:94) [java] at com.jaspersoft.jasperserver.export.ImportCommand.main(ImportCommand.java:43) [java] Caused by: org.hibernate.exception.SQLGrammarException: could not execute query [java] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90) [java] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) [java] at org.hibernate.loader.Loader.doList(Loader.java:2235) [java] at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129) [java] at org.hibernate.loader.Loader.list(Loader.java:2124) [java] at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:118) [java] at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1597) [java] at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306) [java] at org.springframework.orm.hibernate3.HibernateTemplate$36.doInHibernate(HibernateTemplate.java:1056) [java] at org.springframework.orm.hibernate3.HibernateTemplate$36.doInHibernate(HibernateTemplate.java:1) [java] at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406) [java] ... 29 more [java] Caused by: org.postgresql.util.PSQLException: FEHLER: Spalte this_.resourcetype existiert nicht [java] Position: 222 [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273) [java] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) [java] at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208) [java] at org.hibernate.loader.Loader.getResultSet(Loader.java:1812) [java] at org.hibernate.loader.Loader.doQuery(Loader.java:697) [java] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259) [java] at org.hibernate.loader.Loader.doList(Loader.java:2232) [java] ... 37 more BUILD FAILED C:tmpjasperreports-server-cp-5.0.0-binbuildomaticbindb-common.xml:520: The following error occurred while executing this line: C:tmpjasperreports-server-cp-5.0.0-binbuildomaticbinimport-export.xml:283: The following error occurred while executing this line: C:tmpjasperreports-server-cp-5.0.0-binbuildomaticbinimport-export.xml:158: Java returned: -1 Total time: 16 seconds Checking Ant return code: OK ----------------------------------------------------------------------