This post is more than 5 years old
3 Posts
0
36288
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.
I have checked the link, https://support.software.dell.com/vworkspace/kb/103824, however we don't have additional farm.
I've rebooted the connection brokers and checked the event logs without finding the problem.
DELL-Andrew W1
378 Posts
1
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.
DELL-Andrew W1
378 Posts
0
July 21st, 2016 03:00
Hello,
Please enable Connection Broker logging on each broker and attempt to login again with the same user.
1. In the vWorkspace Management Console, Please drill down through Locations | Location1 | Connection Brokers.
2. Right Click on your Connection Broker and select Properties.
3. Click On Logging
4. Check the option "Enable trace logging to file"
5. Type in the filepath and file name. Eg: C:\temp\cb.log
6. Now, reproduce the error and copy the log here. Let us know the username of the user
7. Once the logs have been collected, turn off broker logging.
Thanks, Andrew.
eugenechen
3 Posts
0
July 21st, 2016 20:00
HI,
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.
The statement has been terminated.
the code is
INSERT INTO #Groups VALUES (SUBSTRING(@TargetValue_GroupList, @N+1, CHARINDEX('|', @TargetValue_GroupList, @N+1) - @N-1))
even though
@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.
eugenechen
3 Posts
0
July 27th, 2016 18:00
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?