Dear All,
I just wanted to share a solution that took me almost a month to solve, if you have come across this error, I would be very interested to hear how you have solved it.
SAGE Support was unable to help, and had no knowledgebase notes on the subject. So having spent almost £ 2000 of IT support and several weeks searching for a solution, I feel I should share my efforts.
We are using CITRIX on a remote server environment, and Office 365 online using SAGE Line 50, Version 22
The error appears to be on ODBC error, but it is more likely to be a "share" network error.
The solution is to set the registry value of "IRPStackSize" to a higher value
(I have set it to the maximum of 50 decimal)
Solution: Youtube video + notes
https://www.youtube.com/watch?v=ct4OXRB8vtk
- IRPStackSize
- Go to the below Registry entry to edit the IRPStackSize
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters
If you do not have the Registry entry then create one manually, but make sure the name should be correct as it is case sensitive.
To create the Registry entry follow the below steps:
– Open REGEDIT
– Proceed to the following location: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters
– Click Edit, and point to New and then click DWORD Value
– Type IRPStackSize , Click Edit and then modify the Value
– The Value should be 0x00000050 in Hexadecimal or 80 in Decimal. This should resolve your issue, normally values are provided to 1 to 15 in decimal notation. Better if you provide higher value so that the problem doesn’t come back.
– Restart the Server after the changes are done.