file 2 jdbc

[Former Member]

Dear experts....

i configured file to jdbc.....

i encountered with an error which is saying that error in message mapping....

how to solve it

thanks in advance....

somesh

[Former Member]

HI ,

if you get message mapping error

then the structure of the reciever message type might be wrong.ur message type must be

MT_XXXXXXXXXX

STATEMENT Element

TEST Element

ACTION Attribute

TABLE Element

=> ACCESS Element

EMP nameElement

Emp no Element

Company Element

Then map action with constant having query INSERT OR SELECT OR EXECUTE etc.. depending on ur requirement.

map Table with constant and give table name which u created in the database and does not map access to any thing. and map emp name , emp no and company with fields in the sender side . then save and activate it.

refer to this:http://help.sap.com/saphelp_nw70/helpdata/EN/22/b4d13b633f7748b4d34f3191529946/frameset.htm

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

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

regards,

pradeep

if useful reward points..

[Former Member]

Hi

The following links are helpful to you

/people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/jdbcTOJDBC&

http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

reward points if it is useful

Thanks,

Satish

[Former Member]

hi venkatesh,

In case of JDBC receiver the structure of data type is important.

It is a standard format. u can get the structure from the following link.

Do check your structure accordingly and do post if u hav any doubts

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

reward points if helpful

PrasHanT

[Former Member]

Hi Venkata Somesh,

If the error in Message Mapping means either data is wrong or Structure of file or JDBC is wrong

Check the JDBC Structure

STATEMENT NAME Element

-

---

>TEST Element

--->ACTION Attribute

--->TABLE

-

---

> ACCESS

--->EMP ID

--->Emp Name

Regards,

Sateesh,

Edited by: Sateesh N on May 15, 2008 7:26 AM

[Former Member]

Hi,

Check the Communication log in RWB and and take the payload from moni and test the mapping in IR.

Check some links.

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

JDBC RECEIVER ADAPTER

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

Regards,

Phani

[Former Member]

thasnks phani

u r giving answers to all my queries

i made design according to tutorial but still it is giving problem....

can i have u r mail id?????

send me a text mail to someshvs at gmail.com

regards

somesh

[Former Member]

hi check the below:

Document Formats for the Receiver JDBC Adapter

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

Configuring the Receiver JDBC Adapter

http://help.sap.com/saphelp_nw2004s/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

Receiver JDBC adapter - data type declaration

Check this blog...

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

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

Note: reward points if solution found helpfull

Regards

Chandrakanth.k

[Former Member]

Hi,

Go through the linl below,which i s useful

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

regards

[Former Member]

Hi,

Could you please explain in detail about the error.

Thanks,

Kiran

[Former Member]

Hi,

Take the Inbound Payload from MONI and Test it in Message Mapping of Test Tab

And now you will come to know abt the Error Clearly

And also Make sure that you have the Receiver JDBC Structure According to this Blog

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

Regards

Seshagiri