Forum Stats

  • 3,825,769 Users
  • 2,260,558 Discussions
  • 7,896,671 Comments

Discussions

Unable to Attach to Analytic Workspace

4125848
4125848 Member Posts: 2
edited Dec 10, 2019 2:34PM in OLAP

hi,

I am facing an issue in my AWM 12c when I try to create an analytic workspace it gives me below error. I have googled it but haven't find any solution yet.

Unable to Attach to Analytic Workspace GLOBAL_AW.SS

oracle.AWXML.AWException: java.lang.NullPointerException

at oracle.AWXML.AW.readAWDefinitions(Unknown Source)

at oracle.olap.awm.dataobject.aw.WorkspaceDO.getModelAW(WorkspaceDO.java:1089)

at oracle.olap.awm.dataobject.aw.WorkspaceDO.getModelAW(WorkspaceDO.java:1035)

at oracle.olap.awm.navigator.node.WorkspaceNode.getModelerViewChildren(WorkspaceNode.java:480)

at oracle.olap.awm.navigator.node.WorkspaceNode.getChildren(WorkspaceNode.java:429)

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(DTreeDeferredParent.java:585)

at oracle.bali.ewt.dTree.DTreeDeferredParent.setExpanded(DTreeDeferredParent.java:425)

at oracle.olap.awm.navigator.node.BaseNode.expandHelper(BaseNode.java:2716)

at oracle.olap.awm.navigator.node.BaseNode.access$600(BaseNode.java:109)

at oracle.olap.awm.navigator.node.BaseNode$ExpansionThread$1.run(BaseNode.java:2678)

at java.awt.event.InvocationEvent.dispatch(Unknown Source)

at java.awt.EventQueue.dispatchEventImpl(Unknown Source)

at java.awt.EventQueue.access$500(Unknown Source)

at java.awt.EventQueue$3.run(Unknown Source)

at java.awt.EventQueue$3.run(Unknown Source)

at java.security.AccessController.doPrivileged(Native Method)

at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)

at java.awt.EventQueue.dispatchEvent(Unknown Source)

at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)

at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)

at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

at java.awt.EventDispatchThread.run(Unknown Source)

Caused by: java.lang.NullPointerException

... 26 more

Tagged:
4125848

Answers

  • Ken Chin OLAP Option-Oracle
    Ken Chin OLAP Option-Oracle Member Posts: 133 Employee
    edited Nov 8, 2019 8:38AM

    Hi

    From the stack trace it looks like AWM is trying to attach an AW while the database is in Cube Type of 10g mode.

    Would you please verify the Cube Type of your database by going into AWM and selecting the database connection node of your instance?

    After selecting the connection node in the tree on the left, you should see a property panel on the right which will show which Cube Type "mode" you are using.

    Unless trying to attach a legacy AW that was created in 10g, you should be using Cube Type 11g or above.

    Thank you,

    Ken Chin

    4125848
  • 4125848
    4125848 Member Posts: 2
    edited Nov 26, 2019 2:24AM

    hi ken,

    I have seen in the property panel of connection node it is 10g cube type and I still getting this error,

    i am using analytical workplace manager 12 but my database is 10g, and i also select cube type 10g, but still the same error.

  • Ken Chin OLAP Option-Oracle
    Ken Chin OLAP Option-Oracle Member Posts: 133 Employee
    edited Dec 10, 2019 2:34PM

    Would you please open the OLAP Worksheet in AWM and then try to attach the workspace GLOBAL_AW.SS via OLAP DML commands?

    >aw list

    >aw attach GLOBAL_AW.SS ro

    Assuming no errors, then type

    >aw list

    to see the list of attached AW's.