can not load file:/c:/JDev9i_rc2/....  on jdev - BI Beans(Archived)

I create a cross table on jdev,get the info:
can not load file:/c:/JDev9i_rc2/jdev/mywork/olap/olap/src/bidefs/olapBDesigner1/sale crosstab.xml
errors:
org.omg.CORBA.OBJECT_NOT_EXIST: minor code: 0 completed: No
     void org.omg.CORBA.OBJECT_NOT_EXIST.<init>(java.lang.String)
     void org.omg.CORBA.OBJECT_NOT_EXIST.<init>()
     com.inprise.vbroker.ProtocolEngine.ProtocolConnector com.inprise.vbroker.ProtocolEngine.PortfolioImpl.getConnector(long)
     com.inprise.vbroker.ProtocolEngine.ProtocolConnector com.inprise.vbroker.ProtocolEngine.ManagerImpl.getConnector(org.omg.CORBA.Object, com.inprise.vbroker.IOP.IORValue, long)
     void com.inprise.vbroker.orb.DelegateImpl._bind(org.omg.CORBA.Object, boolean)
     void com.inprise.vbroker.orb.DelegateImpl.verifyConnection(org.omg.CORBA.Object, boolean)
     boolean com.inprise.vbroker.orb.DelegateImpl.is_local(org.omg.CORBA.Object)
     boolean org.omg.CORBA.portable.ObjectImpl._is_local()
     void oracle.express.idl.ExpressConnectionModule._ConnectionInterfaceStub.close()
     void oracle.express.connection.Connection.close()
     int oracle.dss.connection.server.drivers.mdm.MDMConnectionDriverImpl.disconnect()
     int oracle.dss.connection.server.drivers.mdm.MDMConnectionDriverImpl.connect()
     oracle.dss.metadataUtil.PropertyBag oracle.dss.connection.server.drivers.mdm.MDMConnectionDriverImpl.connect(oracle.dss.metadataUtil.PropertyBag)
     oracle.dss.connection.common.ConnectionObj oracle.dss.connection.server.ConnectionImpl.connect(oracle.dss.connection.common.ConnectionObj, oracle.dss.metadataUtil.PropertyBag)
     int oracle.dss.connection.client.Connection.connect(oracle.dss.metadataUtil.PropertyBag)
     int oracle.dss.connection.client.Connection.connect()
     int oracle.dss.metadataManager.client.MetadataManager.setConnectionObjects(java.util.Vector)
     int oracle.dss.metadataManager.client.MetadataManager.attach(oracle.dss.metadataUtil.PropertyBag)
     int oracle.dss.metadataManager.client.MetadataManager.attach()
     oracle.dss.metadataManager.client.MetadataManager oracle.dss.addins.designer.BIDesignerImpl.getMetadataManager(boolean)
     oracle.dss.metadataManager.client.MetadataManager oracle.dss.addins.designer.BIDesignerImpl.getMetadataManager(boolean, boolean)
     oracle.dss.metadataManager.client.MetadataManager oracle.dss.addins.designer.BIDesignerImpl.getMetadataManager(boolean, boolean)
     void oracle.dss.addins.designer.BIObjectNode.internalLoad()
     java.lang.Object oracle.dss.addins.designer.BIObjectNode.getLiveInstance(oracle.dss.addins.editor.presentation.DisplayWaitMessage)
     oracle.dss.addins.editor.presentation.PresentationEditor$PresPanel oracle.dss.addins.editor.presentation.PresentationEditor.createPresPanel(oracle.ide.model.Element)
     java.awt.Component oracle.dss.addins.editor.presentation.PresentationEditor.getGUI()
     boolean oracle.ideimpl.editor.BarEditorFrameImpl.activateEditor(oracle.ide.editor.Editor)
     oracle.ide.editor.Editor oracle.ideimpl.editor.EditorFrameImpl.activateEditor(java.lang.Class, oracle.ide.addin.Context)
     oracle.ide.editor.Editor oracle.ideimpl.editor.EditorDesktop.activateEditor(java.lang.Class, oracle.ide.addin.Context)
     oracle.ide.editor.Editor oracle.ideimpl.editor.BarEditorManagerImpl.openEditorInFrame(java.lang.Class, oracle.ide.addin.Context)
     oracle.ide.editor.Editor oracle.ideimpl.editor.EditorManagerImpl.openDefaultEditorInFrame(oracle.ide.addin.Context)
     boolean oracle.ideimpl.editor.EditorManagerImpl.handleDefaultAction(oracle.ide.addin.Context)
     boolean oracle.ide.ContextMenu.fireDefaultAction(oracle.ide.addin.Context)
     void oracle.ideimpl.explorer.BaseTreeExplorer.fireDefaultAction(java.awt.event.InputEvent)
     void oracle.ideimpl.explorer.BaseTreeExplorer.dblClicked(java.awt.event.MouseEvent)
     void oracle.ideimpl.explorer.BaseTreeExplorer.mouseReleased(java.awt.event.MouseEvent)
     void oracle.ideimpl.explorer.CustomTree.processMouseEvent(java.awt.event.MouseEvent)
     void java.awt.Component.processEvent(java.awt.AWTEvent)
     void java.awt.Container.processEvent(java.awt.AWTEvent)
     void java.awt.Component.dispatchEventImpl(java.awt.AWTEvent)
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
     void java.awt.LightweightDispatcher.retargetMouseEvent(java.awt.Component, int, java.awt.event.MouseEvent)
     boolean java.awt.LightweightDispatcher.processMouseEvent(java.awt.event.MouseEvent)
     boolean java.awt.LightweightDispatcher.dispatchEvent(java.awt.AWTEvent)
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
     void java.awt.Window.dispatchEventImpl(java.awt.AWTEvent)
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
     void java.awt.EventQueue.dispatchEvent(java.awt.AWTEvent)
     boolean java.awt.EventDispatchThread.pumpOneEventForHierarchy(java.awt.Component)
     void java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Conditional, java.awt.Component)
     void java.awt.EventDispatchThread.pumpEvents(java.awt.Conditional)
     void java.awt.EventDispatchThread.run()
what's happened?
how to do? 

Can you state what you did?
also, can you confirm if the following file exists?
c:/JDev9i_rc2/jdev/mywork/olap/olap/src/bidefs/olapBDesigner1/sale crosstab.xml
Thanks 

because tables contain chinese,it make olap service shutdown.
when create dim not use chinese and use english,and tables not contain chinese,the olap run OK and will not occur the errors on solaris.
if on windows,chinese can't display normal.
why can olap services not support chinese?

Related

Test OLAP connection gives error message - BIB 16613 using BIBeans 9.0.3

