“An error was reported while committing a database transaction but it could not be determined whether the transaction succeeded or failed on the database server“-Always on Availability groups

FPVI-SQL1HA(1595)-------1GB(N/W)--------FPMC-SQL1HA(1568)

We have Always on Availability groups Synchronous Configured between FPVI-SQL1HA and FPMC-SQL1HA (both got SQL Server 2014 installed)

No issues happened, and we had automatic failover happened without any data loss.

 

FPVI-SQL1HA(1595)-------100MB(N/W)--------FPMC-SQL1HA(Colocation)

As soon as we moved to Colocation to a 100MB network between two servers, issues started happening

 “An error was reported while committing a database transaction but it could not be determined whether the transaction succeeded or failed on the database server“

Ref:

https://msdn.microsoft.com/en-us/library/dn135335(v=sql.110).aspx

Synchronous mode :Transaction should be committed on Secondary FPMC and send ACK to primary FPVI for commit(Automatic Failover)

Asynchronous mode : Transaction  should be committed on Primary FPVI and  send ACK to Secondary FPMC(Manual Failover)