cancel
Showing results for 
Search instead for 
Did you mean: 

Inserting Idoc in Oracle

Former Member
0 Kudos

Hi everybody

I´m trying to insert Idoc´s into an Oracle Data Base by an asynchronous interface.

When i send the Idoc, in XI sxmb_moni transaction code I see that it was succesfully inserted.

But when I see the table in Oracle it is empty.

Can someone tell me how can I check that the Idoc is correctly inserted??

(without making synchronous the interface because I need it asynchronous)

Or how to insert it??

Thanks in advanced.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Please check your JDBC receiver communication channel in RWB.

Thanx

Aamir

Answers (7)

Answers (7)

Former Member
0 Kudos

Hi everyone

The problem is solved, it was happening because the Oracle DBA modified the structure without telling me.

Thanks everyone for your answers.

Former Member
0 Kudos

Hi

Check u r "Receiver JDBC Adapter" in RWB CC monitoring.

check if there is any error here.

Also check wether the Inbound interface is norms with recevier Adapter type for insert action

regards

srini

Former Member
0 Kudos

Hi,

Have you tried inserting data using Sql-plus. I mean ensure that there is no mandatory field which is going empty, or some type mismatch of your data with the table datatype.

Regards

Former Member
0 Kudos

Hey,

Check the pipeline steps in Moni. Check whether the payload passes through all the steps.

If no check in which step it does not and make the corresponding changes.

Also check the communication channel (Receiver) in RWB.

regards,

Milan

aashish_sinha
Active Contributor
0 Kudos

Hi ,

Looks Like some problem in JDBC receiver adapter configuration.

Please refer

Receiver JDBC Adapter

http://help.sap.com/saphelp_nw70/helpdata/en/b0/676b3c255b1475e10000000a114084/content.htm

Blogs

https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/1403 [original link is broken] [original link is broken] [original link is broken]

Regards

Aashish Sinha

Former Member
0 Kudos

Hi

Are you able to see Payload in SXMB_MONI and RWB.

Check the connection parameters exactly where it is inserting the data if something is wrong there.

Thanks

Gaurav

Former Member
0 Kudos

hi emmanuel,

In RWB of the XI Server check in communication channel monitoring.

You could figure out why it is happening.

Regards

Ramesh P