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]
