Spotlight for Sybase SQL Text is not available on SQL Detail tab (4327534)

SQL Text is not available when  we click on SQL Detail tab.  

For example, we ran a sample query against a Sybase database  via isql.

Then, on Spotlight for Sybase, we select  Users | SQL Details tab.

It always display "SQL Text not available" in the SQL Text field.

The Execution Plan is displayed in the Show Plan field correctly.

The SQL Plan is  generated by Sybase itself. The execution time of the SQL is not long enough for Sybase ASE to capture. Spotlight for Sybase relys on Sybase ASE to capture the currently running SQL.

To test the SQL Detail tab, try login isql and execute a long running SQL (Note: execute a SQL with execution time of at least  30 seconds)

Spotlight for Sybase retrieves the SQL text from the master..monProcessSQLText table. You may follow the below steps to verify.

1. Login to two isql with different ASE login
2. Execute a long running transaction in one of them
3. Execute the below SQL in another isq
Select SQLText from master..monProcessSQLText where SPID=<SPID in  step 2>