Integration Suite JDBC Duplicate Key error

[ic3]

Hello everyone,

on the Integration Suite we get the error "Duplicate Key error" when using the JDBC adapter and an update.
This interface already exists on the PI and works properly.

The test on the Integration Suite takes place with exactly the same payload, exported from the PI.
There is no mapping or special logic. The message is forwarded 1:1 from the source.

Error Message Integration Suite

Sent Message

Configuration on Integration Suite

The difference between SAP PI and Integration Suite are following settings which are not available on Integration Suite. And i think this could be the problem.

And like i said i can take the payload from the integration suite and successfully send it over the PI.

The DB is Microsoft on Premise.

Can you guys help with this problem?

Thanks very much!

Best regards

Igor

[openrico · Accepted solution]

Hi Igor,

as a test: have you tried to implement a content modifier to modify the body to something plain like this:

Update table yyy set ... Where id=xx and pn=yy

Of course you need another content modifier to get the data from the xpath.

Greetings

Enrico

[ic3 · Accepted solution]

Thank you! The answer is correct.