Users are unable to connect to an active session from another device. Users receive "access denied" error.

Users are unable to connect to an active session from another device. Users receive "access denied" error.

book

Article ID: CTX318047

calendar_today

Updated On:

Description

User is unable to reconnect to an active session with Workspace Control.

 Ther error is "Access Denied" and the session stays on "Welcome" logon screen.
AccessDenied.PNG

On VDA side, in event viewer, event ID 1050 is seen .Reason "Unlicensed".

License.PNG

Resolution

Untick the XACT_ABORT option in the SQL instance .
 
If the setting is set please check if other databases on the instance require this setting. If that is the case the only solution may be to create a separate instance for CVAD  and ensure this option is not set.

Problem Cause

There are SQL errors seen in the DDC trace .

31814,0,2021-05-18 02:49:37:63816,9948,1620,BrokerService.exe,0,BrokerDAL,,0,,1,Information,"[TID:e33ffdaa-b772-11eb-8126-ad3935bebebe]Transaction retry (#5 of 5): TX$AddTemporaryLicense ...",""
31815,0,2021-05-18 02:49:37:64056,9948,1620,BrokerService.exe,0,BrokerDAL,,0,,1,Information,"[TID:e33ffdaa-b772-11eb-8126-ad3935bebebe]Warning: Rollback transaction TX$AddTemporaryLicense: Error 3930: Impossibile eseguire il commit della transazione corrente. Tale transazione non è inoltre in grado di supportare le operazioni che implicano la scrittura nel file di log. Eseguire il rollback della transazione.",""
31816,0,2021-05-18 02:49:37:64067,9948,1620,BrokerService.exe,0,BrokerDAL,,0,,1,Error,"[TID:e33ffdaa-b772-11eb-8126-ad3935bebebe]ERROR: Transaction TX$AddTemporaryLicense failed: General database error: Impossibile eseguire il commit della transazione corrente. Tale transazione non è inoltre in grado di supportare le operazioni che implicano la scrittura nel file di log. Eseguire il rollback della transazione.",""

On the SQL server XACT_ABORT option is set on the SQL instance where the database resides.
Note - Screenshot here shows it unset .


cid:image005.jpg@01D75C93.A6154A40

When setting the XACT_ABORT option, all SQL transactions that throw an error are rolled back.
 
When assigning a temporary license to an active session (i.e. during a smooth roaming scenario) the attempt to assign the temp license is seen as an "error" and thus is rolled back and the error condition is attributed.