how can we set the Transaction No while inserting tracking event in OTM

Summary:

We have a case wherein we are creating tracking event from Automation agent

but as I_transaction_no is always unique, so how can we generate Next Transaction_no to be set for the event in OTM

we have tried Max(I_TRANSACTION_NO)+1 in SQL but it is throwing error sometimes

Content (please ensure you mask any confidential information):

We have a case wherein we are creating tracking event from Automation agent

but as I_transaction_no is always unique, so how can we generate Next Transaction_no to be set for the event in OTM

we have tried Max(I_TRANSACTION_NO)+1 in SQL but it is throwing error sometimes