SD - Data analysis (Excel workbook) - Connection problem

This article is about product releases

ALVAO Service Desk 11.1 and higher

Symptoms

Error: 1004 Could not use view of function 'Query.RequestContinualResponseCsy' because of binding errors

Cause

The cause is a bug in ALVAO products. Domain login name is not imported from SCIM.

Solution

Workaround

Open the SQL Management Studio with your Alvao database and set the column SamAccountName in the table tPerson for the current user to the value that contains his domain login name, e.g.: 'domain-name\login-name'

Steps to reproduce this behavior

Login to Windows as a user that was imported to Alvao from SCIM. Open some workbook in Excel that is used to perform data analysis. Fill in the connection parameter fields (server and database name) and click the button to set the connection to SQL server.

Issue number

T152162ALVAO

Did not find what you were looking for? Ask our technical support team.