This discussion is archived
1 Reply Latest reply: Dec 22, 2012 6:12 AM by 563840 RSS

AWM connection issues

563840 Newbie
Currently Being Moderated
Hello all,

I am trying to connect to our database using AWM. Here are the versions:

AWM: awm112030A_Standalone
Client Machine: Windows Server 2003

Database:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

I am connecting using hostname:port/servicename. I can successfully connect but the 'connect to database' dialog does not go away. I know I am connected to the database - I checked on the database and could see my connection.
Also, on the database I ran the following query to see if OLAP is installed properly:

SELECT comp_name, version, status FROM DBA_REGISTRY
WHERE comp_name LIKE '%OLAP%';

Results:

COMP_NAME     VERSION     STATUS

OLAP Analytic Workspace     11.2.0.1.0     VALID
Oracle OLAP API     11.2.0.1.0     VALID
OLAP Catalog     11.2.0.1.0     VALID



I turned on logging from the client and the following is the error in the log file - any help is appreciated.

Thanks
Praveen

02012.December.21 AD 05:33:45:0491 PM [ERR] SwingUtilWrapperThread.run() Exception:
java.lang.reflect.InvocationTargetException
     at java.awt.EventQueue.invokeAndWait(Unknown Source)
     at javax.swing.SwingUtilities.invokeAndWait(Unknown Source)
     at oracle.olap.awm.util.SwingUtilWrapperThread.run(SwingUtilitiesWrapper.java:89)
Caused by: java.lang.AbstractMethodError: oracle.jdbc.driver.OraclePreparedStatementWrapper.setPoolable(Z)V
     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
     at java.lang.reflect.Method.invoke(Unknown Source)
     at oracle.ucp.jdbc.proxy.StatementProxyFactory.setStatementPooling(StatementProxyFactory.java:310)
     at oracle.ucp.jdbc.proxy.StatementProxyFactory.<init>(StatementProxyFactory.java:139)
     at oracle.ucp.jdbc.proxy.PreparedStatementProxyFactory.<init>(PreparedStatementProxyFactory.java:83)
     at oracle.ucp.jdbc.proxy.PreparedStatementProxyFactory.createPreparedStatementProxy(PreparedStatementProxyFactory.java:66)
     at oracle.ucp.jdbc.proxy.ConnectionProxyFactory.proxyInvokeAfterTargetInvoke(ConnectionProxyFactory.java:145)
     at oracle.ucp.jdbc.proxy.JDBCConnectionProxyFactory.invoke(JDBCConnectionProxyFactory.java:276)
     at $Proxy0.prepareStatement(Unknown Source)
     at oracle.olap.awm.util.jdbc.SQLWrapper.execute(SQLWrapper.java:70)
     at oracle.olap.awm.util.jdbc.SQLWrapper.execute(SQLWrapper.java:34)
     at oracle.olap.awm.businessobject.SchemaBO.getSchemas(SchemaBO.java:294)
     at oracle.olap.awm.navigator.node.SchemaFolderNode.getChildren(SchemaFolderNode.java:145)
     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.setExpandedAndWait(BaseNode.java:308)
     at oracle.olap.awm.navigator.node.BaseNode.expandNode(BaseNode.java:2101)
     at oracle.olap.awm.navigator.node.DatabaseNode.itemExpanded(DatabaseNode.java:323)
     at oracle.olap.awm.navigator.node.BaseNodeModel.dTreeItemExpanded(BaseNodeModel.java:247)
     at oracle.bali.ewt.dTree.DTreeDeferredParent.__fireExpansionChanged(Unknown Source)
     at oracle.bali.ewt.dTree.DTreeDeferredParent.setExpanded(Unknown Source)
     at oracle.olap.awm.navigator.node.BaseNode.expandHelper(BaseNode.java:2264)
     at oracle.olap.awm.navigator.node.BaseNode.access$600(BaseNode.java:96)
     at oracle.olap.awm.navigator.node.BaseNode$ExpansionThread$1.run(BaseNode.java:2226)
     at java.awt.event.InvocationEvent.dispatch(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)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points