Updates not reflected on DB, but no errors shown on SXMB_MONI

[Former Member]

Hello everyone

I followed the blog [FILE to JDBC Adapter using SAP XI 3.0|https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/1772] [original link is broken] [original link is broken] [original link is broken]; and it seemed like I configured it correctly.

When I put a file on the ftp server, XI takes it and erases the file. I can even go to SXMB_MONI and I see the flag that the message was ok

however, I don't see the newly created record on the DB table I configured (SQL Server)

I know for sure that the jdbc driver works, since I've used it on another scenario, same XI, same SQL Server

I do have some questions about it

1) if I see the message as "Succesful" on SXMB_MONI, why it didn't insert the record?

2) Where do I tell XI the SQL sentence to execute? as far as I know, I only created an XML structure with the "action" attribute with value constant "INSERT", but what happens with the values to be inserted? are they taken from the names of the other tags on the XML structure?

3) If I feed XI an xml file, is it ok to set the sender transfer as binary?

Thanks for your help!

Alejandro

[Former Member · Accepted solution]

Hi,

You will have success message in SXMB_MONI, even though the Interface fails.

1) Check in Message Monitoring in RWB.

It may be length problem or any other problem related to database Table.

First find out the Length of the Fields in the table.

Check whether correct length is passed. If length of the File fields exceeds than the Table Field length, it will through error.

So check in RWB and post the error you got, so that we can help you out.

Thanks,

Kishore.

[Former Member · Accepted solution]

Hello:

I've checked RWB and indeed, there it shows the errors:

Message Data

Attribute Value

Engine All

Status System Error

Repeatable Yes

Cancelable No

Start 27.02.2008 16:51:29

End 27.02.2008 17:06:30

Sender Party

Sender Service ProviderBusinessSystem_001

Sender Interface http://sap.com/BPP/mi_file_001

Receiver Party

Receiver Service ConsumerBusinessSystem_001

Receiver Interface http://sap.com/BPP/mi_jdbc_001

Quality of Service Exactly Once

Error Category

Error Code

Message 8853E490E58611DCADF9001517100818

Reference

I forgot to put the content of my test File:

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

<ns0:data_filesender_001 xmlns:ns0="http://sap.com/BPP">
   <ID_CLIENTE>1</ID_CLIENTE>
   <Nombre>a</Nombre>
</ns0:data_filesender_001>

I only send a number "1" and a leter "a" so there shouldnt be any database restriction issues, besides, is says the error relays on the "sender", that is, the file sender

any ideas?

Thanks!

[justin_santhanam · Accepted solution]

Leon,

Could you tell us the structure you are using to insert into the DB?

raj.

[Former Member · Accepted solution]

When I do a Test on message mapping, I get this result:

<?xml version="1.0" encoding="UTF-8"?>
<ns0:data_jdbcreceiver_001 xmlns:ns0="http://sap.com/BPP">
<STATEMENTNAME>
<TEST>
<action>INSERT</action>
<TABLE>Clientes</TABLE>
<access><ID_Cliente>1</ID_Cliente><Nombre>name</Nombre></access>
</TEST>
</STATEMENTNAME>
</ns0:data_jdbcreceiver_001>

The structure (the data type) is as follows:

data_jdbcreceiver_001
---STATEMENTNAME (element)
    |________TEST (element)
                     |_________action (attribute - optional)
                     |_________ TABLE (element - string)
                     |_________ access(element)
                                       |_________ ID_Cliente(element - Integer)
                                       |_________ Nombre(element -String)

And the table on SQL Server is:

Table "Clientes" ID_Cliente::Integer, Nombre::varchar(40)

Is that what you meant?

Thanks!

Alejandro

[Former Member · Accepted solution]

I've changed the destination. instead of being a JDBC adapter, I used file adapter and it works fine, so it must have something to do with the jdbc connection

what could be the issue?

thanks!

[agasthuri_doss · Accepted solution]

Hi,

What is the status in Component Montoring ( RWB ) of the JDBC Adapter,

Regards

Agasthuri Doss

[justin_santhanam · Accepted solution]

Alejandro,

The strcuture looks fine.

Can u confirm these two field name is the same in your table ID_Cliente, Nombre . As Doss said, can u reply what u see in Component Monitoring for the comm.channel JDBC?

raj.

[Former Member · Accepted solution]

Try the target structure as given in the following

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

[Former Member · Accepted solution]

Hello:

Indeed, on that blog, the Structure seemed to be misconstructed. I followed the link Guru mentioned and it works now

Thanks everyone

Alejandro