jdbc receiver update_count=0 and insert_count=0

[ricardo_marcondes]

Hello,

I have a jdbc receiver scenario on PI 7.0 for one table on MS SQL Server and I'm using the update_insert action.

When the entry already exists, it's generated the statements for insert and for update (the 2 statements are visible on RWB) and returns insert_count=0 and update_count=0.

Any error occurs and in the RWB the log shows the request was processed with success.

I've already enabled the log for sql statements on the channel, but the statements are correct.

Have you already seen this problem?

Thank you very much.

[Former Member · Accepted solution]

Have you used the SAP recommended JDBC response message structure to get response?

Your jdbc request root tag starts with <Statement> then jdbc response root tag should start with <Statement_response>.

If you follow the above syntax, you should be able to get it.

● action=UPDATE_INSERT

The response document has the following format; one of the two values is always 0 because either an UPDATE or an INSERT action is always executed:

<update_count>count</update_count>

<insert_count>count</insert_count>

[ricardo_marcondes · Accepted solution]

The structure is correct because it´s getting this as response:

tag on the mapping and it's ok.

[ricardo_marcondes · Accepted solution]

I fixed my mapping and worked.

Thank you.