SQL POST URL posts once, but inserts two rows

Jeremy Morgan

January 28, 2022 15:51 Edited

I have a POST URL that is called on the very last step to send the results to our SQL Server database. It gets called one time and posts with a code of 200. However, it is inserting two rows every time instead of one.

 

Any ideas??

1

• Official comment

  

  Megan Ellis

  February 02, 2022 00:59 Edited

  Hi Jeremy,

  I recommend double checking the configuration of the method you are using to post to your db (Business Rule or Doc URI approach), as well as your configuration.xml file. You can also check the database-connector.log file to see if there are more details about the post actions that can lead you to the root cause.

  If you need further help identifying the issue, please open a support case or contact your frevvo Account Manager to request Client Services assistance. Thanks!
• 

  Jeremy Morgan

  February 01, 2022 12:17

  After checking the database-connector.log file, it is showing back to back lines for row's created. They are only .013 seconds apart. This happens although the URL is posted once. The rule is designed to only be called on the very last step once all the data is ran and the console shows it successfully running one time.

  0
• 

  Megan Ellis

  February 02, 2022 00:59 Edited

  Hi Jeremy,

  That is not the expected behavior, of course. To get further assistance troubleshooting this, please open a support case or contact your frevvo Account Manager to request Client Services assistance. Thanks!

  0

Please sign in to leave a comment.