MetaDataNotFound when trying to get the root schema - BI Beans(Archived)

Hi,
I am running
Database: 9.2.0.1.0.A
JDeveloper: 9.0.3.988
BI Beans: pre-9.0.3
and get the following stack trace/output
================================================================================
D:\jdev9i\jdk\bin\javaw.exe -ojvm -classpath D:\mywork\Test\Project3\classes;D:\jdev9i\lib;D:\jdev9i\jdk\lib;D:\jdev9i\jdbc\lib;D:\jdev9i\bibeans\lib;D:\jdev9i\jdev\lib;D:\jdev9i\jdev\lib\jdev-rt.jar;D:\jdev9i\jdev\lib\ext\..\..\..\bibeans\lib\olap_api_92.jar;D:\jdev9i\jdev\lib\ext\..\..\..\bibeans\lib\biaddinsrt.jar;D:\jdev9i\jdev\lib\ext\..\..\..\bibeans\lib\biamlocal.jar;D:\jdev9i\jdev\lib\ext\..\..\..\bibeans\lib\bicmn.jar;D:\jdev9i\jdev\lib\ext\..\..\..\bibeans\lib\bidataclt.jar;D:\jdev9i\jdev\lib\ext\..\..\..\bibeans\lib\bidatacmn.jar;D:\jdev9i\jdev\lib\ext\..\..\..\bibeans\lib\bidatasvr.jar;D:\jdev9i\jdev\lib\ext\..\..\..\bibeans\lib\biext.jar;D:\jdev9i\jdev\lib\ext\..\..\..\bibeans\lib\bipres.jar;D:\jdev9i\jdev\lib\ext\..\..\..\bibeans\lib\bidata-nls.zip;D:\jdev9i\jdev\lib\ext\..\..\..\bibeans\lib\bipres-nls.zip;D:\jdev9i\jdev\lib\ext\..\..\..\bibeans\lib\bicmn-nls.zip;D:\jdev9i\jdev\lib\ext\..\..\..\bibeans\lib\biaddins-nls.zip;D:\jdev9i\jdev\lib\ext\..\..\..\jlib\LW_PfjBean.jar;D:\jdev9i\jdev\lib\ext\..\..\..\jlib\share.jar;D:\jdev9i\jdev\lib\ext\..\..\..\jlib\jewt4.jar;D:\jdev9i\jdev\lib\ext\..\..\..\jlib\jewt4-nls.jar;D:\jdev9i\jdev\lib\ext\..\..\infobus\lib\infobus.jar;D:\jdev9i\BC4J\jlib\bc4jmtvb.jar;D:\jdev9i\BC4J\lib\bc4jct.jar;D:\jdev9i\BC4J\jlib\bc4jctvb.jar;D:\jdev9i\vbroker4\lib\vbjorb.jar;D:\jdev9i\jdbc\lib\classes12.jar;D:\jdev9i\jdbc\lib\nls_charset12.jar;D:\jdev9i\jdk\lib\tools.jar;D:\jdev9i\jdev\lib\jdev.jar;D:\jdev9i\jdev\lib\xmleditor.jar;D:\jdev9i\jdev\lib\xmladdin.jar;D:\jdev9i\jlib\jewt4.jar;D:\jdev9i\jdev\lib\ant.jar;D:\jdev9i\jdev\lib\optional.jar;D:\jdev9i\jlib\regexp.jar;D:\jdev9i\rdbms\jlib\jmscommon.jar;D:\jdev9i\rdbms\jlib\aqapi.jar;D:\jdev9i\j2ee\home\lib\jta.jar;D:\jdev9i\BC4J\lib\bc4jct.jar;D:\jdev9i\BC4J\lib\bc4jctejb.jar;D:\jdev9i\BC4J\lib\collections.jar;D:\jdev9i\j2ee\home\lib\ejb.jar;D:\jdev9i\j2ee\home\lib\jndi.jar;D:\jdev9i\BC4J\lib\bc4jmtejb.jar;D:\jdev9i\j2ee\home\lib\ejb.jar;D:\jdev9i\j2ee\home\lib\jndi.jar;D:\jdev9i\BC4J\jlib\bc4jdomgnrc.jar;D:\jdev9i\BC4J\lib\bc4jhtml.jar;D:\jdev9i\BC4J\lib\datatags.jar;D:\jdev9i\BC4J\lib\bc4juixtags.jar;D:\jdev9i\BC4J\lib\bc4j_jclient_common.jar;D:\jdev9i\BC4J\lib\bc4jct.jar;D:\jdev9i\BC4J\lib\bc4jctejb.jar;D:\jdev9i\BC4J\lib\collections.jar;D:\jdev9i\j2ee\home\lib\ejb.jar;D:\jdev9i\j2ee\home\lib\jndi.jar;D:\jdev9i\j2ee\home\lib\jta.jar;D:\jdev9i\j2ee\home\oc4jclient.jar;D:\jdev9i\j2ee\home\lib\jms.jar;D:\jdev9i\j2ee\home\lib\jaas.jar;D:\jdev9i\BC4J\lib\bc4jdomorcl.jar;D:\jdev9i\BC4J\jlib\bc4jdatum.jar;D:\jdev9i\BC4J\lib\bc4jmt.jar;D:\jdev9i\BC4J\lib\collections.jar;D:\jdev9i\BC4J\lib\bc4jct.jar;D:\jdev9i\lib\xmlparserv2.jar;D:\jdev9i\j2ee\home\lib\jndi.jar;D:\jdev9i\BC4J\jlib\bc4jstruts.jar;D:\jdev9i\BC4J\jlib\bc4jtester.jar;D:\jdev9i\jlib\jdev-cm.jar;D:\jdev9i\lib\xmlparserv2.jar;D:\jdev9i\jlib\help4-nls.jar;D:\jdev9i\jlib\help4.jar;D:\jdev9i\jlib\share.jar;D:\jdev9i\jlib\jewt4-nls.jar;D:\jdev9i\jlib\jewt4.jar;D:\jdev9i\jlib\oracle_ice5.jar;D:\jdev9i\BC4J\lib\bc4jct.jar;D:\jdev9i\BC4J\lib\collections.jar;D:\jdev9i\BC4J\jlib\bc4jctvb.jar;D:\jdev9i\vbroker4\lib\vbjorb.jar;D:\jdev9i\j2ee\home\lib\jndi.jar;D:\jdev9i\jlib\LW_PfjBean.jar;D:\jdev9i\jlib\jdev-cm.jar;D:\jdev9i\jdev\lib\dmsstub.jar;D:\jdev9i\jdev\lib\ebiadapters.jar;D:\jdev9i\lib\xmlparserv2.jar;D:\jdev9i\rdbms\jlib\jmscommon.jar;D:\jdev9i\rdbms\jlib\aqapi.jar;D:\jdev9i\jdev\lib\jdebi.jar;D:\jdev9i\jlib\oracle_ice5.jar;D:\jdev9i\BC4J\jlib\dacf.zip;D:\jdev9i\jdev\infobus\lib\infobus.jar;D:\jdev9i\j2ee\home\lib\activation.jar;D:\jdev9i\j2ee\home\lib\ejb.jar;D:\jdev9i\j2ee\home\lib\jaas.jar;D:\jdev9i\j2ee\home\lib\jaxp.jar;D:\jdev9i\j2ee\home\lib\jcert.jar;D:\jdev9i\j2ee\home\lib\jdbc.jar;D:\jdev9i\j2ee\home\lib\jms.jar;D:\jdev9i\j2ee\home\lib\jndi.jar;D:\jdev9i\j2ee\home\lib\jnet.jar;D:\jdev9i\j2ee\home\lib\jsse.jar;D:\jdev9i\j2ee\home\lib\jta.jar;D:\jdev9i\j2ee\home\lib\mail.jar;D:\jdev9i\ord\jlib\jmf.jar;D:\jdev9i\BC4J\jlib\bc4jui.jar;D:\jdev9i\jlib\bigraphbean.jar;D:\jdev9i\jlib\LW_PfjBean.jar;D:\jdev9i\classes;D:\jdev9i\jdev\lib\jdev.jar;D:\jdev9i\jdev\lib\jdscm.jar;D:\jdev9i\jdev\lib\jdev.jar;D:\jdev9i\jdev\lib\jdukshare.jar;D:\jdev9i\jdev\lib\jgl3.1.0.jar;D:\jdev9i\lib\aurora_client.jar;D:\jdev9i\vbroker4\lib\vbjorb.jar;D:\jdev9i\vbroker4\lib\vbjdev.jar;D:\jdev9i\vbroker4\lib\vbdev.jar;D:\jdev9i\javavm\lib\aurora.zip;D:\jdev9i\sqlj\lib\translator.jar;D:\jdev9i\sqlj\lib\runtime.jar;D:\jdev9i\lib\mts.jar;D:\jdev9i\j2ee\home\lib\ojsp.jar;D:\jdev9i\j2ee\home\jsp\lib\taglib\ojsputil.jar;D:\jdev9i\j2ee\home\oc4j.jar;D:\jdev9i\j2ee\home\lib\servlet.jar;D:\jdev9i\jdev\lib\ojc.jar;D:\jdev9i\jdev\lib\ext\..\..\..\bibeans\lib\olap_api_901.jar;D:\jdev9i\orant\lite\classes\olite40.jar;D:\jdev9i\j2ee\home\oc4j.jar;D:\jdev9i\jlib\bigraphbean.jar;D:\jdev9i\jlib\bigraphbean-nls.zip;D:\jdev9i\lib\dms.jar;D:\jdev9i\forms90\java\f90all.jar;D:\jdev9i\BC4J\lib\bc4jimdomains.jar;D:\jdev9i\ord\jlib\ordim.jar;D:\jdev9i\ord\jlib\ordhttp.jar;D:\jdev9i\BC4J\lib\bc4jimdomains.jar;D:\jdev9i\BC4J\jlib\bc4jimjui.jar;D:\jdev9i\ord\jlib\ordim.jar;D:\jdev9i\ord\jlib\ordhttp.jar;D:\jdev9i\ord\jlib\jmf.jar;D:\jdev9i\jdev\lib\ojc.jar;D:\jdev9i\jlib\share.jar;D:\jdev9i\jlib\jewt4.jar;D:\jdev9i\jlib\jewt4-nls.jar;D:\jdev9i\jlib\inspect4.jar;D:\jdev9i\jlib\inspect4-nls.jar;D:\jdev9i\jlib\dbui2.zip;D:\jdev9i\jlib\dbui2-nls.zip;D:\jdev9i\jlib\help4.jar;D:\jdev9i\jlib\help4-nls.jar;D:\jdev9i\webservices\lib\wsdl.jar;D:\jdev9i\jdev\lib\jdev-rt.jar;D:\jdev9i\soap\lib\soap.jar;D:\jdev9i\lib\xmlparserv2.jar;D:\jdev9i\jlib\javax-ssl-1_2.jar;D:\jdev9i\jlib\jssl-1_2.jar;D:\jdev9i\j2ee\home\lib\activation.jar;D:\jdev9i\j2ee\home\lib\mail.jar;D:\jdev9i\j2ee\home\lib\http_client.jar;D:\jdev9i\ds\uddi\lib\uddiclient.jar;D:\jdev9i\lib\xmlparserv2.jar;D:\jdev9i\lib\xmlcomp.jar;D:\jdev9i\rdbms\jlib\xsu12.jar;D:\jdev9i\j2ee\home\oc4j.jar;D:\jdev9i\j2ee\home\lib\servlet.jar;D:\jdev9i\sqlj\lib\runtime12.jar;D:\jdev9i\jakarta-struts\lib\struts.jar;D:\jdev9i\lib\xmlparserv2.jar;D:\jdev9i\jlib\regexp.jar;D:\jdev9i\jlib\share.jar;D:\jdev9i\jlib\uix2.jar;D:\jdev9i\vbroker4\lib\vbjorb.jar;D:\jdev9i\vbroker4\lib\vbjdev.jar;D:\jdev9i\vbroker4\lib\vbdev.jar;D:\jdev9i\lib\oraclexsql.jar;D:\jdev9i\rdbms\jlib\xsu12.jar;D:\jdev9i\lib\xsqlserializers.jar;D:\jdev9i\lib\xmlparserv2.jar DiscoverMeta.DiscoverMeta
start connect
end connect
start init
end init
end getDefaultMetadataProvider
oracle.express.mdm.MetadataNotFoundException
     oracle.olapi.metadata.MetadataObject oracle.express.mdm.MdmMetadataProvider$Holder.getMetadataObject()
          MdmMetadataProvider.java:170
     oracle.express.mdm.MdmObject oracle.express.mdm.MdmMetadataProvider.getMetadataObject(java.lang.String)
          MdmMetadataProvider.java:410
     oracle.express.mdm.MdmSchema oracle.express.mdm.MdmMetadataProvider.getRootSchema()
          MdmMetadataProvider.java:548
     void DiscoverMeta.DiscoverMeta.<init>()
          DiscoverMeta.java:53
     void DiscoverMeta.DiscoverMeta.main(java.lang.String[])
          DiscoverMeta.java:67
