2 Replies Latest reply on Oct 9, 2012 6:13 AM by 942827

    Help-Task not found - Please check the Task Type, Name and Location are cor

      HI all,

      i have upgraded my owb from version 11gr1 to 11gr2. the installation is complete and all my mappings and objects are imported successfully.
      i was able to execute the mappings using the sql code:


      by logging into sqlplus as the user in whose schema mappings are deployed.

      hOwever, suddenly i am getting the error since sometime back - not sure what might have happened or what might have gone wrong. can someone please help me understand what might be wrong - how to decode this?

      Here is my error:
      Role set.
      Enter value for 1: WSODS
      Call completed.
      Enter value for 2: ODS_SCHEMA
      Enter value for 3: PLSQLMAP
      Enter value for 4: MAPPING_1
      Enter value for 6: ","
      Enter value for 5: ","
      Stage 1: Decoding Parameters
      |  location_name=ODS_SCHEMA
      |  task_type=PLSQLMAP
      |  task_name=MAPPING_1
      Stage 2: Opening Task
      ERROR at line 1:
      ORA-20001: Task not found - Please check the Task Type, Name and Location are
      ORA-06512: at "OWBSYS.WB_RT_API_EXEC", line 759
      ORA-06512: at "OWBSYS.WB_RT_SCRIPT_UTIL", line 910
      ORA-06512: at line 2
      When i execute this: i get the result as follows:
      SELECT warehouse_object_id, store_id, object_type_id, object_type_name, object_name FROM owb$wb_rt_warehouse_objects
      where object_name = 'MAPPING_1';
      WAREHOUSE_OBJECT_ID     STORE_ID                OBJECT_TYPE_ID          OBJECT_TYPE_NAME                                                 OBJECT_NAME                                                      
      ----------------------- ----------------------- ----------------------- ---------------------------------------------------------------- ---------------------------------------------------------------- 
      15947                   15325                   769                     PLSQLMap                                                         MAPPING_1                                                        
      1 rows selected
      Edited by: Chaitanya on Mar 5, 2012 3:33 AM