Payload Not passed from Mapping??

[Former Member]

HI All..

I am trying to execute a FCC to JDBC scenario. Where i am trying to execute stored procedure.

This is my paylaod for inbound message

<?xml version="1.0" encoding="utf-8" ?>

- <ns:STP_Test_Input_DT xmlns:ns="http://MCDBtest">

- <Record>

- <Root>

<Data1>007</Data1>

<Data2>PALMONE</Data2>

</Root>

- <Root>

<Data1>001</Data1>

<Data2>GAURAV</Data2>

</Root>

</Record>

</ns:STP_Test_Input_DT>

I am not able to map it to the output structure.

it is showing only this..

<?xml version="1.0" encoding="UTF-8"?>

<ns0:STP_Test_Output_MT xmlns:ns0="http://MCDBtest"><Statement><stored_Proc_Name action="EXECUTE"></stored_Proc_Name></Statement></ns0:STP_Test_Output_MT>

can you help me with the kind of output structure i require to map it correctly

i have created input and output as follows

record

root

data1

data2

for FCC and

statement

action

data1

isInput

type

data2

isInput

type

for JDBC stored procedure execution

i have tried with

statement

action

record

root

data1

isInput

type

data2

isInput

type

but still not able to map the payload correctly.

[Former Member · Accepted solution]

Hi Gaurav,

there is some problem in mapping ,did u mapped the correct source fields with the target fields pls check once again and let me know .

Regards,

Azeez khan.

[Former Member]

Error discovered in mapping due to context objects. Its resolved.

Thanks

[Former Member]

Gaurav,

Lets go step by step..

In JDBC receiver communication channel..

Set additional parameters on..and put the Parameter :

Name : logSQLStatement

Value : True

by doing this you will be able to see wthere XI is passing the value further to RDBMs or not..

GO to RWB and check the communication channel there you can see the SQL query generated and passed to RDBMS..

Let me know for any further clarification..

Regards,

[Former Member]

Thanks for replying

Yes i have checked with mapping

I am executing a stored procedure and reading data from a CSV file

input structure is

Record

Root 0.. unbounded

Data1 string 0..1

Data 2 string 0..1

output strucure is

statement

storedprocedurename

action -> execute

table -> constant (stored procedure name)

Data1 String 0..1 mapped to Data1 of input

isInput -> true

type -> CHAR

Data2 String 0..1mapped to Data2 of input

isInput -> true

type -> CHAR

problem i m getting is while testing data is going to action and table and after that its not going

i have also tried with changed output structure as i kept root over data1 and data2 and mapped root to root of input structure.

Thanks

Gaurav