Process exited with exit code 0.
================================================================================
when running the following program.
================================================================================
package DiscoverMeta;
import oracle.express.olapi.transaction.*;
import com.sun.java.util.collections.ArrayList;
import com.sun.java.util.collections.List;
import com.sun.java.util.collections.Iterator;
import oracle.express.mdm.*;
import oracle.olapi.metadata.MetadataObject;
import oracle.olapi.data.source.Source;
import oracle.express.olapi.data.full.ExpressDataProvider;
public class DiscoverMeta
{
public DiscoverMeta()
{
String Answer="";
String host = "obs.obs.obs.de";
String port = "1573";
String sid = "BIDEMO";
String s1 = "jdbc:oracle:thin:#" + host + ":" + port + ":" + sid ;
String user = "OBFUSCATED";
String password = "OBFUSCATED";
// connection
try {
System.out.println("start connect");
Class.forName("oracle.jdbc.driver.OracleDriver");
oracle.jdbc.OracleConnection conn = (oracle.jdbc.OracleConnection)
java.sql.DriverManager.getConnection(s1, user, password);
System.out.println("end connect");
ExpressTransactionProvider tp = new ExpressTransactionProvider();
ExpressDataProvider dp = new ExpressDataProvider(conn,tp);
System.out.println("start init");
dp.initialize();
// End connection
System.out.println("end init");
MdmMetadataProvider mp = null;
mp = (MdmMetadataProvider) dp.getDefaultMetadataProvider();
System.out.println("end getDefaultMetadataProvider");
MdmSchema root = null;
root = (MdmSchema)mp.getRootSchema();
System.out.println("end getRoot");
System.out.println(root.getName());
List dims = root.getDimensions();
}
catch (Exception e){
e.printStackTrace();
}
}
public static void main(String[] args)
{
DiscoverMeta discoverMeta = new DiscoverMeta();
}
}
================================================================================
This is not the error described in Doc ID: 371234.999 in Metalink. It is getRootSchema() that fails.
Regards,
Joern

