SQL Activity SQL Queries are not displayed, just the error: /* SPID:0 does not exist. */ in Spotlight versions 9.5.2 and 10.1 (4238168)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

SQL Activity SQL Queries are not displayed, just the error: /* SPID:0 does not exist. */ in Spotlight versions 9.5.2 and 10.1
Description

When checking SPIDs, in v9.5.2 and v10.1, it's not possible to see any queries. Instead, the following message is shown:

/* SPID:0 does not exist. */
Cause

This problem occurs if the system’s regional setting is assigning “,” (comma) as the decimal point.
Resolution

WORKAROUND:
Set the regional settings to English style.
“.” for the decimal point, “,” for digit grouping.
e.g.
10.000.000,123 => 10,000,000.12
STATUS:
Issue fixed in the current release of Spotlight on SQL Server Enterprise. Latest version of Spotlight can be downloaded from here.
To upgrade to the latest version without loss of existing connections and configurations, upgrade to Spotlight version 10.0 first. Contact support team to obtain installers of previous versions of Spotlight.
Defect ID

SOSE-2373
Additional Information

The fix for this is scheduled for V10.5. The release date for V10.5 is tentatively set for the end of may 2014.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title