Skip Navigation LinksALVAO 11.1Known issues Skip Navigation Links.


WA - Data queries - eror "500 Internal server error, invalid syntax near xxx. Must declare the scalar variable @yyy"

This article is about product releases

ALVAO 11.1 and higher

Symptoms

- name of the query columns contains spaces

Cause

The cause is a bug in ALVAO products.

Solution

Fixed in release 11.2.1134 - 11.2 (2024-04-11)

Workaround

Edit the SQL query - edit the column names so that they do not contain spaces.

Steps to reproduce this behavior

Attachments

Issue number

T154878ALVAO

 

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