Notes document reverting to previous values

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?

Subject: The very first thing I’d check…

…is whether the document was actually updated when the workflow ran. Check Document Properties - you can see when the document was last updated.

If the values were being reverted, you should see a current change date. On the second tab of document properties you can also see previous updates ($Revisions) and by who ($UpdatedBy).

Subject: What Mark said.

Then … my next steps are:

1- check whether SaveOptions is in use on the doc or form, then what it is.

2- check whether $Readers is in use on the doc or form, then what it is.

3- search for author and reader names fields and see what they are.

Generally development around ACLs and SaveOptions have “shortcuts”, and aren’t always reliable.