Status

Unresolved


Issue

A ConnectWise SQL Error occurs when syncing Procurement / Inventory after applying the patch 58617.


Update 15 Octpber 2018: The error has now been reported on the latest v2018.6 patch (58651).


It has been explained that error is caused by a problem with the GL Entries that were generated for the purchase order. A workaround has been provided, scroll down for more information.


A permanent solution to mitigate the SQL Error has not been found.


Update 24 October 2018: ConnectWise have not found the root cause to this problem, so cannot provide a permanent solution at this stage. We now have reports that the workaround provided by ConnectWise on the 17th October is not working in all cases.


Contact support@wise-sync.com if you are experiencing this error. 


ConnectWise have asked us to advise them of partners that report the problem as they come through, which we will do, however we strongly recommend that if you are experiencing this error, that you contact ConnectWise Support quoting the ticket number #11033681 to follow up a permanent solution.


How do we know this is an issue? Scroll down to see more.


Version Affected

ConnectWise Manage Version v2018.6 (58617 - 58651).


What we're doing about it

We've logged this with ConnectWise.


You may request updates to this ticket and advise if you are affected by this issue: 


ConnectWise Ticket: #11033681 

Date Reported: 8th October, 2018


Updates

8 October 2018
Ticket logged with ConnectWise.

ConnectWise acknowledge receipt of issue.

The error could be replicated by the ConnectWise Platform team and has been escalated to Development for correction.  
10 October 2018
We've followed up ConnectWise for an update.
11 October 2018
ConnectWise have made an update in the backend and have asked us to see if the issue is resolved.

If you have been affected by this error, please attempt Procurement Sync. Contact support@wise-sync.com if you're still experiencing the error.

15 October 2018
Partners reporting this error occuring on the latest v2018.6 patch (58651).

We've followed up ConnectWise for a permanent solution.
16 October 2018
No update.
17 October 2018
Workaround provided, scroll down for more information.

Expectations of when we should expect a permanent solution wasn't provided, we've chased this up.
24 October 2018

ConnectWise have not found the root cause to this problem, so cannot provide a permanent solution at this stage.


Contact support@wise-sync.com if you are experiencing this error. 


ConnectWise have asked us to advise them of partners that report the problem as they come through, which we will do as they trickle in, however we strongly recommend that if you are experiencing this error, that you contact ConnectWise Support quoting the ticket number #11033681 to follow up a permanent solution.    

11 December 2018ConnnectWise closed the ticket without providing a permanent solution. We've re-opened a ticket to chase this up.


How do we know this is an issue?

During sync, you may see the error below


Workaround

This workaround has been suggested by ConnectWise using the example below:



1 Locate the Packing Slip Number reported in the error.


2 Unreceive/Re-open products on the Purchase Order you are receiving the error for. 


3 Re-receive and close the Purchase Order to re-create the GL Entries and send the Purchase Order back to Unposted Procurement.


4 Attempt Sync.


NOTE: You may need to repeat the process for subsequent packing slips receiving the error.