bg_data_collector.pm - Unable to parse statement: select j.owner owner ,j.job_name || decode(j.job_subname,null,null,':') || j.job_subname job_name ,decode(schedule_type,'ONCE','TRUE',j.enabled) enabled ,j.failure_count ,EXTRACT(DAY FROM j.last_run_duration)*24*60*60 + EXTRACT(HOUR FROM j.last_run_duration)*60*60 + EXTRACT(MINUTE FROM j.last_run_duration)*60 + EXTRACT(SECOND FROM j.last_run_duration) last_exec_seconds ,EXTRACT(DAY FROM r.elapsed_time)*24*60*60 + EXTRACT(HOUR FROM r.elapsed_time)*60*60 + EXTRACT(MINUTE FROM r.elapsed_time)*60 + EXTRACT(SECOND FROM r.elapsed_time) cur_exec_seconds ,EXTRACT(DAY FROM r.cpu_used)*24*60*60 + EXTRACT(HOUR FROM r.cpu_used)*60*60 + EXTRACT(MINUTE FROM r.cpu_used)*60 + EXTRACT(SECOND FROM r.cpu_used) cur_cpu_seconds ,NVL(l.status,'NEVER RUN') as last_run_status from dba_scheduler_jobs j ,dba_scheduler_running_jobs r ,(select owner ,job_name ,NVL(job_subname,'xxx') as job_subname , status from dba_scheduler_job_run_details d1 ,(select max(log_id) as log_id from dba_scheduler_job_run_details group by owner,job_name,job_subname) d2 where d1.log_id = d2.log_id) l where j.owner = r.owner (+) and j.job_name = r.job_name (+) and j.job_subname = r.job_subname (+) and j.owner = l.owner (+) and j.job_name = l.job_name (+) and NVL(j.job_subname,'xxx') = l.job_subname (+) and j.schedule_type != 'ONCE' and NOT (l.status IS NULL and r.elapsed_time IS NULL) and j.last_start_date > sysdate - 90 DBD::Oracle::db prepare_cached failed: ORA-00904: "JOB_SUBNAME": invalid identifier (DBD ERROR: error possibly near <*> indicator at char 1021 in ' select j.owner owner ,j.job_name || decode(j.job_subname,null,null,':') || j.job_subname job_name ,decode(schedule_type,'ONCE','TRUE',j.enabled) enabled ,j.failure_count ,EXTRACT(DAY FROM j.last_run_duration)*24*60*60 + EXTRACT(HOUR FROM j.last_run_duration)*60*60 + EXTRACT(MINUTE FROM j.last_run_duration)*60 + EXTRACT(SECOND FROM j.last_run_duration) last_exec_seconds ,EXTRACT(DAY FROM r.elapsed_time)*24*60*60 + EXTRACT(HOUR FROM r.elapsed_time)*60*60 + EXTRACT(MINUTE FROM r.elapsed_time)*60 + EXTRACT(SECOND FROM r.elapsed_time) cur_exec_seconds ,EXTRACT(DAY FROM r.cpu_used)*24*60*60 + EXTRACT(HOUR FROM r.cpu_used)*60*60 + EXTRACT(MINUTE FROM r.cpu_used)*60 + EXTRACT(SECOND FROM r.cpu_used) cur_cpu_seconds ,NVL(l.status,'NEVER RUN') as last_run_status from dba_scheduler_jobs j ,dba_scheduler_running_jobs r ,(select owner ,job_name ,NVL(job_subname,'xxx') as job_subname , status from dba_scheduler_job_run_details d1 ,(select max(log_id) as log_id from dba_scheduler_job_run_details group by owner,job_name,<*>job_subname) d2 where d1.log_id = d2.log_id) l where j.owner = r.owner (+) and j.job_name = r.job_name (+) and j.job_subname = r.job_subname (+) and j.owner = l.owner (+) and j.job_name = l.job_name (+) and NVL(j.job_subname,'xxx') = l.job_subname (+) and j.schedule_type != 'ONCE' and NOT (l.status IS NULL and r.elapsed_time IS NULL) and j.last_start_date > sysdate - 90 ') [for Statement " select j.owner owner ,j.job_name || decode(j.job_subname,null,null,':') || j.job_subname job_name ,decode(schedule_type,'ONCE','TRUE',j.enabled) enabled ,j.failure_count ,EXTRACT(DAY FROM j.last_run_duration)*24*60*60 + EXTRACT(HOUR FROM j.last_run_duration)*60*60 + EXTRACT(MINUTE FROM j.last_run_duration)*60 + EXTRACT(SECOND FROM j.last_run_duration) last_exec_seconds ,EXTRACT(DAY FROM r.elapsed_time)*24*60*60 + EXTRACT(HOUR FROM r.elapsed_time)*60*60 + EXTRACT(MINUTE FROM r.elapsed_time)*60 + EXTRACT(SECOND FROM r.elapsed_time) cur_exec_seconds ,EXTRACT(DAY FROM r.cpu_used)*24*60*60 + EXTRACT(HOUR FROM r.cpu_used)*60*60 + EXTRACT(MINUTE FROM r.cpu_used)*60 + EXTRACT(SECOND FROM r.cpu_used) cur_cpu_seconds ,NVL(l.status,'NEVER RUN') as last_run_status from dba_scheduler_jobs j ,dba_scheduler_running_jobs r ,(select owner ,job_name ,NVL(job_subname,'xxx') as job_subname , status from dba_scheduler_job_run_details d1 ,(select max(log_id) as log_id from dba_scheduler_job_run_details group by owner,job_name,job_subname) d2 where d1.log_id = d2.log_id) l where j.owner = r.owner (+) and j.job_name = r.job_name (+) and j.job_subname = r.job_subname (+) and j.owner = l.owner (+) and j.job_name = l.job_name (+) and NVL(j.job_subname,'xxx') = l.job_subname (+) and j.schedule_type != 'ONCE' and NOT (l.status IS NULL and r.elapsed_time IS NULL) and j.last_start_date > sysdate - 90 "] at /home/monocle/src/lib/bg/bg_data_collector.pm line 104. DBD::Oracle::db prepare_cached failed: ORA-00904: "JOB_SUBNAME": invalid identifier (DBD ERROR: error possibly near <*> indicator at char 1021 in ' select j.owner owner ,j.job_name || decode(j.job_subname,null,null,':') || j.job_subname job_name ,decode(schedule_type,'ONCE','TRUE',j.enabled) enabled ,j.failure_count ,EXTRACT(DAY FROM j.last_run_duration)*24*60*60 + EXTRACT(HOUR FROM j.last_run_duration)*60*60 + EXTRACT(MINUTE FROM j.last_run_duration)*60 + EXTRACT(SECOND FROM j.last_run_duration) last_exec_seconds ,EXTRACT(DAY FROM r.elapsed_time)*24*60*60 + EXTRACT(HOUR FROM r.elapsed_time)*60*60 + EXTRACT(MINUTE FROM r.elapsed_time)*60 + EXTRACT(SECOND FROM r.elapsed_time) cur_exec_seconds ,EXTRACT(DAY FROM r.cpu_used)*24*60*60 + EXTRACT(HOUR FROM r.cpu_used)*60*60 + EXTRACT(MINUTE FROM r.cpu_used)*60 + EXTRACT(SECOND FROM r.cpu_used) cur_cpu_seconds ,NVL(l.status,'NEVER RUN') as last_run_status from dba_scheduler_jobs j ,dba_scheduler_running_jobs r ,(select owner ,job_name ,NVL(job_subname,'xxx') as job_subname , status from dba_scheduler_job_run_details d1 ,(select max(log_id) as log_id from dba_scheduler_job_run_details group by owner,job_name,<*>job_subname) d2 where d1.log_id = d2.log_id) l where j.owner = r.owner (+) and j.job_name = r.job_name (+) and j.job_subname = r.job_subname (+) and j.owner = l.owner (+) and j.job_name = l.job_name (+) and NVL(j.job_subname,'xxx') = l.job_subname (+) and j.schedule_type != 'ONCE' and NOT (l.status IS NULL and r.elapsed_time IS NULL) and j.last_start_date > sysdate - 90 ') [for Statement " select j.owner owner ,j.job_name || decode(j.job_subname,null,null,':') || j.job_subname job_name ,decode(schedule_type,'ONCE','TRUE',j.enabled) enabled ,j.failure_count ,EXTRACT(DAY FROM j.last_run_duration)*24*60*60 + EXTRACT(HOUR FROM j.last_run_duration)*60*60 + EXTRACT(MINUTE FROM j.last_run_duration)*60 + EXTRACT(SECOND FROM j.last_run_duration) last_exec_seconds ,EXTRACT(DAY FROM r.elapsed_time)*24*60*60 + EXTRACT(HOUR FROM r.elapsed_time)*60*60 + EXTRACT(MINUTE FROM r.elapsed_time)*60 + EXTRACT(SECOND FROM r.elapsed_time) cur_exec_seconds ,EXTRACT(DAY FROM r.cpu_used)*24*60*60 + EXTRACT(HOUR FROM r.cpu_used)*60*60 + EXTRACT(MINUTE FROM r.cpu_used)*60 + EXTRACT(SECOND FROM r.cpu_used) cur_cpu_seconds ,NVL(l.status,'NEVER RUN') as last_run_status from dba_scheduler_jobs j ,dba_scheduler_running_jobs r ,(select owner ,job_name ,NVL(job_subname,'xxx') as job_subname , status from dba_scheduler_job_run_details d1 ,(select max(log_id) as log_id from dba_scheduler_job_run_details group by owner,job_name,job_subname) d2 where d1.log_id = d2.log_id) l where j.owner = r.owner (+) and j.job_name = r.job_name (+) and j.job_subname = r.job_subname (+) and j.owner = l.owner (+) and j.job_name = l.job_name (+) and NVL(j.job_subname,'xxx') = l.job_subname (+) and j.schedule_type != 'ONCE' and NOT (l.status IS NULL and r.elapsed_time IS NULL) and j.last_start_date > sysdate - 90 "] at /home/monocle/src/lib/bg/bg_data_collector.pm line 104.