V12 Web Service connections re-opened

SUGGESTED

We're on V12 patch 21, with Syracuse 12.6. We use web services primarily for creating sales orders. I use the SOAP method, I've never tried REST. I have two servers that run Syracuse, one that has Mongo, and the other that's meant to stand alone as handling the web service traffic.

An issue I have is that each morning, there are all sorts of orders locked open by the web service connection. At that point I play a game of whack-a-mole going through the Locked Symbols function into User Monitor to close the connections. Sometimes closing one connection will release numerous locked orders.

The orders in question were imported via web services, but none of them are recent, they might be from a day or two ago.

I've tried restarting the web service pool from each Syracuse server (if it makes a difference). I also restarted Agent Syracuse on the web service server. (That did clear up the connections, but only for a while.) I'm not sure what the best way to handle this is, or if I'm missing something relevant in the integration systems, for example some kind of 'dispose' method at the end of the import process.

Any feedback on this topic would be great. Thanks.

  • 0
    SUGGESTED

    How are you processing the web service call, by your own code or calling the import function (for example) ?  If custom code, maybe you have missed something in the code to close the record, as obviously should not be locked.     Also check your Syracuse logs for any errors in the Wx.log files, which could possibly be leaving open connections hanging around.  You should also check any logs you have from the calling program, as you should be getting back status codes and any errors in processing