JDBC Receiver Adapter

[Former Member]

Under JDBC Receiver Communication Channels Monitoring

Error Msg

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'CUSTOMER' (structure 'Statement'): java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

CUSTOMER is the Table name in MS Access DB

help me in solving this issue..

Regardgs

Wishva

[Former Member · Accepted solution]

Hi,

As said by experts check your action,what u have given in message mapping.

Also check your reciever message type ,whether it is in proper cannonical format or not.

Keep the thread updated.

regards

parvez

[Former Member · Accepted solution]

HI Experts

Thanks 4 Replays

But

i am mentioned the action field in mapping

my receiver message type

InboundMSG cannonical format

-

---

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

<ns0:MT_Customer xmlns:ns0="http://xyz.com/JDBC">

<Statement>

< dbTableName ACTION="INSERT">

<TABLE>CUSTOMER</TABLE>

<ACCESS>

<NSS>10444</NSS>

<NAME>AnuRadha</NAME>

<ADDRESS1>Saifabad</ADDRESS1>

<ADDRESS2>Hyderabad</ADDRESS2>

</ACCESS>

</dbTableName>

</Statement>

</ns0:MT_Customer>

-

---

plz let me know where i am going wrong

Regards

Wishva

[Former Member · Accepted solution]

Hi,

< dbTableName ACTION="INSERT">

action should be in small letter.

Also "ACCESS" should be in small letter.

Thanks

Farooq

Edited by: Farooq Farooqui on Apr 16, 2008 11:33 AM

[Former Member · Accepted solution]

Hi Farooq

Thanks 4 replay

I try with caps and small letter for both ACTION and ACCESS

showing same error MSG in C C Monitoring

Regards

Wishva

[Former Member · Accepted solution]

try with action update_insert.

[Former Member · Accepted solution]

Hi Vishwa,

There can be a mapping error. Sometimes mapping is successful deleivering no content to the output structure.

1. goto SXMB_MONI.

2. Copy the source XML ( goto payload -right click - view source - copy the xml)

3. Paste the xml in the test tab of the IR. Execute.

Please comtinue using small letters for action and access .

Map the incoming message rows to access.

Reply if you get a success message ?

Regards,

Shamly.

Edited by: Shamly MM on Apr 16, 2008 8:59 AM

[Former Member · Accepted solution]

Hi Shamly

I did Test in IR

Message Mapping working Properly

successfully Executed.

Regards

Wishva

[Former Member · Accepted solution]

Hi Viswa,

Please change your structure to the following.

This is the structure that i have follow generally.

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

<ns0:MT_Customer xmlns:ns0="http://xyz.com/JDBC">

<Statement>

< CUSTOMER action="INSERT">

<access>

<NSS>10444</NSS>

<NAME>AnuRadha</NAME>

<ADDRESS1>Saifabad</ADDRESS1>

<ADDRESS2>Hyderabad</ADDRESS2>

</access>

</CUSTOMER>

</Statement>

</ns0:MT_Customer>

Regards,

Shamly

Edited by: Shamly MM on Apr 16, 2008 11:10 AM

[Former Member · Accepted solution]

Hi,

Please check the name of the Table in the database. ALso do check the name of the coloumns.

Thanks

Farooq.

[Former Member · Accepted solution]

Hi Shamly ,

I change to given structure

Showing Same Error CC Monitoring

-

---

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'Customer' (structure 'Statement'): java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

-

---

Hi Farooq

I check the name of the Table and columns also .

Thanking u for u r support

Can u send me the Screen shots of u working scenario with Access

Regards

Wishva

Edited by: Viswanadh Vadde on Apr 16, 2008 12:12 PM

[Former Member · Accepted solution]

can you check your table wether data is inserted or not and confirm me.might be you are looking at the previous error in CC monitoring.

[agasthuri_doss]

Hi,

Check the Mesage Mapping Structure.

Regards

Agasthuri Doss

[former_member556603]

Hi Vadde,

Go through these blogs,

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

/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

Hope this info is useful to you.

Reward points if it is useful,

Thanks,

Satya Kumar

[Former Member]

Hi,

What u have mentioned in the action field in mapping.

Refer this have u done the same thing.

/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

chirag