Hi,
As far as I know, this error primarily indicates that the transaction operation has been promoted to a distributed transaction operation, but because the distributed operation depends on MSDTC. This dependency may have caused the error. For example, MSDTC service
is not enabled, please refer to the following steps to enable MSDTC
Enable DTC service,

Control panel, administrative tools, Component service.

Add firewall rules. Enable inbound rules and outbound rules for 135 port and “C:\Windows\System32\msdtc.exe” application.
Besides, please refer to the below discussion, it might be useful to you.
https://stackoverflow.com/questions/29574664/the-promote-method-returned-an-invalid-value-for-the-distributed-transaction-onl
https://social.technet.microsoft.com/Forums/en-US/f145531c-1861-4579-9434-bc6ae301468f/the-promote-method-returned-an-invalid-value-for-the-distributed-transaction?forum=adodotnetdataproviders
Feel free to let me know if there is anything I can help with.
Best Regards
Abraham