cancel
Showing results for 
Search instead for 
Did you mean: 

file to db scenario not getting out put

Former Member
0 Kudos

In file to db scenario not getting output(mysql db). giving error for receiver dat there is no action attribute in xml docment..

what could be da reason??

Accepted Solutions (0)

Answers (3)

Answers (3)

prabhu_s2
Active Contributor
0 Kudos

u can check with this blog:

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

prabhu_s2
Active Contributor
0 Kudos

The XML document must have the following schema in this case:

<root>
  <StatementName1>
<dbTableName action=”UPDATE” | “UPDATE_INSERT”>
    <table>realDbTableName</table>
<access>
<col1>val1</col1>
<col2>val2new</col2>
</access>
<key1>
<col2>val2old</col2>
<col4>val4</col4>
</key1>
<key2>
<col2>val2old2</col2>
</key2>
</dbTableName>
  </StatementName1>

Former Member
0 Kudos

Shiva,

I think the error says you are missing an attribute in your receiver payload. Please add that and check.

See this weblog for your reference:

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

---Satish

Former Member
0 Kudos

thanks 4 da links... and suggestions..

I rectified the error from ur links... and I see dat I'm not using attribute for action under catagory while creating datatype for receiver db..

thanks alot again its really helped me.