This project is read-only.

Error while importing data in SQL Nexus

Aug 19, 2008 at 2:10 AM
Hi Friends,

I am getting a strange problem. While importing data I am getting error on importing trace files.
Error which I got is

Processing File :E:\ALPCI\ALPCI_PROD_SP_TRACE.trc (sql 2005)
Validating core events exist
Validating necessary events exist for analysis
ERROR: Simulated SPID 60000 exceeds max allowed.
***ERROR: Error encopuntered - HRESULT: 0x80004005 State: 0
Reads completed - Global Error Status 0xffffffff
Flushing final mesage to workers
Cleaning up worker thread resources
Total Events Processed:1
Total Events Filtered: 0

Sep 3, 2008 at 8:03 PM
spid 60,000 seems to be really high.
are you using latest version of SQL nexus?
"About" will tell you which version. latest is 2.5.0.5
The reason I ask about this is that older version of SQL Nexus turn on a trace flag to handle MARS by default. that will pad one zero to every spid.  for example, spid 100 will become 1000.
reply to this message if you are using version 2.5.0.5 and continue to have this issue