Nicole,

Thanks for the detailed response, greatly appreciated. 

A few followup questions to your answers:

1. how can such a task be created? what tool should I use and what method/entry point can I call? right now I've been manually doing it on the webGUI in the system management portal

2/3. I prefer the upgrading of my instance, do you know which version this was fixed in? 2015.x? or a later 2014.x?

thanks so much,

Jason

2. 

David, thanks for the detailed explanation. And yes, we're on 2014.1.3.

Will definitely update the thread if I can reproduce

Sergei, that worked, do you know why purging the cached queries fixes it? and what caused it in the first place?

again, thanks so much