My Oracle Support Banner

ORA-00942 Occurred Connecting To The Database While Opening OLAP AW (Doc ID 461528.1)

Last updated on NOVEMBER 07, 2022

Applies to:

Oracle OLAP - Version 10.1.0.2 and later
Information in this document applies to any platform.

Goal

This Document discuses ORA-00942 when trying to open an OLAP AW.

Error:

Unable to Attach to Analytic  Workspace NAME_AW.AGING
oracle.AWXML.AWException: java.lang.NullPointerException
at oracle.AWXML.AW.readAWDefinitions(AW.java:1341)
at oracle.olap.awm.dataobject.aw.WorkspaceDO.getModelAW(WorkspaceDO.java:739)
at  oracle.olap.awm.dataobject.aw.WorkspaceDO.getModelAW(WorkspaceDO.java:701)
at  oracle.olap.awm.navigator.node.WorkspaceNode.getModelerViewChildren(WorkspaceNode.java:361)
at oracle.olap.awm.navigator.node.WorkspaceNode.getChildren(WorkspaceNode.java:342)
at oracle.olap.awm.navigator.node.BaseNodeModel.refreshData(BaseNodeModel.java:74)
at oracle.olap.awm.navigator.node.BaseNodeModel.dTreeItemExpanding(BaseNodeModel.java:221)
at oracle.bali.ewt.dTree.DTreeDeferredParent.__fireExpansionChanging(Unknown Source)
at oracle.bali.ewt.dTree.DTreeDeferredParent.setExpanded(Unknown Source)
at oracle.olap.awm.navigator.node.BaseNode.expandHelper(BaseNode.java:1853)

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.