I know this is a long shot but I am looking for any help I can find.  I have already reached out to the vendor to support, but am curious if anyone can think of a possible solution.  The support for the vendor does not seem to know what the issue is, so we are in bit of a stalemate.  

Last week (over July 4th holiday) I upgraded Sage from 4.4 to 2014.  Everything seemed to have went well, no errors in the logs during updates, conversions, or installs.

I installed the DSD SQL Mirroring utility for version 5.10.  (http://www.dsdinc.com/enhancement/sql-mirroring-3/)

The SQL mirror appears to work, for the most part.  However, it does not work when data is inserted or updated in SAGE via BOI.  If data is updated or inserted into Sage via a client workstation or VI job, the mirroring works like it should.  So we are at least able to continue to run our business, but I am required to re-sync the SalesOrder & AR tables every hour, which is not a viable long term plan.

Sage Info:

MS Server 2008.  32 GB Memory, (2) 4-core CPU’s @ 2.53GHz.

Sage 100 Advanced ERP 2014 running as service (domain & local server admin account)

Sage 100 ERP Client Server ODBC Driver running as service (domain & local server admin account)

Application that runs BOI interface running as service (domain & local server admin account)

Following EXE properties modified to run as administrator:

\\Sage\Sage 100 Advanced ERP\MAS90\Home\pvxiosvr.exe

\\Sage\Sage 100 Advanced ERP\MAS90\Home\pvxwin32.exe

\\Sage\Sage 100 ERP Workstation\MAS90\Home\pvxcom.exe

\\Sage\Sage 100 ERP Workstation\MAS90\Home\pvxcom.exe

C:\Program Files (x86)\Common Files\Sage\Common Components\pvxcom.exe