Question Re: Integration Suite JDBC Duplicate Key error in Technology Q&A

Integration Suite JDBC Duplicate Key error

ic3 — Fri, 04 Nov 2022 15:19:01 GMT

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

Re: Integration Suite JDBC Duplicate Key error

VijayKonam — Fri, 04 Nov 2022 18:59:55 GMT

Did you change the key in the payload and tried again? Duplicate Key error is nothing to do with CPI or PO. It is the database system that is complaining.

Re: Integration Suite JDBC Duplicate Key error

ic3 — Fri, 04 Nov 2022 20:23:03 GMT

Hello Vijay, thanks!

As I wrote, it is an update and therefore the key must be the same.
Likewise, I can successfully process the same payload with the same key via the PI again and again.
But of course I tried it with another key without success.

Do you have another idea?

Best regards

Igor

Re: Integration Suite JDBC Duplicate Key error

VijayKonam — Fri, 04 Nov 2022 20:41:37 GMT

Sorry. I missed that it was update and the error was no in English. It does look strange as you are saying the same statement is working fine from PI. Did you enable SQL Tracing on the target service and checked the actual SQL query that is being sent to the DB? That might give some idea of why it is throwing that error.

Re: Integration Suite JDBC Duplicate Key error

openrico — Sun, 13 Nov 2022 15:30:26 GMT

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

Re: Integration Suite JDBC Duplicate Key error

ic3 — Mon, 12 Dec 2022 14:58:21 GMT

Thank you! The answer is correct.