Change unique ID generation to use sp_iboGetCounter

In rare circumstances, EFT manages to obtain a non-unique id and thus a database error iss generated.

I have looked further into this and the procedure EFT calls to obtain the Activity.SEQN is sp_asi_GetCounter2 ... and now from the looks of it, the procedure doesn't guarantee a unique value. There is another stored procedure sp_iboGetCounter that does, however it takes different parameters, so there will need to be a recompile of the EFT code to fix this.

login or register to post comments :: |
Submitted by Stu on 4 May 2007 - 12:03am