Hi,
It seems this code cobtains only OLAP API calls, you may be better re-directing this question to the Oracle9i OLAP forum on OTN.
If you have further queries regarding BI Beans, please don't hesitate to post them here.
Thanks for your question.
BI Beans
Product Management 

Ok, ok, what about this one:
after creating a BI Designer, creating a new presentation or calculation gives this error
oracle.express.mdm.MetadataNotFoundException
     oracle.olapi.metadata.MetadataObject oracle.express.mdm.MdmMetadataProvider$Holder.getMetadataObject()
          MdmMetadataProvider.java:170
     oracle.express.mdm.MdmObject oracle.express.mdm.MdmMetadataProvider.getMetadataObject(java.lang.String)
          MdmMetadataProvider.java:410
     oracle.express.mdm.MdmSchema oracle.express.mdm.MdmMetadataProvider.getRootSchema()
          MdmMetadataProvider.java:548
     oracle.express.mdm.MdmSchema oracle.dss.metadataManager.server.drivers.mdm._92.MDMMetadataDriverImpl_92.getMdmSchema()
          MDMMetadataDriverImpl_92.java:1285
     oracle.dss.metadataManager.common.MDObject oracle.dss.metadataManager.server.drivers.mdm._92.MDMMetadataDriverImpl_92.getRoot()
          MDMMetadataDriverImpl_92.java:974
     oracle.dss.metadataManager.common.MDRoot oracle.dss.metadataManager.server.drivers.mdm._92.MDMMetadataDriverImpl_92.addToObjectModel(oracle.dss.metadataManager.common.MDRoot)
          MDMMetadataDriverImpl_92.java:2261
     oracle.dss.metadataManager.common.MDRoot oracle.dss.metadataManager.server.drivers.mdm.MDMMetadataDriverImpl.addToObjectModel(oracle.dss.metadataManager.common.MDRoot)
          MDMMetadataDriverImpl.java:283
     void oracle.dss.metadataManager.server.MetadataManagerImpl.buildObjectModel()
          MetadataManagerImpl.java:1092
     oracle.dss.metadataManager.common.MDRoot oracle.dss.metadataManager.server.MetadataManagerImpl.attach(oracle.dss.metadataManager.common.MDRoot, oracle.dss.metadataUtil.PropertyBag)
          MetadataManagerImpl.java:962
     int oracle.dss.metadataManager.client.MetadataManager.attach(oracle.dss.metadataUtil.PropertyBag)
          MetadataManager.java:866
     int oracle.dss.metadataManager.client.MetadataManager.attach()
          MetadataManager.java:792
     oracle.dss.metadataManager.client.MetadataManager oracle.dss.addins.designer.BIDesignerImpl.getMetadataManager(boolean)
          BIDesignerImpl.java:987
     oracle.dss.metadataManager.client.MetadataManager oracle.dss.addins.designer.BIDesignerImpl.getMetadataManager(boolean, boolean)
          BIDesignerImpl.java:927
     void oracle.dss.addins.wizard.presentation.PresentationWizardContext.initQueryBuilder()
          PresentationWizardContext.java:83
     void oracle.dss.addins.wizard.presentation.PresentationWizardContext.setDesigner(oracle.dss.addins.designer.BIDesigner)
          PresentationWizardContext.java:149
     oracle.dss.addins.designer.BIObject oracle.dss.addins.wizard.presentation.PresentationWizardAddin.createPresentation(oracle.ide.addin.Context, java.lang.String[], oracle.dss.addins.designer.BIFolder, oracle.dss.addins.designer.BIDesigner, boolean, java.awt.Window)
          PresentationWizardAddin.java:83
     oracle.dss.addins.designer.BIObject oracle.dss.addins.designer.BIDesignerImpl.createPresentation(oracle.ide.addin.Context, java.lang.String[], boolean, java.awt.Window)
          BIDesignerImpl.java:1483
     void oracle.dss.addins.wizard.javaApp.BIStartPresentationPanel.btnNew_actionPerformed(java.awt.event.ActionEvent)
          BIStartPresentationPanel.java:269
     void oracle.dss.addins.wizard.javaApp.BIStartPresentationPanel$4.actionPerformed(java.awt.event.ActionEvent)
          BIStartPresentationPanel.java:131
     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.common.wizard.AbstractBuilderDialog.setVisible(boolean)
          AbstractBuilderDialog.java:283
     void oracle.dss.addins.wizard.javaApp.BIJavaWizardDialog.setVisible(boolean)
          BIJavaWizardDialog.java:38
     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:263
     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.javaApp.BIJavaAppWizardAddin.invoke(oracle.ide.addin.Context, java.lang.String[])
          BIJavaAppWizardAddin.java:59
     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
