Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Aug 24, 2020 7:22:07 AM
May 5, 2017 10:40:33 AM
Trying to synchronize users by creating a new User Directory Connector of type Excel (via ODBC) fails. The user after creating the directory connector sees message in yellow in the Edit section of the User Directory connector.
The connection is created but it does not work.
Error printed on screen is:
The User Directory Connector (UDC) is not configured, because the following error occurred: Exception when trying to connect to the data source. Edit the connection string in the user directory connector configuration.
The User Direcotyr Connector (UDC) is not operational.
The Qlik Sense User Management Repository logs read:
Repository.UserDirectoryConnectors.ODBC.OdbcExcel ERROR [42000] [Microsoft][ODBC Excel Driver] Undefined function 'LOWER' in expression
The error may be triggered after an upgrade.
Recreating the User Directory connection causes the same error.
The (Excel via ODBC) connector is deprecated and there are plans to remove it. However we do not know when that will be removed from the available User Directory Connectors. The other issue is that the Microsoft Excel Drivers are not updated too often so some incompatibilities might occur. Please always advise to use the ODBC User Directory Connector when loading users and attributes from Excel.
Resolution:
In order to solve this issue please check the following:
***Make sure that the check box of "Sync user data for existing users" is NOT checked***
If this box is checked you will get the ERROR [42000] [Microsoft][ODBC Excel Driver] Undefined function 'LOWER' in expression.