Skip to Content

PI 7.0 - jdbc receiver issue with MS SQL Server

Hello Experts,

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

When the entry does not exist it is created normally and returns insert_count=1 and update_count=0.

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.

I've reviewed also the <key> tag on the mapping and it's ok.

Any suggestion to try fix this issue?

Thank you very much.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 23, 2011 at 09:54 AM

    Hi,

    It seems to be an issue with the update statement not working according to your requirement. What is the data type of the key value for which the query is being executed.

    Regards,

    Indranil

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 23, 2011 at 02:29 PM

    Just Few cents...

    Since we see issues only during update statement...

    Use the same update statement and check it using toad or some database tool ? Just to make sure the query or data that is being used by statement is not causing. otherwise you might need to see SAP Notes regarding update statement if any.

    Add comment
    10|10000 characters needed characters exceeded