error cannot connect to vworkspace connection broker. Please contact your
system administrator.
Hi
our current setup is the following version:
vWorkspace Version 7.5.304.547 on Windows 2008R2 Standard.
When a new user logs into the brokers via the HTTP link, they see the web portal with the logon textboxes, however when they input their credentials they are given the following error:
error cannot connect to vworkspace connection broker. Please contact your system administrator.
existing users can connect without issues. We have checked that the user's account is not locked.
We seemed to have found the problem. The SQL code seem to through error if the user is part of the many groups and and the total lengh of the group names exceeds 8000 characters, they the error is present in the log.
Msg 537, Level 16, State 3, Line 67
Invalid length parameter passed to the LEFT or SUBSTRING function.
@TargetValue_GroupList is declared as varchar (max), it SET @TargetValue_GroupList = whichis a list of strings. when added together, it will not exceed 8000 length. To fix this, there has to be a workaround to cast the SET statement as a varchar (MAX).
to workaround, we have to remove the user from a few groups.
Just another question Andrew, we are located in Australia and currently we don't have vWorkspace support. We would like to upgrade and renew support, can someone in Australian contact us?
DELL-Andrew W1
378 Posts
3963
1
Posted July 22nd, 2016 02:00
Good Debug skills. I remember the 8000 Char limit. Well the good news is, we fixed that bug 4 years ago! It was Defect Id 191744
It was fixed from 7.6 onwards.
If you have a support contract, you can upgrade to any of the newer versions and the problem is resolved.