Discussed with the Pentaho team, Nate, and Zara team the issues and checked it with them as well for finding if the cause of the error is the extraction of data from XML or the application, as per checking, there are no incorrect data and the application is not wrong as well, the cause is that the internet return transaction is included in the extraction of data, but as per sir Law, it should be not, but this will be verified with Sir Ian.