JasperServer Community Upgrade 7.1 to 7.2

[pokornyjan]

Hi,

I try to upgrade JasperServer Community 7.1 to 7.2.  

Show me the errors:

upgrade-7.1-7.2-ce:
     [echo]  
     [echo]  currentSqlDir = c:/Jaspersoft 7_2/buildomatic/install_resources/sql/postgresql 
     [echo]  dbType = postgresql 
     [echo]  
     [echo] run script: c:/Jaspersoft 7_2/buildomatic/install_resources/sql/postgresql/upgrade-postgresql-7.1.0-7.2.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: c:Jaspersoft 7_2buildomaticinstall_resourcessqlpostgresqlupgrade-postgresql-7.1.0-7.2.0-ce.sql
[advanced-sql] Failed to execute:   ALTER TABLE qrtz_fired_triggers ADD COLUMN sched_time BIGINT
[advanced-sql] org.postgresql.util.PSQLException: ERROR: must be owner of relation qrtz_fired_triggers
[advanced-sql] Failed to execute:  UPDATE qrtz_fired_triggers SET sched_time = fired_time
[advanced-sql] org.postgresql.util.PSQLException: ERROR: column "sched_time" of relation "qrtz_fired_triggers" does not exist
[advanced-sql]   Position: 33
[advanced-sql] Failed to execute:  ALTER TABLE qrtz_fired_triggers ALTER COLUMN sched_time SET NOT NULL
[advanced-sql] org.postgresql.util.PSQLException: ERROR: must be owner of relation qrtz_fired_triggers
[advanced-sql] 0 of 3 SQL statements executed successfully

and

deploy-jdbc-jar:
     [echo] Copy JDBC drivers to the app-server
     [echo] First copy jars
     [echo] FROM the conf_source/db/app-srv-jdbc-drivers folder
     [echo] TO   the folder C:/Jaspersoft/jasperreports-server-cp-6.4.0/apache-tomcat/lib
     [copy] Copying 1 file to C:Jaspersoftjasperreports-server-cp-6.4.0apache-tomcatlib
Attempt to copy c:Jaspersoft 7_2buildomaticconf_sourcedbapp-srv-jdbc-driverspostgresql-9.4-1210.jdbc41.jar to C:Jaspersoftjasperreports-server-cp-6.4.0apache-tomcatlibpostgresql-9.4-1210.jdbc41.jar using NIO Channels failed due to 'C:Jaspersoftjasperreports-server-cp-6.4.0apache-tomcatlibpostgresql-9.4-1210.jdbc41.jar (Access is denied)'.  Falling back to streams.

BUILD FAILED
c:Jaspersoft 7_2buildomaticbinapp-server.xml:1034: Failed to copy c:Jaspersoft 7_2buildomaticconf_sourcedbapp-srv-jdbc-driverspostgresql-9.4-1210.jdbc41.jar to C:Jaspersoftjasperreports-server-cp-6.4.0apache-tomcatlibpostgresql-9.4-1210.jdbc41.jar due to java.io.FileNotFoundException C:Jaspersoftjasperreports-server-cp-6.4.0apache-tomcatlibpostgresql-9.4-1210.jdbc41.jar (Access is denied) and I couldn't delete the corrupt C:Jaspersoftjasperreports-server-cp-6.4.0apache-tomcatlibpostgresql-9.4-1210.jdbc41.jar

 

Can You help me?

Jan

 

[vchiem]

There are 2 errors here. For first error, ensure the owner of the table qrtz_fired_triggers is the username specified in the buildomatic default_master.properties file. You can determine the owner of the table by entering pgAdmin and looking at the table properties. The second error appears to relate to a permissions issue. Check whether the install is done under an admin account or whether the file to be copied or deleted is opened/in-use, locked etc.