Issues with GetNextNumberWithGapsCommit

Hello,

I would like to check on the DB flag settings and the effects on function GetNextNumberWithGapsCommit. We have intermittent issues across application where this function is used. I was reviewing the support site but could not get a good article for this specific issue. The issues appears across modules like Absence, eperformance and Recruitment.

The issue is similar to below.

We see the code snippet for this and see the function used to retrieve the LAST_TXN_NUM.

/*Implementing try-catch approach-Murali 12/Aug/2016*/

   try

      &TEMP_TXN_NUM = GetNextNumberWithGapsCommit(GP_INSTALLATION.LAST_TXN_NUM, 99999999, 1);

   catch Exception &E

      WriteToLog(1, "Exception in GetNextNumberWithGapsCommit: DTTM=" | %Datetime | "-LAST_TXN_NUM=" | GP_INSTALLATION.LAST_TXN_NUM | "-Excep=" | &E.StackTrace);