Work with DB for resolution of hang up process

Prerequisites
---------------
1. Shutdown all Idm servers .
2. Backup the Oracle IdM repository is a must
3. Get a DBA who familiar with Oracle SQL-PLUS and executes SQL
statements in the next action plan.

Next Action Plan
------------------

1. Execute the select query to find the id of TaskInstance Source
Adapter    from the database.

SELECT * FROM task WHERE TYPE = 'TaskInstance' AND name LIKE 'SOURCE
ADAPTER%'
------------------------------------------------------------------------
-------------------------------------
ID                           name                             lockinfo
------------------------------------------------------------------------
-------------------------------------
#ID#YourID      SOURCE ADAPTER TASK  NULL

SELECT * FROM taskattr where id   = '#ID#YourID'
SELECT * FROM taskchange where id = '#ID#YourID'



2. Remove the TaskInstance Source Adapter Task
from database if it exists.
  
     If SELECT * FROM taskchange where id = '#ID#YourID' returns 1 or
more records, then issue delete SQL as below

       DELETE FROM taskchange where id = '#ID#YourID'


     If SELECT * FROM taskattr where id = '#ID#YourID' returns 1 or more
records, then issue delete SQL as below

        DELETE FROM taskattr where id = '#ID#YourID'

     If SELECT * FROM task WHERE TYPE = 'TaskInstance' AND name LIKE
'SOURCE ADAPTER%' returns a record with
     "SOURCE ADAPTER TASK ",  then issue delete
SQL as below
       
      DELETE FROM task where id = '#ID#YourID'        

  Remark : Depends on customer's environment, SELECT * FROM task.. may
return more 1 than record
           where their name column contains server name. In such a case,
delete all Source Adapter Task
          
   
       

3. Execute the select query to find the id of TaskSchedule Source
Adapter Task    from the database.   
 
      SELECT * FROM object WHERE TYPE = 'TaskSchedule' AND name LIKE
'SOURCE ADAPTER%'

------------------------------------------------------------------------
-------------------------------------
      ID                           name                          

------------------------------------------------------------------------
-------------------------------------
      #ID#YourTaskScheduleID      SOURCE ADAPTER TASK

   
   
       SELECT * FROM attribute where id = '#ID#YourTaskScheduleID'
       SELECT * FROM objchange where id = '#ID#YourTaskScheduleID'


      If SELECT * FROM objchange where id = '#ID#YourTaskScheduleID'
returns 1 or more records, then issue delete SQL as below

         DELETE FROM objchange where id = '#ID#YourTaskScheduleID'
       
      If SELECT * FROM attribute where id = '#ID#YourTaskScheduleID'
returns 1 or more records, then issue delete SQL as below       

         DELECT FROM attribute where id = '#ID#YourTaskScheduleID'
      
      If SELECT * FROM object WHERE TYPE = 'TaskSchedule' AND name LIKE
'SOURCE ADAPTER% returns 1 or more records, then issue delete SQL as
below       
      
         DELECT FROM object where id = '#ID#YourTaskScheduleID'
      
                     
       Remark : Depends on customer's environment, SELECT * FROM
object.. may return more 1 than record
                where their name column contains server name. In such a
case, delete all Source Adapter Task schedule
                contains server name.