Updating Jasperserver 6.4.0. to 7.1

[wszystkielogizajete]

Hi, I've read https://community.jaspersoft.com/documentation/tibco-jasperreports-server-community-project-upgrade-guide/v71/upgrading-64-71-0#upgrade-with-sql-script_3648109512_1116632 instruction and managed to run ./js-upgrade-samedb-ce.sh script.  Unfortunately, I am not able to see any changes in my jasperserver. What am I doing wrong?  I have provided sample output from script:

 

Running JasperReports Server upgrade script at 2018-07-24_05-46
----------------------------------------------------------------------
----------------------------------------------------------------------
Using ANT_OPTS: -Dnet.sf.ehcache.disabled=true -Xms512m -Xmx2048m
----------------------------------------------------------------------
[default]
Running upgrade-minimal-ce Ant task.
----------------------------------------------------------------------
Buildfile: /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/build.xml
     [echo] Filtering properties (cleaning out blank spaces)
     [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
  [taskdef] Could not load definitions from resource org/jacoco/ant/antlib.xml. It could not be found.
     [echo] using settings file: /opt/jasperreports-server-cp-7.1.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= /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/build_conf/default
     [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=127.0.0.1
     [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=skipAppServerCheck
     [echo]   appServerDir=/opt/jasperreports-server-cp-6.4.0/apache-tomcat

check-dbtype-for-upgrade-ce:

do-install-upgrade-test:
     [echo] Checking DBMS host and port:
     [echo] About to validate port: 127.0.0.1:5432
     [echo]   Port 5432 is OK
     [echo] Done validating port: 127.0.0.1:5432
     [echo] Validating administrative database connection at jdbc:postgresql://127.0.0.1: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://127.0.0.1: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] 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-6.4-7.1-ce:
     [echo]
     [echo]  currentSqlDir = /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/install_resources/sql/postgresql
     [echo]  dbType = postgresql
     [echo]
     [echo] run script: /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/install_resources/sql/postgresql/upgrade-postgresql-6.4.0-7.1.0-ce.sql
     [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 resource: /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/install_resources/sql/postgresql/upgrade-postgresql-6.4.0-7.1.0-ce.sql
[advanced-sql] 0 rows affected
[advanced-sql] 0 rows affected
[advanced-sql] 2 of 2 SQL statements executed successfully

import-minimal-for-upgrade-ce:
     [echo]
     [echo] Property values (in install.xml):
     [echo]  archiveArg = --input-zip=/opt/jasperreports-server-cp-7.1.0-bin/buildomatic/install_resources/export/js-catalog-postgresql-minimal-ce.zip
     [echo]  dbType = postgresql
     [echo]  jdbcJar = postgresql-9.4-1210.jdbc41.jar
     [echo]  currentConf = /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/build_conf/default
     [echo]  importExportConfig = /opt/jasperreports-server-cp-7.1.0-bin/buildomatic/conf_source/ieCe
     [echo]
     [echo] Validating JasperServer database connection at jdbc:postgresql://127.0.0.1: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.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
     [java] First resource path:/opt/jasperreports-server-cp-7.1.0-bin/buildomatic/conf_source/ieCe/applicationContext-azure-sql-datasource.xml
  [...]
     [java]  -- JasperServer:  TeiidCache preparedplan shutdown called.  This normal shutdown operation.
     [java]  -- JasperServer:  TeiidCache resultset-repl shutdown called.  This normal shutdown operation.
     [java]  -- JasperServer:  TeiidCache resultset shutdown called.  This normal shutdown operation.
     [java]  -- JasperServer:  ProfileAttributeCacheImpl shutdown called.  This normal shutdown operation.

deploy-webapp-ce-if-needed:

do-deploy-webapp-if-needed:
     [echo] Deployment is skipped because appServerType is set to skipAppServerCheck

upgrade-minimal-ce:
     [echo] Upgrade successfully completed!

[shining01]

Hello,

i have the same problem. What is my mistake? Thanks

[shining01]

I have found the solution. In default_master.properties the appServerType must be tomcat oder glasfish or anything else. Don't use "SkipAppServerCheck".

this was my mistake!