My Oracle Support Banner

ESRI GIS AItoCentricity Extraction Fails with " Insufficient permissions" Error (Doc ID 2722465.1)

Last updated on OCTOBER 28, 2020

Applies to:

Oracle Utilities Network Management System - Version 2.3.0.2.0 and later
Oracle Network Management for Utilities - DMS - Version 2.3.0.2.0 and later
Information in this document applies to any platform.

Symptoms

On : 2.4.0.1.0 version, Adapters

ESRI GIS extraction error with insufficient privilege on a relationship table

Using the NMS ESRI GIS Adapter (AItoCentricity), I attempted to extract feeders from the GIS.  The extractor built a list of feeders, and then failed on the first feeder extract because of insufficient privilege on one of the underlying tables.
The table mentioned (<TableA>_<TableB>) is not a member of the electric data set. It is a relationship table between <TableA> and <TableB>.
We want <TableB> to be extracted, but not interested in <TableA>.    Note that <TableA> also is not an Electric Dataset feature.


ERROR

0/10/06 10:51:46.911 *Error* - THE FOLLOWING ERROR WAS ENCOUNTERED WHILE PROCESSING
20/10/06 10:51:46.911 *Error* -
Error encountered in mdlESRItoCESTools.bas.ControlExtraction
#-2147216100 - Insufficient permissions [<owner>.<TableA>_<TableB>][STATE_ID = 14534045]:Line : 1078
20/10/06 10:51:46.911 *Error* - EXITING APPLICATION



Changes

 This is occurring on a newly established project.  No GIS extraction has been done before.

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


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