But i think the reason for these two errors (OLAP API and BI BEANS) is the same.
Regards,
Joern

Well, Thanks to Syarif Ahmed, John Jogminas and others
"You have to change all the jar files in <JDEV_HOME>\jdbc\lib with the new ones from your Oracle 9.2.0.1 installation directory (<ORA_HOME\jdbc\lib>). "
It actually solves the problem.
Regards,
Joern

Related

Exception while creating JSR Portlet

hi,
We are trying to create a new JSR portlet using JDevoloper. We have installed all the necessary plugin and jar files to enable to do so. After choosing a "java portlet" option from the web tier -> portlets option we were able to go through the wizard which comes up to devolop a new java portlet. However as soon as we click "Finished", Jdevoloper throws up following error. A urgernt help on this will really be helpful to us. Thanks
Exception occurred during event dispatching:
oracle.xml.parser.v2.XMLDOMException: Node does not exist.
org.w3c.dom.Node
oracle.xml.parser.v2.XMLAttrList.removeNamedItemNS(java
.lang.String, java.lang.String)
XMLAttrList.java:711
void
oracle.xml.parser.v2.XMLElement.removeAttributeNS(java.lang.String,
java.lang.String)
XMLElement.java:1309
void
com.sun.xml.bind.marshaller.SAX2DOMEx.startElement(java.lang.String
, java.lang.String, java.lang.String, org.xml.sax.Attributes)
SAX2DOMEx.java:105
void
org.xml.sax.helpers.XMLFilterImpl.startElement(java.lang.String, ja
va.lang.String, java.lang.String, org.xml.sax.Attributes)
XMLFilterImpl.java:575
void
com.sun.xml.bind.marshaller.SchemaLocationFilter.startElement(java.
lang.String, java.lang.String, java.lang.String, org.xml.sax.Attributes)
SchemaLocationFilter.java:111
void
oracle.webdb.wsrp.server.meta.impl.runtime.SAXMarshaller.endAttribu
tes()
SAXMarshaller.java:169
void
oracle.webdb.wsrp.server.meta.impl.PortletAppImpl.serializeElementB
ody(oracle.webdb.wsrp.server.meta.impl.runtime.XMLSerializer)
PortletAppImpl.java:42
void
oracle.webdb.wsrp.server.meta.impl.runtime.MarshallerImpl.write(ora
cle.webdb.wsrp.server.meta.impl.runtime.XMLSerializable,
org.xml.sax.ContentHand
ler)
MarshallerImpl.java:161
void
oracle.webdb.wsrp.server.meta.impl.runtime.MarshallerImpl.marshal(j
ava.lang.Object, javax.xml.transform.Result)
MarshallerImpl.java:101
void
javax.xml.bind.helpers.AbstractMarshallerImpl.marshal(java.lang.Obj
ect, org.w3c.dom.Node)
AbstractMarshallerImpl.java:87
char[]
oracle.webdb.jdev.wsrp.PortletAppNode.marshallPortletApp(oracle.w
ebdb.wsrp.server.meta.PortletApp)
PortletAppNode.java:331
void
oracle.webdb.jdev.wsrp.PortletAppNode.commitPortletApp(oracle.webdb
.wsrp.server.meta.PortletApp)
PortletAppNode.java:271
void
oracle.webdb.jdev.wsrp.PortletWizardController.wizardFinished(oracl
e.bali.ewt.wizard.WizardEvent)
PortletWizardController.java:189
void
oracle.bali.ewt.wizard.BaseWizard.processWizardEvent(oracle.bali.ew
t.wizard.WizardEvent)
void
oracle.bali.ewt.wizard.BaseWizard.processEventImpl(java.awt.AWTEven
t)
void oracle.bali.ewt.LWComponent.processEvent(java.awt.AWTEvent)
void oracle.bali.ewt.wizard.BaseWizard.doFinish()
void
oracle.bali.ewt.wizard.BaseWizard$Action.actionPerformed(java.awt.e
vent.ActionEvent)
void
javax.swing.AbstractButton.fireActionPerformed(java.awt.event.Actio
nEvent)
AbstractButton.java:1450
void
javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(java
.awt.event.ActionEvent)
AbstractButton.java:1504
void
javax.swing.DefaultButtonModel.fireActionPerformed(java.awt.event.A
ctionEvent)
DefaultButtonModel.java:378
void javax.swing.DefaultButtonModel.setPressed(boolean)
DefaultButtonModel.java:250
void
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(java.awt.e
vent.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.Componen
t, 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.C
omponent)
EventDispatchThread.java:131
void
java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Condit
ional, 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.ide.wizard.TitledWizardDialog.runDialog()
TitledWizardDialog.java:147
boolean oracle.webdb.provider.v2.jdev.BaseWizardController.run()
BaseWizardController.java:178
boolean
oracle.webdb.jdev.wsrp.PortletWizard.invoke(oracle.ide.addin.Con
text, java.lang.String[])
PortletWizard.java:120
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.C
omponent)
EventDispatchThread.java:131
void
java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Condit
ional, 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
Hello
Help on creating JSR portlet in JDevoloper.
regards
Tugdual Grall

