ODI Studio Operator: All ODI Load Plan Executions Are Shown for Each of the Users, Regardless of Which User Executed the Load Plan (Doc ID 2903430.1)

Last updated on MAY 23, 2023

Applies to:

Symptoms

The following issue is observed in Oracle Data integrator (ODI) 12c Studio > Operator UI,  when attempting to consult the Load Plans executed by an user:

• The count of the number of Load Plans executed by a User U1 shows correctly.
    
• However, expanding the user U1 view, ODI will show all Load Plans executed, regardless to the user who performed the execution. To be correct, ODI should show only the Load Plans executed by the user U1.

The behavior can be replicated at will using the following steps:

1. Start the ODI Agent.
     
2. Start ODI Studio, and connect as SUPERVISOR (or another user, having supervisor role).
     
3. In ODI Studio > Security, create two non-supervisor users:   User1, and User2.
   
   Grant CONNECT and DESIGNER profiles to both the users.
    
4. Create two Load Plans:   LP_User1, and LP_User2.
     
5. Disconnect from ODI Studio, and connect as user User1.
   
   Execute the Load Plan "LP_User1", once.
     
6. Disconnect from ODI Studio, and connect as user User2
   
   Execute the Load Plan "LP_User2", twice.
     
7. Connected to ODI Studio as any user (SUPERVISOR, User1 or User2)
   
   Navigate to the Operator view > Load Plan Executions.
   
   Expand the "User" tree-view.
   
   Observe there are actually 2 entries, showing a number of executions right to the user name:
   
      User1 - 1
      User2 - 2
   
   This is correct.
     
8. Expand the view for any of the users, and observe that all the LP executions show for each of them:
   
      User1:  Shows 3 LP executions: one that belongs to himself and should be shown... but also the 2 executions of User2.
      User2:  Shows 3 LP executions: two that belong to himself and should be shown... but also one execution of User1
   
   This is incorrect.
    
9. Edit the execution of -- for example -- Load Plan "LP_User1", and observe that the "Started By" shows the correct user.
   
   This is correct.

Changes

Cause