At the end of December, I replaced all of our computers - server went from 2012 to 2022, and workstations went from 10 to 11. Ever since then we have had this problem and nobody has been able to tell us what the problem is so far.
When we go to do payroll, we log in fine and tell it to sync. As we watch the sync process, it looks almost like it syncs up fine, then down fine, then up fine, and then the final down fails. The result of this is that the payroll transactions go through fine, but at the end, when it is supposed to push the sage payroll fees down into the journal, that doesn't get done. And now, it looks like some account changes we made (checking account numbers) are not being pushed up - those changes don't seem to be getting to the payroll service, so changes as to where the money goes are not working.
Nothing on our building firewall changed between back when it worked and now. I've tried turning the Windows computer firewall completely off - no change. We tried doing the sync right from the server (also with the firewall off) - no change. It does the same thing on the server and both the workstations.
Here is the error log we get immediately after it tries to sync:
2024/01/20 13:21:40.7076 Beginning Sync process
2024/01/20 13:21:41.1320 Loading Service Selection
2024/01/20 13:21:41.1945 Requesting Authentication
2024/01/20 13:21:41.4143 begin Navigate to https://sync.peachtree.com/Wizard/AuthenticateSync?ClientVersion=31.0.01.0110&AgentVersion=2.13.0.24
2024/01/20 13:21:43.0013 DocumentCompleted. Uri:https://id.sage.com/login?state=hKFo2SA5V1BWWmdDQ0tsZThtQWpGWHlKbzdYb2d3bTlzcmR6cqFupWxvZ2luo3RpZNkgZzNTd1BSM3FpeW9nT1Jfa3lvaElQeThWa3kydUx6dlejY2lk2SA1anMyc3hrN1RPSUtNN2ZCVlUzblZzYzRBQ2QyVHE1bQ&client=5js2sxk7TOIKM7fBVU3nVsc4ACd2Tq5m&protocol=oauth2&redirect_uri=https%3A%2F%2Fsync.peachtree.com%2FWizard%2FAuthenticateSync&response_type=code&scope=openid profile email&nonce=638413717022496598.YzNiMjMwMWYtODY2NS00ZDIwLTkzYzMtNGU0YTQ5MzAyZWQ3MWM1NWVhMjAtY2RhMS00OTFiLWE5NjAtNzQ5YmIwMTdhNmEw&login_hint=eyJmbG93X2hpbnQiOiAibG9naW4ifQ%3D%3D&x-client-SKU=ID_NET461&x-client-ver=6.5.0.0
2024/01/20 13:21:43.0169 url is not https://sync.peachtree.com/Wizard/AuthenticateSync?ClientVersion=31.0.01.0110&AgentVersion=2.13.0.24
2024/01/20 13:21:43.0169 Unexpected Url
2024/01/20 13:21:43.7553 DocumentCompleted. Uri:https://id.sage.com/login?state=hKFo2SA5V1BWWmdDQ0tsZThtQWpGWHlKbzdYb2d3bTlzcmR6cqFupWxvZ2luo3RpZNkgZzNTd1BSM3FpeW9nT1Jfa3lvaElQeThWa3kydUx6dlejY2lk2SA1anMyc3hrN1RPSUtNN2ZCVlUzblZzYzRBQ2QyVHE1bQ&client=5js2sxk7TOIKM7fBVU3nVsc4ACd2Tq5m&protocol=oauth2&redirect_uri=https%3A%2F%2Fsync.peachtree.com%2FWizard%2FAuthenticateSync&response_type=code&scope=openid profile email&nonce=638413717022496598.YzNiMjMwMWYtODY2NS00ZDIwLTkzYzMtNGU0YTQ5MzAyZWQ3MWM1NWVhMjAtY2RhMS00OTFiLWE5NjAtNzQ5YmIwMTdhNmEw&login_hint=eyJmbG93X2hpbnQiOiAibG9naW4ifQ%3D%3D&x-client-SKU=ID_NET461&x-client-ver=6.5.0.0#/
2024/01/20 13:21:43.7553 url is not https://sync.peachtree.com/Wizard/AuthenticateSync?ClientVersion=31.0.01.0110&AgentVersion=2.13.0.24
2024/01/20 13:21:43.7553 Unexpected Url
2024/01/20 13:22:02.8575 url is not https://sync.peachtree.com/Wizard/AuthenticateSync?ClientVersion=31.0.01.0110&AgentVersion=2.13.0.24
2024/01/20 13:22:02.8731 Url contains Success
2024/01/20 13:22:02.9047 Url contains Token
2024/01/20 13:22:03.8947 Automatically selected Company
2024/01/20 13:22:03.9416 Skipping Direct Deposit Review. No Pending Data
2024/01/20 13:22:03.9728 Beginning Data Sync
2024/01/20 13:22:19.5641 DirectDeposit:DataIn LOG: Unexpected Error on datatype:-21013 INFO: Sage.Sync.Sage50.Exceptions.UserException: There was a problem performing the requested operation. ---> System.Data.SqlServerCe.SqlCeException: Internal error: Cannot open the shared memory region.
at Sage.Sync.Sage50.DataAccess.DatabaseConnectionManager.CreateConnection(String filePathName, String password, Int32 maxDbSizeMB, Boolean persistSecurity)
at Sage.Sync.Sage50.DataAccess.DatabaseConnectionManager.CreateTransCenterConnection()
at Sage.Sync.Sage50.DataAccess.DatabaseConnectionManager.get_DbConnection()
at Sage.Sync.Sage50.Models.TransactionCenterModel.get_DefinitionTable()
at Sage.Sync.Sage50.Models.TransactionCenterModel.GetCurrentTableDef(Int32 desktopClientId, Int32 syncDriverDataType)
at Sage.Sync.Sage50.Models.TransactionCenterModel.AddAndProcess(String desktopClientId, String syncDriverDataType, XmlDocument clientXmlDoc, Int32& successfulImportCount, Int32& failedImportCount)
--- End of inner exception stack trace ---
at Sage.Sync.Sage50.Models.TransactionCenterModel.AddAndProcess(String desktopClientId, String syncDriverDataType, XmlDocument clientXmlDoc, Int32& successfulImportCount, Int32& failedImportCount)
at Sage.Sync.Sage50.SyncEngines.BaseEngine.ImportElements(String desktopClientId, String syncDriverDataType, XmlDocument clientXmlDoc, Boolean addToTransactionCenter)
at Sage.Sync.Sage50.SyncEngines.DirectDeposit.DataInInternal(String dataType, String strCompanyId, String strUserDefined, String strData)
at Sage.Sync.Sage50.SyncEngines.BaseEngine.DataIn(String dataType, String strCompanyId, String strUserDefined, String strData)
2024/01/20 13:22:19.9187 Sync LOG: Severity: Exception.
Information: Error during sync steps..
Information: Calling DataIn failed..
Information: There was a problem performing the requested operation..
Information: Internal error: Cannot open the shared memory region..
2024/01/20 13:22:26.1243 Completed Sync process
Any ideas?
