RML : SYNTAX ERROR: String is missing proper closing quote

Feb 16, 2010 at 11:00 AM
Edited Feb 16, 2010 at 11:01 AM

Hi, Has anyone an idea of the cause of this syntax error msg in the ReadTrace.log or any idea how to load the data to use SQL Nexus

SQL Nexus 3.0.0.0, RML Version 9.01.0109 built for x86, DB collation FRENCH_CI_AI

Could it be linked to the collation sequence or the langues (the production server is a german edition)

Thanks for your help

02/16/10 09:56:38.850 [0X0000145C] Readtrace a SQL Server trace processing utility.
Version 9.01.0109 built for x86.
Copyright (c) Microsoft Corporation 1997-2008. All rights reserved.
02/16/10 09:56:38.850 [0X0000145C] Number of processors: 4
02/16/10 09:56:38.850 [0X0000145C]     Active proc mask: 0x0000000F
02/16/10 09:56:38.850 [0X0000145C]         Architecture: 0
02/16/10 09:56:38.850 [0X0000145C]            Page size: 4096
02/16/10 09:56:38.851 [0X0000145C]         Highest node: 0
02/16/10 09:56:38.851 [0X0000145C]         Processor(s): 0x00000001 Function units: Separated
02/16/10 09:56:38.851 [0X0000145C]         Processor(s): 0x00000002 Function units: Separated
02/16/10 09:56:38.851 [0X0000145C]         Processor(s): 0x00000004 Function units: Separated
02/16/10 09:56:38.851 [0X0000145C]         Package mask: 0x0000000F
02/16/10 09:56:38.851 [0X0000145C]         Processor(s): 0x00000008 Function units: Separated
02/16/10 09:56:38.851 [0X0000145C]           Processors: 0x0000000F assigned to Numa node: 0
02/16/10 09:56:38.851 [0X0000145C] -Sdurvilla\abo_dev_05
02/16/10 09:56:38.851 [0X0000145C] -dsqlnexus
02/16/10 09:56:38.852 [0X0000145C] -E
02/16/10 09:56:38.852 [0X0000145C] -T18
02/16/10 09:56:38.852 [0X0000145C] -IH:\Suedost\Perfs\SQLDiagOutput16.02.10\SV0038__sp_trace.trc
02/16/10 09:56:38.852 [0X0000145C] -f
02/16/10 09:56:38.853 [0X0000145C] -oC:\Users\jostorero\AppData\Local\Temp\RML
02/16/10 09:56:38.853 [0X0000145C] -H!PSSDIAG
02/16/10 09:56:38.859 [0X0000145C] Using language id (LCID): 1024 [French_Switzerland.1252] for character formatting with NLS: 0x00040500 and Defined: 0x00040500
02/16/10 09:56:38.860 [0X0000145C] <FILTER>
 <COLUMN NAME="HOST">
  <AND>
   <ARGUMENT>
    <TYPE>NOT EQUAL<TYPE>
    <VALUE>PSSDIAG<VALUE>
   </ARGUMENT>
  </AND>
 </COLUMN>
