none
WCF-SQL inserts the same message multiple times RRS feed

  • Question

  • Hi,

    I have a send port with WCF-SQL adpater which soppose to call SP to write message content into database.

    With small messages everything works fine but when I test with big message (several Mb) BTS inserts the same message in most cases 2 or 3 times. I tried to increase send timeout to 10 min, tried to play with transaction types but it didn't help. My store proc doen't have any logic, is just INSERT statement.

    Any thoughts? Thanks

     

    Monday, February 7, 2011 10:14 PM

Answers

  • Is there any warning or error in your event log?
    -- Please mark as answered if this answers your question.

    No errors in event log.

    I actually found a problem. My system polls messages from one database and push into another, in case of large message BTS polls the same message multiple times so it inserts multiple times in result database. 

    • Marked as answer by Pavlo Tubolets Tuesday, February 8, 2011 10:18 PM
    Tuesday, February 8, 2011 10:18 PM

All replies

  • Is there any warning or error in your event log?
    -- Please mark as answered if this answers your question.
    Tuesday, February 8, 2011 5:53 AM
  • Is there any warning or error in your event log?
    -- Please mark as answered if this answers your question.

    No errors in event log.

    I actually found a problem. My system polls messages from one database and push into another, in case of large message BTS polls the same message multiple times so it inserts multiple times in result database. 

    • Marked as answer by Pavlo Tubolets Tuesday, February 8, 2011 10:18 PM
    Tuesday, February 8, 2011 10:18 PM