IDash ORA-00904: "WAIT_TIME": invalid identifier

Products

• iDash Workload Automation

Issue/Introduction

After upgrading Idash to r12.1.02 Reports failed to generate from the GUI and the CLI with the error: java.sql.SQLSyntaxErrorException:ORA-00904: "WAIT_TIME": invalid identifier

Resolution

DBA needs to check the tables below to see if the columns exist: 

idash_hist_job_run_ca7
idash_job_run_ca7
 
If the columns are not present then add them using these statements:
 
ALTER TABLE idash_job_run_ca7 ADD wait_time number(10) null;
ALTER TABLE idash_hist_job_run_ca7 ADD wait_time number(10) null;

Once the column gets added, restart iDash and the reports should work. There will be a recovery period since it is likely that job runs have been failing to store because the new column was not there.