Re: Error Assign activity: selectionFailure; Fault Data is null

> 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]
>
>