Error Assign activity: selectionFailure; Fault Data is null
|
View:
New views
8 Messages
—
Rating Filter:
Alert me
|
 |
Error Assign activity: selectionFailure; Fault Data is null
by Romano Londt
::
Rate this Message:
Hi,
I am trying to build a simple BPel proces which moves data from one table to another. When I run the proces I recieve the folowing error: BPCOR-6151:The process instance has been terminated because a fault was not handled; Fault Name is {http://docs.oasis-open.org/wsbpel/2.0/process/executable}selectionFailure; Fault Data is null com.sun.jbi.engine.bpel.core.bpel.exception.StandardException: I18N: BPCOR-3025: Selection Failure occurred in BPEL({_NS_}TestProcess) at line 23! BPCOR-6129:Line Number is 21 BPCOR-6130:Activity Name is Assign1 at com.sun.jbi.engine.bpel.core.bpel.engine.impl.BPELInterpreter.createVirtualFaultUnit(BPELInterpreter.java:234) at com.sun.jbi.engine.bpel.core.bpel.engine.impl.BPELInterpreter.execute(BPELInterpreter.java:202) at com.sun.jbi.engine.bpel.core.bpel.engine.BusinessProcessInstanceThread.execute(BusinessProcessInstanceThread.java:98) at com.sun.jbi.engine.bpel.core.bpel.engine.impl.BPELProcessManagerImpl.process(BPELProcessManagerImpl.java:1001) at com.sun.jbi.engine.bpel.core.bpel.engine.impl.EngineImpl.process(EngineImpl.java:258) at com.sun.jbi.engine.bpel.core.bpel.engine.impl.EngineImpl.process(EngineImpl.java:1229) at com.sun.jbi.engine.bpel.BPELSEInOutThread.processRequest(BPELSEInOutThread.java:635) at com.sun.jbi.engine.bpel.BPELSEInOutThread.processMsgEx(BPELSEInOutThread.java:308) at com.sun.jbi.engine.bpel.BPELSEInOutThread.run(BPELSEInOutThread.java:194) Do you have any idea's how to solve my problem? I use the folowing code [code BPEL] <?xml version="1.0"?> <process name="TestProcess" targetNamespace="_NS_" xmlns="http://docs.oasis-open.org/wsbpel/2.0/process/executable" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:tns="_NS_" xmlns:sxt="http://www.sun.com/wsbpel/2.0/process/executable/SUNExtension/Trace" xmlns:sxed="http://www.sun.com/wsbpel/2.0/process/executable/SUNExtension/Editor" xmlns:ns0="http://j2ee.netbeans.org/xsd/tableSchema"> <import namespace="http://j2ee.netbeans.org/wsdl/Test1" location="Partners/Test1/Test1.wsdl" importType="http://schemas.xmlsoap.org/wsdl/"/> <import namespace="http://j2ee.netbeans.org/wsdl/Test2" location="Partners/Test2/Test2.wsdl" importType="http://schemas.xmlsoap.org/wsdl/"/> <partnerLinks> <partnerLink name="PartnerLink2" xmlns:tns="http://j2ee.netbeans.org/wsdl/Test2" partnerLinkType="tns:jdbcpartner" partnerRole="jdbcPortTypeRole"/> <partnerLink name="PartnerLink1" xmlns:tns="http://j2ee.netbeans.org/wsdl/Test1" partnerLinkType="tns:jdbcpartner" myRole="jdbcPortTypeRole"/> </partnerLinks> <variables> <variable name="InsertOut" xmlns:tns="http://j2ee.netbeans.org/wsdl/Test2" messageType="tns:insertRetMsg"/> <variable name="InsertIn" xmlns:tns="http://j2ee.netbeans.org/wsdl/Test2" messageType="tns:inputMsg"/> <variable name="PollrecordsIn" xmlns:tns="http://j2ee.netbeans.org/wsdl/Test1" messageType="tns:inputMsg"/> </variables> <sequence> <receive name="Receive1" createInstance="yes" partnerLink="PartnerLink1" operation="pollrecords" xmlns:tns="http://j2ee.netbeans.org/wsdl/Test1" portType="tns:jdbcPortType" variable="PollrecordsIn"/> <assign name="Assign1" validate="no"> <copy> <from>$PollrecordsIn.part/ns0:record/ns0:OID</from> <to>$InsertIn.part/ns0:record/ns0:OID</to> </copy> </assign> <invoke name="Invoke1" partnerLink="PartnerLink2" operation="insert" xmlns:tns="http://j2ee.netbeans.org/wsdl/Test2" portType="tns:jdbcPortType" inputVariable="InsertIn" outputVariable="InsertOut"/> </sequence> </process> [/code] I am using the jdbc webservice component [code webservice] <?xml version="1.0" encoding="UTF-8"?> <definitions name="Test1" targetNamespace="http://j2ee.netbeans.org/wsdl/Test1" xmlns="http://schemas.xmlsoap.org/wsdl/" xmlns:ns="http://j2ee.netbeans.org/xsd/tableSchema" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:tns="http://j2ee.netbeans.org/wsdl/Test1" xmlns:plink="http://docs.oasis-open.org/wsbpel/2.0/plnktype" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/"> <types> <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" targetNamespace="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/"> <xsd:import namespace="http://j2ee.netbeans.org/xsd/tableSchema" schemaLocation="TEST1.xsd"/> </xsd:schema> </types> <message name="outputMsg"> <part name="part" element="ns:TEST1"/> </message> <message name="insertRetMsg"> <part name="part" type="xsd:int"/> </message> <message name="inputMsg"> <part name="part" element="ns:TEST1"/> </message> <portType name="jdbcPortType"> <operation name="insert"> <input name="inputInsert" message="tns:inputMsg"/> <output name="outputInsert" message="tns:insertRetMsg"/> </operation> <operation name="update"> <input name="inputUpdate" message="tns:inputMsg"/> </operation> <operation name="delete"> <input name="inputDelete" message="tns:inputMsg"/> </operation> <operation name="find"> <input name="inputFind" message="tns:inputMsg"/> <output name="outputFind" message="tns:outputMsg"/> </operation> <operation name="pollrecords"> <input name="inputPoll" message="tns:inputMsg"/> </operation> </portType> <binding name="binding" type="tns:jdbcPortType"> <jdbc:binding xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/"/> <operation name="insert"> <jdbc:operation xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/"/> <input name="inputInsert"> <jdbc:input xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/" MarkColumnName="" MarkColumnValue="" MoveRowToTableName="" PKName="OID" PollMilliSeconds="5000" PollingPostProcessing="MoveRow" TableName="TEST1" Transaction="NOTransaction" numberOfRecords="" operationType="insert" paramOrder="OID,DTD_VERZOEK,USR_DELETED,USR_CREATED,USR_CHANGED,DTD_CREATED,OID_JN,DTD_CHANGED,HAG_OID,DTD_RESPONSE,DTD_DELETED,BERICHT" sql="insert into TEST1 (OID,DTD_VERZOEK,USR_DELETED,USR_CREATED,USR_CHANGED,DTD_CREATED,OID_JN,DTD_CHANGED,HAG_OID,DTD_RESPONSE,DTD_DELETED,BERICHT) values (?,?,?,?,?,?,?,?,?,?,?,?)"/> </input> <output name="outputInsert"> <jdbc:output xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/" returnPartName="part"/> </output> </operation> <operation name="update"> <jdbc:operation xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/"/> <input name="inputUpdate"> <jdbc:input xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/" MarkColumnName="" MarkColumnValue="" MoveRowToTableName="" PKName="OID" PollMilliSeconds="5000" PollingPostProcessing="MoveRow" TableName="TEST1" Transaction="NOTransaction" numberOfRecords="" operationType="update" paramOrder="OID,DTD_VERZOEK,USR_DELETED,USR_CREATED,USR_CHANGED,DTD_CREATED,OID_JN,DTD_CHANGED,HAG_OID,DTD_RESPONSE,DTD_DELETED,BERICHT" sql="update TEST1 set OID = ?,DTD_VERZOEK = ?,USR_DELETED = ?,USR_CREATED = ?,USR_CHANGED = ?,DTD_CREATED = ?,OID_JN = ?,DTD_CHANGED = ?,HAG_OID = ?,DTD_RESPONSE = ?,DTD_DELETED = ?,BERICHT = ?"/> </input> </operation> <operation name="delete"> <jdbc:operation xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/"/> <input name="inputDelete"> <jdbc:input xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/" MarkColumnName="" MarkColumnValue="" MoveRowToTableName="" PKName="OID" PollMilliSeconds="5000" PollingPostProcessing="MoveRow" TableName="TEST1" Transaction="NOTransaction" numberOfRecords="" operationType="delete" paramOrder="" sql="delete from TEST1"/> </input> </operation> <operation name="find"> <jdbc:operation xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/"/> <input name="inputFind"> <jdbc:input xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/" MarkColumnName="" MarkColumnValue="" MoveRowToTableName="" PKName="OID" PollMilliSeconds="5000" PollingPostProcessing="MoveRow" TableName="TEST1" Transaction="NOTransaction" numberOfRecords="" operationType="find" paramOrder="" sql="select OID,DTD_VERZOEK,USR_DELETED,USR_CREATED,USR_CHANGED,DTD_CREATED,OID_JN,DTD_CHANGED,HAG_OID,DTD_RESPONSE,DTD_DELETED,BERICHT from TEST1"/> </input> <output name="outputFind"> <jdbc:output xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/" returnPartName="part"/> </output> </operation> <operation name="pollrecords"> <jdbc:operation xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/"/> <input name="inputPoll"> <jdbc:input xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/" MarkColumnName="" MarkColumnValue="" MoveRowToTableName="" PKName="OID" PollMilliSeconds="5000" PollingPostProcessing="Delete" TableName="TEST1" Transaction="NOTransaction" numberOfRecords="" operationType="poll" paramOrder="" sql="select OID,DTD_VERZOEK,USR_DELETED,USR_CREATED,USR_CHANGED,DTD_CREATED,OID_JN,DTD_CHANGED,HAG_OID,DTD_RESPONSE,DTD_DELETED,BERICHT from TEST1"/> </input> </operation> </binding> <service name="service"> <port name="port" binding="tns:binding"> <jdbc:address xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/" jndiName="jdbc/HysXeDS"/> </port> </service> <plink:partnerLinkType xmlns:plink="http://docs.oasis-open.org/wsbpel/2.0/plnktype" name="jdbcpartner"> <plink:role name="jdbcPortTypeRole" portType="tns:jdbcPortType"/> </plink:partnerLinkType> </definitions> <?xml version="1.0" encoding="UTF-8"?> <xsd:schema elementFormDefault="qualified" targetNamespace="http://j2ee.netbeans.org/xsd/tableSchema" xmlns="http://j2ee.netbeans.org/xsd/tableSchema" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <xsd:element name="TEST1" type="TEST1"></xsd:element> <xsd:complexType name="TEST1"> <xsd:sequence> <xsd:element maxOccurs="unbounded" ref="record"></xsd:element> </xsd:sequence> </xsd:complexType> <xsd:element name="record"> <xsd:complexType> <xsd:sequence> <xsd:element name="OID" type="xsd:decimal"></xsd:element> <xsd:element name="DTD_VERZOEK" type="xsd:string" minOccurs="0"></xsd:element> <xsd:element name="USR_DELETED" type="xsd:string" minOccurs="0"></xsd:element> <xsd:element name="USR_CREATED" type="xsd:string" minOccurs="0"></xsd:element> <xsd:element name="USR_CHANGED" type="xsd:string" minOccurs="0"></xsd:element> <xsd:element name="DTD_CREATED" type="xsd:string" minOccurs="0"></xsd:element> <xsd:element name="OID_JN" type="xsd:decimal" minOccurs="0"></xsd:element> <xsd:element name="DTD_CHANGED" type="xsd:string" minOccurs="0"></xsd:element> <xsd:element name="HAG_OID" type="xsd:decimal" minOccurs="0"></xsd:element> <xsd:element name="DTD_RESPONSE" type="xsd:string" minOccurs="0"></xsd:element> <xsd:element name="DTD_DELETED" type="xsd:string" minOccurs="0"></xsd:element> <xsd:element name="BERICHT" type="xsd:string" minOccurs="0"></xsd:element> </xsd:sequence> </xsd:complexType> </xsd:element> </xsd:schema> [/code] |
|
|
Re: Error Assign activity: selectionFailure; Fault Data is null
by Piotr Kaczyński-2
::
Rate this Message:
Hi Romano,
You probably try to assign null value to a variable. Please verify, that "left side" od the assignment is not null. I get these errors all the time. Best regards, Piotr Romano Londt pisze: > Hi, > > I am trying to build a simple BPel proces which moves data from one table to > another. > > > When I run the proces I recieve the folowing error: > > BPCOR-6151:The process instance has been terminated because a fault was > not handled; Fault Name is > {http://docs.oasis-open.org/wsbpel/2.0/process/executable}selectionFailure; > Fault Data is null > com.sun.jbi.engine.bpel.core.bpel.exception.StandardException: I18N: > BPCOR-3025: Selection Failure occurred in BPEL({_NS_}TestProcess) at line > 23! > BPCOR-6129:Line Number is 21 > BPCOR-6130:Activity Name is Assign1 > at > com.sun.jbi.engine.bpel.core.bpel.engine.impl.BPELInterpreter.createVirtualFaultUnit(BPELInterpreter.java:234) > at > com.sun.jbi.engine.bpel.core.bpel.engine.impl.BPELInterpreter.execute(BPELInterpreter.java:202) > at > com.sun.jbi.engine.bpel.core.bpel.engine.BusinessProcessInstanceThread.execute(BusinessProcessInstanceThread.java:98) > at > com.sun.jbi.engine.bpel.core.bpel.engine.impl.BPELProcessManagerImpl.process(BPELProcessManagerImpl.java:1001) > at > com.sun.jbi.engine.bpel.core.bpel.engine.impl.EngineImpl.process(EngineImpl.java:258) > at > com.sun.jbi.engine.bpel.core.bpel.engine.impl.EngineImpl.process(EngineImpl.java:1229) > at > com.sun.jbi.engine.bpel.BPELSEInOutThread.processRequest(BPELSEInOutThread.java:635) > at > com.sun.jbi.engine.bpel.BPELSEInOutThread.processMsgEx(BPELSEInOutThread.java:308) > at > com.sun.jbi.engine.bpel.BPELSEInOutThread.run(BPELSEInOutThread.java:194) > > > > > Do you have any idea's how to solve my problem? > > > I use the folowing code > > > [code BPEL] > > <?xml version="1.0"?> > <process > name="TestProcess" > targetNamespace="_NS_" > xmlns="http://docs.oasis-open.org/wsbpel/2.0/process/executable" > xmlns:xsd="http://www.w3.org/2001/XMLSchema" > xmlns:tns="_NS_" > xmlns:sxt="http://www.sun.com/wsbpel/2.0/process/executable/SUNExtension/Trace" > xmlns:sxed="http://www.sun.com/wsbpel/2.0/process/executable/SUNExtension/Editor" > xmlns:ns0="http://j2ee.netbeans.org/xsd/tableSchema"> > <import namespace="http://j2ee.netbeans.org/wsdl/Test1" > location="Partners/Test1/Test1.wsdl" > importType="http://schemas.xmlsoap.org/wsdl/"/> > <import namespace="http://j2ee.netbeans.org/wsdl/Test2" > location="Partners/Test2/Test2.wsdl" > importType="http://schemas.xmlsoap.org/wsdl/"/> > <partnerLinks> > <partnerLink name="PartnerLink2" > xmlns:tns="http://j2ee.netbeans.org/wsdl/Test2" > partnerLinkType="tns:jdbcpartner" partnerRole="jdbcPortTypeRole"/> > <partnerLink name="PartnerLink1" > xmlns:tns="http://j2ee.netbeans.org/wsdl/Test1" > partnerLinkType="tns:jdbcpartner" myRole="jdbcPortTypeRole"/> > </partnerLinks> > <variables> > <variable name="InsertOut" > xmlns:tns="http://j2ee.netbeans.org/wsdl/Test2" > messageType="tns:insertRetMsg"/> > <variable name="InsertIn" > xmlns:tns="http://j2ee.netbeans.org/wsdl/Test2" > messageType="tns:inputMsg"/> > <variable name="PollrecordsIn" > xmlns:tns="http://j2ee.netbeans.org/wsdl/Test1" > messageType="tns:inputMsg"/> > </variables> > <sequence> > <receive name="Receive1" createInstance="yes" > partnerLink="PartnerLink1" operation="pollrecords" > xmlns:tns="http://j2ee.netbeans.org/wsdl/Test1" > portType="tns:jdbcPortType" variable="PollrecordsIn"/> > <assign name="Assign1" validate="no"> > <copy> > <from>$PollrecordsIn.part/ns0:record/ns0:OID</from> > <to>$InsertIn.part/ns0:record/ns0:OID</to> > </copy> > </assign> > <invoke name="Invoke1" partnerLink="PartnerLink2" operation="insert" > xmlns:tns="http://j2ee.netbeans.org/wsdl/Test2" > portType="tns:jdbcPortType" inputVariable="InsertIn" > outputVariable="InsertOut"/> > </sequence> > </process> > > [/code] > > > I am using the jdbc webservice component > [code webservice] > <?xml version="1.0" encoding="UTF-8"?> > <definitions name="Test1" > targetNamespace="http://j2ee.netbeans.org/wsdl/Test1" > xmlns="http://schemas.xmlsoap.org/wsdl/" > xmlns:ns="http://j2ee.netbeans.org/xsd/tableSchema" > xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" > xmlns:tns="http://j2ee.netbeans.org/wsdl/Test1" > xmlns:plink="http://docs.oasis-open.org/wsbpel/2.0/plnktype" > xmlns:xsd="http://www.w3.org/2001/XMLSchema" > xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" > xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/"> > <types> > <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" > targetNamespace="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/"> > <xsd:import > namespace="http://j2ee.netbeans.org/xsd/tableSchema" > schemaLocation="TEST1.xsd"/> > </xsd:schema> > </types> > <message name="outputMsg"> > <part name="part" element="ns:TEST1"/> > </message> > <message name="insertRetMsg"> > <part name="part" type="xsd:int"/> > </message> > <message name="inputMsg"> > <part name="part" element="ns:TEST1"/> > </message> > <portType name="jdbcPortType"> > <operation name="insert"> > <input name="inputInsert" message="tns:inputMsg"/> > <output name="outputInsert" message="tns:insertRetMsg"/> > </operation> > <operation name="update"> > <input name="inputUpdate" message="tns:inputMsg"/> > </operation> > <operation name="delete"> > <input name="inputDelete" message="tns:inputMsg"/> > </operation> > <operation name="find"> > <input name="inputFind" message="tns:inputMsg"/> > <output name="outputFind" message="tns:outputMsg"/> > </operation> > <operation name="pollrecords"> > <input name="inputPoll" message="tns:inputMsg"/> > </operation> > </portType> > <binding name="binding" type="tns:jdbcPortType"> > <jdbc:binding > xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/"/> > <operation name="insert"> > <jdbc:operation > xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/"/> > <input name="inputInsert"> > <jdbc:input > xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/" > MarkColumnName="" MarkColumnValue="" MoveRowToTableName="" PKName="OID" > PollMilliSeconds="5000" PollingPostProcessing="MoveRow" TableName="TEST1" > Transaction="NOTransaction" numberOfRecords="" operationType="insert" > paramOrder="OID,DTD_VERZOEK,USR_DELETED,USR_CREATED,USR_CHANGED,DTD_CREATED,OID_JN,DTD_CHANGED,HAG_OID,DTD_RESPONSE,DTD_DELETED,BERICHT" > > sql="insert into TEST1 > (OID,DTD_VERZOEK,USR_DELETED,USR_CREATED,USR_CHANGED,DTD_CREATED,OID_JN,DTD_CHANGED,HAG_OID,DTD_RESPONSE,DTD_DELETED,BERICHT) > > values (?,?,?,?,?,?,?,?,?,?,?,?)"/> > </input> > <output name="outputInsert"> > <jdbc:output > xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/" > returnPartName="part"/> > </output> > </operation> > <operation name="update"> > <jdbc:operation > xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/"/> > <input name="inputUpdate"> > <jdbc:input > xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/" > MarkColumnName="" MarkColumnValue="" MoveRowToTableName="" PKName="OID" > PollMilliSeconds="5000" PollingPostProcessing="MoveRow" TableName="TEST1" > Transaction="NOTransaction" numberOfRecords="" operationType="update" > paramOrder="OID,DTD_VERZOEK,USR_DELETED,USR_CREATED,USR_CHANGED,DTD_CREATED,OID_JN,DTD_CHANGED,HAG_OID,DTD_RESPONSE,DTD_DELETED,BERICHT" > > sql="update TEST1 set OID = ?,DTD_VERZOEK = ?,USR_DELETED = > ?,USR_CREATED = ?,USR_CHANGED = ?,DTD_CREATED = ?,OID_JN = > ?,DTD_CHANGED = ?,HAG_OID = ?,DTD_RESPONSE = ?,DTD_DELETED = ?,BERICHT > = ?"/> > </input> > </operation> > <operation name="delete"> > <jdbc:operation > xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/"/> > <input name="inputDelete"> > <jdbc:input > xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/" > MarkColumnName="" MarkColumnValue="" MoveRowToTableName="" PKName="OID" > PollMilliSeconds="5000" PollingPostProcessing="MoveRow" TableName="TEST1" > Transaction="NOTransaction" numberOfRecords="" operationType="delete" > paramOrder="" sql="delete from TEST1"/> > </input> > </operation> > <operation name="find"> > <jdbc:operation > xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/"/> > <input name="inputFind"> > <jdbc:input > xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/" > MarkColumnName="" MarkColumnValue="" MoveRowToTableName="" PKName="OID" > PollMilliSeconds="5000" PollingPostProcessing="MoveRow" TableName="TEST1" > Transaction="NOTransaction" numberOfRecords="" operationType="find" > paramOrder="" sql="select > OID,DTD_VERZOEK,USR_DELETED,USR_CREATED,USR_CHANGED,DTD_CREATED,OID_JN,DTD_CHANGED,HAG_OID,DTD_RESPONSE,DTD_DELETED,BERICHT > > from TEST1"/> > </input> > <output name="outputFind"> > <jdbc:output > xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/" > returnPartName="part"/> > </output> > </operation> > <operation name="pollrecords"> > <jdbc:operation > xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/"/> > <input name="inputPoll"> > <jdbc:input > xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/" > MarkColumnName="" MarkColumnValue="" MoveRowToTableName="" PKName="OID" > PollMilliSeconds="5000" PollingPostProcessing="Delete" TableName="TEST1" > Transaction="NOTransaction" numberOfRecords="" operationType="poll" > paramOrder="" sql="select > OID,DTD_VERZOEK,USR_DELETED,USR_CREATED,USR_CHANGED,DTD_CREATED,OID_JN,DTD_CHANGED,HAG_OID,DTD_RESPONSE,DTD_DELETED,BERICHT > > from TEST1"/> > </input> > </operation> > </binding> > <service name="service"> > <port name="port" binding="tns:binding"> > <jdbc:address > xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/" > jndiName="jdbc/HysXeDS"/> > </port> > </service> > <plink:partnerLinkType > xmlns:plink="http://docs.oasis-open.org/wsbpel/2.0/plnktype" > name="jdbcpartner"> > <plink:role name="jdbcPortTypeRole" portType="tns:jdbcPortType"/> > </plink:partnerLinkType> > </definitions> > > > <?xml version="1.0" encoding="UTF-8"?> > <xsd:schema elementFormDefault="qualified" > targetNamespace="http://j2ee.netbeans.org/xsd/tableSchema" > xmlns="http://j2ee.netbeans.org/xsd/tableSchema" > xmlns:xsd="http://www.w3.org/2001/XMLSchema"> > <xsd:element name="TEST1" type="TEST1"></xsd:element> > <xsd:complexType name="TEST1"> > <xsd:sequence> > <xsd:element maxOccurs="unbounded" ref="record"></xsd:element> > </xsd:sequence> > </xsd:complexType> > <xsd:element name="record"> > <xsd:complexType> > <xsd:sequence> > <xsd:element name="OID" type="xsd:decimal"></xsd:element> > <xsd:element name="DTD_VERZOEK" type="xsd:string" > minOccurs="0"></xsd:element> > <xsd:element name="USR_DELETED" type="xsd:string" > minOccurs="0"></xsd:element> > <xsd:element name="USR_CREATED" type="xsd:string" > minOccurs="0"></xsd:element> > <xsd:element name="USR_CHANGED" type="xsd:string" > minOccurs="0"></xsd:element> > <xsd:element name="DTD_CREATED" type="xsd:string" > minOccurs="0"></xsd:element> > <xsd:element name="OID_JN" type="xsd:decimal" > minOccurs="0"></xsd:element> > <xsd:element name="DTD_CHANGED" type="xsd:string" > minOccurs="0"></xsd:element> > <xsd:element name="HAG_OID" type="xsd:decimal" > minOccurs="0"></xsd:element> > <xsd:element name="DTD_RESPONSE" type="xsd:string" > minOccurs="0"></xsd:element> > <xsd:element name="DTD_DELETED" type="xsd:string" > minOccurs="0"></xsd:element> > <xsd:element name="BERICHT" type="xsd:string" > minOccurs="0"></xsd:element> > </xsd:sequence> > </xsd:complexType> > </xsd:element> > </xsd:schema> > [/code] > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: Error Assign activity: selectionFailure; Fault Data is null
by Romano Londt
::
Rate this Message:
Hi Piotr,
How can I verify if the assigned variable is null? I inserted a record in my table that does not contain null values. And do you have an idea how to handle null values with the assign activity? Regards, Romano
|
|
|
Re: Error Assign activity: selectionFailure; Fault Data is null
by Murali Pottlapelli
::
Rate this Message:
<copy ignoreMissingFromData="yes"?> ... ... </copy> If you change logging level to FINEST on BPEL-SE it would print the variable value right after the "Assign" activity, it should help you to identify missing elements. Regards Murali Romano Londt wrote: Hi Piotr, How can I verify if the assigned variable is null? I inserted a record in my table that does not contain null values. And do you have an idea how to handle null values with the assign activity? Regards, Romano Piotr Kaczyński-2 wrote: <?xml version="1.0" encoding="windows-1252"?> <process name="process" targetNamespace="http://enterprise.netbeans.org/bpel/assign/AssignBPEL/IgnoreMissingFromData/AssignBpel/process" xmlns="http://docs.oasis-open.org/wsbpel/2.0/process/executable" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:tns="http://enterprise.netbeans.org/bpel/assign/AssignBPEL/IgnoreMissingFromData/AssignBpel/process" xmlns:ns1="http://xml.netbeans.org/assign/AssignBPEL/IgnoreMissingFromData/schema/schema2" xmlns:ns2="http://j2ee.netbeans.org/assign/AssignBPEL/IgnoreMissingFromData/wsdl/testWsdl" xmlns:sxt="http://www.sun.com/wsbpel/2.0/process/executable/SUNExtension/Trace" xmlns:sxed="http://www.sun.com/wsbpel/2.0/process/executable/SUNExtension/Editor" xmlns:ns3="http://xml.netbeans.org/assign/AssignBPEL/IgnoreMissingFromData/schema/schema1"> <import namespace="http://j2ee.netbeans.org/assign/AssignBPEL/IgnoreMissingFromData/wsdl/testWsdl" location="testWsdl.wsdl" importType="http://schemas.xmlsoap.org/wsdl/"/> <import namespace="http://xml.netbeans.org/assign/AssignBPEL/IgnoreMissingFromData/schema/schema2" location="../IgnoreMissingFromData/schema2.xsd" importType="http://www.w3.org/2001/XMLSchema"/> <import namespace="http://xml.netbeans.org/assign/AssignBPEL/IgnoreMissingFromData/schema/schema2" location="schema2.xsd" importType="http://www.w3.org/2001/XMLSchema"/> <partnerLinks> <partnerLink name="PartnerLink1" xmlns:tns="http://j2ee.netbeans.org/assign/AssignBPEL/IgnoreMissingFromData/wsdl/testWsdl" partnerLinkType="tns:testWsdl" myRole="testWsdlPortTypeRole"/> </partnerLinks> <variables> <variable name="Variable2" element="ns1:Main"/> <variable name="Variable1" messageType="ns2:testWsdlOperationRequest"/> <variable name="TestWsdlOperationOut" xmlns:tns="http://j2ee.netbeans.org/assign/AssignBPEL/IgnoreMissingFromData/wsdl/testWsdl" messageType="tns:testWsdlOperationResponse"/> <variable name="TestWsdlOperationIn" xmlns:tns="http://j2ee.netbeans.org/assign/AssignBPEL/IgnoreMissingFromData/wsdl/testWsdl" messageType="tns:testWsdlOperationRequest"/> </variables> <faultHandlers> <catchAll> <sequence name="Sequence2"> <assign name="Assign3"> <copy> <from>concat($TestWsdlOperationIn.In2, ' error.')</from> <to variable="TestWsdlOperationOut" part="Return"/> </copy> </assign> <reply name="Reply2" partnerLink="PartnerLink1" operation="testWsdlOperation" portType="ns2:testWsdlPortType" variable="TestWsdlOperationOut"/> </sequence> </catchAll> </faultHandlers> <sequence> <receive name="Receive1" createInstance="yes" partnerLink="PartnerLink1" operation="testWsdlOperation" xmlns:tns="http://j2ee.netbeans.org/assign/AssignBPEL/IgnoreMissingFromData/wsdl/testWsdl" portType="tns:testWsdlPortType" variable="TestWsdlOperationIn"/> <if name="If1"> <condition>$TestWsdlOperationIn.In2 = 'case1'</condition> <sequence name="Sequence1"> <assign name="Assign8"> <copy> <from>concat($TestWsdlOperationIn.In2, ' in branch1')</from> <to variable="TestWsdlOperationIn" part="In2"/> </copy> </assign> <assign name="Assign1"> <copy ignoreMissingFromData="yes"> <from variable="Variable1" part="In2"/> <to variable="TestWsdlOperationOut" part="Return"/> </copy> </assign> </sequence> <elseif> <condition>$TestWsdlOperationIn.In2 = 'case2'</condition> <sequence name="Sequence3"> <assign name="Assign9"> <copy> <from>concat($TestWsdlOperationIn.In2, ' in branch2')</from> <to variable="TestWsdlOperationIn" part="In2"/> </copy> </assign> <assign name="Assign2"> <copy ignoreMissingFromData="yes"> <from>$Variable1.In1/ns3:Data</from> <to variable="TestWsdlOperationOut" part="Return"/> </copy> </assign> </sequence> </elseif> <elseif> <condition>$TestWsdlOperationIn.In2 = 'case3'</condition> <sequence name="Sequence4"> <assign name="Assign10"> <copy> <from>concat($TestWsdlOperationIn.In2, ' in branch3')</from> <to variable="TestWsdlOperationIn" part="In2"/> </copy> </assign> <assign name="Assign5"> <copy> <from>$TestWsdlOperationIn.In1/ns3:Id</from> <to>$Variable1.In1/ns3:Id</to> </copy> <copy ignoreMissingFromData="yes"> <from>$Variable1.In1/ns3:Data</from> <to variable="TestWsdlOperationOut" part="Return"/> </copy> </assign> </sequence> </elseif> <elseif> <condition>$TestWsdlOperationIn.In2 = 'case4'</condition> <sequence name="Sequence5"> <assign name="Assign11"> <copy> <from>concat($TestWsdlOperationIn.In2, ' in branch4')</from> <to variable="TestWsdlOperationIn" part="In2"/> </copy> </assign> <assign name="Assign6"> <copy ignoreMissingFromData="yes"> <from>$Variable2/ns1:Sub2</from> <to variable="TestWsdlOperationOut" part="Return"/> </copy> </assign> </sequence> </elseif> <elseif> <condition>$TestWsdlOperationIn.In2 = 'case5'</condition> <sequence name="Sequence6"> <assign name="Assign12"> <copy> <from>concat($TestWsdlOperationIn.In2, ' in branch5')</from> <to variable="TestWsdlOperationIn" part="In2"/> </copy> </assign> <assign name="Assign7"> <copy> <from>$TestWsdlOperationIn.In1/ns3:Id</from> <to>$Variable2/ns1:Sub1</to> </copy> <copy ignoreMissingFromData="yes"> <from>$Variable2/ns1:Sub2</from> <to variable="TestWsdlOperationOut" part="Return"/> </copy> </assign> </sequence> </elseif> </if> <assign name="Assign4"> <copy> <from>concat($TestWsdlOperationIn.In2, ' successful')</from> <to variable="TestWsdlOperationOut" part="Return"/> </copy> </assign> <reply name="Reply1" partnerLink="PartnerLink1" operation="testWsdlOperation" xmlns:tns="http://j2ee.netbeans.org/assign/AssignBPEL/IgnoreMissingFromData/wsdl/testWsdl" portType="tns:testWsdlPortType" variable="TestWsdlOperationOut"/> </sequence> </process> --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: Error Assign activity: selectionFailure; Fault Data is null
by Piotr Kaczyński-2
::
Rate this Message:
You can also print out variables using BPEL logger. It was not included
in NB 6.0 (standalone), but install the newest open esb + NB and it is there. You can log any activity using mapper-like functionality, but nulls are not ". Regards, Piotr Murali Pottlapelli pisze: > BPEL-SE runtime supports ignoreMissingFromData, but there is no design > time support. So please switch to source/text mode, identify "copy" > element where you getting selection failure and add > ignoreMissingFromData attribute and set it to yes. I have attached > example BP. > > <copy ignoreMissingFromData="yes"?> > ... > ... > > </copy> > > If you change logging level to FINEST on BPEL-SE it would print the > variable value right after the "Assign" activity, it should help you > to identify missing elements. > > Regards > Murali > > > Romano Londt wrote: >> Hi Piotr, >> >> How can I verify if the assigned variable is null? I inserted a record in my >> table that does not contain null values. >> >> And do you have an idea how to handle null values with the assign activity? >> >> Regards, >> >> Romano >> >> >> >> Piotr Kaczyński-2 wrote: >> >>> Hi Romano, >>> >>> You probably try to assign null value to a variable. Please verify, that >>> "left side" od the assignment is not null. >>> >>> I get these errors all the time. >>> >>> Best regards, >>> Piotr >>> >>> Romano Londt pisze: >>> >>>> Hi, >>>> >>>> I am trying to build a simple BPel proces which moves data from one table >>>> to >>>> another. >>>> >>>> >>>> When I run the proces I recieve the folowing error: >>>> >>>> BPCOR-6151:The process instance has been terminated because a fault was >>>> not handled; Fault Name is >>>> {http://docs.oasis-open.org/wsbpel/2.0/process/executable}selectionFailure; >>>> Fault Data is null >>>> com.sun.jbi.engine.bpel.core.bpel.exception.StandardException: I18N: >>>> BPCOR-3025: Selection Failure occurred in BPEL({_NS_}TestProcess) at line >>>> 23! >>>> BPCOR-6129:Line Number is 21 >>>> BPCOR-6130:Activity Name is Assign1 >>>> at >>>> com.sun.jbi.engine.bpel.core.bpel.engine.impl.BPELInterpreter.createVirtualFaultUnit(BPELInterpreter.java:234) >>>> at >>>> com.sun.jbi.engine.bpel.core.bpel.engine.impl.BPELInterpreter.execute(BPELInterpreter.java:202) >>>> at >>>> com.sun.jbi.engine.bpel.core.bpel.engine.BusinessProcessInstanceThread.execute(BusinessProcessInstanceThread.java:98) >>>> at >>>> com.sun.jbi.engine.bpel.core.bpel.engine.impl.BPELProcessManagerImpl.process(BPELProcessManagerImpl.java:1001) >>>> at >>>> com.sun.jbi.engine.bpel.core.bpel.engine.impl.EngineImpl.process(EngineImpl.java:258) >>>> at >>>> com.sun.jbi.engine.bpel.core.bpel.engine.impl.EngineImpl.process(EngineImpl.java:1229) >>>> at >>>> com.sun.jbi.engine.bpel.BPELSEInOutThread.processRequest(BPELSEInOutThread.java:635) >>>> at >>>> com.sun.jbi.engine.bpel.BPELSEInOutThread.processMsgEx(BPELSEInOutThread.java:308) >>>> at >>>> com.sun.jbi.engine.bpel.BPELSEInOutThread.run(BPELSEInOutThread.java:194) >>>> >>>> >>>> >>>> >>>> Do you have any idea's how to solve my problem? >>>> >>>> >>>> I use the folowing code >>>> >>>> >>>> [code BPEL] >>>> >>>> <?xml version="1.0"?> >>>> <process >>>> name="TestProcess" >>>> targetNamespace="_NS_" >>>> xmlns="http://docs.oasis-open.org/wsbpel/2.0/process/executable" >>>> xmlns:xsd="http://www.w3.org/2001/XMLSchema" >>>> xmlns:tns="_NS_" >>>> xmlns:sxt="http://www.sun.com/wsbpel/2.0/process/executable/SUNExtension/Trace" >>>> xmlns:sxed="http://www.sun.com/wsbpel/2.0/process/executable/SUNExtension/Editor" >>>> xmlns:ns0="http://j2ee.netbeans.org/xsd/tableSchema"> >>>> <import namespace="http://j2ee.netbeans.org/wsdl/Test1" >>>> location="Partners/Test1/Test1.wsdl" >>>> importType="http://schemas.xmlsoap.org/wsdl/"/> >>>> <import namespace="http://j2ee.netbeans.org/wsdl/Test2" >>>> location="Partners/Test2/Test2.wsdl" >>>> importType="http://schemas.xmlsoap.org/wsdl/"/> >>>> <partnerLinks> >>>> <partnerLink name="PartnerLink2" >>>> xmlns:tns="http://j2ee.netbeans.org/wsdl/Test2" >>>> partnerLinkType="tns:jdbcpartner" partnerRole="jdbcPortTypeRole"/> >>>> <partnerLink name="PartnerLink1" >>>> xmlns:tns="http://j2ee.netbeans.org/wsdl/Test1" >>>> partnerLinkType="tns:jdbcpartner" myRole="jdbcPortTypeRole"/> >>>> </partnerLinks> >>>> <variables> >>>> <variable name="InsertOut" >>>> xmlns:tns="http://j2ee.netbeans.org/wsdl/Test2" >>>> messageType="tns:insertRetMsg"/> >>>> <variable name="InsertIn" >>>> xmlns:tns="http://j2ee.netbeans.org/wsdl/Test2" >>>> messageType="tns:inputMsg"/> >>>> <variable name="PollrecordsIn" >>>> xmlns:tns="http://j2ee.netbeans.org/wsdl/Test1" >>>> messageType="tns:inputMsg"/> >>>> </variables> >>>> <sequence> >>>> <receive name="Receive1" createInstance="yes" >>>> partnerLink="PartnerLink1" operation="pollrecords" >>>> xmlns:tns="http://j2ee.netbeans.org/wsdl/Test1" >>>> portType="tns:jdbcPortType" variable="PollrecordsIn"/> >>>> <assign name="Assign1" validate="no"> >>>> <copy> >>>> <from>$PollrecordsIn.part/ns0:record/ns0:OID</from> >>>> <to>$InsertIn.part/ns0:record/ns0:OID</to> >>>> </copy> >>>> </assign> >>>> <invoke name="Invoke1" partnerLink="PartnerLink2" >>>> operation="insert" >>>> xmlns:tns="http://j2ee.netbeans.org/wsdl/Test2" >>>> portType="tns:jdbcPortType" inputVariable="InsertIn" >>>> outputVariable="InsertOut"/> >>>> </sequence> >>>> </process> >>>> >>>> [/code] >>>> >>>> >>>> I am using the jdbc webservice component >>>> [code webservice] >>>> <?xml version="1.0" encoding="UTF-8"?> >>>> <definitions name="Test1" >>>> targetNamespace="http://j2ee.netbeans.org/wsdl/Test1" >>>> xmlns="http://schemas.xmlsoap.org/wsdl/" >>>> xmlns:ns="http://j2ee.netbeans.org/xsd/tableSchema" >>>> xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" >>>> xmlns:tns="http://j2ee.netbeans.org/wsdl/Test1" >>>> xmlns:plink="http://docs.oasis-open.org/wsbpel/2.0/plnktype" >>>> xmlns:xsd="http://www.w3.org/2001/XMLSchema" >>>> xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" >>>> xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/"> >>>> <types> >>>> <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" >>>> targetNamespace="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/"> >>>> <xsd:import >>>> namespace="http://j2ee.netbeans.org/xsd/tableSchema" >>>> schemaLocation="TEST1.xsd"/> >>>> </xsd:schema> >>>> </types> >>>> <message name="outputMsg"> >>>> <part name="part" element="ns:TEST1"/> >>>> </message> >>>> <message name="insertRetMsg"> >>>> <part name="part" type="xsd:int"/> >>>> </message> >>>> <message name="inputMsg"> >>>> <part name="part" element="ns:TEST1"/> >>>> </message> >>>> <portType name="jdbcPortType"> >>>> <operation name="insert"> >>>> <input name="inputInsert" message="tns:inputMsg"/> >>>> <output name="outputInsert" message="tns:insertRetMsg"/> >>>> </operation> >>>> <operation name="update"> >>>> <input name="inputUpdate" message="tns:inputMsg"/> >>>> </operation> >>>> <operation name="delete"> >>>> <input name="inputDelete" message="tns:inputMsg"/> >>>> </operation> >>>> <operation name="find"> >>>> <input name="inputFind" message="tns:inputMsg"/> >>>> <output name="outputFind" message="tns:outputMsg"/> >>>> </operation> >>>> <operation name="pollrecords"> >>>> <input name="inputPoll" message="tns:inputMsg"/> >>>> </operation> >>>> </portType> >>>> <binding name="binding" type="tns:jdbcPortType"> >>>> <jdbc:binding >>>> xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/"/> >>>> <operation name="insert"> >>>> <jdbc:operation >>>> xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/"/> >>>> <input name="inputInsert"> >>>> <jdbc:input >>>> xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/" >>>> MarkColumnName="" MarkColumnValue="" MoveRowToTableName="" PKName="OID" >>>> PollMilliSeconds="5000" PollingPostProcessing="MoveRow" TableName="TEST1" >>>> Transaction="NOTransaction" numberOfRecords="" operationType="insert" >>>> paramOrder="OID,DTD_VERZOEK,USR_DELETED,USR_CREATED,USR_CHANGED,DTD_CREATED,OID_JN,DTD_CHANGED,HAG_OID,DTD_RESPONSE,DTD_DELETED,BERICHT" >>>> >>>> sql="insert into TEST1 >>>> (OID,DTD_VERZOEK,USR_DELETED,USR_CREATED,USR_CHANGED,DTD_CREATED,OID_JN,DTD_CHANGED,HAG_OID,DTD_RESPONSE,DTD_DELETED,BERICHT) >>>> >>>> values (?,?,?,?,?,?,?,?,?,?,?,?)"/> >>>> </input> >>>> <output name="outputInsert"> >>>> <jdbc:output >>>> xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/" >>>> returnPartName="part"/> >>>> </output> >>>> </operation> >>>> <operation name="update"> >>>> <jdbc:operation >>>> xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/"/> >>>> <input name="inputUpdate"> >>>> <jdbc:input >>>> xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/" >>>> MarkColumnName="" MarkColumnValue="" MoveRowToTableName="" PKName="OID" >>>> PollMilliSeconds="5000" PollingPostProcessing="MoveRow" TableName="TEST1" >>>> Transaction="NOTransaction" numberOfRecords="" operationType="update" >>>> paramOrder="OID,DTD_VERZOEK,USR_DELETED,USR_CREATED,USR_CHANGED,DTD_CREATED,OID_JN,DTD_CHANGED,HAG_OID,DTD_RESPONSE,DTD_DELETED,BERICHT" >>>> >>>> sql="update TEST1 set OID = ?,DTD_VERZOEK = ?,USR_DELETED = >>>> ?,USR_CREATED = ?,USR_CHANGED = ?,DTD_CREATED = ?,OID_JN = >>>> ?,DTD_CHANGED = ?,HAG_OID = ?,DTD_RESPONSE = ?,DTD_DELETED = >>>> ?,BERICHT >>>> = ?"/> >>>> </input> >>>> </operation> >>>> <operation name="delete"> >>>> <jdbc:operation >>>> xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/"/> >>>> <input name="inputDelete"> >>>> <jdbc:input >>>> xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/" >>>> MarkColumnName="" MarkColumnValue="" MoveRowToTableName="" PKName="OID" >>>> PollMilliSeconds="5000" PollingPostProcessing="MoveRow" TableName="TEST1" >>>> Transaction="NOTransaction" numberOfRecords="" operationType="delete" >>>> paramOrder="" sql="delete from TEST1"/> >>>> </input> >>>> </operation> >>>> <operation name="find"> >>>> <jdbc:operation >>>> xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/"/> >>>> <input name="inputFind"> >>>> <jdbc:input >>>> xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/" >>>> MarkColumnName="" MarkColumnValue="" MoveRowToTableName="" PKName="OID" >>>> PollMilliSeconds="5000" PollingPostProcessing="MoveRow" TableName="TEST1" >>>> Transaction="NOTransaction" numberOfRecords="" operationType="find" >>>> paramOrder="" sql="select >>>> OID,DTD_VERZOEK,USR_DELETED,USR_CREATED,USR_CHANGED,DTD_CREATED,OID_JN,DTD_CHANGED,HAG_OID,DTD_RESPONSE,DTD_DELETED,BERICHT >>>> >>>> from TEST1"/> >>>> </input> >>>> <output name="outputFind"> >>>> <jdbc:output >>>> xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/" >>>> returnPartName="part"/> >>>> </output> >>>> </operation> >>>> <operation name="pollrecords"> >>>> <jdbc:operation >>>> xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/"/> >>>> <input name="inputPoll"> >>>> <jdbc:input >>>> xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/" >>>> MarkColumnName="" MarkColumnValue="" MoveRowToTableName="" PKName="OID" >>>> PollMilliSeconds="5000" PollingPostProcessing="Delete" TableName="TEST1" >>>> Transaction="NOTransaction" numberOfRecords="" operationType="poll" >>>> paramOrder="" sql="select >>>> OID,DTD_VERZOEK,USR_DELETED,USR_CREATED,USR_CHANGED,DTD_CREATED,OID_JN,DTD_CHANGED,HAG_OID,DTD_RESPONSE,DTD_DELETED,BERICHT >>>> >>>> from TEST1"/> >>>> </input> >>>> </operation> >>>> </binding> >>>> <service name="service"> >>>> <port name="port" binding="tns:binding"> >>>> <jdbc:address >>>> xmlns:jdbc="http://schemas.sun.com/jbi/wsdl-extensions/jdbc/" >>>> jndiName="jdbc/HysXeDS"/> >>>> </port> >>>> </service> >>>> <plink:partnerLinkType >>>> xmlns:plink="http://docs.oasis-open.org/wsbpel/2.0/plnktype" >>>> name="jdbcpartner"> >>>> <plink:role name="jdbcPortTypeRole" portType="tns:jdbcPortType"/> >>>> </plink:partnerLinkType> >>>> </definitions> >>>> >>>> >>>> <?xml version="1.0" encoding="UTF-8"?> >>>> <xsd:schema elementFormDefault="qualified" >>>> targetNamespace="http://j2ee.netbeans.org/xsd/tableSchema" >>>> xmlns="http://j2ee.netbeans.org/xsd/tableSchema" >>>> xmlns:xsd="http://www.w3.org/2001/XMLSchema"> >>>> <xsd:element name="TEST1" type="TEST1"></xsd:element> >>>> <xsd:complexType name="TEST1"> >>>> <xsd:sequence> >>>> <xsd:element maxOccurs="unbounded" ref="record"></xsd:element> >>>> </xsd:sequence> >>>> </xsd:complexType> >>>> <xsd:element name="record"> >>>> <xsd:complexType> >>>> <xsd:sequence> >>>> <xsd:element name="OID" type="xsd:decimal"></xsd:element> >>>> <xsd:element name="DTD_VERZOEK" type="xsd:string" >>>> minOccurs="0"></xsd:element> >>>> <xsd:element name="USR_DELETED" type="xsd:string" >>>> minOccurs="0"></xsd:element> >>>> <xsd:element name="USR_CREATED" type="xsd:string" >>>> minOccurs="0"></xsd:element> >>>> <xsd:element name="USR_CHANGED" type="xsd:string" >>>> minOccurs="0"></xsd:element> >>>> <xsd:element name="DTD_CREATED" type="xsd:string" >>>> minOccurs="0"></xsd:element> >>>> <xsd:element name="OID_JN" type="xsd:decimal" >>>> minOccurs="0"></xsd:element> >>>> <xsd:element name="DTD_CHANGED" type="xsd:string" >>>> minOccurs="0"></xsd:element> >>>> <xsd:element name="HAG_OID" type="xsd:decimal" >>>> minOccurs="0"></xsd:element> >>>> <xsd:element name="DTD_RESPONSE" type="xsd:string" >>>> minOccurs="0"></xsd:element> >>>> <xsd:element name="DTD_DELETED" type="xsd:string" >>>> minOccurs="0"></xsd:element> >>>> <xsd:element name="BERICHT" type="xsd:string" >>>> minOccurs="0"></xsd:element> >>>> </xsd:sequence> >>>> </xsd:complexType> >>>> </xsd:element> >>>> </xsd:schema> >>>> [/code] >>>> >>>> >>>> >>> --------------------------------------------------------------------- >>> To unsubscribe, e-mail: users-unsubscribe@... >>> For additional commands, e-mail: users-help@... >>> >>> >>> >>> >> >> > ------------------------------------------------------------------------ > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscribe@... > For additional commands, e-mail: users-help@... --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
|
|
Re: Error Assign activity: selectionFailure; Fault Data is null
by Romano Londt
::
Rate this Message:
Hi,
Thank you both for your input. My variable is indeed "null". I was using Oracle as the Database with the default drivers. Since there is a problem with the default Oracle Drivers I am using the DataDirect driver in Netbeans and the Oracle driver in Glassfish. Unfortunally this did not solve my problem. Now I recieve the problem: systemFault; Fault Data is <?xml version="1.0" encoding="UTF-8"?><jbi:message xmlns:sxeh="http://www.sun.com/wsbpel/2.0/process/executable/SUNExtension/ErrorHandling" type="sxeh:faultMessage" version="1.0" xmlns:jbi="http://java.sun.com/xml/ns/jbi/wsdl-11-wrapper"><jbi:part>null</jbi:part></jbi:message> My main concern here is the jbi:part tag which contains "null". I have put some logging to the application and there is data in the PollrecordsIn/part but there is no data in the PollrecordsIn/part/record. Any idea is welcome!! Regards, Romano
|
|
|
Re: Error Assign activity: selectionFailure; Fault Data is null
by Romano Londt
::
Rate this Message:
Hi,
While looking at the messages I noticed that the <record> tag was not used inside the messages. When rewriting the xsd from <?xml version="1.0" encoding="UTF-8"?> <xsd:schema elementFormDefault="qualified" targetNamespace="http://j2ee.netbeans.org/xsd/tableSchema" xmlns="http://j2ee.netbeans.org/xsd/tableSchema" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <xsd:element name="TEST1" type="TEST1"></xsd:element> <xsd:complexType name="TEST1"> <xsd:sequence> <xsd:element maxOccurs="unbounded" ref="record"></xsd:element> </xsd:sequence> </xsd:complexType> <xsd:element name="record"> <xsd:complexType> <xsd:sequence> <xsd:element name="OID" type="xsd:decimal"></xsd:element> <xsd:element name="DTD_VERZOEK" type="xsd:string" minOccurs="0"></xsd:element> <xsd:element name="USR_DELETED" type="xsd:string" minOccurs="0"></xsd:element> <xsd:element name="USR_CREATED" type="xsd:string" minOccurs="0"></xsd:element> <xsd:element name="USR_CHANGED" type="xsd:string" minOccurs="0"></xsd:element> <xsd:element name="DTD_CREATED" type="xsd:string" minOccurs="0"></xsd:element> <xsd:element name="OID_JN" type="xsd:decimal" minOccurs="0"></xsd:element> <xsd:element name="DTD_CHANGED" type="xsd:string" minOccurs="0"></xsd:element> <xsd:element name="HAG_OID" type="xsd:decimal" minOccurs="0"></xsd:element> <xsd:element name="DTD_RESPONSE" type="xsd:string" minOccurs="0"></xsd:element> <xsd:element name="DTD_DELETED" type="xsd:string" minOccurs="0"></xsd:element> <xsd:element name="BERICHT" type="xsd:string" minOccurs="0"></xsd:element> </xsd:sequence> </xsd:complexType> </xsd:element> </xsd:schema> To: <?xml version="1.0" encoding="UTF-8"?> <xsd:schema elementFormDefault="qualified" targetNamespace="http://j2ee.netbeans.org/xsd/tableSchema" xmlns="http://j2ee.netbeans.org/xsd/tableSchema" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <xsd:element name="TEST1" type="TEST1"></xsd:element> <xsd:complexType name="TEST1"> <xsd:sequence> <xsd:element name="OID" type="xsd:decimal"></xsd:element> <xsd:element name="HAG_OID" type="xsd:decimal" minOccurs="1" nillable="true"></xsd:element> <xsd:element name="DTD_VERZOEK" type="xsd:dateTime" minOccurs="1" nillable="true"></xsd:element> <xsd:element name="DTD_RESPONSE" type="xsd:dateTime" minOccurs="1" nillable="true"></xsd:element> <xsd:element name="BERICHT" type="xsd:string" minOccurs="1" nillable="true"></xsd:element> <xsd:element name="OID_JN" type="xsd:decimal" minOccurs="1" nillable="true"></xsd:element> <xsd:element name="DTD_CREATED" type="xsd:dateTime" minOccurs="1" nillable="true"></xsd:element> <xsd:element name="USR_CREATED" type="xsd:string" minOccurs="1" nillable="true"></xsd:element> <xsd:element name="DTD_CHANGED" type="xsd:dateTime" minOccurs="1" nillable="true"></xsd:element> <xsd:element name="USR_CHANGED" type="xsd:string" minOccurs="1" nillable="true"></xsd:element> <xsd:element name="DTD_DELETED" type="xsd:dateTime" minOccurs="1" nillable="true"></xsd:element> <xsd:element name="USR_DELETED" type="xsd:string" minOccurs="1" nillable="true"></xsd:element> </xsd:sequence> </xsd:complexType> </xsd:schema> I got data in my assign activity. Can anyone verify if my action is "legal" and does not have any negative sideeffects? Regards, Romano |
|
|
Re: Error Assign activity: selectionFailure; Fault Data is null
by Wouter van Reeven
::
Rate this Message:
Hi Romano,
On Mon, Jun 02, 2008 at 03:47:55AM -0700, Romano Londt wrote: > While looking at the messages I noticed that the <record> tag was not used > inside the messages. > When rewriting the xsd from > > > <xsd:element name="TEST1" type="TEST1"></xsd:element> > <xsd:complexType name="TEST1"> > <xsd:sequence> > <xsd:element maxOccurs="unbounded" ref="record"></xsd:element> > </xsd:sequence> > </xsd:complexType> > <xsd:element name="record"> > <xsd:complexType> > <xsd:sequence> > </xsd:sequence> > </xsd:complexType> > </xsd:element> > > To: > > <xsd:element name="TEST1" type="TEST1"></xsd:element> > <xsd:complexType name="TEST1"> > <xsd:sequence> > </xsd:sequence> > </xsd:complexType> > > I got data in my assign activity. > > Can anyone verify if my action is "legal" and does not have any negative > sideeffects? AFAIK rewriting the xsd as you did above (with the lines I deleted for clarity included again) you now only expect ONE element inside your TEST1 element instead of 0, 1 or more. Not sure why the first xsd doesn't return any data... HTH, Wouter van Reeven -- People: "If she weighs the same as a Duck, she's made of wood!" Sir Bedevere: "And therefore...?" --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscribe@... For additional commands, e-mail: users-help@... |
| Free embeddable forum powered by Nabble | Forum Help |
