kaung_1

I followed this instruction to hide stack trace messages and restarted the server. But the stack traces are still being displayed. Has it been broken in JRS 6.2.1? http://community.jaspersoft.com/documentation/tibco-jasperreports-server-security-guide/v62/hiding-stack-trace-messages <bean id="webAppSecurityFilter" class="com.jaspersoft.jasperserver.api.security.WebAppSecurityFilter"> <property name="messages" ref="messageSource"/> <property name="redirectUrl" value="/error.html"/> <property name="localeResolver" ref="filterLocaleResolver"/> <property name="showStacktraceMessage" value="false"/> </bean>

That SQL_QUERY string itself will contain parameters. e.g. If my report is to get all users from a certain country, there will be a "where users = $P{country}" somewhere in that SQL_QUERY string. Would jasper further substitute these paramters or will the string get sent to database lterally as it is? Would be amazing if substituation happens.... (I'll test it out soon but I doubt parameter substitution will happen)

I am trying to use external queries to create a report(s) that can support multiple SQL databases - mysql and oracle. My idea is I will create multiple queries - one for each database type, and a single reportUnit. Depending on which db type a customer has, I will link the right queries to the reportUnit. But my reportUnit contains subreports and I cannot find a way to set an external query to a subreport. I can set only one external query to a reportUnit and that query seem to override only the main_jrxml of the reportUnit. SubReports are not affected by external query. Here, I find docs about external queries but there is no mention how it behaves with subreports. http://community.jaspersoft.com/documentation/jasperreports-server-user-guide/defining-query I tried the following: * If only I could pass a report's query to a subreport via subreport tag, it would be a solution. But subreports tag only support passing report connection but not query. There seem to be no other way to me. Is there any way that I can externalize they query from a subreport? Thanks in advance.

Thanks @hozawa. The trouble is each container has its own configuration system for JNDI resources and I was hoping buildomatic to support disabling of these sample datasources (since buildomatic is the layer that does multiple container support in the first place). But after researching, that seems not to be the case. I had to use a manual post-install modification of wildfly configuration files (i.e 3 files, WEB-INF/web.xml, WEB-INF/jboss-web.xml and js-jboss7-ds.xml).

foodmart and sugarcrm sample databases are great for demo, testing and development. But these connection pools are causing unnecessary warnings for production deployment. How can I switch them off completely? I am using wildfly8, JRS 6.2.1 pro and centos 7 2016-10-11 05:23:39,821 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (JCA PoolFiller) IJ000610: Unable to fill pool: javax.resource.ResourceException: Could not create connection at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:347) at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:354) at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:288) at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:1166) [ironjacamar-core-impl-1.1.9.Final.jar:1.1.9.Final] at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.fillTo(SemaphoreArrayListManagedConnectionPool.java:1030) [ironjacamar-core-impl-1.1.9.Final.jar:1.1.9.Final] at org.jboss.jca.core.connectionmanager.pool.mcp.PoolFiller.run(PoolFiller.java:97) [ironjacamar-core-impl-1.1.9.Final.jar:1.1.9.Final] at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_92]Caused by: java.sql.SQLException: Could not connect: Unknown database 'foodmart' at org.mariadb.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:149) at org.mariadb.jdbc.internal.SQLExceptionMapper.throwException(SQLExceptionMapper.java:106) at org.mariadb.jdbc.Driver.connect(Driver.java:114) at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:322) ... 6 moreCaused by: org.mariadb.jdbc.internal.common.QueryException: Could not connect: Unknown database 'foodmart' at org.mariadb.jdbc.internal.mysql.MySQLProtocol.checkErrorPacket(MySQLProtocol.java:446) at org.mariadb.jdbc.internal.mysql.MySQLProtocol.connect(MySQLProtocol.java:408) at org.mariadb.jdbc.internal.mysql.MySQLProtocol.connect(MySQLProtocol.java:593) at org.mariadb.jdbc.internal.mysql.MySQLProtocol.<init>(MySQLProtocol.java:216) at org.mariadb.jdbc.Driver.connect(Driver.java:110) ... 7 more

