Import of Jaspersoft content fails with error - ORA-12899: value too large for column "PPM_JASPERSOFT"."JIREPORTJOBREPODEST"."PASSWORD" (actual: 434, maximum: 250)

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Editing and exporting and importing of scheduled reports from one instance of Jaspersoft to another instance generating an error with below stack and import is failing 

2022-04-11T06:54:24,514 ERROR ImportRunnable,pool-14-thread-1:81 [] - Import failed: 
com.jaspersoft.jasperserver.export.service.ImportFailedException: Import failed. Reason: JDBC exception on Hibernate data access: SQLException for 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [72000]; error code [12899]; could not execute batch; nested exception is org.hibernate.exception.GenericJDBCException: could not execute batch

 

Steps to Reproduce: 

1. Create at least 350+ schedule reports in Advance reporting
2. Export the repository/few reports along with schedules from one jaspersoft instance to another 

Expected Results: The export should be successful 

Actual Results: The export of repository fails with below error stack 

2022-04-11T06:54:24,514 ERROR ImportRunnable,pool-14-thread-1:81 [] - Import failed: 
com.jaspersoft.jasperserver.export.service.ImportFailedException: Import failed. Reason: JDBC exception on Hibernate data access: SQLException for 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [72000]; error code [12899]; could not execute batch; nested exception is org.hibernate.exception.GenericJDBCException: could not execute batch

 

Environment

15.9.3, 16.0, 16.0.1 with Jaspersoft 7.8

Cause

This is a Jaspersoft defect logged by Tibco JS-57772 and Broadcom is tracking under DE64749

Resolution

Workaround: Till the defect is fixed by Tibco and incorporated in the build provided by Broadcom Clarity Team  

• Stop the Jaspersoft service 
• Run the alter statement on table JIREPORTJOBREPODEST
  • ALTER TABLE JIREPORTJOBREPODEST MODIFY PASSWORD NVARCHAR2(500);
• Note if it still fails increase the field length type greater then 500