openConnection exception

Hi All,
We are running oracle 9iLite ver 5.0.1 against an 8.1.7 database (on Windows 2000). The following exception is thrown even though the java code succesfully connects to the Repository. What may be the reason ? The exception is NOT caught by the catch block...
Thanks.
-vasudeva
The java code is as follows :
try
{
ResourceManager.openConnection(schema, password);
System.out.println("Succesfully Connected");
}
catch (Exception e)
{
System.out.println("Exception = " + e.toString());
return;
}
The out put is :
java.lang.NullPointerException
     void oracle.lite.sync.SiteDef.<clinit>()
     void oracle.lite.sync.Consolidator.<clinit>()
     oracle.lite.web.resource.ResourceFactory oracle.lite.web.resource.ResourceFactory.getInstance(java.sql.Connection)
     void oracle.mobile.admin.ResourceManager.<init>(java.lang.String, java.lang.String, java.lang.String)
     void oracle.mobile.admin.ResourceManager.<init>(java.lang.String, java.lang.String)
     void oracle.mobile.admin.ResourceManager.openConnection(java.lang.String, java.lang.String)
     void SentToDeveloper.main(java.lang.String[])
Succesfully Connected

Access to OLAP Metadata from BI Beans 903

Hi,
we have a problem accessing OLAP objects via BI Beans.
Having created OLAP dimensions and facts via OWB or EIM, we were not able to see them in the BI Beans Query Builder.
We then ran the "cwm2_olap_metadata_refresh.mr_refresh" routine on the OLAPSYS schema, which is supposed to update the CWM OLAP objects into CWM2 format.
In BI Beans we now try to connect to our schema which contains the OLAP objects; the connection is fine; when doing "New (matrix, table, graph)", we get a Query Builder error message : "Unable to initialize Query Builder"
On the detail screen (see java error below), it seems that dimensions cannot be retrieved from the OLAP catalog.
However, we see entries for our dimensions when looking in union views, such as all$olap2udimensions or in tables such as the CWM2$MRALL_HIERDIMS table.
Thanks,
Klaus
oracle.dss.dataSource.common.QueryRuntimeException
java.lang.NullPointerException
java.util.Vector oracle.dss.dataSource.common.QueryQueryAccess.getDimensions(java.lang.String)
QueryQueryAccess.java:413
java.util.Vector oracle.dss.queryBuilder.QueryBuilderQueryAccessUtils.getVisibleDimensions(java.lang.String)
QueryBuilderQueryAccessUtils.java:130
java.util.Vector oracle.dss.queryBuilder.QueryBuilderUtils.getVisibleDimensions(oracle.dss.queryBuilder.QueryBuilder)
QueryBuilderUtils.java:495
void oracle.dss.queryBuilder.QueryBuilderUI.createDefaultPanels()
QueryBuilderUI.java:405
void oracle.dss.queryBuilder.QueryBuilderUI.init()
QueryBuilderUI.java:351
boolean oracle.dss.queryBuilder.QueryBuilder.initialize()
QueryBuilder.java:2337
void oracle.dss.addins.wizard.presentation.PresentationWizardContext.initQueryBuilder()
PresentationWizardContext.java:102
void oracle.dss.addins.wizard.presentation.PresentationWizardContext.setDesigner(oracle.dss.addins.designer.BIDesigner)
PresentationWizardContext.java:149
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:64
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
java.lang.NullPointerException
java.lang.Object java.util.Hashtable.put(java.lang.Object, java.lang.Object)
Hashtable.java:380
oracle.dss.metadataManager.common.MDDimension oracle.dss.dataSource.common.Query.getMeasureDim()
Query.java:3015
oracle.dss.metadataManager.common.MDDimension oracle.dss.dataSource.common.QueryQueryAccess._getMeasureDimension()
QueryQueryAccess.java:679
java.lang.String oracle.dss.dataSource.common.QueryQueryAccess.getMeasureDimension(java.lang.String)
QueryQueryAccess.java:456
void oracle.dss.dataSource.common.QueryQueryAccess._initializeDimensionality()
QueryQueryAccess.java:792
java.util.Vector oracle.dss.dataSource.common.QueryQueryAccess.getDimensions(java.lang.String)
QueryQueryAccess.java:409
java.util.Vector oracle.dss.queryBuilder.QueryBuilderQueryAccessUtils.getVisibleDimensions(java.lang.String)
QueryBuilderQueryAccessUtils.java:130
java.util.Vector oracle.dss.queryBuilder.QueryBuilderUtils.getVisibleDimensions(oracle.dss.queryBuilder.QueryBuilder)
QueryBuilderUtils.java:495
void oracle.dss.queryBuilder.QueryBuilderUI.createDefaultPanels()
QueryBuilderUI.java:405
void oracle.dss.queryBuilder.QueryBuilderUI.init()
QueryBuilderUI.java:351
boolean oracle.dss.queryBuilder.QueryBuilder.initialize()
QueryBuilder.java:2337
void oracle.dss.addins.wizard.presentation.PresentationWizardContext.initQueryBuilder()
PresentationWizardContext.java:102
void oracle.dss.addins.wizard.presentation.PresentationWizardContext.setDesigner(oracle.dss.addins.designer.BIDesigner)
PresentationWizardContext.java:149
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:64
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
Hi,
Can you confirm the version number of the various products you are using please:
- Database
- JDeveloper
- BIBeans
- Oracle Warehouse Builder (OWB)
- EIM (can you explain what this is please)
I presume you have created a database using the data warehouse option of the Database Configuration Assistant. This should install a demo schema owned by the user SH. Can you create a crosstab using this schema. This will help determine the status of the metadata layer.
Keith Laker
BIBeans Product Manager
Oracle Corporation

