✅[SOLVED] Upgrade v4.2.1 to v7.1 - BUILD FAILED - Problem to import scheduled jobs.

[peter.sramo]

Hello,

I'm performing an upgrade of JasperReports Server v4.2.1 to v 7.1.
Before I successfully made an upgrade, but now I have an problem with importing (upgrading) of an scheduled jobs - all the resources are getting imported, but at the end the jobs are going to be imported probably and I'm getting an error.

My procedure is:
1. Export old resources from an Oracle Database using buildomatic and jdk6. Used command: js-export.bat --everything --output-zip js-export.zip
2. Import and upgrade an exported resources using new buildomatic and jdk8. Used command: js-upgrade-newdb-ce.bat js-export.zip

If I firstly delete all the scheduled jobs, I can successfully perform an upgrade, but I cannot use this way - I need to upgrade repositories with all the jobs too.

Please - do someone have some idea or an knowledge how to solve my issue?  I guess the problem can be with the NLS settings and timeformat. But the databases has the same nls settings.

LOGFILE: js-upgrade-ce_YYYY-MM-DD_XX-XX_XXXXX.log

     [java] ORA-00904: "TIMESTAMP_PATTERN": invalid identifier     [java]      [java] ORA-00904: "TIMESTAMP_PATTERN": invalid identifier     [java]      [java] Could not synchronize database state with session     [java] org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update.........     [java] Caused by: java.sql.BatchUpdateException: ORA-00904: "TIMESTAMP_PATTERN": invalid identifier.........     [java]     ... 58 more     [java] ************** HibernateDaoImpl.executeWriteCallback EXCEPTION **********      [java] org.springframework.dao.InvalidDataAccessResourceUsageException: Could not execute JDBC batch update; SQL [insert into JIReportJobRepoDest (version, folder_uri, sequential_filenames, overwrite_files, save_to_repository, output_description, timestamp_pattern, using_def_rpt_opt_folder_uri, output_local_folder, user_name, password, server_name, folder_path, ssh_private_key, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update.........     [java] Caused by: org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update.........     [java]     ... 44 more     [java] Caused by: java.sql.BatchUpdateException: ORA-00904: "TIMESTAMP_PATTERN": invalid identifier.........     [java]     ... 58 more     [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.      [java] com.jaspersoft.jasperserver.api.JSExceptionWrapper: Could not execute JDBC batch update; SQL [insert into JIReportJobRepoDest (version, folder_uri, sequential_filenames, overwrite_files, save_to_repository, output_description, timestamp_pattern, using_def_rpt_opt_folder_uri, output_local_folder, user_name, password, server_name, folder_path, ssh_private_key, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update     [java] Arguments:      [java] com.jaspersoft.jasperserver.api.JSExceptionWrapper: org.springframework.dao.InvalidDataAccessResourceUsageException: Could not execute JDBC batch update; SQL [insert into JIReportJobRepoDest (version, folder_uri, sequential_filenames, overwrite_files, save_to_repository, output_description, timestamp_pattern, using_def_rpt_opt_folder_uri, output_local_folder, user_name, password, server_name, folder_path, ssh_private_key, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update.........     [java] Caused by: org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update.........     [java]     ... 44 more     [java] Caused by: java.sql.BatchUpdateException: ORA-00904: "TIMESTAMP_PATTERN": invalid identifier     [java]      [java]     at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:11190)     [java]     at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:244)     [java]     at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)     [java]     at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)     [java]     at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)     [java]     at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)     [java]     ... 58 moreBUILD FAILED[/code]

[peter.sramo]

Typo was found in file: "buildomaticinstall_resourcessqloraclejs-create.ddl", in create table JIReportJobRepoDest. The name of column is wrong, just for oracle environment.

Original:

date_pattern varchar2(250),

Edit:

timestamp_pattern varchar2(250),

 

Upgrade succesfull after edit of js-create.ddl