Anybody's help will be much appreciated on the problem below. Thank you
************************************************************************************
Client:
Oracle JDeveloper 9.0.3 Preview
BI Beans 9.0.3 Preview
Server:
Oracle9i Release 2 for Windows
Oracle OLAP 9.2.0.1.0A patch for Windows
Symptoms:
Unable to Test Olap connection
Exception chain
oracle.dss.security.BISecurityException: BIB-16613 Database access error occurred while connecting to the OLAP instance.
java.sql.SQLException: ORA-28009: connection to sys should be as sysdba or sysoper
     java.lang.Object oracle.dss.connection.server.drivers.mdm.MDMPluggableConnectionDriverImpl.connectToDatabase(java.util.Hashtable)
          MDMPluggableConnectionDriverImpl.java:141
     java.lang.Object oracle.dss.connection.server.drivers.mdm.MDMPluggableConnectionDriverImpl.connect(java.util.Hashtable)
          MDMPluggableConnectionDriverImpl.java:40
     oracle.dss.metadataUtil.PropertyBag oracle.dss.connection.server.drivers.mdm.MDMConnectionDriverImpl.connect(oracle.dss.metadataUtil.PropertyBag)
          MDMConnectionDriverImpl.java:149
     oracle.dss.connection.common.ConnectionObj oracle.dss.connection.server.ConnectionImpl.connect(oracle.dss.connection.common.ConnectionObj, oracle.dss.metadataUtil.PropertyBag)
          ConnectionImpl.java:279
     int oracle.dss.connection.client.Connection.connect(oracle.dss.metadataUtil.PropertyBag)
          Connection.java:401
     int oracle.dss.connection.client.Connection.connect()
          Connection.java:320
     oracle.dss.connection.client.Connection oracle.dss.addins.designer.BIDesignerImpl.getOlapConnection()
          BIDesignerImpl.java:888
     oracle.dss.metadataManager.client.MetadataManager oracle.dss.addins.designer.BIDesignerImpl.getMetadataManager(boolean)
          BIDesignerImpl.java:962
     oracle.dss.metadataManager.client.MetadataManager oracle.dss.addins.designer.BIDesignerImpl.getMetadataManager(boolean, boolean)
          BIDesignerImpl.java:927
     void oracle.dss.addins.wizard.calc.CalcWizardContext.initMetadataManager()
          CalcWizardContext.java:65
     void oracle.dss.addins.wizard.calc.CalcWizardContext.setDesigner(oracle.dss.addins.designer.BIDesigner)
          CalcWizardContext.java:86
     boolean oracle.dss.addins.common.wizard.BIDesignerPanel.validateAndWriteToState(oracle.ide.wizard.BaliWizardState)
          BIDesignerPanel.java:222
     boolean oracle.dss.addins.common.wizard.BIDesignerPanel.setActive(boolean)
          BIDesignerPanel.java:195
     boolean oracle.dss.datautil.gui.DefaultBuilderDialog.setActive(java.lang.String, boolean)
          DefaultBuilderDialog.java:1064
     boolean oracle.dss.datautil.gui.DefaultBuilderDialog.validateNextPreviousEvent(oracle.bali.ewt.wizard.WizardEvent)
          DefaultBuilderDialog.java:1388
     void oracle.dss.datautil.gui.DefaultBuilderDialog$BuilderWizardValidateAdapter.wizardValidatePage(oracle.bali.ewt.wizard.WizardEvent)
          DefaultBuilderDialog.java:2105
     void oracle.bali.ewt.wizard.WizardPage.processWizardValidateEvent(oracle.bali.ewt.wizard.WizardValidateEvent)
     boolean oracle.bali.ewt.wizard.WizardPage.validatePage()
     boolean oracle.dss.datautil.gui.CustomImageWizardPage.validatePage()
          CustomImageWizardPage.java:81
     boolean oracle.bali.ewt.wizard.BaseWizard.validateSelectedPage()
     void oracle.bali.ewt.wizard.BaseWizard.doNext()
     void oracle.dss.datautil.gui.CustomWizard.doNext()
          CustomWizard.java:415
     void oracle.bali.ewt.wizard.BaseWizard$Action.actionPerformed(java.awt.event.ActionEvent)
     void javax.swing.AbstractButton.fireActionPerformed(java.awt.event.ActionEvent)
          AbstractButton.java:1450
     void javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(java.awt.event.ActionEvent)
          AbstractButton.java:1504
     void javax.swing.DefaultButtonModel.fireActionPerformed(java.awt.event.ActionEvent)
          DefaultButtonModel.java:378
     void javax.swing.DefaultButtonModel.setPressed(boolean)
          DefaultButtonModel.java:250
     void javax.swing.plaf.basic.BasicButtonListener.mouseReleased(java.awt.event.MouseEvent)
          BasicButtonListener.java:216
     void java.awt.Component.processMouseEvent(java.awt.event.MouseEvent)
          Component.java:3715
     void java.awt.Component.processEvent(java.awt.AWTEvent)
          Component.java:3544
     void java.awt.Container.processEvent(java.awt.AWTEvent)
          Container.java:1164
     void java.awt.Component.dispatchEventImpl(java.awt.AWTEvent)
          Component.java:2593
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
          Container.java:1213
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
          Component.java:2497
     void java.awt.LightweightDispatcher.retargetMouseEvent(java.awt.Component, int, java.awt.event.MouseEvent)
          Container.java:2451
     boolean java.awt.LightweightDispatcher.processMouseEvent(java.awt.event.MouseEvent)
          Container.java:2216
     boolean java.awt.LightweightDispatcher.dispatchEvent(java.awt.AWTEvent)
          Container.java:2125
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
          Container.java:1200
     void java.awt.Window.dispatchEventImpl(java.awt.AWTEvent)
          Window.java:922
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
          Component.java:2497
     void java.awt.EventQueue.dispatchEvent(java.awt.AWTEvent)
          EventQueue.java:339
     boolean java.awt.EventDispatchThread.pumpOneEventForHierarchy(java.awt.Component)
          EventDispatchThread.java:131
     void java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Conditional, java.awt.Component)
          EventDispatchThread.java:98
     void java.awt.Dialog.show()
          Dialog.java:380
     void java.awt.Component.show(boolean)
          Component.java:946
     void java.awt.Component.setVisible(boolean)
          Component.java:903
     void oracle.dss.addins.wizard.calc.CalcWizardDialog.setVisible(boolean)
          CalcWizardDialog.java:48
     boolean oracle.bali.ewt.wizard.WizardDialog.runDialog()
     boolean oracle.dss.datautil.gui.DefaultBuilderDialog.runDialog()
          DefaultBuilderDialog.java:481
     boolean oracle.dss.addins.wizard.calc.CalcWizardDialog.runDialog()
          CalcWizardDialog.java:57
     boolean oracle.dss.datautil.gui.DefaultBuilderDialog.run()
          DefaultBuilderDialog.java:466
     boolean oracle.dss.calculation.client.calcBuilder.CalcBuilder.run()
          CalcBuilder.java:922
     oracle.dss.metadataManager.common.MDObject oracle.dss.calculation.client.calcBuilder.CalcBuilderStepStorage.invoke()
          CalcBuilderStepStorage.java:366
     boolean oracle.dss.addins.wizard.calc.CalcWizardAddin.invoke(oracle.ide.addin.Context, java.lang.String[])
          CalcWizardAddin.java:75
     void oracle.ide.WizardManager$1.run()
          WizardManager.java:450
     void java.awt.event.InvocationEvent.dispatch()
          InvocationEvent.java:154
     void java.awt.EventQueue.dispatchEvent(java.awt.AWTEvent)
          EventQueue.java:337
     boolean java.awt.EventDispatchThread.pumpOneEventForHierarchy(java.awt.Component)
          EventDispatchThread.java:131
     void java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Conditional, java.awt.Component)
          EventDispatchThread.java:98
     void java.awt.EventDispatchThread.pumpEvents(java.awt.Conditional)
          EventDispatchThread.java:93
     void java.awt.EventDispatchThread.run()
          EventDispatchThread.java:85