Help on creating JSR portlet in JDevoloper

hi,
We are trying to create a new JSR portlet using JDevoloper. We have installed all the necessary plugin and jar files to enable us to do so. After choosing a "java portlet" option from the web tier -> portlets option we were able to go through the wizard which comes up to devolop a new java portlet. However as soon as we click "Finished", Jdevoloper throws up following error. A urgernt help on this will really be helpful to us. Thanks
Exception occurred during event dispatching:
oracle.xml.parser.v2.XMLDOMException: Node does not exist.
org.w3c.dom.Node
oracle.xml.parser.v2.XMLAttrList.removeNamedItemNS(java
.lang.String, java.lang.String)
XMLAttrList.java:711
void
oracle.xml.parser.v2.XMLElement.removeAttributeNS(java.lang.String,
java.lang.String)
XMLElement.java:1309
void
com.sun.xml.bind.marshaller.SAX2DOMEx.startElement(java.lang.String
, java.lang.String, java.lang.String, org.xml.sax.Attributes)
SAX2DOMEx.java:105
void
org.xml.sax.helpers.XMLFilterImpl.startElement(java.lang.String, ja
va.lang.String, java.lang.String, org.xml.sax.Attributes)
XMLFilterImpl.java:575
void
com.sun.xml.bind.marshaller.SchemaLocationFilter.startElement(java.
lang.String, java.lang.String, java.lang.String, org.xml.sax.Attributes)
SchemaLocationFilter.java:111
void
oracle.webdb.wsrp.server.meta.impl.runtime.SAXMarshaller.endAttribu
tes()
SAXMarshaller.java:169
void
oracle.webdb.wsrp.server.meta.impl.PortletAppImpl.serializeElementB
ody(oracle.webdb.wsrp.server.meta.impl.runtime.XMLSerializer)
PortletAppImpl.java:42
void
oracle.webdb.wsrp.server.meta.impl.runtime.MarshallerImpl.write(ora
cle.webdb.wsrp.server.meta.impl.runtime.XMLSerializable,
org.xml.sax.ContentHand
ler)
MarshallerImpl.java:161
void
oracle.webdb.wsrp.server.meta.impl.runtime.MarshallerImpl.marshal(j
ava.lang.Object, javax.xml.transform.Result)
MarshallerImpl.java:101
void
javax.xml.bind.helpers.AbstractMarshallerImpl.marshal(java.lang.Obj
ect, org.w3c.dom.Node)
AbstractMarshallerImpl.java:87
char[]
oracle.webdb.jdev.wsrp.PortletAppNode.marshallPortletApp(oracle.w
ebdb.wsrp.server.meta.PortletApp)
PortletAppNode.java:331
void
oracle.webdb.jdev.wsrp.PortletAppNode.commitPortletApp(oracle.webdb
.wsrp.server.meta.PortletApp)
PortletAppNode.java:271
void
oracle.webdb.jdev.wsrp.PortletWizardController.wizardFinished(oracl
e.bali.ewt.wizard.WizardEvent)
PortletWizardController.java:189
void
oracle.bali.ewt.wizard.BaseWizard.processWizardEvent(oracle.bali.ew
t.wizard.WizardEvent)
void
oracle.bali.ewt.wizard.BaseWizard.processEventImpl(java.awt.AWTEven
t)
void oracle.bali.ewt.LWComponent.processEvent(java.awt.AWTEvent)
void oracle.bali.ewt.wizard.BaseWizard.doFinish()
void
oracle.bali.ewt.wizard.BaseWizard$Action.actionPerformed(java.awt.e
vent.ActionEvent)
void
javax.swing.AbstractButton.fireActionPerformed(java.awt.event.Actio
nEvent)
AbstractButton.java:1450
void
javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(java
.awt.event.ActionEvent)
AbstractButton.java:1504
void
javax.swing.DefaultButtonModel.fireActionPerformed(java.awt.event.A
ctionEvent)
DefaultButtonModel.java:378
void javax.swing.DefaultButtonModel.setPressed(boolean)
DefaultButtonModel.java:250
void
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(java.awt.e
vent.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.Componen
t, 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.C
omponent)
EventDispatchThread.java:131
void
java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Condit
ional, 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.ide.wizard.TitledWizardDialog.runDialog()
TitledWizardDialog.java:147
boolean oracle.webdb.provider.v2.jdev.BaseWizardController.run()
BaseWizardController.java:178
boolean
oracle.webdb.jdev.wsrp.PortletWizard.invoke(oracle.ide.addin.Con
text, java.lang.String[])
PortletWizard.java:120
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.C
omponent)
EventDispatchThread.java:131
void
java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Condit
ional, 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
Hello Tushar,
Here some information about the Wizard
- you must use Oracle JDeveloper 9.0.3.x (it does not work in the the 10g version. Oracle Portal Team is currently working on the migration of the wizard)
- be sure that you are using the Java Web Service Development Pack (JWSDP) version 1.2. available on the archive section of the Sun web site.
Regards
Tugdual Grall

