10 Replies Latest reply on Dec 16, 2009 5:23 AM by 101340

    Problems creating physical data service to relational table

    672962
      Good morning.

      I am running AquaLogic Data Services Platform 3.2 on WebLogic 10.0 in a JRockit 1.5 Java VM on my PC (and it is not a clustered environment) under Windows XP SP3.

      I am trying to create access functionality to a table in a MS SQL 2005 database, but I am having trouble with the update map functionality. I can create and test the read function with no problems. When I try to edit the return structure, it gives me the following warning message

      Cannot narrow remote object ClusterableRemoteRef(-10913774038965890074S :127.0.0.1 :7102,7102,-1,-1,-1,-1,-1*:ESBDSP:AdminServer [(-10913774038965890074S :127.0.0.1 :*7102,7102,-1,-1,-1,-1,-1]:ESBDSP:AdminServer/320*)/320 to com.bea.dsp.ejb.ServerHome*

      (ESBDSP is the server domain, AdminServer is the WL server name, 7102 is the port)

      When I then try to alter a value and Submit, it gives me the following error message

      java.lang.NullPointerException
      ** at com.bea.dsp.ide.xquery.views.test.QueryExecutor.invokeUpdate(QueryExecutor.java:191)**
      ** at com.bea.dsp.ide.xquery.views.test.ResultPanel.submitChanges(ResultPanel.java:1313)**
      ** at com.bea.dsp.ide.xquery.views.test.ResultPanel.access$300(ResultPanel.java:111)**
      ** at com.bea.dsp.ide.xquery.views.test.ResultPanel$2.run(ResultPanel.java:1203)**
      ** at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:369)**
      ** at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:313)**
      ** at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:479)**
      ** at org.eclipse.ui.internal.progress.ProgressMonitorJobsDialog.run(ProgressMonitorJobsDialog.java:265)**
      ** at org.eclipse.ui.internal.progress.ProgressManager.run(ProgressManager.java:1107)**
      ** at com.bea.dsp.ide.xquery.views.test.ResultPanel.doSubmitImpl(ResultPanel.java:1210)**
      ** at com.bea.dsp.ide.xquery.views.test.ResultPanel.access$200(ResultPanel.java:111)**
      ** at com.bea.dsp.ide.xquery.views.test.ResultPanel$1.run(ResultPanel.java:1189)**
      ** at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:67)**
      ** at com.bea.dsp.ide.xquery.views.test.ResultPanel.doSubmit(ResultPanel.java:1193)**
      ** at com.bea.dsp.ide.xquery.views.test.ResultPanel.widgetSelected(ResultPanel.java:2779)**
      ** at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:90)**
      ** at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)**
      ** at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:928)**
      ** at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3348)**
      ** at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2968)**
      ** at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1930)**
      ** at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1894)**
      ** at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:422)**
      ** at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)**
      ** at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:95)**
      ** at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:78)**
      ** at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:92)**
      ** at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:68)**
      ** at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:400)**
      ** at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:177)**
      ** at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)**
      ** at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)**
      ** at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)**
      ** at java.lang.reflect.Method.invoke(Method.java:585)**
      ** at org.eclipse.core.launcher.Main.invokeFramework(Main.java:339)**
      ** at org.eclipse.core.launcher.Main.basicRun(Main.java:283)**
      ** at org.eclipse.core.launcher.Main.run(Main.java:984)**
      ** at org.eclipse.core.launcher.Main.eclipse_main(Main.java:959)**
      ** at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)**
      ** at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)**
      ** at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)**
      ** at java.lang.reflect.Method.invoke(Method.java:585)**
      ** at com.m7.installer.util.NitroxMain$1.run(NitroxMain.java:39)**
      ** at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:199)**
      ** at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)**
      ** at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)**
      ** at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)**
      ** at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)**
      ** at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)**
      ** at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)**

      I have also tried to test the update function using the following data graph

      *<sdo:datagraph xmlns:sdo="commonj.sdo">*
      *<changeSummary>*
      * <per:Persistance sdo:ref="#/sdo:datagraph/per:Persistance" xmlns:per="http://www.example.org/Persistance">*
      * <per:Value>a different value</per:Value>*
      * </per:Persistance>*
      * </changeSummary>*
      * <per:Persistance xmlns:per="http://www.example.org/Persistance">*
      * <per:ID>1</per:ID>*
      * </per:Persistance>*
      *</sdo:datagraph>*

      The error message I receive is the following

      *<Error> <ALDSP> <PW130131> <AdminServer> <ACTIVE ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <weblogic> <> <> <1229102443940> <BEA-000000> <Test> <System error while executing the query: {ld:Physical/Persistance}updatePersistance:1*


      *weblogic.xml.query.exceptions.XQuerySagaException: {bea-err}UPD003: Update failure: mixed outcome, update error dispatched (updateid=SAGA_2d641b85a027a9ba:43f1e2cd:11e2800892f:-7fd2): com.bea.dsp.wrappers.rdb.exceptions.RDBWrapperException: {bea-err}RDBW0025: esb: [UPDATE "ESBdev"."dbo"."Persistance"*


      *SET "Value" = ?*


      *WHERE (("ID" = ?) AND ("Value" = ?))]: [NULL, 1, a different value|http://forums.oracle.com/forums/]: Optimistic locking failure. Update count returned by database is 0, expected 1*


      at com.bea.ld.server.update.recovery.SagaRecovery.process(SagaRecovery.java:102)


      at com.bea.ld.server.update.recovery.DSPSagaManager.processSagaFailure(DSPSagaManager.java:219)


      at weblogic.xml.query.update.recovery.SagaState$2.afterCompletion(SagaState.java:83)


      at weblogic.xml.query.transaction.TransactionManager.afterCompletion(TransactionManager.java:133)


      at weblogic.transaction.internal.ServerSCInfo.doAfterCompletion(ServerSCInfo.java:1032)


      at weblogic.transaction.internal.ServerSCInfo.callAfterCompletions(ServerSCInfo.java:1011)


      at weblogic.transaction.internal.ServerTransactionImpl.callAfterCompletions(ServerTransactionImpl.java:2946)


      at weblogic.transaction.internal.ServerTransactionImpl.afterRolledBackStateHousekeeping(ServerTransactionImpl.java:2827)


      at weblogic.transaction.internal.ServerTransactionImpl.setRolledBack(ServerTransactionImpl.java:2803)


      at weblogic.transaction.internal.ServerTransactionImpl.globalRetryRollback(ServerTransactionImpl.java:3043)


      at weblogic.transaction.internal.ServerTransactionImpl.globalRollback(ServerTransactionImpl.java:2793)


      at weblogic.transaction.internal.ServerTransactionImpl.internalRollback(ServerTransactionImpl.java:397)


      at weblogic.transaction.internal.ServerTransactionImpl.rollback(ServerTransactionImpl.java:375)


      at weblogic.xml.query.transaction.TransactionHelper.rollback(TransactionHelper.java:102)


      at weblogic.xml.query.transaction.TransactionManager.teardownOnFailure(TransactionManager.java:262)


      at com.bea.ld.EJBRequestHandler.handleThrowable(EJBRequestHandler.java:810)


      at com.bea.ld.EJBRequestHandler.invokeOperation(EJBRequestHandler.java:311)


      at com.bea.ld.ServerBean.executeOperationStreaming(ServerBean.java:84)


      at com.bea.ld.Server_ydm4ie_EOImpl.executeOperationStreaming(Server_ydm4ie_EOImpl.java:354)


      at com.bea.ld.Server_ydm4ie_EOImpl_WLSkel.invoke(Unknown Source)


      at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:589)


      at weblogic.rmi.cluster.ClusterableServerRef.invoke(ClusterableServerRef.java:224)


      at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:479)


      at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)


      at weblogic.security.service.SecurityManager.runAs(Unknown Source)


      at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:475)


      at weblogic.rmi.internal.BasicServerRef.access$300(BasicServerRef.java:59)


      at weblogic.rmi.internal.BasicServerRef$BasicExecuteRequest.run(BasicServerRef.java:1016)


      at weblogic.work.ExecuteThread.execute(ExecuteThread.java:200)


      at weblogic.work.ExecuteThread.run(ExecuteThread.java:172)


      *com.bea.dsp.wrappers.rdb.exceptions.RDBWrapperException: {bea-err}RDBW0025: esb: [UPDATE "ESBdev"."dbo"."Persistance"*


      *SET "Value" = ?*


      *WHERE (("ID" = ?) AND ("Value" = ?))]: [NULL, 1, a different value|http://forums.oracle.com/forums/]: Optimistic locking failure. Update count returned by database is 0, expected 1*


      at com.bea.dsp.wrappers.rdb.exceptions.RDBWrapperException.create(RDBWrapperException.java:87)


      at weblogic.xml.query.exceptions.XQueryException.create(XQueryException.java:128)


      at weblogic.xml.query.exceptions.XQueryException.create(XQueryException.java:88)


      at weblogic.xml.query.exceptions.XQueryException.create(XQueryException.java:202)


      at weblogic.xml.query.exceptions.XQueryException.create(XQueryException.java:188)


      at com.bea.dsp.wrappers.rdb.runtime.ExecuteSQLUpdateInternal.raiseUpdateFailureException(ExecuteSQLUpdateInternal.java:19)


      at com.bea.dsp.wrappers.rdb.runtime.ExecuteSQLUpdateDeleteBase.executeSQL(ExecuteSQLUpdateDeleteBase.java:31)


      at com.bea.dsp.wrappers.rdb.runtime.ExecuteSQLRuntimeBase.prepareAndExecuteQuery(ExecuteSQLRuntimeBase.java:170)


      at com.bea.dsp.wrappers.rdb.runtime.ExecuteSQLModificationBase.prepareAndExecuteQuery(ExecuteSQLModificationBase.java:77)


      at com.bea.dsp.wrappers.rdb.runtime.ExecuteSQLRuntimeBase.fetchNext(ExecuteSQLRuntimeBase.java:95)


      at weblogic.xml.query.iterators.GenericIterator.next(GenericIterator.java:114)


      at weblogic.xml.query.runtime.core.ExecutionWrapper.fetchNext(ExecutionWrapper.java:85)


      at weblogic.xml.query.iterators.GenericIterator.hasNext(GenericIterator.java:135)


      at weblogic.xml.query.runtime.util.TokenBuffer.addAll(TokenBuffer.java:296)


      at weblogic.xml.query.update.runtime.Interpreter$Frame.setValueUsingTemporary(Interpreter.java:436)


      at weblogic.xml.query.update.runtime.Interpreter.processMSet(Interpreter.java:297)


      at weblogic.xml.query.update.runtime.Interpreter.run(Interpreter.java:125)


      at weblogic.xml.query.update.recovery.SagaInterpreter$NestedFactory$1.run(SagaInterpreter.java:134)


      at weblogic.xml.query.update.runtime.ExecuteRelational.fetchNext(ExecuteRelational.java:52)


      at weblogic.xml.query.iterators.GenericIterator.next(GenericIterator.java:114)


      at weblogic.xml.query.runtime.core.ExecutionWrapper.fetchNext(ExecutionWrapper.java:85)


      at weblogic.xml.query.iterators.GenericIterator.hasNext(GenericIterator.java:135)


      at weblogic.xml.query.runtime.util.TokenBuffer.addAll(TokenBuffer.java:296)


      at weblogic.xml.query.update.runtime.Interpreter$Frame.setValueUsingTemporary(Interpreter.java:436)


      at weblogic.xml.query.update.runtime.Interpreter.processMSet(Interpreter.java:297)


      at weblogic.xml.query.update.runtime.Interpreter.run(Interpreter.java:125)


      at weblogic.xml.query.update.recovery.SagaInterpreter$NestedFactory$1.run(SagaInterpreter.java:134)


      at weblogic.xml.query.update.recovery.SagaInterpreter.run(SagaInterpreter.java:54)


      at weblogic.xml.query.update.runtime.UVMRewritingEvaluatorImpl.run(UVMRewritingEvaluatorImpl.java:33)


      at weblogic.xml.query.xdbcimpl.XQSEStatementImpl.execute(XQSEStatementImpl.java:100)


      at com.bea.ld.server.XQueryInvocation.execute(XQueryInvocation.java:731)


      at com.bea.ld.EJBRequestHandler.invokeQueryInternal(EJBRequestHandler.java:611)


      at com.bea.ld.EJBRequestHandler.invokeOperationInternal(EJBRequestHandler.java:466)


      at com.bea.ld.EJBRequestHandler.invokeOperation(EJBRequestHandler.java:308)


      at com.bea.ld.ServerBean.executeOperationStreaming(ServerBean.java:84)


      at com.bea.ld.Server_ydm4ie_EOImpl.executeOperationStreaming(Server_ydm4ie_EOImpl.java:354)


      at com.bea.ld.Server_ydm4ie_EOImpl_WLSkel.invoke(Unknown Source)


      at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:589)


      at weblogic.rmi.cluster.ClusterableServerRef.invoke(ClusterableServerRef.java:224)


      at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:479)


      at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)


      at weblogic.security.service.SecurityManager.runAs(Unknown Source)


      at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:475)


      at weblogic.rmi.internal.BasicServerRef.access$300(BasicServerRef.java:59)


      at weblogic.rmi.internal.BasicServerRef$BasicExecuteRequest.run(BasicServerRef.java:1016)


      at weblogic.work.ExecuteThread.execute(ExecuteThread.java:200)

      at weblogic.work.ExecuteThread.run(ExecuteThread.java:172)

      One of the things I don't understand is why the SQL update seems to have the parameter values reversed and why it is using the Value column for it's wehere clause i.e

      *[UPDATE "ESBdev"."dbo"."Persistance"*
      *SET "Value" = ?*


      *WHERE (("ID" = ?) AND ("Value" = ?))]: *[NULL, 1, a different value]

      when it should really be

      *[UPDATE "ESBdev"."dbo"."Persistance"*


      *SET "Value" = ?*


      *WHERE ("ID" = ?)]: *[a different value, 1


      I hope someone has an idea as to what is going on.

      Edited by: MarcP on Dec 12, 2008 12:30 PM                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
        • 1. Re: Problems creating physical data service to relational table
          Mike Reiche-Oracle
          Hi Marc -

          ALDSP is trying to do what you asked. The value in the <changeSummary> is the old value, and the <Persistence> element that follows is what the new/current element is supposed to look like. So it has the arguments correct for the datagraph that was provided. If you want to learn more about what datagraph you should be sending - there is a good write in the ALDSP edocs. http://e-docs.bea.com/aldsp/docs30/datasrvc/Test%20an%20Update%20Procedure.html There is also more info at http://e-docs.bea.com/aldsp/docs30/datasrvc/Testing%20Data%20Services.html

          The Value column also appears in the WHERE clause - because of Optimistic Locking is about - it looks for a row that matches the "old values" (and the unmodified values in the new/current element). That way, if the row was modified by someone else in between when the object was read and the update, the update would fail - something useful when your application is updating bank account balances. There is discussion of Optimistic Locking in the links above

          - Mike
          1 person found this helpful
          • 2. Re: Problems creating physical data service to relational table
            672962

            Thanks Mike, I changed the graph the way you explained and the update works.

            I still have a problem with the create function.

            The XSD for the table looks like this



            *&lt;xs:schema targetNamespace="ld:Physical/Persistance2" xmlns:xs="http://www.w3.org/2001/XMLSchema"&gt;*
            * &lt;xs:element name="Persistance"&gt;*
            *&lt;xs:complexType&gt;*
            * &lt;xs:sequence&gt;*
            * &lt;xs:element name="ID" type="xs:int"/&gt;*
            * &lt;xs:element name="Project" type="xs:string"/&gt;*
            * &lt;xs:element name="Property" type="xs:string"/&gt;*
            * &lt;xs:element name="Value" type="xs:string" minOccurs="0"/&gt;*
            * &lt;xs:element name="TS" type="xs:hexBinary"/&gt;*
            * &lt;/xs:sequence&gt;*
            * &lt;/xs:complexType&gt;*
            * &lt;/xs:element&gt;*
            *&lt;/xs:schema&gt;*

            In the table, ID is an IDENTITY column, and TS is a timestamp column (therefore they should only be modified by the DB engine). How do I tell DSP to take these constraints into account when wuing the create function?

            When I test it with the following,

            *&lt;per:Persistance2 xmlns:per="ld:Physical/Persistance2"&gt;*
            * &lt;ID&gt;0&lt;/ID&gt;*
            *&lt;Project&gt;def&lt;/Project&gt;*
            *&lt;Property&gt;ghi&lt;/Property&gt;*
            *&lt;Value&gt;new string&lt;/Value&gt;*
            * &lt;TS&gt;0000000000000000&lt;/TS&gt;*
            *&lt;/per:Persistance2&gt;*

            it gives the follwiing error

            *&lt;Error&gt; &lt;ALDSP&gt; &lt;xxxxxxx&gt; &lt;AdminServer&gt; &lt;[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'&gt; &lt;weblogic&gt; &lt;&gt; &lt;&gt; &lt;1229106812568&gt; &lt;BEA-000000&gt; &lt;Test&gt; &lt;System error while executing the query: {ld:Physical/Persistance2}createPersistance2:1*
            *weblogic.xml.query.exceptions.XQuerySagaException: {bea-err}UPD003: Update failure: mixed outcome, update error dispatched (updateid=SAGA_2d641b85a027a9ba:43f1e2cd:11e2800892f:-7fcd): com.bea.dsp.wrappers.rdb.exceptions.RDBWrapperException: {bea-err}RDBW0004: [esb]: [INSERT INTO "ESBdev"."dbo"."Persistance" ("ID", "Project", "Property", "Value", "TS")*
            *VALUES (?, ?, ?, ?, ?)]: [0, def, ghi, new string, 0000000000000000]: Error executing SQL query: [BEA][SQLServer JDBC Driver][SQLServer]Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column.*
            * at com.bea.ld.server.update.recovery.SagaRecovery.process(SagaRecovery.java:102)*
            * at com.bea.ld.server.update.recovery.DSPSagaManager.processSagaFailure(DSPSagaManager.java:219)*
            * at weblogic.xml.query.update.recovery.SagaState$2.afterCompletion(SagaState.java:83)*
            * at weblogic.xml.query.transaction.TransactionManager.afterCompletion(TransactionManager.java:133)*
            * at weblogic.transaction.internal.ServerSCInfo.doAfterCompletion(ServerSCInfo.java:1032)*
            * at weblogic.transaction.internal.ServerSCInfo.callAfterCompletions(ServerSCInfo.java:1011)*
            * at weblogic.transaction.internal.ServerTransactionImpl.callAfterCompletions(ServerTransactionImpl.java:2946)*
            * at weblogic.transaction.internal.ServerTransactionImpl.afterRolledBackStateHousekeeping(ServerTransactionImpl.java:2827)*
            * at weblogic.transaction.internal.ServerTransactionImpl.setRolledBack(ServerTransactionImpl.java:2803)*
            * at weblogic.transaction.internal.ServerTransactionImpl.globalRetryRollback(ServerTransactionImpl.java:3043)*
            * at weblogic.transaction.internal.ServerTransactionImpl.globalRollback(ServerTransactionImpl.java:2793)*
            * at weblogic.transaction.internal.ServerTransactionImpl.internalRollback(ServerTransactionImpl.java:397)*
            * at weblogic.transaction.internal.ServerTransactionImpl.rollback(ServerTransactionImpl.java:375)*
            * at weblogic.xml.query.transaction.TransactionHelper.rollback(TransactionHelper.java:102)*
            * at weblogic.xml.query.transaction.TransactionManager.teardownOnFailure(TransactionManager.java:262)*
            * at com.bea.ld.EJBRequestHandler.handleThrowable(EJBRequestHandler.java:810)*
            * at com.bea.ld.EJBRequestHandler.invokeOperation(EJBRequestHandler.java:311)*
            * at com.bea.ld.ServerBean.executeOperationStreaming(ServerBean.java:84)*
            * at com.bea.ld.Server_ydm4ie_EOImpl.executeOperationStreaming(Server_ydm4ie_EOImpl.java:354)*
            * at com.bea.ld.Server_ydm4ie_EOImpl_WLSkel.invoke(Unknown Source)*
            * at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:589)*
            * at weblogic.rmi.cluster.ClusterableServerRef.invoke(ClusterableServerRef.java:224)*
            * at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:479)*
            * at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)*
            * at weblogic.security.service.SecurityManager.runAs(Unknown Source)*
            * at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:475)*
            * at weblogic.rmi.internal.BasicServerRef.access$300(BasicServerRef.java:59)*
            * at weblogic.rmi.internal.BasicServerRef$BasicExecuteRequest.run(BasicServerRef.java:1016)*
            * at weblogic.work.ExecuteThread.execute(ExecuteThread.java:200)*
            * at weblogic.work.ExecuteThread.run(ExecuteThread.java:172)*
            *com.bea.dsp.wrappers.rdb.exceptions.RDBWrapperException: {bea-err}RDBW0004: [esb]: [INSERT INTO "ESBdev"."dbo"."Persistance" ("ID", "Project", "Property", "Value", "TS")*
            *VALUES (?, ?, ?, ?, ?)]: [0, def, ghi, new string, 0000000000000000]: Error executing SQL query: [BEA][SQLServer JDBC Driver][SQLServer]Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column.*
            * at com.bea.dsp.wrappers.rdb.exceptions.RDBWrapperException.create(RDBWrapperException.java:87)*
            * at weblogic.xml.query.exceptions.XQueryException.create(XQueryException.java:128)*
            * at weblogic.xml.query.exceptions.XQueryException.create(XQueryException.java:176)*
            * at weblogic.xml.query.exceptions.XQueryException.create(XQueryException.java:163)*
            * at com.bea.dsp.wrappers.rdb.runtime.DBSession.executeUpdate(DBSession.java:151)*
            * at com.bea.dsp.wrappers.rdb.runtime.ExecuteSQLInsertInternal.executeSQL(ExecuteSQLInsertInternal.java:110)*
            * at com.bea.dsp.wrappers.rdb.runtime.ExecuteSQLRuntimeBase.prepareAndExecuteQuery(ExecuteSQLRuntimeBase.java:170)*
            * at com.bea.dsp.wrappers.rdb.runtime.ExecuteSQLModificationBase.prepareAndExecuteQuery(ExecuteSQLModificationBase.java:77)*
            * at com.bea.dsp.wrappers.rdb.runtime.ExecuteSQLRuntimeBase.fetchNext(ExecuteSQLRuntimeBase.java:95)*
            * at weblogic.xml.query.iterators.GenericIterator.next(GenericIterator.java:114)*
            * at weblogic.xml.query.runtime.core.ExecutionWrapper.fetchNext(ExecutionWrapper.java:85)*
            * at weblogic.xml.query.iterators.GenericIterator.hasNext(GenericIterator.java:135)*
            * at weblogic.xml.query.runtime.util.TokenBuffer.addAll(TokenBuffer.java:296)*
            * at weblogic.xml.query.update.runtime.Interpreter$Frame.setValueUsingTemporary(Interpreter.java:436)*
            * at weblogic.xml.query.update.runtime.Interpreter.processMSet(Interpreter.java:297)*
            * at weblogic.xml.query.update.runtime.Interpreter.run(Interpreter.java:125)*
            * at weblogic.xml.query.update.recovery.SagaInterpreter$NestedFactory$1.run(SagaInterpreter.java:134)*
            * at weblogic.xml.query.update.runtime.ExecuteRelational.fetchNext(ExecuteRelational.java:52)*
            * at weblogic.xml.query.iterators.GenericIterator.next(GenericIterator.java:114)*
            * at weblogic.xml.query.runtime.core.ExecutionWrapper.fetchNext(ExecutionWrapper.java:85)*
            * at weblogic.xml.query.iterators.GenericIterator.hasNext(GenericIterator.java:135)*
            * at weblogic.xml.query.runtime.util.TokenBuffer.addAll(TokenBuffer.java:296)*
            * at weblogic.xml.query.update.runtime.Interpreter$Frame.setValueUsingTemporary(Interpreter.java:436)*
            * at weblogic.xml.query.update.runtime.Interpreter.processMSet(Interpreter.java:297)*
            * at weblogic.xml.query.update.runtime.Interpreter.run(Interpreter.java:125)*
            * at weblogic.xml.query.update.recovery.SagaInterpreter$NestedFactory$1.run(SagaInterpreter.java:134)*
            * at weblogic.xml.query.update.recovery.SagaInterpreter.run(SagaInterpreter.java:54)*
            * at weblogic.xml.query.update.runtime.UVMRewritingEvaluatorImpl.run(UVMRewritingEvaluatorImpl.java:33)*
            * at weblogic.xml.query.xdbcimpl.XQSEStatementImpl.execute(XQSEStatementImpl.java:100)*
            * at com.bea.ld.server.XQueryInvocation.execute(XQueryInvocation.java:731)*
            * at com.bea.ld.EJBRequestHandler.invokeQueryInternal(EJBRequestHandler.java:611)*
            * at com.bea.ld.EJBRequestHandler.invokeOperationInternal(EJBRequestHandler.java:466)*
            * at com.bea.ld.EJBRequestHandler.invokeOperation(EJBRequestHandler.java:308)*
            * at com.bea.ld.ServerBean.executeOperationStreaming(ServerBean.java:84)*
            * at com.bea.ld.Server_ydm4ie_EOImpl.executeOperationStreaming(Server_ydm4ie_EOImpl.java:354)*
            * at com.bea.ld.Server_ydm4ie_EOImpl_WLSkel.invoke(Unknown Source)*
            * at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:589)*
            * at weblogic.rmi.cluster.ClusterableServerRef.invoke(ClusterableServerRef.java:224)*
            * at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:479)*
            * at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)*
            * at weblogic.security.service.SecurityManager.runAs(Unknown Source)*
            * at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:475)*
            * at weblogic.rmi.internal.BasicServerRef.access$300(BasicServerRef.java:59)*
            * at weblogic.rmi.internal.BasicServerRef$BasicExecuteRequest.run(BasicServerRef.java:1016)*
            * at weblogic.work.ExecuteThread.execute(ExecuteThread.java:200)*
            * at weblogic.work.ExecuteThread.run(ExecuteThread.java:172)*
            *java.sql.SQLException: [BEA][SQLServer JDBC Driver][SQLServer]Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column.*
            * at weblogic.jdbc.base.BaseExceptions.createException(Unknown Source)*
            * at weblogic.jdbc.base.BaseExceptions.getException(Unknown Source)*
            * at weblogic.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)*
            * at weblogic.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)*
            * at weblogic.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)*
            * at weblogic.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)*
            * at weblogic.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)*
            * at weblogic.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)*
            * at weblogic.jdbc.base.BaseStatement.postImplExecute(Unknown Source)*
            * at weblogic.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source)*
            * at weblogic.jdbc.base.BaseStatement.commonExecute(Unknown Source)*
            * at weblogic.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source)*
            * at weblogic.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Source)*
            * at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:125)*
            * at com.bea.dsp.wrappers.rdb.runtime.DBSession.executeUpdate(DBSession.java:144)*
            * at com.bea.dsp.wrappers.rdb.runtime.ExecuteSQLInsertInternal.executeSQL(ExecuteSQLInsertInternal.java:110)*
            * at com.bea.dsp.wrappers.rdb.runtime.ExecuteSQLRuntimeBase.prepareAndExecuteQuery(ExecuteSQLRuntimeBase.java:170)*
            * at com.bea.dsp.wrappers.rdb.runtime.ExecuteSQLModificationBase.prepareAndExecuteQuery(ExecuteSQLModificationBase.java:77)*
            * at com.bea.dsp.wrappers.rdb.runtime.ExecuteSQLRuntimeBase.fetchNext(ExecuteSQLRuntimeBase.java:95)*
            * at weblogic.xml.query.iterators.GenericIterator.next(GenericIterator.java:114)*
            * at weblogic.xml.query.runtime.core.ExecutionWrapper.fetchNext(ExecutionWrapper.java:85)*
            * at weblogic.xml.query.iterators.GenericIterator.hasNext(GenericIterator.java:135)*
            * at weblogic.xml.query.runtime.util.TokenBuffer.addAll(TokenBuffer.java:296)*
            * at weblogic.xml.query.update.runtime.Interpreter$Frame.setValueUsingTemporary(Interpreter.java:436)*
            * at weblogic.xml.query.update.runtime.Interpreter.processMSet(Interpreter.java:297)*
            * at weblogic.xml.query.update.runtime.Interpreter.run(Interpreter.java:125)*
            * at weblogic.xml.query.update.recovery.SagaInterpreter$NestedFactory$1.run(SagaInterpreter.java:134)*
            * at weblogic.xml.query.update.runtime.ExecuteRelational.fetchNext(ExecuteRelational.java:52)*
            * at weblogic.xml.query.iterators.GenericIterator.next(GenericIterator.java:114)*
            * at weblogic.xml.query.runtime.core.ExecutionWrapper.fetchNext(ExecutionWrapper.java:85)*
            * at weblogic.xml.query.iterators.GenericIterator.hasNext(GenericIterator.java:135)*
            * at weblogic.xml.query.runtime.util.TokenBuffer.addAll(TokenBuffer.java:296)*
            * at weblogic.xml.query.update.runtime.Interpreter$Frame.setValueUsingTemporary(Interpreter.java:436)*
            * at weblogic.xml.query.update.runtime.Interpreter.processMSet(Interpreter.java:297)*
            * at weblogic.xml.query.update.runtime.Interpreter.run(Interpreter.java:125)*
            * at weblogic.xml.query.update.recovery.SagaInterpreter$NestedFactory$1.run(SagaInterpreter.java:134)*
            * at weblogic.xml.query.update.recovery.SagaInterpreter.run(SagaInterpreter.java:54)*
            * at weblogic.xml.query.update.runtime.UVMRewritingEvaluatorImpl.run(UVMRewritingEvaluatorImpl.java:33)*
            * at weblogic.xml.query.xdbcimpl.XQSEStatementImpl.execute(XQSEStatementImpl.java:100)*
            * at com.bea.ld.server.XQueryInvocation.execute(XQueryInvocation.java:731)*
            * at com.bea.ld.EJBRequestHandler.invokeQueryInternal(EJBRequestHandler.java:611)*
            * at com.bea.ld.EJBRequestHandler.invokeOperationInternal(EJBRequestHandler.java:466)*
            * at com.bea.ld.EJBRequestHandler.invokeOperation(EJBRequestHandler.java:308)*
            * at com.bea.ld.ServerBean.executeOperationStreaming(ServerBean.java:84)*
            * at com.bea.ld.Server_ydm4ie_EOImpl.executeOperationStreaming(Server_ydm4ie_EOImpl.java:354)*
            * at com.bea.ld.Server_ydm4ie_EOImpl_WLSkel.invoke(Unknown Source)*
            * at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:589)*
            * at weblogic.rmi.cluster.ClusterableServerRef.invoke(ClusterableServerRef.java:224)*
            * at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:479)*
            * at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)*
            * at weblogic.security.service.SecurityManager.runAs(Unknown Source)*
            * at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:475)*
            * at weblogic.rmi.internal.BasicServerRef.access$300(BasicServerRef.java:59)*
            * at weblogic.rmi.internal.BasicServerRef$BasicExecuteRequest.run(BasicServerRef.java:1016)*
            * at weblogic.work.ExecuteThread.execute(ExecuteThread.java:200)*
            * at weblogic.work.ExecuteThread.run(ExecuteThread.java:172)*
            *java.sql.SQLException: [BEA][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.*
            * at weblogic.jdbc.base.BaseExceptions.createException(Unknown Source)*
            * at weblogic.jdbc.base.BaseExceptions.getException(Unknown Source)*
            * at weblogic.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)*
            * at weblogic.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)*
            * at weblogic.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)*
            * at weblogic.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)*
            * at weblogic.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)*
            * at weblogic.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)*
            * at weblogic.jdbc.base.BaseStatement.postImplExecute(Unknown Source)*
            * at weblogic.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source)*
            * at weblogic.jdbc.base.BaseStatement.commonExecute(Unknown Source)*
            * at weblogic.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source)*
            * at weblogic.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Source)*
            * at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:125)*
            * at com.bea.dsp.wrappers.rdb.runtime.DBSession.executeUpdate(DBSession.java:144)*
            * at com.bea.dsp.wrappers.rdb.runtime.ExecuteSQLInsertInternal.executeSQL(ExecuteSQLInsertInternal.java:110)*
            * at com.bea.dsp.wrappers.rdb.runtime.ExecuteSQLRuntimeBase.prepareAndExecuteQuery(ExecuteSQLRuntimeBase.java:170)*
            * at com.bea.dsp.wrappers.rdb.runtime.ExecuteSQLModificationBase.prepareAndExecuteQuery(ExecuteSQLModificationBase.java:77)*
            * at com.bea.dsp.wrappers.rdb.runtime.ExecuteSQLRuntimeBase.fetchNext(ExecuteSQLRuntimeBase.java:95)*
            * at weblogic.xml.query.iterators.GenericIterator.next(GenericIterator.java:114)*
            * at weblogic.xml.query.runtime.core.ExecutionWrapper.fetchNext(ExecutionWrapper.java:85)*
            * at weblogic.xml.query.iterators.GenericIterator.hasNext(GenericIterator.java:135)*
            * at weblogic.xml.query.runtime.util.TokenBuffer.addAll(TokenBuffer.java:296)*
            * at weblogic.xml.query.update.runtime.Interpreter$Frame.setValueUsingTemporary(Interpreter.java:436)*
            * at weblogic.xml.query.update.runtime.Interpreter.processMSet(Interpreter.java:297)*
            * at weblogic.xml.query.update.runtime.Interpreter.run(Interpreter.java:125)*
            * at weblogic.xml.query.update.recovery.SagaInterpreter$NestedFactory$1.run(SagaInterpreter.java:134)*
            * at weblogic.xml.query.update.runtime.ExecuteRelational.fetchNext(ExecuteRelational.java:52)*
            * at weblogic.xml.query.iterators.GenericIterator.next(GenericIterator.java:114)*
            * at weblogic.xml.query.runtime.core.ExecutionWrapper.fetchNext(ExecutionWrapper.java:85)*
            * at weblogic.xml.query.iterators.GenericIterator.hasNext(GenericIterator.java:135)*
            * at weblogic.xml.query.runtime.util.TokenBuffer.addAll(TokenBuffer.java:296)*
            * at weblogic.xml.query.update.runtime.Interpreter$Frame.setValueUsingTemporary(Interpreter.java:436)*
            * at weblogic.xml.query.update.runtime.Interpreter.processMSet(Interpreter.java:297)*
            * at weblogic.xml.query.update.runtime.Interpreter.run(Interpreter.java:125)*
            * at weblogic.xml.query.update.recovery.SagaInterpreter$NestedFactory$1.run(SagaInterpreter.java:134)*
            * at weblogic.xml.query.update.recovery.SagaInterpreter.run(SagaInterpreter.java:54)*
            * at weblogic.xml.query.update.runtime.UVMRewritingEvaluatorImpl.run(UVMRewritingEvaluatorImpl.java:33)*
            * at weblogic.xml.query.xdbcimpl.XQSEStatementImpl.execute(XQSEStatementImpl.java:100)*
            * at com.bea.ld.server.XQueryInvocation.execute(XQueryInvocation.java:731)*
            * at com.bea.ld.EJBRequestHandler.invokeQueryInternal(EJBRequestHandler.java:611)*
            * at com.bea.ld.EJBRequestHandler.invokeOperationInternal(EJBRequestHandler.java:466)*
            * at com.bea.ld.EJBRequestHandler.invokeOperation(EJBRequestHandler.java:308)*
            * at com.bea.ld.ServerBean.executeOperationStreaming(ServerBean.java:84)*
            * at com.bea.ld.Server_ydm4ie_EOImpl.executeOperationStreaming(Server_ydm4ie_EOImpl.java:354)*
            * at com.bea.ld.Server_ydm4ie_EOImpl_WLSkel.invoke(Unknown Source)*
            * at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:589)*
            * at weblogic.rmi.cluster.ClusterableServerRef.invoke(ClusterableServerRef.java:224)*
            * at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:479)*
            * at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)*
            * at weblogic.security.service.SecurityManager.runAs(Unknown Source)*
            * at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:475)*
            * at weblogic.rmi.internal.BasicServerRef.access$300(BasicServerRef.java:59)*
            * at weblogic.rmi.internal.BasicServerRef$BasicExecuteRequest.run(BasicServerRef.java:1016)*
            * at weblogic.work.ExecuteThread.execute(ExecuteThread.java:200)*
            * at weblogic.work.ExecuteThread.run(ExecuteThread.java:172)*

            • 3. Re: Problems creating physical data service to relational table
              Mike Reiche-Oracle
              For the timestamp column - change the definition in the schema as below, and then don't specify it in the 'create'

              <xs:element name="TS" type="xs:hexBinary" minOccurs="0"/>

              For the ID column - go to the Design View, go to the Properties tab, then click on the ID column. Under General in the Properties tab, the second last item is AutoNumber. Click on it, then select "identity" from the drop-down.
              1 person found this helpful
              • 4. Re: Problems creating physical data service to relational table
                672962
                Unfortunately, when I choose the ID column in Design view, there is no Autonumber choice available.
                • 5. Re: Problems creating physical data service to relational table
                  Mike Reiche-Oracle
                  Then you don't have it defined as a unique key in your database - you probably want to do that.

                  If you don't want it to be a key - you can just do the same as you did with the timestamp column.
                  • 6. Re: Problems creating physical data service to relational table
                    672962
                    Actually, it is defined as a primary key in the table. I also have a unique clustered index defined on two other fields (Project and Property). Would this interfere?
                    • 7. Re: Problems creating physical data service to relational table
                      Mike Reiche-Oracle
                      I also have a unique clustered index defined on two other fields (Project and Property). Would this interfere?
                      Possibly (depends on the database). And since you say it doesn't show the AutoNumber property, I would say absolutely.

                      Is there some reason that just making it optional and not specifying it is not acceptable?
                      • 8. Re: Problems creating physical data service to relational table
                        101340
                        I am getting the same errors when I try to perform an update from the IDE (ALDSP 3.2, WLS 10.1)

                        what was the solution to the original warning: "*Cannot narrow remote object ClusterableRemoteRef(-10913774038965890074S :127.0.0.1 :7102,7102,-1,-1,-1,-1,-1:ESBDSP:AdminServer (-10913774038965890074S :127.0.0.1 :*7102,7102,-1,-1,-1,-1,-1:ESBDSP:AdminServer/320*)/320 to com.bea.dsp.ejb.ServerHome*" followed by the NullPointerException error?

                        Edited by: ayimani on Dec 13, 2009 8:59 PM
                        • 9. Re: Problems creating physical data service to relational table
                          Mike Reiche-Oracle
                          There is an ALDSP 3.2 bug with "cannot narrow" in it - it appears to have been fixed in ODSI 10.3 . I would suggest either upgrading to ODSI 10.3 or opening a case with customer support.
                          • 10. Re: Problems creating physical data service to relational table
                            101340
                            Thanks Mike, got the fix from Customer Support