Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

Home > Success Center > Web Help Desk (WHD) > Error: EvaluateExpression failed: Next Exception:SQL State:22021 -- Error code: 0

Error: EvaluateExpression failed: Next Exception:SQL State:22021 -- Error code: 0

Created by Robert Magpantay, last modified by MindTouch on Jun 23, 2016

Views: 12 Votes: 1 Revisions: 3

Updated June 13, 2016

Overview

This article shows how to fix the error EvaluateExpression failed: Next Exception:SQL State:22021 -- Error code: 0 when logging in to Web Help Desk.

 

Environment

All OS Platform and WHD wersion using AD/LDAP Synchronization

 

Cause 

Issue is caused by recent changes in AD/LDAP OU's that breaks the current synchronization settings in WHD.

 

Resolution

  1. Use a WHD Tech Account with Admin privileges.
  2. Go to Web Help Desk Database and execute the following SQL statement:

UPDATE TECH

SET PASSWORD='yourTemporaryPasswordHereInsideQuote',

USE_LDAP_AUTHENTICATION=0,

INCORRECT_AUTH_ATTEMPTS=0,

INACTIVE=0

WHERE USER_NAME='yourAdminUsernameHereInsideQuote';

    3. Log in to Web Help Desk using the temporary password that you have selected.

    4. Make the necessary adjustments into the Users DN under the following location: Setup > AD /LDAP Connection > [yourConnectionName] > Advanced > Users DN.

    5. Save the settings and verify if other users can now login to WHD.

    6. Enable back LDAP Authentication into the account that has been used under the following location: Setup > Techs > Techs > [theAdminAccountUsed] > Edit > Enable \LDAP Authentication.

 

 

Last modified
04:39, 23 Jun 2016

Tags

Classifications

Public