# Unable to commit transaction error message suddenly appearing

**URL:** <https://clarionhub.com/t/unable-to-commit-transaction-error-message-suddenly-appearing/1710>\
**Category:** questions\
**Tags:** error\
**Created:** [February 27, 2018, 9:16am UTC](https://clarionhub.com/t/unable-to-commit-transaction-error-message-suddenly-appearing/1710 "2018-02-27T09:16:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Graeme](https://clarionhub.com/letter_avatar_proxy/v4/letter/g/50afbb/32.png) [@Graeme](https://clarionhub.com/u/Graeme)\
**Post date:** [February 27, 2018, 9:16am UTC](https://clarionhub.com/t/unable-to-commit-transaction-error-message-suddenly-appearing/1710/1 "2018-02-27T09:16:28Z")

</div>

Hi all, one of our installs has suddenly been getting Assertion Failed error messages advising the system is unable to commit transaction.

They have about 20 users and the build of the system they are using they would have had for at least 6 months with no issues. The system is still in C8, uses TPS and was compiled in debug mode (not sure if that makes a difference).

Below is the error message they get and also the relevant line of the ABFILE.clw.

User access rights have not changed and server size seems OK.

Any pointers as I honestly don’t know where to start.

Many thanks

Graeme

 ![image](https://clarionhub-uploads.s3.dualstack.eu-north-1.amazonaws.com/original/2X/9/9b5b84c8b570a089c6642ab513070e81f9fca89f.png)

From the ABFILE.clw

> ```
> RelationManager.Update PROCEDURE(BYTE FromForm)
> RetVal BYTE(Level:Benign)
> I LONG,AUTO
> CODE
> RetVal = SELF.ForceOpen()
> DO CheckError
> IF SELF.UseLogout
> RetVal = SELF.LogoutUpdate()
> DO CheckError
> LOGOUT(SELF.LogoutTimeout)
> IF ERRORCODE()
> SELF.Me.Throw(Msg:LogoutFailed)
> RetVal = Level:Notify
> DO CheckError
> END
> END
> RetVal = SELF.Me.TryUpdate()
> IF RetVal
> IF SELF.UseLogout
> ROLLBACK
> END
> IF FromForm AND SELF.Me.LastError = Msg:ConcurrencyFailed
> SELF.Me.LastError = Msg:ConcurrencyFailedFromForm
> END
> IF RetVal = Level:Notify
> SELF.Me.Throw
> END
> IF SELF.Me.LastError = Msg:ConcurrencyFailed OR SELF.Me.LastError = Msg:ConcurrencyFailedFromForm
> RetVal = Level:Notify
> ELSE
> RetVal = Level:User
> END
> DO CheckError
> END
> SELF.DeferedRelations()
> LOOP I = 1 TO RECORDS(SELF.Relations)
> GET(SELF.Relations,I)
> IF LocalAction(SELF.Relations.UpdateMode) AND NOT SELF.Relations.Fields.EqualLeftBuffer()
> RetVal = SELF.Relations.File.UpdateSecondary(SELF.Relations.HisKey,SELF.Relations.Fields,SELF.Relations.UpdateMode)
> IF RetVal
> SELF.Relations.Fields.AssignRightToLeft
> DO CheckError
> END
> END
> END
> IF SELF.UseLogout
> COMMIT
> **? ASSERT(~ERRORCODE(),'Unable to commit transaction')**
> END
> SELF.Close
> RETURN RetVal
> 
> ```

---

<div class="post-metadata">

**Author:** ![PurpleEdge2214](https://clarionhub.com/user_avatar/clarionhub.com/purpleedge2214/32/5109_2.png) [@PurpleEdge2214](https://clarionhub.com/u/PurpleEdge2214)\
**Post date:** [February 28, 2018, 12:19pm UTC](https://clarionhub.com/t/unable-to-commit-transaction-error-message-suddenly-appearing/1710/2 "2018-02-28T12:19:01Z")

</div>

Sounds like it might be data related, have you checked all the tables involved in the transaction?

How repeatable is the error, is it random or constant?

Can you reproduce the error with their data on a different server?

---

<div class="post-metadata">

**Author:** ![Graeme](https://clarionhub.com/letter_avatar_proxy/v4/letter/g/50afbb/32.png) [@Graeme](https://clarionhub.com/u/Graeme)\
**Post date:** [March 2, 2018, 10:18pm UTC](https://clarionhub.com/t/unable-to-commit-transaction-error-message-suddenly-appearing/1710/3 "2018-03-02T22:18:09Z")

</div>

Thanks yes it was a corruption in one data table. I have not been able to repeat it but have been looking to see if teck support had changed anything on their server or the AV software.