It seems that I am able to export just the jobs without reportUnits using REST v2 export service using the following option

Hi elizam, Why is there risk of scheduling non-existent jobs? Jasper anyway refuses to create resource if the dependency is missing. Anyway, I was able to export the jobs without reportUnits. (sorry, can't find a way to comment on your answer)

Is it possible to export just the schedule job definitions without the reportUnits? It would be nice to be able to create a catalog only contain schedule jobs. That way we can create multiple sets of schedules on the same set of reports, eg one that schedules reports every month, another every week and import one that suits customer requirements.

I am installing a war file distribution of JRS 6.2.1 - wildfly8, oracle database, linux rhel 6.8. I am getting this error. Now, I think I need to deploy an oracle driver there instead but I am not sure this is supposed to happen. Could I be doing something wrong or is it really that I need an oracle driver? import-minimal-pro: [echo] [echo] Property values (in install.xml): [echo] archiveArg = --input-zip=/var/opt/nevisreports/jrs/buildomatic-home/buildomatic/install_resources/export/js-catalog-oracle-minimal-pro.zip [echo] dbType = oracle [echo] jdbcJar = TIoracle-5.14.2.jar [echo] currentConf = /var/opt/nevisreports/jrs/buildomatic-home/buildomatic/build_conf/default [echo] importExportConfig = /var/opt/nevisreports/jrs/buildomatic-home/buildomatic/conf_source/iePro [echo] [echo] Validating JasperServer database connection at jdbc:tibcosoftware:oracle://xxx.xxx.xx:xxx;ServiceName=xxxxx. Phase: [import-export-test] [echo] For JDBC driver the artifactId and version properties are set: [echo] maven.jdbc.artifactId=TIoracle [echo] maven.jdbc.version=5.14.2 [echo] Specified JDBC driver jar exists[select-sql] Executing commands[select-sql] Failed to execute: SELECT USERNAME FROM ALL_USERS WHERE USERNAME = UPPER('unevrptest_kaung') BUILD FAILED/var/opt/nevisreports/jrs/buildomatic-home/buildomatic/bin/import-export.xml:279: The following error occurred while executing this line:/var/opt/nevisreports/jrs/buildomatic-home/buildomatic/bin/import-export.xml:144: The following error occurred while executing this line:/var/opt/nevisreports/jrs/buildomatic-home/buildomatic/bin/validation.xml:376: The following error occurred while executing this line:/var/opt/nevisreports/jrs/buildomatic-home/buildomatic/conf_source/db/oracle/db.xml:153: The following error occurred while executing this line:/var/opt/nevisreports/jrs/buildomatic-home/buildomatic/conf_source/db/oracle/db.xml:208: The following error occurred while executing this line:/var/opt/nevisreports/jrs/buildomatic-home/buildomatic/bin/app-server.xml:154: java.sql.SQLException: [TibcoSoftwareInc][Oracle JDBC Driver]This driver is locked for use with embedded applications.at tibcosoftwareinc.jdbc.oraclebase.ddcr.b(Unknown Source) at tibcosoftwareinc.jdbc.oraclebase.ddcr.a(Unknown Source) at tibcosoftwareinc.jdbc.oraclebase.ddcq.b(Unknown Source) at tibcosoftwareinc.jdbc.oraclebase.ddcq.a(Unknown Source) at tibcosoftwareinc.jdbc.oraclebase.BaseConnection.createStatement(Unknown Source) at tibcosoftwareinc.jdbc.oraclebase.BaseConnection.createStatement(Unknown Source) at tibcosoftware.jdbc.common.oracle.ConnectionImpl.createStatement(ConnectionImpl.java:130) at org.apache.tools.ant.taskdefs.SQLExec.getStatement(SQLExec.java:980) at com.jaspersoft.buildomatic.sql.ant.SelectSQLExec.execSQL(SelectSQLExec.java:98) at org.apache.tools.ant.taskdefs.SQLExec.runStatements(SQLExec.java:764) at org.apache.tools.ant.taskdefs.SQLExec$Transaction.runTransaction(SQLExec.java:1062) at org.apache.tools.ant.taskdefs.SQLExec$Transaction.access$000(SQLExec.java:1004) at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:672) at com.jaspersoft.buildomatic.sql.ant.AdvancedSQLExec.execute(AdvancedSQLExec.java:82) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292) at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:68) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292) at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.taskdefs.MacroInstance.execute(MacroInstance.java:396) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292) at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:68) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292) at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.taskdefs.MacroInstance.execute(MacroInstance.java:396) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292) at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:68) at net.sf.antcontrib.logic.IfTask.execute(IfTask.java:197) at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.TaskAdapter.execute(TaskAdapter.java:154) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292) at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:68) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292) at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.taskdefs.MacroInstance.execute(MacroInstance.java:396) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292) at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:68) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292) at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.taskdefs.MacroInstance.execute(MacroInstance.java:396) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292) at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:68) at net.sf.antcontrib.logic.IfTask.execute(IfTask.java:197) at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.TaskAdapter.execute(TaskAdapter.java:154) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292) at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:68) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292) at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.taskdefs.MacroInstance.execute(MacroInstance.java:396) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:292) at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:435) at org.apache.tools.ant.Target.performTasks(Target.java:456) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1393) at org.apache.tools.ant.Project.executeTarget(Project.java:1364) at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41) at org.apache.tools.ant.Project.executeTargets(Project.java:1248) at org.apache.tools.ant.Main.runBuild(Main.java:851) at org.apache.tools.ant.Main.startAnt(Main.java:235) at org.apache.tools.ant.launch.Launcher.run(Launcher.java:280) at org.apache.tools.ant.launch.Launcher.main(Launcher.java:109) Total time: 1 second[/code]

Hi, According to http://community.jaspersoft.com/documentation/v630/tibco-jasperreports-server-supported-platform-datasheet wildlfy 8.x is one of the supported application servers. But ""deploy-webapp" target (buildomatic/bin/app-server.xml) has no support for jboss 8 or wildfly 8. I noted that "deploy-webapp" target normally does small changes to the .war file before deploying it to the container. Lacking this automated configuration, are there any manual configuration guidelines for configuring the war file for deployment into wildlfy 8?

It appears that 'skip-dependent-resources' option in rest_v2 export service is not working? http://community.jaspersoft.com/documentation/tibco-jasperreports-server-rest-api-reference/v621/export-service#Polling_the_Export_Status I did the following: % cat export-6.2.1.json { "uris": ["/organizations/organization_1/reports"], "parameters": ["skip-dependent-resources"] } % curl -XPOST -d @export-6.2.1.json "https://superuser:superuser@localhost:8777/jasperserver-pro/rest_v2/export" -k -H "content-type: application/json" <?xml version="1.0" encoding="UTF-8" standalone="yes"?><state><id>fe08c4d8-54b3-4f36-9361-86f0170620d8</id><message>Export in progress.</message><phase>inprogress</phase></state> % curl "https://superuser:superuser@localhost:8777/jasperserver-pro/rest_v2/export/fe08c4d8-54b3-4f36-9361-86f0170620d8/state" -k <?xml version="1.0" encoding="UTF-8" standalone="yes"?><state><id>fe08c4d8-54b3-4f36-9361-86f0170620d8</id><message>Export succeeded.</message><phase>finished</phase></state> % wget "https://superuser:superuser@localhost:8777/jasperserver-pro/rest_v2/export/fe08c4d8-54b3-4f36-9361-86f0170620d8/export.zip" --no-check-certificate The export.zip still contains datasources and images (that I put in a folder called shared_resources) referenced by the reports. resources/organizations/organization_1/datasources/... resources/organizations/organization_1/shared_resources I am expecting only resources/organizations/organization_1/reports directory in the zip. Am I missing something? JasperServer version: 6.2.1