Thato

Hi All I want to set a diffrent theme as active theme using Japer REST v2 api. I'm able to get my theme/resource using this endpoint http://<host>:<port>/jasperserver[-pro]/rest_v2/resources/themes/my_theme What I want is to change active default theme to my theme. Thank you

I want to sort selected items in Multi Select Query Input Control. I want the selected items to be sortable. What I want is already implemented on Input control View/Window in Jasper Server. On inpit controls window, left click any input control and drag it up or down you will what I want to achieve. I'm using community edition. I can see similar question was asked from the linik below https://community.jaspersoft.com/questions/1094656/there-way-manually-sort-multi-select-list-input-control Could you please help good people.

Hi @pjimenez_2 The problem was My Database Character Encoding Type I had to change it to utf8 and it worked. If using PostgreSQL this will help you. https://gist.github.com/amolkhanorkar/8706915 Thank you

Hi Paul Thank you very much for your response. No, I didn't try installing it manually, I'm going to do that now. I'm using version 6.4.0 Thanks

I have a problem installing JASPERREPORTS® SERVER COMMUNITY WAR file using js-install scripts: I'm using PostgreSQL and Apache Tomcat 9.0.1 Below is the log file details ---------------------------------------------------------------------- Running JasperReports Server install script at 2018-04-09_02-51 ---------------------------------------------------------------------- [default] Running install-normal-ce Ant task ---------------------------------------------------------------------- Buildfile: C:ApplicationsTIB_js-jrs-cp_6.4.0_binjasperreports-server-cp-6.4.0-binbuildomaticbuild.xml [echo] Filtering properties (cleaning out blank spaces) [encrypt-props] Encrypt dbPassword [echo] chkIfPackageManagedTomcat: check if package managed tomcat [echo] Tomcat DBCP Factory: com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory [echo] creating C:/Applications/TIB_js-jrs-cp_6.4.0_bin/jasperreports-server-cp-6.4.0-bin/buildomatic/build_conf/default [mkdir] Created dir: C:ApplicationsTIB_js-jrs-cp_6.4.0_binjasperreports-server-cp-6.4.0-binbuildomaticbuild_confdefault [copy] Copying 1 file to C:ApplicationsTIB_js-jrs-cp_6.4.0_binjasperreports-server-cp-6.4.0-binbuildomaticbuild_confdefault [copy] Copying 1 file to C:ApplicationsTIB_js-jrs-cp_6.4.0_binjasperreports-server-cp-6.4.0-binbuildomaticbuild_confdefault [copy] Copying 1 file to C:ApplicationsTIB_js-jrs-cp_6.4.0_binjasperreports-server-cp-6.4.0-binbuildomaticbuild_confdefault [copy] Copying 1 file to C:ApplicationsTIB_js-jrs-cp_6.4.0_binjasperreports-server-cp-6.4.0-binbuildomaticbuild_confdefault [copy] Copying 1 file to C:ApplicationsTIB_js-jrs-cp_6.4.0_binjasperreports-server-cp-6.4.0-binbuildomaticbuild_confdefault [echo] chkAndSetLocaleDbSettings: dbType is postgresql [echo] chkAndSetLocaleDbSettings: db.set.lc_collate and db.set.lc_ctype are NOT both set [echo] chkAndSetLocaleDbSettings: parse: scripts.properties for db commands [copy] Copying 27 files to C:ApplicationsTIB_js-jrs-cp_6.4.0_binjasperreports-server-cp-6.4.0-binbuildomaticbuild_confdefault [copy] Copying 1 file to C:ApplicationsTIB_js-jrs-cp_6.4.0_binjasperreports-server-cp-6.4.0-binbuildomatic [copy] Copying 1 file to C:ApplicationsTIB_js-jrs-cp_6.4.0_binjasperreports-server-cp-6.4.0-binbuildomaticbuild_confdefaultwebappWEB-INF [echo] chkIfPackageManagedTomcat: check if package managed tomcat [echo] using settings file: C:/Applications/TIB_js-jrs-cp_6.4.0_bin/jasperreports-server-cp-6.4.0-bin/buildomatic/build_conf/default/maven_settings.xml gen-config: [echo] Regen config files if they have already been cleaned: [echo] currentConf= C:/Applications/TIB_js-jrs-cp_6.4.0_bin/jasperreports-server-cp-6.4.0-bin/buildomatic/build_conf/default [echo] chkIfPackageManagedTomcat: check if package managed tomcat [echo] Tomcat DBCP Factory: com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory [echo] chkAndSetLocaleDbSettings: dbType is postgresql [echo] chkAndSetLocaleDbSettings: db.set.lc_collate and db.set.lc_ctype are NOT both set [echo] chkAndSetLocaleDbSettings: parse: scripts.properties for db commands test-ce-all-props: [echo] Checking properties: [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 [echo] appServerType=tomcat [echo] appServerDir=C:Applicationsapache-tomcat-9.0.1 check-dbtype-ce: test-appServerType-ce: do-install-upgrade-test: [echo] Checking DBMS host and port: [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.4-1210.jdbc41 [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.4-1210.jdbc41 [echo] Specified JDBC driver jar exists [advanced-sql] Failed to connect: FATAL: database "jasperserver" does not exist [echo] Connection failed: [echo] SQLState: 3D000 [echo] Vendor specific error code: 0 [echo] Message: [FATAL: database "jasperserver" does not exist] [echo] Database doesn't exist. Treating problem with JDBC connection as noncritical. Proceeding to next step do-pre-install-test: [echo] Validating FoodMart database connection at jdbc:postgresql://localhost:5432/foodmart. Phase: [test] [echo] For JDBC driver the artifactId and version properties are set: [echo] maven.jdbc.artifactId=postgresql [echo] maven.jdbc.version=9.4-1210.jdbc41 [echo] Specified JDBC driver jar exists [advanced-sql] Failed to connect: FATAL: database "foodmart" does not exist [echo] Connection failed: [echo] SQLState: 3D000 [echo] Vendor specific error code: 0 [echo] Message: [FATAL: database "foodmart" does not exist] [echo] Database doesn't exist. Treating problem with JDBC connection as noncritical. Proceeding to next step [echo] Validating SugarCRM database connection at jdbc:postgresql://localhost:5432/sugarcrm. Phase: [test] [echo] For JDBC driver the artifactId and version properties are set: [echo] maven.jdbc.artifactId=postgresql [echo] maven.jdbc.version=9.4-1210.jdbc41 [echo] Specified JDBC driver jar exists [advanced-sql] Failed to connect: FATAL: database "sugarcrm" does not exist [echo] Connection failed: [echo] SQLState: 3D000 [echo] Vendor specific error code: 0 [echo] Message: [FATAL: database "sugarcrm" does not exist] [echo] Database doesn't exist. Treating problem with JDBC connection as noncritical. Proceeding to next step pre-install-test-ce: recreate-js-db: [echo] Validating JasperServer database connection at jdbc:postgresql://localhost:5432/jasperserver. Phase: [before] [echo] For JDBC driver the artifactId and version properties are set: [echo] maven.jdbc.artifactId=postgresql [echo] maven.jdbc.version=9.4-1210.jdbc41 [echo] Specified JDBC driver jar exists [advanced-sql] Failed to connect: FATAL: database "jasperserver" does not exist [echo] Connection failed: [echo] SQLState: 3D000 [echo] Vendor specific error code: 0 [echo] Message: [FATAL: database "jasperserver" does not exist] [echo] Database doesn't exist. Treating problem with JDBC connection as noncritical. Proceeding to next step [echo] Filtering properties (cleaning out blank spaces) [encrypt-props] The master properties have already been encrypted. To re-enable the encryption, make sure the passwords are in plain text, set master property encrypt to true and remove encrypt.done. [echo] chkIfPackageManagedTomcat: check if package managed tomcat [echo] Tomcat DBCP Factory: com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory [echo] chkAndSetLocaleDbSettings: dbType is postgresql [echo] chkAndSetLocaleDbSettings: db.set.lc_collate and db.set.lc_ctype are NOT both set [echo] chkAndSetLocaleDbSettings: parse: scripts.properties for db commands [echo] chkIfPackageManagedTomcat: check if package managed tomcat [echo] using settings file: C:/Applications/TIB_js-jrs-cp_6.4.0_bin/jasperreports-server-cp-6.4.0-bin/buildomatic/build_conf/default/maven_settings.xml create-js-db: [echo] Creating database, js.dbName = jasperserver, create database "jasperserver" encoding='utf8' [echo] For JDBC driver the artifactId and version properties are set: [echo] maven.jdbc.artifactId=postgresql [echo] maven.jdbc.version=9.4-1210.jdbc41 [echo] Specified JDBC driver jar exists [advanced-sql] Executing commands [advanced-sql] Failed to execute: create database "jasperserver" encoding='utf8' BUILD FAILED C:ApplicationsTIB_js-jrs-cp_6.4.0_binjasperreports-server-cp-6.4.0-binbuildomaticbindb-common.xml:1078: The following error occurred while executing this line: C:ApplicationsTIB_js-jrs-cp_6.4.0_binjasperreports-server-cp-6.4.0-binbuildomaticbindb-common.xml:1125: The following error occurred while executing this line: C:ApplicationsTIB_js-jrs-cp_6.4.0_binjasperreports-server-cp-6.4.0-binbuildomaticbindb-common.xml:1149: The following error occurred while executing this line: C:ApplicationsTIB_js-jrs-cp_6.4.0_binjasperreports-server-cp-6.4.0-binbuildomaticbindb-common.xml:47: The following error occurred while executing this line: C:ApplicationsTIB_js-jrs-cp_6.4.0_binjasperreports-server-cp-6.4.0-binbuildomaticbinapp-server.xml:60: org.postgresql.util.PSQLException: ERROR: new encoding (UTF8) is incompatible with the encoding of the template database (WIN1252) Hint: Use the same encoding as in the template database, or use template0 as template. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2453) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2153) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:286) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:432) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:358) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:305) at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:291) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:269) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:265) at org.apache.tools.ant.taskdefs.SQLExec.execSQL(SQLExec.java:794) at org.apache.tools.ant.taskdefs.SQLExec.runStatements(SQLExec.java:770) 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.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.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38) at org.apache.tools.ant.Project.executeTargets(Project.java:1248) at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:441) at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105) 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$ElseIf.execute(IfTask.java:144) at net.sf.antcontrib.logic.IfTask.execute(IfTask.java:211) 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 Checking Ant return code: OK ----------------------------------------------------------------------