Hi Zdenek,
I would not recommend updating the batch status directly in the database, you will likely experience errors like the one stated. The similar action in the UI does more than just update the batch status when returning a batch to a previous stage.
You can retrieve the data from a batch more than once, providing you have the Batch ID. The only action that won't work a second time for the same batch, is "Get Next Available Batch", as this removes the respective batch from the RabbitMQ queue.
Thanks
Ben
Ben Lyons
Principal Product Specialist - Decipher
SS&C Blue Prism
UK based