I feel like a clown posting this, however I have an application where certain values on the document seem to revert to a previous value. For example, I have a bunch of emails that are generated when a specific workflow is completed. I know the document would have had a complete status and can check that the emails were generated, yet the document will be in a previous state on the server.
This only happens for some documents.
I have a logfile that generates an entry whenever a new error is reached and references the specific record number and the user. I have checked back in the logs (I know the exact time the workflow was closed) and there are no errors.
The database is very large (40Gb) - mostly attachments. I have not noticed this issue with any other applications on the server.
We have 2 servers in the environment. Same time and date. no replication issues. All users work off the same server. I have run a fixup (no issues reported) and compact.
I have not raised this with IBM as yet because it is such a vague issue. Anyone with any thoughts on how to troubleshoot?