Hi there!
For one of our processed batches, when trying to move it from Processed to Export (or any other stage), I receive the following message:
The required action cannot be performed: some of the selected pages are being used by another process.
There are no tasks assigned to this batch. I also tried restarting all the services, but with no luck.
Possible steps done in the batch that created the issue:
- Open verification station, find a batch by ID. The batch is on a Processed stage.
- Change a field in one of the documents
- Save it
- (Accidentally) close the verification station
- Immediately re-open it again and try to send the whole batch to the Export stage.
I have also noticed that few pages in the batch have no value in Stage column.
FlexiCapture version 12.0.1.292.
Comments
3 comments
Hello Vasily,
Please try delete all the session in the Administration and monitoring Console > Processing Monitor > System monitor > Sessions.
Please let me know if this has worked.
Alexey.
Hello Alexey,
Unfortunately, no, it did not help. Please let me know, if there is any data I can provide you to ease the research.
In case it can help to identify the issue, I was able to identify the exact documents without stages by analyzing BatchItem table with the following script:
Please check the dbo.Lock table in the database and if there are records without SessionId - delete them.
If this will not work, try to enable deadlock log with the command DBCC TRACEON (1204, 3605, 1222, -1) in the Sql server console, and contact your regional support by sending them the logs.
(They will most likely need your database backup nevertheless)
Alexey
Please sign in to leave a comment.