We have this application that has a problem with regards to data consistency, which the applications is created on ASP.NET MVC 5, and in AngularJS 1.8.2. and SQL Server and we use Entity Framework.
What we encountered is we have a transaction on the system that is already completed, and then there is another transaction that is still in-process, and when the transaction is being updated, the title of the process has been changed from the title of the completed transaction, no movements has been done for the completed transaction.
This happened thrice in the span of 12 months, we actually try to replicate it, check the code and everything, but we can’t see the reason for it, and the funny thing is, it only updates one field, which is the “Title” field, which all data is still the same, only the title fields.
We are very puzzled about it, and for my experience, I never encountered this kind of thing, I’m thinking that is this about the sessions, the cookies or cache something.
We also encounter of data loss, some of the data is missing without any idea what happened, the application does not have a audit logs (as the management don’t want to bloated the database too much), so we are having a hard time finding the reasons, though I sneak a audit log, just in case it happens again.
But anyway now we have to maintain it, and the problem is we don’t know how to fix this. Has anyone using a similar setup encountered this before?
Thanks everyone.
To try and replicate the problem, we debug the code step by step, and we can’t replicate the problem, I’m trying to add a session expiration, thinking that this will help on this problem.