Continued to debug the application to give the exact cause of the error with the ISCI team, and as per checking, the cause is the data, the output in the daily file is correct, but in hourly it is incorrect. The sales invoice sequence looks like resetting or jumping every hour because at 12 pm the SI is at number 40 but at 1 pm it returned to 2, this should be discussed with the Pentaho team as they are the ones extracting the data from XML.