OUA MVs Fail During Job Execution
(Doc ID 2833662.1)
Last updated on JUNE 03, 2024
Applies to:
Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.7.0.1.0 and laterInformation in this document applies to any platform.
Goal
On: 2.7.0.1.2 version, METERDATA - Meter Data Analytics
OUA MVs fail during Job execution
OUA 2.7.0.1.2 version is configured with MDM and NMS. The MDM database is in
CHAR Semantics and hence OUA Database is also in CHAR Semantics. The
dimension and fact jobs are executed but when the Materialized view jobs are
enabled, they are erroring out with the below error: "ORA-01450: maximum key
length (6398) exceeded "
We have checked the space in the Database and that is not the issue. Do we
have to increase the DB Block size from 8K to 32K, since the database is in
CHAR semantics?
Solution
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
Goal |
Solution |
References |