java.sql.SQLException: ORA-28009: connection to sys should be as sysdba or sysoper
     void oracle.jdbc.dbaccess.DBError.throwSqlException(java.lang.String, java.lang.String, int)
          DBError.java:134
     void oracle.jdbc.ttc7.TTIoer.processError()
          TTIoer.java:289
     void oracle.jdbc.ttc7.O3log.receive2nd()
          O3log.java:496
     oracle.jdbc.dbaccess.DBConversion oracle.jdbc.ttc7.TTC7Protocol.logon(java.lang.String, java.lang.String, java.lang.String, java.util.Properties)
          TTC7Protocol.java:278
     void oracle.jdbc.driver.OracleConnection.<init>(oracle.jdbc.dbaccess.DBAccess, java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.util.Properties)
          OracleConnection.java:346
     java.sql.Connection oracle.jdbc.driver.OracleDriver.getConnectionInstance(java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.util.Properties)
          OracleDriver.java:468
     java.sql.Connection oracle.jdbc.driver.OracleDriver.connect(java.lang.String, java.util.Properties)
          OracleDriver.java:314
     java.sql.Connection java.sql.DriverManager.getConnection(java.lang.String, java.util.Properties, java.lang.ClassLoader)
          DriverManager.java:517
     java.sql.Connection java.sql.DriverManager.getConnection(java.lang.String, java.lang.String, java.lang.String)
          DriverManager.java:177
     java.lang.Object oracle.dss.connection.server.drivers.mdm.MDMPluggableConnectionDriverImpl.connectToDatabase(java.util.Hashtable)
          MDMPluggableConnectionDriverImpl.java:127
     java.lang.Object oracle.dss.connection.server.drivers.mdm.MDMPluggableConnectionDriverImpl.connect(java.util.Hashtable)
          MDMPluggableConnectionDriverImpl.java:40
     oracle.dss.metadataUtil.PropertyBag oracle.dss.connection.server.drivers.mdm.MDMConnectionDriverImpl.connect(oracle.dss.metadataUtil.PropertyBag)
          MDMConnectionDriverImpl.java:149
     oracle.dss.connection.common.ConnectionObj oracle.dss.connection.server.ConnectionImpl.connect(oracle.dss.connection.common.ConnectionObj, oracle.dss.metadataUtil.PropertyBag)
          ConnectionImpl.java:279
     int oracle.dss.connection.client.Connection.connect(oracle.dss.metadataUtil.PropertyBag)
          Connection.java:401
     int oracle.dss.connection.client.Connection.connect()
          Connection.java:320
     oracle.dss.connection.client.Connection oracle.dss.addins.designer.BIDesignerImpl.getOlapConnection()
          BIDesignerImpl.java:888
     oracle.dss.metadataManager.client.MetadataManager oracle.dss.addins.designer.BIDesignerImpl.getMetadataManager(boolean)
          BIDesignerImpl.java:962
     oracle.dss.metadataManager.client.MetadataManager oracle.dss.addins.designer.BIDesignerImpl.getMetadataManager(boolean, boolean)
          BIDesignerImpl.java:927
     void oracle.dss.addins.wizard.calc.CalcWizardContext.initMetadataManager()
          CalcWizardContext.java:65
     void oracle.dss.addins.wizard.calc.CalcWizardContext.setDesigner(oracle.dss.addins.designer.BIDesigner)
          CalcWizardContext.java:86
     boolean oracle.dss.addins.common.wizard.BIDesignerPanel.validateAndWriteToState(oracle.ide.wizard.BaliWizardState)
          BIDesignerPanel.java:222
     boolean oracle.dss.addins.common.wizard.BIDesignerPanel.setActive(boolean)
          BIDesignerPanel.java:195
     boolean oracle.dss.datautil.gui.DefaultBuilderDialog.setActive(java.lang.String, boolean)
          DefaultBuilderDialog.java:1064
     boolean oracle.dss.datautil.gui.DefaultBuilderDialog.validateNextPreviousEvent(oracle.bali.ewt.wizard.WizardEvent)
          DefaultBuilderDialog.java:1388
     void oracle.dss.datautil.gui.DefaultBuilderDialog$BuilderWizardValidateAdapter.wizardValidatePage(oracle.bali.ewt.wizard.WizardEvent)
          DefaultBuilderDialog.java:2105
     void oracle.bali.ewt.wizard.WizardPage.processWizardValidateEvent(oracle.bali.ewt.wizard.WizardValidateEvent)
     boolean oracle.bali.ewt.wizard.WizardPage.validatePage()
     boolean oracle.dss.datautil.gui.CustomImageWizardPage.validatePage()
          CustomImageWizardPage.java:81
     boolean oracle.bali.ewt.wizard.BaseWizard.validateSelectedPage()
     void oracle.bali.ewt.wizard.BaseWizard.doNext()
     void oracle.dss.datautil.gui.CustomWizard.doNext()
          CustomWizard.java:415
     void oracle.bali.ewt.wizard.BaseWizard$Action.actionPerformed(java.awt.event.ActionEvent)
     void javax.swing.AbstractButton.fireActionPerformed(java.awt.event.ActionEvent)
          AbstractButton.java:1450
     void javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(java.awt.event.ActionEvent)
          AbstractButton.java:1504
     void javax.swing.DefaultButtonModel.fireActionPerformed(java.awt.event.ActionEvent)
          DefaultButtonModel.java:378
     void javax.swing.DefaultButtonModel.setPressed(boolean)
          DefaultButtonModel.java:250
     void javax.swing.plaf.basic.BasicButtonListener.mouseReleased(java.awt.event.MouseEvent)
          BasicButtonListener.java:216
     void java.awt.Component.processMouseEvent(java.awt.event.MouseEvent)
          Component.java:3715
     void java.awt.Component.processEvent(java.awt.AWTEvent)
          Component.java:3544
     void java.awt.Container.processEvent(java.awt.AWTEvent)
          Container.java:1164
     void java.awt.Component.dispatchEventImpl(java.awt.AWTEvent)
          Component.java:2593
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
          Container.java:1213
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
          Component.java:2497
     void java.awt.LightweightDispatcher.retargetMouseEvent(java.awt.Component, int, java.awt.event.MouseEvent)
          Container.java:2451
     boolean java.awt.LightweightDispatcher.processMouseEvent(java.awt.event.MouseEvent)
          Container.java:2216
     boolean java.awt.LightweightDispatcher.dispatchEvent(java.awt.AWTEvent)
          Container.java:2125
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
          Container.java:1200
     void java.awt.Window.dispatchEventImpl(java.awt.AWTEvent)
          Window.java:922
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
          Component.java:2497
     void java.awt.EventQueue.dispatchEvent(java.awt.AWTEvent)
          EventQueue.java:339
     boolean java.awt.EventDispatchThread.pumpOneEventForHierarchy(java.awt.Component)
          EventDispatchThread.java:131
     void java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Conditional, java.awt.Component)
          EventDispatchThread.java:98
     void java.awt.Dialog.show()
          Dialog.java:380
     void java.awt.Component.show(boolean)
          Component.java:946
     void java.awt.Component.setVisible(boolean)
          Component.java:903
     void oracle.dss.addins.wizard.calc.CalcWizardDialog.setVisible(boolean)
          CalcWizardDialog.java:48
     boolean oracle.bali.ewt.wizard.WizardDialog.runDialog()
     boolean oracle.dss.datautil.gui.DefaultBuilderDialog.runDialog()
          DefaultBuilderDialog.java:481
     boolean oracle.dss.addins.wizard.calc.CalcWizardDialog.runDialog()
          CalcWizardDialog.java:57
     boolean oracle.dss.datautil.gui.DefaultBuilderDialog.run()
          DefaultBuilderDialog.java:466
     boolean oracle.dss.calculation.client.calcBuilder.CalcBuilder.run()
          CalcBuilder.java:922
     oracle.dss.metadataManager.common.MDObject oracle.dss.calculation.client.calcBuilder.CalcBuilderStepStorage.invoke()
          CalcBuilderStepStorage.java:366
     boolean oracle.dss.addins.wizard.calc.CalcWizardAddin.invoke(oracle.ide.addin.Context, java.lang.String[])
          CalcWizardAddin.java:75
     void oracle.ide.WizardManager$1.run()
          WizardManager.java:450
     void java.awt.event.InvocationEvent.dispatch()
          InvocationEvent.java:154
     void java.awt.EventQueue.dispatchEvent(java.awt.AWTEvent)
          EventQueue.java:337
     boolean java.awt.EventDispatchThread.pumpOneEventForHierarchy(java.awt.Component)
          EventDispatchThread.java:131
     void java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Conditional, java.awt.Component)
          EventDispatchThread.java:98
     void java.awt.EventDispatchThread.pumpEvents(java.awt.Conditional)
          EventDispatchThread.java:93
     void java.awt.EventDispatchThread.run()
          EventDispatchThread.java:85
Looks like you are trying to connect as SYS. Edit your OLAP database connection and make sure your are trying to login as username:BIBDEMO, password: BIBDEMO.
hope this helps,
doug

BI Designer Test generates BIB-16623

Hello
I'm working with JDeveloper9i and want to use the BI Beans. I have an Oracle9i database on a Sun Sparc server with patch 9.0.1.3 and OLAP Patch 9.0.1.2.1. I have unlocked the users and modified olap.key so the password matches the ones in the database. OLAPServer context exist in /etc of the JVM Contexts. OLAP Agent starts up fine and also the OLAP Service in OEM. The users that I'm using to connect to the Database are olapdba and bicat, they have olapsvr as they're proxy user. When I try to connect using JDeveloper I always get:
oracle.dss.security.BISecurityException: BIB-16623 Cannot locate the specified OLAP instance: OLAPServer
javax.naming.NameNotFoundException: BIB-16623 Cannot locate the specified OLAP instance: OLAPServer
     java.lang.Object oracle.dss.connection.server.drivers.mdm.MDMPluggableConnectionDriverImpl.connect(java.util.Hashtable)
     int oracle.dss.connection.server.drivers.mdm.MDMConnectionDriverImpl.connect()
     oracle.dss.metadataUtil.PropertyBag oracle.dss.connection.server.drivers.mdm.MDMConnectionDriverImpl.connect(oracle.dss.metadataUtil.PropertyBag)
     oracle.dss.connection.common.ConnectionObj oracle.dss.connection.server.ConnectionImpl.connect(oracle.dss.connection.common.ConnectionObj, oracle.dss.metadataUtil.PropertyBag)
     int oracle.dss.connection.client.Connection.connect(oracle.dss.metadataUtil.PropertyBag)
     int oracle.dss.connection.client.Connection.connect()
     int oracle.dss.addins.designer.OLAPSource.test()
     boolean oracle.dss.addins.wizard.configFileEditor.OlapPanel.testConnection(boolean, java.lang.String)
     void oracle.dss.addins.wizard.designer.BIDesignerRolapPanel.btnTest_actionPerformed(java.awt.event.ActionEvent)
     void oracle.dss.addins.wizard.designer.BIDesignerRolapPanel$2.actionPerformed(java.awt.event.ActionEvent)
     void javax.swing.AbstractButton.fireActionPerformed(java.awt.event.ActionEvent)
     void javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(java.awt.event.ActionEvent)
     void javax.swing.DefaultButtonModel.fireActionPerformed(java.awt.event.ActionEvent)
     void javax.swing.DefaultButtonModel.setPressed(boolean)
     void javax.swing.plaf.basic.BasicButtonListener.mouseReleased(java.awt.event.MouseEvent)
     void java.awt.Component.processMouseEvent(java.awt.event.MouseEvent)
     void java.awt.Component.processEvent(java.awt.AWTEvent)
     void java.awt.Container.processEvent(java.awt.AWTEvent)
     void java.awt.Component.dispatchEventImpl(java.awt.AWTEvent)
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
     void java.awt.LightweightDispatcher.retargetMouseEvent(java.awt.Component, int, java.awt.event.MouseEvent)
     boolean java.awt.LightweightDispatcher.processMouseEvent(java.awt.event.MouseEvent)
     boolean java.awt.LightweightDispatcher.dispatchEvent(java.awt.AWTEvent)
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
     void java.awt.Window.dispatchEventImpl(java.awt.AWTEvent)
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
     void java.awt.EventQueue.dispatchEvent(java.awt.AWTEvent)
     boolean java.awt.EventDispatchThread.pumpOneEventForHierarchy(java.awt.Component)
     void java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Conditional, java.awt.Component)
     void java.awt.Dialog.show()
     void java.awt.Component.show(boolean)
     void java.awt.Component.setVisible(boolean)
     void oracle.dss.addins.common.wizard.AbstractBuilderDialog.setVisible(boolean)
     boolean oracle.bali.ewt.wizard.WizardDialog.runDialog()
     boolean oracle.dss.datautil.gui.DefaultBuilderDialog.runDialog()
     boolean oracle.dss.addins.common.wizard.AbstractBuilderDialog.runDialog()
     boolean oracle.ide.dialogs.WizardLauncher.runDialog(javax.swing.JDialog)
     boolean oracle.dss.addins.common.BIWizardImpl.invoke(oracle.ide.addin.Context, java.lang.String[])
     void oracle.ide.WizardManager$1.run()
     void java.awt.event.InvocationEvent.dispatch()
     void java.awt.EventQueue.dispatchEvent(java.awt.AWTEvent)
     boolean java.awt.EventDispatchThread.pumpOneEventForHierarchy(java.awt.Component)
     void java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Conditional, java.awt.Component)
     void java.awt.EventDispatchThread.pumpEvents(java.awt.Conditional)
     void java.awt.EventDispatchThread.run()
