07-27-2016 04:27 AM
Is is possible to ever see duplicate batchnum's in the archivedqueue table? I do not see it set up as solely unique in SQL Server. As far as I can tell, there are some indexes set up but it would still allow unique combinations of the batchnum and status fields.
I assume as the batch transitions the unique record that contains the batchnum in the table gets updated with all the relevant information like the status etc.and there can never be duplicate batchnum's in the archivedqueue table? Would that be a correct assumption?
07-27-2016 07:22 AM
Hey Peter,
To my knowledge, no it is not possible natively within the software to have a duplicate batchnum in the hsi.archivedqueue. It is constantly incremented anytime a batch is created so they should always be unique. If memory serves me correct the archivedqueue1 index is unique which should prevent duplicate batchnums from occurring.
Hope this helps!
07-27-2016 07:22 AM
Hey Peter,
To my knowledge, no it is not possible natively within the software to have a duplicate batchnum in the hsi.archivedqueue. It is constantly incremented anytime a batch is created so they should always be unique. If memory serves me correct the archivedqueue1 index is unique which should prevent duplicate batchnums from occurring.
Hope this helps!
07-27-2016 07:32 AM
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.