![](http://content.invisioncic.com/i328763/set_resources_3/84c1e40ea0e759e3f1505eb1788ddf3c_pattern.png)
thomas.frommelt
-
Posts
26 -
Joined
-
Last visited
Content Type
Forum
Downloads
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Events
Profiles
Posts posted by thomas.frommelt
-
-
Use User: jasperadmin and Password: jasperadmin
I don't no why but only this user works.
-
-
-
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.
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.
-
-
-
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~ -
-
-
-
i have found the problem. it's the intranet compatibility view! You should deselct it in the compatibility dialog of the ie.
-
-
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
----------------------------------------------------------------------
REST v2 API / PHP Client Errors
in Developers and API
Posted
Use User: jasperadmin and Password: jasperadmin
I don't no why but only this user works.