</FILTER>
02/16/10 09:56:38.862 [0X0000145C] Attempting to cleanup existing RML files from previous execution
02/16/10 09:56:38.863 [0X0000145C] Using extended RowsetFastload synchronization
02/16/10 09:56:38.863 [0X0000145C] Establishing initial database connection:
02/16/10 09:56:38.864 [0X0000145C] Server: durvilla\abo_dev_05
02/16/10 09:56:38.864 [0X0000145C] Database: sqlnexus
02/16/10 09:56:38.865 [0X0000145C] Authentication: Windows
02/16/10 09:56:39.230 [0X0000145C] Using SQL Client version 10
02/16/10 09:56:39.231 [0X0000145C] Creating or clearing the performance database
02/16/10 09:56:41.345 [0X0000145C] Processing file: H:\Suedost\Perfs\SQLDiagOutput16.02.10\SV0038__sp_trace.trc (SQL 2005)
02/16/10 09:56:41.345 [0X0000145C] Validating core events exist
02/16/10 09:56:41.346 [0X0000145C] Validating necessary events exist for analysis
02/16/10 09:56:41.395 [0X0000145C] Events Read: 1000 Queued: 998 Processed/sec: 2
02/16/10 09:56:41.906 [0X0000145C] Events Read: 2000 Queued: 976 Processed/sec: 1024
02/16/10 09:56:41.946 [0X0000145C] Events Read: 3000 Queued: 1819 Processed/sec: 1181
02/16/10 09:56:42.065 [0X0000145C] Events Read: 4000 Queued: 2623 Processed/sec: 1377
02/16/10 09:56:42.361 [0X0000145C] Events Read: 5000 Queued: 3623 Processed/sec: 1377
02/16/10 09:56:42.467 [0X0000145C] Events Read: 6000 Queued: 4623 Processed/sec: 1377
02/16/10 09:56:42.543 [0X0000145C] Events Read: 7000 Queued: 5612 Processed/sec: 1388
02/16/10 09:56:42.621 [0X0000145C] Events Read: 8000 Queued: 6612 Processed/sec: 1388
02/16/10 09:56:42.712 [0X0000145C] Events Read: 9000 Queued: 7612 Processed/sec: 1388
02/16/10 09:56:45.200 [0X0000145C] Events Read: 25000 Queued: 7586 Processed/sec: 4353
02/16/10 09:56:48.240 [0X0000145C] Events Read: 50000 Queued: 9038 Processed/sec: 5851
02/16/10 09:56:51.005 [0X0000145C] Events Read: 75000 Queued: 8438 Processed/sec: 7395
02/16/10 09:56:53.347 [0X00000B0C] SPID: 67 Seq: 14771082 [Error: 110003][State: 0][Abs Char: 113][Seq: 0] SYNTAX ERROR: String is missing proper closing quote near (Char Pos: 0xC1 Byte Pos: 0x182)
0x00000071: 65006C00 65006300 74002000 6E006100 e.l.e.c.t. .n.a.
0x00000081: 6D006500 2C002000 64006200 69006400 m.e.,. .d.b.i.d.
0x00000091: 2C002000 73007400 61007400 75007300 ,. .s.t.a.t.u.s.
0x000000A1: 2C002000 76006500 72007300 69006F00 ,. .v.e.r.s.i.o.
0x000000B1: 6E002000 66007200 6F006D00 20006D00 n. .f.r.o.m. .m.
0x000000C1: 61007300 74006500 72002E00 64006200 a.s.t.e.r...d.b.
0x000000D1: 6F002E00 73007900 73006400 61007400 o...s.y.s.d.a.t.
0x000000E1: 61006200 61007300 65007300 20007700 a.b.a.s.e.s. .w.
0x000000F1: 68006500 72006500 20006E00 61006D00 h.e.r.e. .n.a.m.
0x00000101: 65002000 6C006900 6B006500 20004E00 e. .l.i.k.e. .N.
0x00000111:
This is frequently caused by an embedded NULL, incorrect escaping, smart quotes or incorrect syntax from the original trace event.
---------------------
exec(N'declare hCdbs cursor global for select name, dbid, status, version from master.dbo.sysdatabases where name like N''' + @qual2 + N'''')

     
---------------------
02/16/10 09:56:54.077 [0X00001150] SPID: 79 Seq: 14775950 [Error: 110003][State: 0][Abs Char: 113][Seq: 0] SYNTAX ERROR: String is missing proper closing quote near (Char Pos: 0xC1 Byte Pos: 0x182)
0x00000071: 65006C00 65006300 74002000 6E006100 e.l.e.c.t. .n.a.
0x00000081: 6D006500 2C002000 64006200 69006400 m.e.,. .d.b.i.d.
0x00000091: 2C002000 73007400 61007400 75007300 ,. .s.t.a.t.u.s.
0x000000A1: 2C002000 76006500 72007300 69006F00 ,. .v.e.r.s.i.o.
0x000000B1: 6E002000 66007200 6F006D00 20006D00 n. .f.r.o.m. .m.
0x000000C1: 61007300 74006500 72002E00 64006200 a.s.t.e.r...d.b.
0x000000D1: 6F002E00 73007900 73006400 61007400 o...s.y.s.d.a.t.
0x000000E1: 61006200 61007300 65007300 20007700 a.b.a.s.e.s. .w.
0x000000F1: 68006500 72006500 20006E00 61006D00 h.e.r.e. .n.a.m.
0x00000101: 65002000 6C006900 6B006500 20004E00 e. .l.i.k.e. .N.
0x00000111:
This is frequently caused by an embedded NULL, incorrect escaping, smart quotes or incorrect syntax from the original trace event.
---------------------
exec(N'declare hCdbs cursor global for select name, dbid, status, version from master.dbo.sysdatabases where name like N''' + @qual2 + N'''')

     
---------------------
02/16/10 09:56:54.238 [0X0000145C] Events Read: 100000 Queued: 9006 Processed/sec: 6999
02/16/10 09:56:57.134 [0X00000DAC] SPID: 59 Seq: 14788511 [Error: 110009][State: 10][Abs Char: 0][Seq: 0] WARNING: The input stream contains an embedded NULL (0x0) character near [SET FMTONLY ON  EXEC GetCirconscriptionId ' ',0,0,' ',0    SET FMTONLY OFF].  This commonly indicates input stream damage and causes unexpected results.
02/16/10 09:56:57.384 [0X0000145C] Events Read: 125000 Queued: 10312 Processed/sec: 7168
02/16/10 09:56:59.786 [0X00000980] SPID: 84 Seq: 14814560 [Error: 110009][State: 10][Abs Char: 0][Seq: 0] WARNING: The input stream contains an embedded NULL (0x0) character near [SET FMTONLY ON  EXEC GetCirconscriptionId ' ',0,0,' ',0    SET FMTONLY OFF].  This commonly indicates input stream damage and causes unexpected results.
02/16/10 09:57:00.829 [0X0000145C] Events Read: 150000 Queued: 11760 Processed/sec: 7275
02/16/10 09:57:04.070 [0X0000145C] Events Read: 175000 Queued: 10648 Processed/sec: 7470
02/16/10 09:57:04.687 [0X00000DAC] SPID: 59 Seq: 14845641 [Error: 110009][State: 10][Abs Char: 0][Seq: 0] WARNING: The input stream contains an embedded NULL (0x0) character near [SET FMTONLY ON  EXEC GetCirconscriptionId ' ',0,0,' ',0    SET FMTONLY OFF].  This commonly indicates input stream damage and causes unexpected results.
02/16/10 09:57:07.420 [0X00000980] SPID: 84 Seq: 14880360 [Error: 110009][State: 10][Abs Char: 0][Seq: 0] WARNING: The input stream contains an embedded NULL (0x0) character near [SET FMTONLY ON  EXEC GetCirconscriptionId ' ',0,0,' ',0    SET FMTONLY OFF].  This commonly indicates input stream damage and causes unexpected results.
02/16/10 09:57:07.525 [0X0000145C] Events Read: 200000 Queued: 11072 Processed/sec: 7266
02/16/10 09:57:10.684 [0X0000145C] Events Read: 225000 Queued: 10472 Processed/sec: 7397
02/16/10 09:57:13.473 [0X0000145C] Processing file: H:\Suedost\Perfs\SQLDiagOutput16.02.10\SV0038__sp_trace_1.trc (SQL 2005)
02/16/10 09:57:13.534 [0X0000145C] Found TRACE_STOP with 0 bytes of data
02/16/10 09:57:13.534 [0X0000145C] Found [TRACE_STOP] event indicating the end of the trace files.
02/16/10 09:57:13.536 [0X0000145C] Reads completed
02/16/10 09:57:13.539 [0X0000145C] Shutting down the worker thread message queues.
02/16/10 09:57:13.540 [0X0000145C] Waiting for the worker threads to complete final actions.
02/16/10 09:57:13.626 [0X00000DAC] SPID: 59 Seq: 14912845 [Error: 110009][State: 10][Abs Char: 0][Seq: 0] WARNING: The input stream contains an embedded NULL (0x0) character near [SET FMTONLY ON  EXEC GetCirconscriptionId ' ',0,0,' ',0    SET FMTONLY OFF].  This commonly indicates input stream damage and causes unexpected results.
02/16/10 09:57:14.738 [0X0000145C] Performing general cleanup actions.
02/16/10 09:57:14.738 [0X0000145C] Reducing cached memory.
02/16/10 09:57:14.777 [0X0000145C] Total Events Processed: 249347
02/16/10 09:57:14.778 [0X0000145C]  Total Events Filtered: 28668
02/16/10 09:57:14.778 [0X0000145C] Parse errors: 2
02/16/10 09:57:15.229 [0X0000145C] Table ReadTrace.tblUniqueBatches: loaded ~679 rows
02/16/10 09:57:15.275 [0X0000145C] Table ReadTrace.tblUniqueStatements: loaded ~974 rows
02/16/10 09:57:15.294 [0X0000145C] Table ReadTrace.tblUniquePlans: loaded ~1775 rows
02/16/10 09:57:15.315 [0X0000145C] Table ReadTrace.tblUniquePlanRows: loaded ~10807 rows
02/16/10 09:57:15.348 [0X0000145C] Table ReadTrace.tblBatches: loaded ~25225 rows
02/16/10 09:57:15.372 [0X0000145C] Table ReadTrace.tblStatements: loaded ~37332 rows
02/16/10 09:57:15.401 [0X0000145C] Table ReadTrace.tblPlans: loaded ~29030 rows
02/16/10 09:57:15.437 [0X0000145C] Table ReadTrace.tblPlanRows: loaded ~160719 rows
02/16/10 09:57:15.478 [0X0000145C] Table ReadTrace.tblInterestingEvents: loaded ~177 rows
02/16/10 09:57:15.498 [0X0000145C] Table ReadTrace.tblConnections: loaded ~1567 rows
02/16/10 09:57:15.517 [0X0000145C] WARNING: One or more warning conditions exist that may affect the quality of the analysis data.  See sqlnexus.ReadTrace.tblWarnings table and the ReadTrace log for complete details.
02/16/10 09:57:15.557 [0X0000145C] Indexing tables...
02/16/10 09:57:19.670 [0X0000145C] Doing post-load data cleanup...
02/16/10 09:57:34.841 [0X0000145C] Computing partial aggregates...
02/16/10 09:57:57.114 [0X0000145C] Data load completed.
02/16/10 09:57:57.132 [0X0000145C] *******************************************************************************
* ReadTrace encountered one or more WARNINGS. A warning condition typically   *
* continues processing with reduced functionality, but the ReadTrace output   *
* may be adversely affected. Review the log file for details.                 *
*******************************************************************************

Feb 17, 2010 at 3:47 PM

Fixed in ReadTrace version 9.02.0004. Ask http://blogs.msdn.com/psssql/contact.aspx if not available for download.

jostorero