Is there anyother step that I have to take to connect to the OLAP repository?.

Java.lang.NullPointerException when try to create OLAP connection

I'm using Oracle 9.2.0.1.0 in an XP 2000 PC
and I try to access SH demo cube in Jdevelopper 9.0.2.8.2 (in the same machine) whith the OLAP bibeans
When I try to create a new OLAP connection, I give the different parameter of
my database and When the software look for an OLAP instance I get this message :
Java.lang.NullPointerException
I try to copy the file in 9IHOME\jdbc\lib to JDEVHOME\jdbc\lib but it still the same error
Could someone help me ? 
Such a nullpointer exception can have different causes. So it would be nice if you provide the stack trace of that exception.
I had a similar problem but found out that it was caused by an NLS (national language support) conflict with an Oracle character set. In that case I had to include the nls_charset12.jar (in the Oracle jdbc directory).
HTH
Stefan 
oracle.dss.addins.designer.OLAPSource$OlapSourceException: Les informations de connexion sont incomplhtes : Nom du service n'est pas difini.
     void oracle.dss.addins.designer.OLAPSource.checkConnectionInfo()
     int oracle.dss.addins.designer.OLAPSource.test()
     int oracle.dss.addins.designer.BIDesignerImpl.testConnection(boolean, boolean)
     oracle.dss.metadataManager.client.MetadataManager oracle.dss.addins.designer.BIDesignerImpl.getMetadataManager(boolean, boolean)
     void oracle.dss.addins.wizard.presentation.PresentationWizardContext.initQueryBuilder()
     void oracle.dss.addins.wizard.presentation.PresentationWizardContext.setDesigner(oracle.dss.addins.designer.BIDesigner)
     boolean oracle.dss.addins.common.wizard.BIDesignerPanel.validateAndWriteToState(oracle.ide.wizard.BaliWizardState)
     boolean oracle.dss.addins.common.wizard.AbstractBuilderDialog.validateBIPanelEvent(oracle.bali.ewt.wizard.WizardEvent)
     boolean oracle.dss.addins.common.wizard.AbstractBuilderDialog.validateNextPreviousEvent(oracle.bali.ewt.wizard.WizardEvent)
     boolean oracle.dss.addins.wizard.presentation.PresentationWizardDialog.validateNextPreviousEvent(oracle.bali.ewt.wizard.WizardEvent)
     void oracle.dss.datautil.gui.DefaultBuilderDialog$BuilderWizardValidateAdapter.wizardValidatePage(oracle.bali.ewt.wizard.WizardEvent)
     void oracle.bali.ewt.wizard.WizardPage.processWizardValidateEvent(oracle.bali.ewt.wizard.WizardValidateEvent)
     boolean oracle.bali.ewt.wizard.WizardPage.validatePage()
     boolean oracle.dss.datautil.gui.CustomImageWizardPage.validatePage()
     boolean oracle.bali.ewt.wizard.BaseWizard.validateSelectedPage()
     void oracle.bali.ewt.wizard.BaseWizard.doNext()
     void oracle.dss.datautil.gui.CustomWizard.doNext()
     void oracle.bali.ewt.wizard.BaseWizard$Action.actionPerformed(java.awt.event.ActionEvent)
     void javax.swing.AbstractButton.fireActionPerformed(java.awt.event.ActionEvent)
     void javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(java.awt.event.ActionEvent)
     void javax.swing.DefaultButtonModel.fireActionPerformed(java.awt.event.ActionEvent)
     void javax.swing.DefaultButtonModel.setPressed(boolean)
     void javax.swing.plaf.basic.BasicButtonListener.mouseReleased(java.awt.event.MouseEvent)
     void java.awt.Component.processMouseEvent(java.awt.event.MouseEvent)
     void java.awt.Component.processEvent(java.awt.AWTEvent)
     void java.awt.Container.processEvent(java.awt.AWTEvent)
     void java.awt.Component.dispatchEventImpl(java.awt.AWTEvent)
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
     void java.awt.LightweightDispatcher.retargetMouseEvent(java.awt.Component, int, java.awt.event.MouseEvent)
     boolean java.awt.LightweightDispatcher.processMouseEvent(java.awt.event.MouseEvent)
     boolean java.awt.LightweightDispatcher.dispatchEvent(java.awt.AWTEvent)
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
     void java.awt.Window.dispatchEventImpl(java.awt.AWTEvent)
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
     void java.awt.EventQueue.dispatchEvent(java.awt.AWTEvent)
     boolean java.awt.EventDispatchThread.pumpOneEventForHierarchy(java.awt.Component)
     void java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Conditional, java.awt.Component)
     void java.awt.Dialog.show()
     void java.awt.Component.show(boolean)
     void java.awt.Component.setVisible(boolean)
     void oracle.dss.addins.common.wizard.AbstractBuilderDialog.setVisible(boolean)
     void oracle.dss.addins.wizard.presentation.PresentationWizardDialog.setVisible(boolean)
     boolean oracle.bali.ewt.wizard.WizardDialog.runDialog()
     boolean oracle.dss.datautil.gui.DefaultBuilderDialog.runDialog()
     boolean oracle.dss.addins.common.wizard.AbstractBuilderDialog.runDialog()
     boolean oracle.ide.dialogs.WizardLauncher.runDialog(javax.swing.JDialog)
     boolean oracle.dss.addins.common.BIWizardImpl.invoke(oracle.ide.addin.Context, java.lang.String[])
     boolean oracle.dss.addins.wizard.presentation.PresentationWizardAddin.invoke(oracle.ide.addin.Context, java.lang.String[])
     void oracle.ide.WizardManager$1.run()
     void java.awt.event.InvocationEvent.dispatch()
     void java.awt.EventQueue.dispatchEvent(java.awt.AWTEvent)
     boolean java.awt.EventDispatchThread.pumpOneEventForHierarchy(java.awt.Component)
     void java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Conditional, java.awt.Component)
     void java.awt.EventDispatchThread.pumpEvents(java.awt.Conditional)
     void java.awt.EventDispatchThread.run()
I think we'd better start with the basic questions.
1) Have you applied patch/one-off 2323002 for Windows 2000 & XP which addresses an OLAP API bug?
2) Is the server running?
3) Is the connection information correct?
I don't know how to set the connection information in the BI Beans. If this is the question, you will want to post it to their forum.
Products > Developer Suite > BI Beans

Internal errors during Query Builder

