My Oracle Support Banner

OUA MVs Fail During Job Execution (Doc ID 2833662.1)

Last updated on JANUARY 24, 2022

Applies to:

Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.7.0.1.0 and later
Information 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


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