Article - CS292394
SQL Query service is giving an incomplete result in ThingWorx running on Microsoft SQL Server
Modified: 19-Jul-2023
Applies To
- ThingWorx Platform 7.1 to 8.5 SP5
- Microsoft SQL server
Description
- SQL Query service is giving an incomplete result running on Microsoft SQL Server
- Same stored procedure called from SQL Server Management Studio returns correct number of rows
- SQL Query or stored procedure called from service defined in JDBC entity giving fewer rows than in SQL Server Management Studio
- ThingWorx service returns fewer rows for same set of data compared to running stored procedure in the database
This is a printer-friendly version of Article 292394 and may be out of date. For the latest version click CS292394