Please help me to correct a problem. Database user has a very simple cube: a measure with two dimensions. User (named "warehouse") owns it, the fact table, the dimension tables etc.; client application connects using warehouse account too.
While QueryBuilder makes a data source, one dimension (providers) fails at the some selections; for example, selections "top 10" and "last 3" works, but selection "measure value > 10000" fails; the other dimension (services) works great with all selections tried.
"Fails" means that selection step can be selected (moved from "available" to "selected" box), but cannot be configured (edited) at any manner, both in the left and right boxes - for example, I cannot edit value "10000". This selection cannot be applied too. Visually query builder does nothing, but prints exception trace (see below).
My configuration:
BI Beans Diagnostics(v1.0.0.0) 04.03.04
===============================================================================
JDEV_ORACLE_HOME ............................. = C:\JDeveloper
JAVA_HOME .................................... = C:\JDeveloper\jdk
JDeveloper version ........................... = 9.0.3.1.1107
BI Beans version ............................. = 9.0.3.6.0
BI Beans internal version .................... = 2.7.0.14
Connect to database .......................... = Successful
JDBC driver version .......................... = 9.2.0.3.0
JDBC JAR file location ....................... = C:\JDeveloper\jdbc\lib
Database version ............................. = 9.2.0.4.0
OLAP Catalog version ......................... = 9.2.0.4.1
OLAP AW Engine version ....................... = 9.2.0.4.1
OLAP API Server version ...................... = 9.2.0.4.1
BI Beans Catalog version ..................... = N/A; not installed in warehouse
OLAP API JAR file version .................... = 9.2
OLAP API JAR file location ................... = C:\JDeveloper\jdev\lib\ext
Load OLAP API metadata ....................... = Successful
Number of metadata folders ................... = 3
Number of metadata measures .................. = 1
Number of metadata dimensions ................ = 2
Metadata output location ..................... = C:\JDeveloper\bibeans\bin\bi_metadata.txt
Exception:
Thu Mar 04 11:08:21 MSK 2004 In oracle.dss.queryBuilder.QueryBuilderQueryAccessUtils::getDimMembers
Sorry, these lines are re-translated from localized version
oracle.express.ExpressServerException Error class: OLAPI
Server errors description:
DPR: Unable to create server cursor, Universal at TxsOqDefinitionManagerSince9202::crtCurMgrWthInputTypes
OES: ORA-01722: invalid number
, Universal at TxsRdbSelectStatement:execute()
     oracle.express.idl.ExpressOlapiDataCursorModule.CursorManagerInterface oracle.express.olapi.data.full.DefinitionManagerSince9202.createCursorManagerInterface(oracle.olapi.data.source.CursorManagerSpecification, oracle.olapi.data.source.SourceDefinition, oracle.olapi.data.source.Source[], long)
          DefinitionManagerSince9202.java:260
     oracle.express.olapi.data.full.ExpressSpecifiedCursorManager oracle.express.olapi.data.full.DefinitionManager.createCursorManager(oracle.olapi.data.source.CursorManagerSpecification, oracle.olapi.data.source.Source[], long)
          DefinitionManager.java:132
     oracle.olapi.data.source.SpecifiedCursorManager oracle.express.olapi.data.full.ExpressDataProvider.createCursorManagerSince9202(oracle.olapi.data.source.CursorManagerSpecification, oracle.olapi.data.source.Source[], long)
          ExpressDataProvider.java:729
     oracle.olapi.data.source.SpecifiedCursorManager oracle.express.olapi.data.full.ExpressDataProvider.internalCreateCursorManager(oracle.olapi.data.source.CursorManagerSpecification, oracle.olapi.data.source.Source[], long)
          ExpressDataProvider.java:624
     oracle.olapi.data.source.SpecifiedCursorManager oracle.express.olapi.data.full.ExpressDataProvider.createCursorManager(oracle.olapi.data.source.CursorManagerSpecification, oracle.olapi.data.source.Source[])
          ExpressDataProvider.java:555
     oracle.olapi.data.source.SpecifiedCursorManager oracle.olapi.data.source.DataProvider.createCursorManager(oracle.olapi.data.source.CursorManagerSpecification)
          DataProvider.java:269
     oracle.express.olapi.data.full.ExpressSpecifiedCursorManager[] oracle.dss.dataSource.QueryUtilities.setUpCursors(oracle.dss.dataSource.SourceTemplate[], oracle.dss.dataSource.common.CubeCursor[], oracle.olapi.data.source.Source[], oracle.express.olapi.data.full.ExpressSpecifiedCursorManager[], boolean, boolean, boolean, boolean)
          QueryUtilities.java:558
     oracle.express.olapi.data.full.ExpressSpecifiedCursorManager[] oracle.dss.dataSource.QueryServer._setUpCursorsForMainQuery(oracle.dss.dataSource.SourceTemplate[], oracle.dss.dataSource.common.CubeCursor[], boolean, boolean, boolean, boolean)
          QueryServer.java:7036
     void oracle.dss.dataSource.QueryServer._getCursorForCube(oracle.dss.dataSource.common.DimTree, boolean, boolean, boolean, boolean, boolean)
          QueryServer.java:4096
     void oracle.dss.dataSource.QueryServer._createCubeAndCursor(boolean, boolean, boolean)
          QueryServer.java:4251
     void oracle.dss.dataSource.QueryServer._createCommonQuery(java.lang.String[][], java.lang.String[], oracle.dss.util.Operation, oracle.dss.dataSource.common.QueryState)
          QueryServer.java:3894
     void oracle.dss.dataSource.QueryServer._initQuery(java.lang.String[][], java.lang.String[], oracle.dss.util.Operation, oracle.dss.dataSource.common.QueryState)
          QueryServer.java:3841
     java.lang.Object java.lang.reflect.Method.invoke(java.lang.Object, java.lang.Object[])
          native code
     java.lang.Object oracle.dss.util.Operation.execute(java.lang.Object)
          Operation.java:69
     java.lang.Object oracle.dss.dataSource.OperationQueue.update()
          OperationQueue.java:68
     java.lang.Object oracle.dss.dataSource.common.BaseOperationQueue.addOperation(oracle.dss.util.Operation, int)
          BaseOperationQueue.java:176
     java.lang.Object oracle.dss.dataSource.common.BaseOperationQueue.addOperation(oracle.dss.util.Operation)
          BaseOperationQueue.java:146
     java.lang.Object oracle.dss.dataSource.QueryServer.queueOperation(java.lang.String, oracle.dss.util.Parameter[], boolean, oracle.dss.dataSource.common.QueryEvent, java.lang.String, oracle.dss.util.Parameter[], oracle.dss.dataSource.common.QueryState)
          QueryServer.java:7073
     void oracle.dss.dataSource.QueryServer.initQuery(java.lang.String[][], java.lang.String[])
          QueryServer.java:3803
     java.lang.Object java.lang.reflect.Method.invoke(java.lang.Object, java.lang.Object[])
          native code
     java.lang.Object oracle.dss.util.Operation.execute(java.lang.Object)
          Operation.java:69
     java.lang.Object oracle.dss.dataSource.QueryManagerServer.sendQueue(oracle.dss.dataSource.common.BaseOperationQueue)
          QueryManagerServer.java:1548
     java.lang.Object oracle.dss.dataSource.common.OperationQueue.update()
          OperationQueue.java:198
     java.lang.Object oracle.dss.dataSource.common.BaseOperationQueue.addOperation(oracle.dss.util.Operation, int)
          BaseOperationQueue.java:176
     java.lang.Object oracle.dss.dataSource.common.BaseOperationQueue.addOperation(oracle.dss.util.Operation)
          BaseOperationQueue.java:146
     void oracle.dss.dataSource.client.QueryClient.initQuery(java.lang.String[][], java.lang.String[])
          QueryClient.java:1581
     oracle.dss.util.DataAccess oracle.dss.dataSource.common.QueryQueryAccess$SelCursor.getDataAccess(boolean)
          QueryQueryAccess.java:1099
     oracle.dss.util.DataAccess oracle.dss.dataSource.common.QueryQueryAccess.getDataAccess(java.lang.String)
          QueryQueryAccess.java:278
     java.util.Vector oracle.dss.queryBuilder.QueryBuilderQueryAccessUtils.getDimMembers(oracle.dss.datautil.QueryAccessUtilities, java.lang.String, java.lang.String, java.util.Vector, java.lang.String)
          QueryBuilderQueryAccessUtils.java:220
     oracle.dss.datautil.DimensionMember oracle.dss.queryBuilder.QueryBuilderQueryAccessUtils.getDimMember(oracle.dss.datautil.QueryAccessUtilities, java.lang.String, java.lang.String, java.lang.String, java.lang.String)
          QueryBuilderQueryAccessUtils.java:156
     java.util.Vector oracle.dss.queryBuilder.stepView.ConditionStepView.getQDRMemberNames(java.lang.String, oracle.dss.selection.OlapQDR)
          ConditionStepView.java:230
     void oracle.dss.queryBuilder.stepView.ConditionStepView.updateQDRControls()
          ConditionStepView.java:606
     void oracle.dss.queryBuilder.stepView.MeasConditionStepView.updateQDR()
          MeasConditionStepView.java:451
     void oracle.dss.queryBuilder.stepView.MeasConditionStepView.updateMeasureEditorSelection()
          MeasConditionStepView.java:208
     void oracle.dss.queryBuilder.stepView.MeasConditionStepView.updateMeasureEditorContents()
          MeasConditionStepView.java:271
     void oracle.dss.queryBuilder.stepView.MeasConditionStepView.updateMeasureEditorSelection()
          MeasConditionStepView.java:161
     void oracle.dss.queryBuilder.stepView.MeasConditionStepView.updateControls()
          MeasConditionStepView.java:148
     void oracle.dss.queryBuilder.stepView.StepView.updateStepEditor(oracle.dss.selection.step.Step, boolean, boolean, int)
          StepView.java:562
     javax.swing.JPanel oracle.dss.queryBuilder.stepView.StepView.getStepEditor(oracle.dss.selection.step.Step, boolean, boolean, int, int)
          StepView.java:522
     void oracle.dss.queryBuilder.StepsPanelEditor.startEdit(java.awt.Component, java.lang.String, int, java.awt.Rectangle)
          StepsPanelEditor.java:93
     boolean oracle.dss.util.dimensionList.DimensionList.doEdit(int)
          DimensionList.java:525
     void oracle.dss.queryBuilder.StepsPanel$MyDimensionListAdapter.startEditingNewSelection()
          StepsPanel.java:404
     void oracle.dss.queryBuilder.StepsPanel$MyDimensionListAdapter.dimensionSelected(oracle.dss.util.dimensionList.DimensionListEvent)
          StepsPanel.java:374
     void oracle.dss.util.dimensionList.DimensionList.notifyDimensionListListener(oracle.dss.util.dimensionList.DimensionListEvent)
          DimensionList.java:2074
     void oracle.dss.util.dimensionList.DimensionList.valueChanged(javax.swing.event.ListSelectionEvent)
          DimensionList.java:1772
     void javax.swing.JList.fireSelectionValueChanged(int, int, boolean)
          JList.java:946
     void javax.swing.JList$ListSelectionHandler.valueChanged(javax.swing.event.ListSelectionEvent)
          JList.java:960
     void javax.swing.DefaultListSelectionModel.fireValueChanged(int, int, boolean)
          DefaultListSelectionModel.java:170
     void javax.swing.DefaultListSelectionModel.fireValueChanged(boolean)
          DefaultListSelectionModel.java:140
     void javax.swing.DefaultListSelectionModel.setValueIsAdjusting(boolean)
          DefaultListSelectionModel.java:507
     void javax.swing.JList.setValueIsAdjusting(boolean)
          JList.java:1261
     void javax.swing.plaf.basic.BasicListUI$MouseInputHandler.mouseReleased(java.awt.event.MouseEvent)
          BasicListUI.java:831
     void java.awt.AWTEventMulticaster.mouseReleased(java.awt.event.MouseEvent)
          AWTEventMulticaster.java:231
     void java.awt.AWTEventMulticaster.mouseReleased(java.awt.event.MouseEvent)
          AWTEventMulticaster.java:230
     void java.awt.Component.processMouseEvent(java.awt.event.MouseEvent)
          Component.java:3715
     void oracle.dss.util.dimensionList.DragList.processMouseEvent(java.awt.event.MouseEvent)
          DragList.java:202
     void oracle.dss.util.dimensionList.DimensionList.processMouseEvent(java.awt.event.MouseEvent)
          DimensionList.java:2167
     void java.awt.Component.processEvent(java.awt.AWTEvent)
          Component.java:3544
     void java.awt.Container.processEvent(java.awt.AWTEvent)
          Container.java:1164
     void java.awt.Component.dispatchEventImpl(java.awt.AWTEvent)
          Component.java:2593
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
          Container.java:1213
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
          Component.java:2497
     void java.awt.LightweightDispatcher.retargetMouseEvent(java.awt.Component, int, java.awt.event.MouseEvent)
          Container.java:2451
     boolean java.awt.LightweightDispatcher.processMouseEvent(java.awt.event.MouseEvent)
          Container.java:2216
     boolean java.awt.LightweightDispatcher.dispatchEvent(java.awt.AWTEvent)
          Container.java:2125
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
          Container.java:1200
     void java.awt.Window.dispatchEventImpl(java.awt.AWTEvent)
          Window.java:922
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
          Component.java:2497
     void java.awt.EventQueue.dispatchEvent(java.awt.AWTEvent)
          EventQueue.java:339
     boolean java.awt.EventDispatchThread.pumpOneEventForHierarchy(java.awt.Component)
          EventDispatchThread.java:131
     void java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Conditional, java.awt.Component)
          EventDispatchThread.java:98
     void java.awt.Dialog.show()
          Dialog.java:380
     void java.awt.Component.show(boolean)
          Component.java:946
     void java.awt.Component.setVisible(boolean)
          Component.java:903
     boolean oracle.bali.ewt.wizard.WizardDialog.runDialog()
     boolean oracle.dss.datautil.gui.DefaultBuilderDialog.runDialog()
          DefaultBuilderDialog.java:481
     boolean oracle.dss.datautil.gui.DefaultBuilderDialog.run()
          DefaultBuilderDialog.java:466
     boolean oracle.dss.queryBuilder.QueryBuilder.run()
          QueryBuilder.java:2401
     void borlas.oa.Actions.actionEditQuery.doAction()
          actionEditQuery.java:44
     boolean borlas.oa.Actions.Action.fire()
          Action.java:88
     void borlas.oa.Forms.FormModule.editQuery()
          FormModule.java:132
     void borlas.oa.Forms.FormModule.access$6000071(borlas.oa.Forms.FormModule)
          FormModule.java:42
     void borlas.oa.Forms.FormModule$1.actionPerformed(java.awt.event.ActionEvent)
          FormModule.java:113
     void javax.swing.AbstractButton.fireActionPerformed(java.awt.event.ActionEvent)
          AbstractButton.java:1450
     void javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(java.awt.event.ActionEvent)
          AbstractButton.java:1504
     void javax.swing.DefaultButtonModel.fireActionPerformed(java.awt.event.ActionEvent)
          DefaultButtonModel.java:378
     void javax.swing.DefaultButtonModel.setPressed(boolean)
          DefaultButtonModel.java:250
     void javax.swing.AbstractButton.doClick(int)
          AbstractButton.java:279
     void javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(java.awt.event.MouseEvent)
          BasicMenuItemUI.java:886
     void java.awt.Component.processMouseEvent(java.awt.event.MouseEvent)
          Component.java:3715
     void java.awt.Component.processEvent(java.awt.AWTEvent)
          Component.java:3544
     void java.awt.Container.processEvent(java.awt.AWTEvent)
          Container.java:1164
     void java.awt.Component.dispatchEventImpl(java.awt.AWTEvent)
          Component.java:2593
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
          Container.java:1213
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
          Component.java:2497
     void java.awt.LightweightDispatcher.retargetMouseEvent(java.awt.Component, int, java.awt.event.MouseEvent)
          Container.java:2451
     boolean java.awt.LightweightDispatcher.processMouseEvent(java.awt.event.MouseEvent)
          Container.java:2216
     boolean java.awt.LightweightDispatcher.dispatchEvent(java.awt.AWTEvent)
          Container.java:2125
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
          Container.java:1200
     void java.awt.Window.dispatchEventImpl(java.awt.AWTEvent)
          Window.java:922
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
          Component.java:2497
     void java.awt.EventQueue.dispatchEvent(java.awt.AWTEvent)
          EventQueue.java:339
     boolean java.awt.EventDispatchThread.pumpOneEventForHierarchy(java.awt.Component)
          EventDispatchThread.java:131
     void java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Conditional, java.awt.Component)
          EventDispatchThread.java:98
     void java.awt.EventDispatchThread.pumpEvents(java.awt.Conditional)
          EventDispatchThread.java:93
     void java.awt.EventDispatchThread.run()
          EventDispatchThread.java:85
