ORA-00904: "JOB_TYPE": invalid identifier

book

Article ID: 196712

calendar_today

Updated On:

Products

CA Workload Automation iDash

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

 

Cause

JOB_TYPE column is missing from the idash_job_id table.

Environment

Release : 12.1

Component : CA WORKLOAD AUTOMATION AE IDASH

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.