peter.sramo
-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Downloads
Posts posted by 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.zipIf 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]
✅[SOLVED] Upgrade v4.2.1 to v7.1 - BUILD FAILED - Problem to import scheduled jobs.
in Products
Posted
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