Exception occurred during event dispatching:
java.lang.NullPointerException
     java.util.Vector oracle.dss.queryBuilder.stepView.ConditionStepView.getQDRMemberNames(java.lang.String, oracle.dss.selection.OlapQDR)
          ConditionStepView.java:230
     void oracle.dss.queryBuilder.stepView.ConditionStepView.updateQDRControls()
          ConditionStepView.java:606
     void oracle.dss.queryBuilder.stepView.MeasConditionStepView.updateQDR()
          MeasConditionStepView.java:451
     void oracle.dss.queryBuilder.stepView.MeasConditionStepView.updateMeasureEditorSelection()
          MeasConditionStepView.java:208
     void oracle.dss.queryBuilder.stepView.MeasConditionStepView.updateMeasureEditorContents()
          MeasConditionStepView.java:271
     void oracle.dss.queryBuilder.stepView.MeasConditionStepView.updateMeasureEditorSelection()
          MeasConditionStepView.java:161
     void oracle.dss.queryBuilder.stepView.MeasConditionStepView.updateControls()
          MeasConditionStepView.java:148
     void oracle.dss.queryBuilder.stepView.StepView.updateStepEditor(oracle.dss.selection.step.Step, boolean, boolean, int)
          StepView.java:562
     javax.swing.JPanel oracle.dss.queryBuilder.stepView.StepView.getStepEditor(oracle.dss.selection.step.Step, boolean, boolean, int, int)
          StepView.java:522
     void oracle.dss.queryBuilder.StepsPanelEditor.startEdit(java.awt.Component, java.lang.String, int, java.awt.Rectangle)
          StepsPanelEditor.java:93
     boolean oracle.dss.util.dimensionList.DimensionList.doEdit(int)
          DimensionList.java:525
     void oracle.dss.queryBuilder.StepsPanel$MyDimensionListAdapter.startEditingNewSelection()
          StepsPanel.java:404
     void oracle.dss.queryBuilder.StepsPanel$MyDimensionListAdapter.dimensionSelected(oracle.dss.util.dimensionList.DimensionListEvent)
          StepsPanel.java:374
     void oracle.dss.util.dimensionList.DimensionList.notifyDimensionListListener(oracle.dss.util.dimensionList.DimensionListEvent)
          DimensionList.java:2074
     void oracle.dss.util.dimensionList.DimensionList.valueChanged(javax.swing.event.ListSelectionEvent)
          DimensionList.java:1772
     void javax.swing.JList.fireSelectionValueChanged(int, int, boolean)
          JList.java:946
     void javax.swing.JList$ListSelectionHandler.valueChanged(javax.swing.event.ListSelectionEvent)
          JList.java:960
     void javax.swing.DefaultListSelectionModel.fireValueChanged(int, int, boolean)
          DefaultListSelectionModel.java:170
     void javax.swing.DefaultListSelectionModel.fireValueChanged(boolean)
          DefaultListSelectionModel.java:140
     void javax.swing.DefaultListSelectionModel.setValueIsAdjusting(boolean)
          DefaultListSelectionModel.java:507
     void javax.swing.JList.setValueIsAdjusting(boolean)
          JList.java:1261
     void javax.swing.plaf.basic.BasicListUI$MouseInputHandler.mouseReleased(java.awt.event.MouseEvent)
          BasicListUI.java:831
     void java.awt.AWTEventMulticaster.mouseReleased(java.awt.event.MouseEvent)
          AWTEventMulticaster.java:231
     void java.awt.AWTEventMulticaster.mouseReleased(java.awt.event.MouseEvent)
          AWTEventMulticaster.java:230
     void java.awt.Component.processMouseEvent(java.awt.event.MouseEvent)
          Component.java:3715
     void oracle.dss.util.dimensionList.DragList.processMouseEvent(java.awt.event.MouseEvent)
          DragList.java:202
     void oracle.dss.util.dimensionList.DimensionList.processMouseEvent(java.awt.event.MouseEvent)
          DimensionList.java:2167
     void java.awt.Component.processEvent(java.awt.AWTEvent)
          Component.java:3544
     void java.awt.Container.processEvent(java.awt.AWTEvent)
          Container.java:1164
     void java.awt.Component.dispatchEventImpl(java.awt.AWTEvent)
          Component.java:2593
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
          Container.java:1213
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
          Component.java:2497
     void java.awt.LightweightDispatcher.retargetMouseEvent(java.awt.Component, int, java.awt.event.MouseEvent)
          Container.java:2451
     boolean java.awt.LightweightDispatcher.processMouseEvent(java.awt.event.MouseEvent)
          Container.java:2216
     boolean java.awt.LightweightDispatcher.dispatchEvent(java.awt.AWTEvent)
          Container.java:2125
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
          Container.java:1200
     void java.awt.Window.dispatchEventImpl(java.awt.AWTEvent)
          Window.java:922
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
          Component.java:2497
     void java.awt.EventQueue.dispatchEvent(java.awt.AWTEvent)
          EventQueue.java:339
     boolean java.awt.EventDispatchThread.pumpOneEventForHierarchy(java.awt.Component)
          EventDispatchThread.java:131
     void java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Conditional, java.awt.Component)
          EventDispatchThread.java:98
     void java.awt.Dialog.show()
          Dialog.java:380
     void java.awt.Component.show(boolean)
          Component.java:946
     void java.awt.Component.setVisible(boolean)
          Component.java:903
     boolean oracle.bali.ewt.wizard.WizardDialog.runDialog()
     boolean oracle.dss.datautil.gui.DefaultBuilderDialog.runDialog()
          DefaultBuilderDialog.java:481
     boolean oracle.dss.datautil.gui.DefaultBuilderDialog.run()
          DefaultBuilderDialog.java:466
     boolean oracle.dss.queryBuilder.QueryBuilder.run()
          QueryBuilder.java:2401
     void borlas.oa.Actions.actionEditQuery.doAction()
          actionEditQuery.java:44
     boolean borlas.oa.Actions.Action.fire()
          Action.java:88
     void borlas.oa.Forms.FormModule.editQuery()
          FormModule.java:132
     void borlas.oa.Forms.FormModule.access$6000071(borlas.oa.Forms.FormModule)
          FormModule.java:42
     void borlas.oa.Forms.FormModule$1.actionPerformed(java.awt.event.ActionEvent)
          FormModule.java:113
     void javax.swing.AbstractButton.fireActionPerformed(java.awt.event.ActionEvent)
          AbstractButton.java:1450
     void javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(java.awt.event.ActionEvent)
          AbstractButton.java:1504
     void javax.swing.DefaultButtonModel.fireActionPerformed(java.awt.event.ActionEvent)
          DefaultButtonModel.java:378
     void javax.swing.DefaultButtonModel.setPressed(boolean)
          DefaultButtonModel.java:250
     void javax.swing.AbstractButton.doClick(int)
          AbstractButton.java:279
     void javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(java.awt.event.MouseEvent)
          BasicMenuItemUI.java:886
     void java.awt.Component.processMouseEvent(java.awt.event.MouseEvent)
          Component.java:3715
     void java.awt.Component.processEvent(java.awt.AWTEvent)
          Component.java:3544
     void java.awt.Container.processEvent(java.awt.AWTEvent)
          Container.java:1164
     void java.awt.Component.dispatchEventImpl(java.awt.AWTEvent)
          Component.java:2593
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
          Container.java:1213
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
          Component.java:2497
     void java.awt.LightweightDispatcher.retargetMouseEvent(java.awt.Component, int, java.awt.event.MouseEvent)
          Container.java:2451
     boolean java.awt.LightweightDispatcher.processMouseEvent(java.awt.event.MouseEvent)
          Container.java:2216
     boolean java.awt.LightweightDispatcher.dispatchEvent(java.awt.AWTEvent)
          Container.java:2125
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
          Container.java:1200
     void java.awt.Window.dispatchEventImpl(java.awt.AWTEvent)
          Window.java:922
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
          Component.java:2497
     void java.awt.EventQueue.dispatchEvent(java.awt.AWTEvent)
          EventQueue.java:339
     boolean java.awt.EventDispatchThread.pumpOneEventForHierarchy(java.awt.Component)
          EventDispatchThread.java:131
     void java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Conditional, java.awt.Component)
          EventDispatchThread.java:98
     void java.awt.EventDispatchThread.pumpEvents(java.awt.Conditional)
          EventDispatchThread.java:93
     void java.awt.EventDispatchThread.run()
          EventDispatchThread.java:85

