Provide a XOG trace for both the working environment and the one that has the issue. Steps to do a XOG trace are at: Enable SQL trace for XOG
Do you get any errors when XOGing? If yes, what is the error?
Include the files that were used to XOG:
read XML
write XML
output XML
If the XOG is running in a process, can you reproduce the issue outside of the process using XOG client (to rule out any process related aspects causing the issue)