Error: Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.

Version 4

    Verified Product Versions

    LANDESK Management Suite 9.6

    This document is written with the intention of helping you understand and troubleshoot complex queries filtered by Location in SmartVue Web.


    Problem:


    In the creation of a LDMS query that includes an "and" or an "or" operator and attempting to add it to the LOCATION field in SmartVue Configuration could result in the following SQL error:

    Error: Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.


    This error message will be contained in the following log file and location on your LDMS core server:


    %ldms_home%\log\LDGatherData.exe.log


    Root Cause:

    When creating a LDMS query that includes identifying attributes not specific to LOCATION, such as but not limited to the following, could prevent the SQL statement from executing:


    • device type
    • date
    • time


    The SmartVue widgets natively account for the device type and will not factor in a the date or time in the display.


    *Note - This is only applicable to SmartVue, the LDMS query could still successfully execute in the management console. The SmartVue tool is not designed to handle complex queries. The tool is intended to utilize simple queries to identify items by LOCATION.



    Resolution:


    Simplify The LDMS query and only include identifiers specific to LOCATION. Ex: The user wants to see all devices on the 1st floor or building A. The LDMS query can be created off an identifier that points to that location such as ip address.