My Oracle Support Banner

Datastores Show Empty when an ODI 12c Non-Supervisor User Edits a Mapping Using Them (Doc ID 2537978.1)

Last updated on MAY 06, 2019

Applies to:

Oracle Data Integrator - Version 12.1.2.0.0 and later
Information in this document applies to any platform.

Symptoms

An Oracle Data Integrator (ODI) 12c non-supervisor user has been granted with full access on Models and Projects.

When the non-supervisor user views / edits a Mapping and navigates to the "Logical" tab, the Datastores that the Mapping contains are shown as white / empty boxes: The Datastore properties, Attributes, Model, Schema, etc are not shown.

In addition, when navigating to the "Physical" tab, the following "READ permission" error is received:

...
Caused by: oracle.odi.core.security.PermissionDeniedException: ODI-10134: You do not have READ permission on at least one object from the collection/list.
    at oracle.odi.core.persistence.toplink.support.OdiIndirectList.toArray(OdiIndirectList.java:256)
    at java.util.Collections$UnmodifiableCollection.toArray(Collections.java:1033)
    at java.util.ArrayList.addAll(ArrayList.java:577)
    at oracle.odi.domain.model.OdiDataStore.getColumns(OdiDataStore.java:788)
    at oracle.odi.domain.mapping.component.DefaultDelegate$DefaultConnectorPointDelegate.syncWithDataStore(DefaultDelegate.java:187)
    at oracle.odi.domain.mapping.component.DefaultDelegate$DefaultConnectorPointDelegate.customSyncConnectorPoint(DefaultDelegate.java:125)
    at oracle.odi.domain.mapping.MapConnectorPoint.syncConnectorPoint(MapConnectorPoint.java:2775)
    at oracle.odi.domain.mapping.MapComponent.syncComponent(MapComponent.java:562)
    at oracle.odi.domain.mapping.MapRootContainer.syncMapping(MapRootContainer.java:1018)
    at oracle.odi.domain.mapping.MapRootContainer.syncMapping(MapRootContainer.java:983)
    at oracle.odi.window.node.AbsOdiNavTreeNode.updateEntity(AbsOdiNavTreeNode.java:515)
    ... 52 more

The issue can be reproduced at will with the following steps:

  1. In ODI Studio > Security, create a non-supervisor user.
              
  2. Grant Profiles:

         CONNECT
         --> View on Logical Schema and Physical Schema must be set as generic

         NG DESIGNER
         --> View on Sub-Model and Datastore must be set as generic
         --> Edit and View on Interface must be set as generic
         --> View on Column must be set as non-generic

         NG METADATA ADMIN
         --> View on Language and Language Element must be set as generic
         --> View on Column must be set as non-generic

         OPERATOR
      
  3. Edit any Mapping, and identify the Models involved.

    Notice the Project which holds the Mapping.
      
  4. Grant to that user the Project and Models that the Mapping uses.
              
  5. Disconnect from ODI Studio, and re-connect with the non-supervisor user above.
           
  6. Edit the Mapping and observe:
    • The empty boxes shown for the Datastores that the Mapping uses...
    • The ODI-10153 error messages shown in the **Log** window...
NOTE: In the images and examples above or below any data, names, etc. represent a fictitious sample.  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.