An error referring to an uncommittable transaction may be logged as part of an upgrade to an on-premise copy of Sage CRM.


The below may appear in

Get Errors 1 Items
After line 6675: SQLError: Uncommitable transaction is detected at the end of the batch. The transaction is rolled back (exec fixViewsMetadata)


The issue is caused by a malformed view in the CRM database. The fixViewsMetadata stored procedure attempts to rebuild view metadata on SQL Server - one of the views involved may be experiencing an issue. It is recommended that the process laid out in KBA 536-15802 be followed in order to resolve the issue.