ORA-00904: "JOB_TYPE": invalid identifier

Products

• iDash Workload Automation

Issue/Introduction

20-08-05 13.26.53 [ERROR] U13:com.ca.idash.core.db.idashdb.IdashDBJobID: IdashDBJobID.getDuplicateJobIdCount():ORA-00904: "JOB_TYPE": invalid identifier

java.sql.SQLSyntaxErrorException: ORA-00904: "JOB_TYPE": invalid identifier

20-08-05 13.26.53 [ERROR] U13:com.ca.idash.core.instance.InstanceThread: java.sql.SQLSyntaxErrorException:ORA-00904: "JOB_TYPE": invalid identifier

com.ca.idash.core.exception.IdashException: java.sql.SQLSyntaxErrorException:ORA-00904: "JOB_TYPE": invalid identifier

 

Environment

Release : 12.1

Component : CA WORKLOAD AUTOMATION AE IDASH

Cause

JOB_TYPE column is missing from the idash_job_id table.

Resolution

Stop idash and have the DBA add the missing job_type column to the idash_job_id table. Use the alltables.sql as a guide in creating the missing column. Located in $IDASH_HOME/install/oracle.