ora-00932

Hi,
After selecting the measures and dimension in the query builder pressing the next button gives the following error
Thu Mar 11 22:16:34 CET 2004 In BuilderWizardValidateAdapter::wizardValidatePage
oracle.express.ExpressServerExceptionFoutklasse: OLAPI
Serverfoutbeschrijvingen:
DPR: Kan geen servercursor maken., Algemeen in TxsOqDefinitionManagerSince9202::
crtCurMgrWthInputTypes
OES: ORA-00932: inconsistente gegevenstypen: CHAR verwacht, NUMBER verkregen.
, Algemeen in TxsRdbSelectStatement:execute()
oracle.express.idl.ExpressOlapiDataCursorModule.CursorManagerInterface o
racle.express.olapi.data.full.DefinitionManagerSince9202.createCursorManagerInte
rface(oracle.olapi.data.source.CursorManagerSpecification, oracle.olapi.data.sou
rce.SourceDefinition, oracle.olapi.data.source.Source[], long)
DefinitionManagerSince9202.java:260
oracle.express.olapi.data.full.ExpressSpecifiedCursorManager oracle.expr
ess.olapi.data.full.DefinitionManager.createCursorManager(oracle.olapi.data.sour
ce.CursorManagerSpecification, oracle.olapi.data.source.Source[], long)
DefinitionManager.java:132
oracle.olapi.data.source.SpecifiedCursorManager oracle.express.olapi.dat
a.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.dat
a.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.dat
a.full.ExpressDataProvider.createCursorManager(oracle.olapi.data.source.CursorMa
nagerSpecification, oracle.olapi.data.source.Source[])
ExpressDataProvider.java:555
oracle.olapi.data.source.SpecifiedCursorManager oracle.olapi.data.source
.DataProvider.createCursorManager(oracle.olapi.data.source.CursorManagerSpecific
ation)
DataProvider.java:269
oracle.express.olapi.data.full.ExpressSpecifiedCursorManager[] oracle.ds
s.dataSource.QueryUtilities.setUpCursors(oracle.dss.dataSource.SourceTemplate[],
oracle.dss.dataSource.common.CubeCursor[], oracle.olapi.data.source.Source[], o
racle.express.olapi.data.full.ExpressSpecifiedCursorManager[], boolean, boolean,
boolean, boolean)
QueryUtilities.java:543
oracle.express.olapi.data.full.ExpressSpecifiedCursorManager[] oracle.ds
s.dataSource.QueryServer._setUpCursorsForMainQuery(oracle.dss.dataSource.SourceT
emplate[], oracle.dss.dataSource.common.CubeCursor[], boolean, boolean, boolean,
boolean)
QueryServer.java:7020
void oracle.dss.dataSource.QueryServer._getCursorForCube(oracle.dss.data
Source.common.DimTree, boolean, boolean, boolean, boolean, boolean)
QueryServer.java:4080
void oracle.dss.dataSource.QueryServer._createCubeAndCursor(boolean, boo
lean, boolean)
QueryServer.java:4235
void oracle.dss.dataSource.QueryServer._createCommonQuery(java.lang.Stri
ng[][], java.lang.String[], oracle.dss.util.Operation, oracle.dss.dataSource.com
mon.QueryState)
QueryServer.java:3878
void oracle.dss.dataSource.QueryServer._initCubeQuery(java.lang.String[]
, java.lang.String[][], oracle.dss.util.Operation, oracle.dss.dataSource.common.
QueryState)
QueryServer.java:3763
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.addOper
ation(oracle.dss.util.Operation, int)
BaseOperationQueue.java:176
java.lang.Object oracle.dss.dataSource.common.BaseOperationQueue.addOper
ation(oracle.dss.util.Operation)
BaseOperationQueue.java:146
java.lang.Object oracle.dss.dataSource.QueryServer.queueOperation(java.l
ang.String, oracle.dss.util.Parameter[], boolean, oracle.dss.dataSource.common.Q
ueryEvent, java.lang.String, oracle.dss.util.Parameter[], oracle.dss.dataSource.
common.QueryState)
QueryServer.java:7057
void oracle.dss.dataSource.QueryServer.initCubeQuery(java.lang.String[],
java.lang.String[][])
QueryServer.java:3704
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(orac
le.dss.dataSource.common.BaseOperationQueue)
QueryManagerServer.java:1483
java.lang.Object oracle.dss.dataSource.common.OperationQueue.update()
OperationQueue.java:198
java.lang.Object oracle.dss.dataSource.common.BaseOperationQueue.addOper
ation(oracle.dss.util.Operation, int)
BaseOperationQueue.java:176
java.lang.Object oracle.dss.dataSource.common.BaseOperationQueue.addOper
ation(oracle.dss.util.Operation)
BaseOperationQueue.java:146
void oracle.dss.dataSource.client.QueryClient._initCubeQuery(oracle.dss.
dataSource.common.BaseOperationQueue, java.lang.String[], java.lang.String[][])
QueryClient.java:1536
void oracle.dss.dataSource.client.QueryClient.initCubeQuery(java.lang.St
ring[], java.lang.String[][])
QueryClient.java:1523
void oracle.dss.dataSource.common.QueryLayoutAccess.setMeasures(java.lan
g.String[])
QueryLayoutAccess.java:122
void oracle.dss.queryBuilder.SelectedItemsPanel.updateDims()
SelectedItemsPanel.java:522
boolean oracle.dss.queryBuilder.SelectedItemsPanel.setActive(boolean)
SelectedItemsPanel.java:348
boolean oracle.dss.queryBuilder.ItemsPanel.setActive(boolean)
ItemsPanel.java:251
boolean oracle.dss.datautil.gui.DefaultBuilderDialog.setActive(java.lang
.String, boolean)
DefaultBuilderDialog.java:1064
boolean oracle.dss.addins.common.wizard.AbstractBuilderDialog.setActive(
java.lang.String, boolean)
AbstractBuilderDialog.java:492
boolean oracle.dss.datautil.gui.DefaultBuilderDialog.validateNextPreviou
sEvent(oracle.bali.ewt.wizard.WizardEvent)
DefaultBuilderDialog.java:1388
boolean oracle.dss.addins.common.wizard.AbstractBuilderDialog.validateNe
xtPreviousEvent(oracle.bali.ewt.wizard.WizardEvent)
AbstractBuilderDialog.java:325
boolean oracle.dss.addins.wizard.presentation.PresentationWizardDialog.v
alidateNextPreviousEvent(oracle.bali.ewt.wizard.WizardEvent)
PresentationWizardDialog.java:97
void oracle.dss.datautil.gui.DefaultBuilderDialog$BuilderWizardValidateA
dapter.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.e
vent.ActionEvent)
void javax.swing.AbstractButton.fireActionPerformed(java.awt.event.Actio
nEvent)
AbstractButton.java:1450
void javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(java
.awt.event.ActionEvent)
AbstractButton.java:1504
void javax.swing.DefaultButtonModel.fireActionPerformed(java.awt.event.A
ctionEvent)
DefaultButtonModel.java:378
void javax.swing.DefaultButtonModel.setPressed(boolean)
DefaultButtonModel.java:250
void javax.swing.plaf.basic.BasicButtonListener.mouseReleased(java.awt.e
vent.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.Componen
t, 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.C
omponent)
EventDispatchThread.java:131
void java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Condit
ional, 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(bo
olean)
AbstractBuilderDialog.java:286
void oracle.dss.addins.wizard.presentation.PresentationWizardDialog.setV
isible(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.Co
ntext, java.lang.String[])
BIWizardImpl.java:147
boolean oracle.dss.addins.wizard.presentation.PresentationWizardAddin.in
voke(oracle.ide.addin.Context, java.lang.String[])
PresentationWizardAddin.java:54
boolean oracle.dss.addins.wizard.presentation.PresentationWizardAddin.in
vokeFromMenu(oracle.ide.addin.Context, java.lang.String[], oracle.dss.addins.des
igner.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.Actio
nEvent)
AbstractButton.java:1450
void javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(java
.awt.event.ActionEvent)
AbstractButton.java:1504
void javax.swing.DefaultButtonModel.fireActionPerformed(java.awt.event.A
ctionEvent)
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.mouseRelea
sed(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.Componen
t, 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.C
omponent)
EventDispatchThread.java:131
void java.awt.EventDispatchThread.pumpEventsForHierarchy(java.awt.Condit
ional, 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
Jurgen 
This can happens if you defined character measure but didn't change default aggregation from 'SUM' to something applicable (sorry for my Deutsch, but I cannot translate is CHAR or NUMBER value expected)

Categories

Resources