Database Software

Hello,

My OWB version is 11.1.0.7. I recently migrated the mapping to new server and mapping works well. When i start the workflow manually, it wroks well.
The job is scheduled at 12:50AM.

SQL> select state,failure_count, enabled from dba_scheduler_jobs
2 where owner='IAEBT_DW' and job_name='PF_JOB';

STATE FAILURE_COUNT ENABLED
--------------------------------------------- ------------- ---------------
RUNNING 0 TRUE

SQL>

SQL> l
1 select job_name, value from dba_scheduler_job_args
2* where job_name = 'PF_JOB'
SQL> /

JOB_NAME VALUE
-------------------- --------------------
PF_JOB 3101
PF_JOB ScheduledJob
PF_JOB PF_JOB
PF_JOB IAEBT_DW
PF_JOB PF_JOB
PF_JOB PlatformSchema
PF_JOB PF
PF_JOB PlatformSchema
PF_JOB IAEBT_OWBOWNER
PF_JOB IAEBT_WSPACE

10 rows selected.

Here is the problem.

The job is started at 12:50AM exactly and it is keep running. It has been more than 10 hours now. It is not completing. It has not loaded any data in data mart.
I checked the last_ddl_time in all tables. The date is not changed. My very first mapping load the data in ETL_START table. But that table has not changed.

Here is the lock on the tables.


SQL> select b.username,b.sid,c.object_name object, c.object_type,
2 b.osuser
3 from v$lock a, v$session b, all_objects c
4 where
5 a.sid = b.sid and c.object_id = a.id1 and
6 (a.type = 'TX' or a.type='TM')
7 /

USERNAME SID OBJECT OBJECT_TYPE OSUSER
------------------------------ ---------- ------------------------------ ------------------- -------
IAEBT_OWBOWNER 879 CMPSCOCFGCLASSES TABLE oracle
IAEBT_OWBOWNER 879 CMPFCOCLASSES TABLE oracle
IAEBT_OWBOWNER 879 ALLINTERLINK TABLE oracle
IAEBT_OWBOWNER 879 ALLINTRALINK TABLE oracle
IAEBT_DW 944 WB_RT_NOTIFY_QUEUE_TAB TABLE oracle

SQL>
SQL>

How do i trouble shoot this issue?