bibeans error

hi
i have created a cube with one multi level dimension
and 3 one level dimension using owb 9.2
and i checked the metadata using bi_checkconfig and the out put is ok
when i try to build a presentation in the Bibeans i get the following error in the multi-level dimension page
java.lang.NullPointerException
     boolean oracle.dss.dataSource.common.CubeCursor._compareStrings(java.lang.String, java.lang.String, int)
          CubeCursor.java:1943
     int oracle.dss.dataSource.common.CubeCursor.findMember(int, int[], int, java.lang.String, java.lang.String, int)
          CubeCursor.java:1924
     int oracle.dss.dataSource.common.QueryDataAccess.findMember(int, int[], int, java.lang.String, java.lang.String, int)
          QueryDataAccess.java:1152
     int oracle.dss.datautil.QueryAccessUtilities.getDimMemberPosition(java.lang.String, java.lang.String)
          QueryAccessUtilities.java:528
     oracle.dss.util.RangeCollection oracle.dss.queryBuilder.DimensionListShuttlePanel.getAbsoluteRangeCollection(oracle.dss.util.RangeCollection, int)
          DimensionListShuttlePanel.java:460
     void oracle.dss.queryBuilder.DimensionListShuttlePanel.updateRangeCollection(oracle.dss.selection.step.MemberStep)
          DimensionListShuttlePanel.java:576
     oracle.dss.selection.step.MemberStep oracle.dss.queryBuilder.DimensionListShuttlePanel.createMemberStep(int[], java.lang.String, java.lang.String, int)
          DimensionListShuttlePanel.java:599
     java.lang.Object[] oracle.dss.queryBuilder.DimensionListShuttlePanel.getItems(int[], java.lang.String, java.lang.String, int)
          DimensionListShuttlePanel.java:480
     java.lang.Object[] oracle.dss.queryBuilder.DimensionListShuttlePanel.getSelectedItems(int)
          DimensionListShuttlePanel.java:499
     java.lang.Object[] oracle.dss.queryBuilder.DimensionListShuttlePanel.getSelectedItems()
          DimensionListShuttlePanel.java:531
     void oracle.dss.datautil.gui.Shuttle.updateEnabled()
          Shuttle.java:445
     void oracle.dss.datautil.gui.Shuttle.focusGained(java.awt.event.FocusEvent)
          Shuttle.java:687
     void oracle.dss.queryBuilder.ShuttlePanel.fireFocusEvent(java.awt.event.FocusEvent)
          ShuttlePanel.java:191
     void oracle.dss.queryBuilder.ShuttlePanel.fireFocusEvent()
          ShuttlePanel.java:276
     void oracle.dss.queryBuilder.DimensionListShuttlePanel$MyDimensionListAdapter.dimensionSelecting(oracle.dss.util.dimensionList.DimensionListEvent)
          DimensionListShuttlePanel.java:937
     void oracle.dss.util.dimensionList.DimensionList.notifyDimensionListListener(oracle.dss.util.dimensionList.DimensionListEvent)
          DimensionList.java:2067
     void oracle.dss.util.dimensionList.DimensionList.valueChanged(javax.swing.event.ListSelectionEvent)
          DimensionList.java:1775
     void javax.swing.JList.fireSelectionValueChanged(int, int, boolean)
          JList.java:946
     void javax.swing.JList$ListSelectionHandler.valueChanged(javax.swing.event.ListSelectionEvent)
          JList.java:960
     void javax.swing.DefaultListSelectionModel.fireValueChanged(int, int, boolean)
          DefaultListSelectionModel.java:170
     void javax.swing.DefaultListSelectionModel.fireValueChanged(int, int)
          DefaultListSelectionModel.java:150
     void javax.swing.DefaultListSelectionModel.fireValueChanged()
          DefaultListSelectionModel.java:197
     void javax.swing.DefaultListSelectionModel.changeSelection(int, int, int, int, boolean)
          DefaultListSelectionModel.java:359
     void javax.swing.DefaultListSelectionModel.changeSelection(int, int, int, int)
          DefaultListSelectionModel.java:368
     void javax.swing.DefaultListSelectionModel.setSelectionInterval(int, int)
          DefaultListSelectionModel.java:392
     void javax.swing.JList.setSelectionInterval(int, int)
          JList.java:1209
     void javax.swing.plaf.basic.BasicListUI$MouseInputHandler.mousePressed(java.awt.event.MouseEvent)
          BasicListUI.java:795
     void java.awt.AWTEventMulticaster.mousePressed(java.awt.event.MouseEvent)
          AWTEventMulticaster.java:221
     void java.awt.AWTEventMulticaster.mousePressed(java.awt.event.MouseEvent)
          AWTEventMulticaster.java:220
     void java.awt.Component.processMouseEvent(java.awt.event.MouseEvent)
          Component.java:3712
     void oracle.dss.util.dimensionList.DragList.processMouseEvent(java.awt.event.MouseEvent)
          DragList.java:202
     void oracle.dss.util.dimensionList.DimensionList.processMouseEvent(java.awt.event.MouseEvent)
          DimensionList.java:2167
     void java.awt.Component.processEvent(java.awt.AWTEvent)
          Component.java:3544
     void java.awt.Container.processEvent(java.awt.AWTEvent)
          Container.java:1164
     void java.awt.Component.dispatchEventImpl(java.awt.AWTEvent)
          Component.java:2593
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
          Container.java:1213
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
          Component.java:2497
     void java.awt.LightweightDispatcher.retargetMouseEvent(java.awt.Component, int, java.awt.event.MouseEvent)
          Container.java:2451
     boolean java.awt.LightweightDispatcher.processMouseEvent(java.awt.event.MouseEvent)
          Container.java:2210
     boolean java.awt.LightweightDispatcher.dispatchEvent(java.awt.AWTEvent)
          Container.java:2125
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
          Container.java:1200
     void java.awt.Window.dispatchEventImpl(java.awt.AWTEvent)
          Window.java:922
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
          Component.java:2497
     void java.awt.EventQueue.dispatchEvent(java.awt.AWTEvent)
          EventQueue.java:339
     boolean java.awt.EventDispatchThread.pumpOneEventForHierarchy(java.awt.Component)
          EventDispatchThread.java:131
     void java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Conditional, java.awt.Component)
          EventDispatchThread.java:98
     void java.awt.Dialog.show()
          Dialog.java:380
     void java.awt.Component.show(boolean)
          Component.java:946
     void java.awt.Component.setVisible(boolean)
          Component.java:903
     void oracle.dss.addins.common.wizard.AbstractBuilderDialog.setVisible(boolean)
          AbstractBuilderDialog.java:286
     void oracle.dss.addins.wizard.presentation.PresentationWizardDialog.setVisible(boolean)
          PresentationWizardDialog.java:397
     boolean oracle.bali.ewt.wizard.WizardDialog.runDialog()
     boolean oracle.dss.datautil.gui.DefaultBuilderDialog.runDialog()
          DefaultBuilderDialog.java:481
     boolean oracle.dss.addins.common.wizard.AbstractBuilderDialog.runDialog()
          AbstractBuilderDialog.java:266
     boolean oracle.ide.dialogs.WizardLauncher.runDialog(javax.swing.JDialog)
          WizardLauncher.java:51
     boolean oracle.dss.addins.common.BIWizardImpl.invoke(oracle.ide.addin.Context, java.lang.String[])
          BIWizardImpl.java:147
     boolean oracle.dss.addins.wizard.presentation.PresentationWizardAddin.invoke(oracle.ide.addin.Context, java.lang.String[])
          PresentationWizardAddin.java:54
     boolean oracle.dss.addins.wizard.presentation.PresentationWizardAddin.invokeFromMenu(oracle.ide.addin.Context, java.lang.String[], oracle.dss.addins.designer.BIFolder, oracle.dss.addins.designer.BIDesigner, boolean)
          PresentationWizardAddin.java:73
     void oracle.dss.addins.designer.BIDesignerAddin.actionPerformed(java.awt.event.ActionEvent)
          BIDesignerAddin.java:572
     void javax.swing.AbstractButton.fireActionPerformed(java.awt.event.ActionEvent)
          AbstractButton.java:1450
     void javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(java.awt.event.ActionEvent)
          AbstractButton.java:1504
     void javax.swing.DefaultButtonModel.fireActionPerformed(java.awt.event.ActionEvent)
          DefaultButtonModel.java:378
     void javax.swing.DefaultButtonModel.setPressed(boolean)
          DefaultButtonModel.java:250
     void javax.swing.AbstractButton.doClick(int)
          AbstractButton.java:279
     void javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(java.awt.event.MouseEvent)
          BasicMenuItemUI.java:886
     void java.awt.Component.processMouseEvent(java.awt.event.MouseEvent)
          Component.java:3715
     void java.awt.Component.processEvent(java.awt.AWTEvent)
          Component.java:3544
     void java.awt.Container.processEvent(java.awt.AWTEvent)
          Container.java:1164
     void java.awt.Component.dispatchEventImpl(java.awt.AWTEvent)
          Component.java:2593
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
          Container.java:1213
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
          Component.java:2497
     void java.awt.LightweightDispatcher.retargetMouseEvent(java.awt.Component, int, java.awt.event.MouseEvent)
          Container.java:2451
     boolean java.awt.LightweightDispatcher.processMouseEvent(java.awt.event.MouseEvent)
          Container.java:2216
     boolean java.awt.LightweightDispatcher.dispatchEvent(java.awt.AWTEvent)
          Container.java:2125
     void java.awt.Container.dispatchEventImpl(java.awt.AWTEvent)
          Container.java:1200
     void java.awt.Window.dispatchEventImpl(java.awt.AWTEvent)
          Window.java:922
     void java.awt.Component.dispatchEvent(java.awt.AWTEvent)
          Component.java:2497
     void java.awt.EventQueue.dispatchEvent(java.awt.AWTEvent)
          EventQueue.java:339
     boolean java.awt.EventDispatchThread.pumpOneEventForHierarchy(java.awt.Component)
          EventDispatchThread.java:131
     void java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Conditional, java.awt.Component)
          EventDispatchThread.java:98
     void java.awt.EventDispatchThread.pumpEvents(java.awt.Conditional)
          EventDispatchThread.java:93
     void java.awt.EventDispatchThread.run()
          EventDispatchThread.java:85
