I've posted the below in the PB general group however I'm now thinking
it may be a DB connectivity setting... specifically MARS
Any help would be massively appreciated
It turns out that someone had coded a commit in code that was being
executed after the retrieve, therefore the transaction was being
closed and the subsequent retrieve couldn't take place