AWM: Errors retrieving and creating workspaces
876761Jul 20 2011 — edited Jul 22 2011Hi there, I'm a complete OLAP newb and attempting to use Analytic Workspace Manager to experiment with workspaces on an 11g database (Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production) with the OLAP option enabled.
I have downloaded AWM (11.2.0.2.0A Patch) from here: http://www.oracle.com/technetwork/database/options/olap/olap-downloads-098860.html
I can connect to the database (on a machine that is not under my control), but on connection, I receive the following error:
"java.sql.SQLException: ORA-00942: table or view does not exist
at oracle.olap.awm.businessobject.aw.WorkspaceBO.getWorkspacesOwnedBySchema(Unknown Source)
at oracle.olap.awm.navigator.node.WorkspaceFolderNode.getChildren(Unknown Source)
at oracle.olap.awm.navigator.node.BaseNodeModel.refreshData(Unknown Source)
at oracle.olap.awm.navigator.node.BaseNodeModel.dTreeItemExpanding(Unknown Source)
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(Unknown Source)
at oracle.olap.awm.navigator.node.BaseNode.access$400(Unknown Source)
at oracle.olap.awm.navigator.node.BaseNode$ExpansionThread.run(Unknown Source)"
If I then try to create a workspace, I recieve the following error:
ORA-06550: line 1, column 13:
PLS-00201: identifier 'OLAPIBOOTSTRAP2' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
I have searched the web and found no information on these errors, a handful of others with the problem but no resolutions.
Any ideas?
TIA
Dominic