Integration

Have you verified that BPEL process is receving the data properly by looking at the Audit trail of BPEL component in EM?

- Sandeep

Yes..sandeep,

I verified it. The input variable of the bpel process is received the data.

In the audit traill i clicked on "view xml document" link. The data is there. But an empty payload has been transformed to the database table.
Edited by: 951294 on Sep 5, 2012 1:29 AM

Edited by: 951294 on Sep 5, 2012 1:29 AM

Edited by: 951294 on Sep 5, 2012 1:57 AM

Check the output of transform activity in the audit trail. make sure that it is properly mapping the data and the output is being sent to DB adapter.

Regards,
Anuj

Hi Anju,


The mapping was done properly. Infact the table contains an extra column (ordertime) and i am able to insert the value using date functions(current time). The remaining values are null.

Edited by: 951294 on Sep 5, 2012 2:12 AM

Can you provide your table definition and XML passed to DB adapter?

Regards,
Anuj

Hi Anuj,

Thanks for helping me..For your reference i have provided the table , xml payload and audit trail details... Please find those.



Table Name : STUDENT_RESERVATION

Columns : SNO (NUMBER)

FIRSTNAME (VARCHAR)

LASTNAME (VARCHAR)

AGE (NUMBER)

MARKS (NUMBER)

RESERVATION (VARCHAR)

INCOME (NUMBER)

INSERTIONDATE (TIMESTAMP)


It also has sequence SEQ_RESERVATION.

My XML Payload is

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">

<soap:Body xmlns:ns1="http://www.prokarma.com/training/soa/xsd/UniversityAdmission">

<ns1:UniversityAdmissionRequest>

<ns1:firstName>Ravindra</ns1:firstName>

<ns1:lastName>Nalamothu</ns1:lastName>

<ns1:age>30</ns1:age>

<ns1:marksPercentage>78</ns1:marksPercentage>

<ns1:reservationCategory>SC</ns1:reservationCategory>

<ns1:parentsAnnualIncome>19000</ns1:parentsAnnualIncome>

<ns1:bankName>ICICI</ns1:bankName>

<ns1:bankAccNumber>123456789</ns1:bankAccNumber>

<ns1:bankPin>2323</ns1:bankPin>

<ns1:feeAmount>10000</ns1:feeAmount>

</ns1:UniversityAdmissionRequest>
</soap:Body>
</soap:Envelope>




The Audit trail is:



<process>
<main (79)>
receiveInputreceiveInput

Sep 5, 2012 1:47:28 PM Received "process" call from partner "eventreceivebpel_client"Received "process" call from partner "eventreceivebpel_client"
View XML Document


Transform1
Sep 5, 2012 1:47:28 PM Updated variable "InvokeEventDB_InputVariable"Updated variable "InvokeEventDB_InputVariable"

<payload>
<InvokeEventDB_InputVariable>

<part name="StudentReservationCollection">

<StudentReservationCollection>
<ns0:StudentReservation>
<ns0:name/>
<ns0:age/>
<ns0:markspercentage/>
<ns0:reservationcategory/>
<ns0:annualincome/>
<ns0:insertiondate>2012-09-05T13:47:28+05:30</ns0:insertiondate>
</ns0:StudentReservation>
</StudentReservationCollection>

</part>

</InvokeEventDB_InputVariable>


Sep 5, 2012 1:47:28 PM Completed assignCompleted assign

InvokeEventDB


Sep 5, 2012 1:47:28 PM Started invocation of operation "insert" on partner "EventDB".Started invocation of operation "insert" on partner "EventDB".
Sep 5, 2012 1:47:28 PM Invoked 2-way operation "insert" on partner "EventDB".Invoked 2-way operation "insert" on partner "EventDB".


<payload>
<messages>
<InvokeEventDB_InputVariable>
<part name="StudentReservationCollection">
<StudentReservationCollection>
<ns0:StudentReservation>
<ns0:name/>
<ns0:age/>
<ns0:markspercentage/>
<ns0:reservationcategory/>
<ns0:annualincome/>
<ns0:insertiondate>2012-09-05T13:47:28+05:30</ns0:insertiondate>
</ns0:StudentReservation>
</StudentReservationCollection>
</part>


</InvokeEventDB_InputVariable>
<InvokeEventDB_insert_OutputVariable>
<part name="StudentReservationCollection">
<StudentReservationCollection>
<StudentReservation>
<sno>1006</sno>
<name/>
<age/>
<markspercentage/>
<reservationcategory/>
<annualincome/>
<insertiondate>2012-09-05T13:47:28.000+05:30</insertiondate>
</StudentReservation>
</StudentReservationCollection>
</part>


</InvokeEventDB_insert_OutputVariable>

</messages>
Sep 5, 2012 1:47:28 PM BPEL process instance "370267" completedBPEL process instance "370267" completed

Edited by: 951294 on Sep 5, 2012 3:11 AM

Edited by: 951294 on Sep 5, 2012 3:38 AM

Transform1
Sep 5, 2012 1:47:28 PM Updated variable "InvokeEventDB_InputVariable"Updated variable "InvokeEventDB_InputVariable"
<payload>
<InvokeEventDB_InputVariable>
<part name="StudentReservationCollection">
<StudentReservationCollection>
<ns0:StudentReservation>
<ns0:name/>
<ns0:age/>
<ns0:markspercentage/>
<ns0:reservationcategory/>
<ns0:annualincome/>
<ns0:insertiondate>2012-09-05T13:47:28+05:30</ns0:insertiondate>
</ns0:StudentReservation>
</StudentReservationCollection>
</part>

As you can see here, your transformation is not really assigning the values into the target XML. Please check your XSL and make sure that mappings are correct.

Regards,
Anuj

Edited by: Anuj Dwivedi on Sep 5, 2012 4:31 PM