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

> 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@...