Hi Guys,
This is something that I have known about for a long time now but I had come up with a workaround so it hadn't really bothered me.
I'm setting up the service on a new system as we are decommissioning an older one and I remembered these two quirks with the Jiwa Import Queue Processing Service.
Jiwa version 6.5.12
Firstly, there appears to be a memory leak in the Jiwa Import Queue Processing Service. If you leave it on for a while processing the import queue, the more XML data it processes, the more RAM it will use, until eventually it will use up all the system resources. In our case, during the day it would take about 3-4 hours before it would be using about 200mb of RAM, and about 2-3 days before it would be using all available RAM on the system. My fix for this was a scheduled task that ran every 2 hours to restart the service.
Secondly, I'm not sure if this is still the case but a note I had in my batch file says "a bug is causing the Initiated Date of a sales order to be overwritten with the date the service was started". Meaning, if we start the service today and leave it running all day until tomorrow, tomorrow the initiated date will be entered in as today's date. Restarting the service each day is also a fix for this issue.
Is anyone else using the Import Queue Processing Service and experiencing similar issues? Has this been fixed in a more recent build of Jiwa?