when i edit the cube and remove the multi level dimension from it every thing is ok.
So what is the problem?
thanks
Which version of the database are you using
Which version of the JDeveloper are you using
Which version of the BIBeans are you using
What type of OLAP schema are you trying to create relational or AW?
Did you try running BICheckConfig with '-q' option which will force a query to be run against each measure and each dimension in your catalog.
Also have you ensured all your dimension values are unique across all levels. The OLAPI interface creates a union of all dimension members from all the key columns identified in the metadata. Hence, your dimension keys across all levels need to be unique.
Hope this helps
Business Intelligence Beans Product Management Team
Oracle Corporation 
thanks for your reply
JDeveloper version = 9.0.3.1.1107
BI Beans version = 9.0.3.6.0A
BI Beans internal version = 2.7.0.13.1
Database version = 9.2.0.4.0
OLAP Catalog version = 9.2.0.4.1
when i use the -q option it shows that the problem is with the cube, but when i remove the multi level dimension from the cube it works correctly
so what do you think what can i do?
OLAP and BI Beans does support multi-level dimensions, see the BIBDEMO schema shipped with BI Beans in the JDEV_HOME/bibeans/bibdemo_schema.
There are certain requirements for creating a multi-level dimension. Please refer the OLAP user guides, which are available on the OLAP documentation section of OTN. There are additional validators you can run against your schema to provide very low level information on dimensions, levels and hierarchies:
set serveroutput on size 1000000
exec cwm2_olap_manager.Set_Echo_On;
exec cwm2_olap_manager.Begin_Log('insert utl_file_dir' ,'Instance_Validate.log');
exec cwm2_olap_validate.Validate_ALL_Dimensions('OLAP API');
exec cwm2_olap_validate.Validate_ALL_Cubes('OLAP API');
exec cwm2_olap_validate.Validate_Olap_Catalog('OLAP API');
exec cwm2_olap_manager.End_Log;
You need to have UTIL_FILE_DIR set in your init.ora to allow a report to be created and the output displayed within SQLPlus
Business Intelligence Beans Product Management Team
Oracle Corporation

Categories

Resources