Getting Error "ORA-01031: insufficient privileges" - Unable To Save View Areas in a Migrated 2.5 Environment
(Doc ID 2783229.1)
Last updated on JUNE 09, 2021
Applies to:
Oracle Utilities Network Management System - Version 2.5.0.0.0 to 2.5.0.1.0 [Release 2.5]Oracle Network Management for Utilities - DMS - Version 2.5.0.0.0 to 2.5.0.1.0 [Release 2.5]
Information in this document applies to any platform.
Symptoms
On : 2.5.0.0.0 version, Installation
We found that we cannot save view areas in our migrated 2.5 environment.
Ran into an issue when testing web switching on a migration 2.5.0 system. It looks like it is related to the view_area table.
Error
Error Code: 1031
Call: INSERT INTO VIEW_AREA (AREA_KEY, AREA_NAME, CATEGORY, COORD_SYSTEM,
SECONDARY_X_MAX, SECONDARY_X_MIN, SECONDARY_Y_MAX, SECONDARY_Y_MIN,
VIEWER_NAME, X_MAX, X_MIN, Y_MAX, Y_MIN) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?)
bind => [13 parameters
bound]],numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since
begin=0,seconds left=60,useSecure=false,XAServerResourceInfo[JDBC Data
Source-sdge1_1_nms_12214]=(ServerResourceInfo[JDBC Data
sync=org.eclipse.persistence.transaction.JTASynchronizationListener@124c88be
Exception [EclipseLink-4002] (Eclipse Persistence Services -
2.6.7.v20190604-418f1a1c56):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient
privileges
Expect that - Users should be able to create and save view areas.
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 |
| Fix Description |
| Migration |
| References |