How can we help you today? How can we help you today?
sgtwilko
Activity overview Badges (0) Posts (4) Comments (5)

Activity overview

Latest activity by sgtwilko

Any issues with latest SQL Change Automation (4.4.22039.29135) in Azure Devops?
  1. Community
  2. SQL Change Automation
Hi,We have a pipeline that's been running for a while using the Azure Devops SQL Change automation task to build and test the DB.This was working until the pipeline started using version 4.4.22039....
1 follower 1 comment 0 votes
Hi @Sergio R Again thanks for the response. Do you know if the Redgate SQL Change Automation Build task will update and start using the new builds of tSQLt? If so would it be possible to add the code coverage at the same time? Thanks / comments
  1. Community
  2. SQL Test
  3. Azure Devops pipeline - Generating SQL Test code coverage.
Hi @Sergio R Again thanks for the response.Do you know if the Redgate SQL Change Automation Build task will update and start using the new builds of tSQLt?If so would it be possible to add the code...
0 votes
Hi @Sergio R, Thanks for the response, do you know if the required SQLCover DLLs are included in the existing Redgate plugin? Do you know how the existing plugin creates a local DB connection (as the documentation suggest we need to spin up an additional database to test a package)? I don't really want to move away from using the redgate plugin, but if I'm having to hand-roll the solution I won't be using it to run the tests and submit the test report. Thanks / comments
  1. Community
  2. SQL Test
  3. Azure Devops pipeline - Generating SQL Test code coverage.
Hi @Sergio R,Thanks for the response, do you know if the required SQLCover DLLs are included in the existing Redgate plugin?Do you know how the existing plugin creates a local DB connection (as the...
0 votes
Hi @DanC, Thanks for the response, but I think I probably needed to expand on my question. I have the pipeline running SQL Tests via the RedgateSqlChangeAutomationBuild task: [image] [image] I need to get the code coverage. Does this task output the code coverage, if so, where is the file? I'm happy to convert it to the correct format after I have the file, but so far I can't see how to get the coverage from this task. From what I've read, it would seem that I have to abort using Redgate to get the coverage information. Thanks. / comments
  1. Community
  2. SQL Test
  3. Azure Devops pipeline - Generating SQL Test code coverage.
Hi @DanC,Thanks for the response, but I think I probably needed to expand on my question.I have the pipeline running SQL Tests via the RedgateSqlChangeAutomationBuild task:I need to get the code co...
0 votes
Azure Devops pipeline - Generating SQL Test code coverage.
  1. Community
  2. SQL Test
Hi,I've got a nuget package being created by the "Redgate SQL Change Automation Build" task.I'm then running the tSQLt tests against that package using the same task type.This is running the tests,...
3 followers 5 comments 0 votes
Encrypted databases.
  1. Community
  2. SQL Prompt 3 Beta
Sorry I've been meaning to post this for a few weeks, and I nolonger have the logs (been busy working:), and didn't expect the cut off) I had a lot of crashes using SQLPrompt, I believe that most c...
1 follower 1 comment 0 votes
also missed the most of the log; here's the important bit. SqlPromptEngine: Script info after setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 72 ScriptModel: End position (from script provider) = Line: 0; Column: 72 ScriptModel: Last line length (from lines collection) = 72 ScriptModel: Caret position: Line: 0; Column: 68 SqlPromptEngine: Setting script provider with initial caret position at Line: 0; Column: 41 SqlPromptEngine: Script info before setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 72 ScriptModel: End position (from script provider) = Line: 0; Column: 45 ScriptModel: Last line length (from lines collection) = 72 ScriptModel: Caret position: Line: 0; Column: 68 unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _43._1() unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _24._1(CaretPosition , CaretPosition , TextReader ) SqlPromptEngine: Script info after setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 45 ScriptModel: End position (from script provider) = Line: 0; Column: 45 ScriptModel: Last line length (from lines collection) = 45 ScriptModel: Caret position: Line: 0; Column: 41 SqlPromptEngine: Setting script provider with initial caret position at Line: 0; Column: 41 SqlPromptEngine: Script info before setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 45 ScriptModel: End position (from script provider) = Line: 0; Column: 45 ScriptModel: Last line length (from lines collection) = 45 ScriptModel: Caret position: Line: 0; Column: 41 unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _43._1() unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _24._1(CaretPosition , CaretPosition , TextReader ) SqlPromptEngine: Script info after setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 45 ScriptModel: End position (from script provider) = Line: 0; Column: 45 ScriptModel: Last line length (from lines collection) = 45 ScriptModel: Caret position: Line: 0; Column: 41 SqlPromptEngine: Setting script provider with initial caret position at Line: 0; Column: 41 SqlPromptEngine: Script info before setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 45 ScriptModel: End position (from script provider) = Line: 0; Column: 45 ScriptModel: Last line length (from lines collection) = 45 ScriptModel: Caret position: Line: 0; Column: 41 unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _43._1() unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _24._1(CaretPosition , CaretPosition , TextReader ) SqlPromptEngine: Script info after setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 45 ScriptModel: End position (from script provider) = Line: 0; Column: 45 ScriptModel: Last line length (from lines collection) = 45 ScriptModel: Caret position: Line: 0; Column: 41 SqlPromptEngine: Setting script provider with initial caret position at Line: 0; Column: 42 SqlPromptEngine: Script info before setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 45 ScriptModel: End position (from script provider) = Line: 0; Column: 46 ScriptModel: Last line length (from lines collection) = 45 ScriptModel: Caret position: Line: 0; Column: 41 unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _43._1() unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _24._1(CaretPosition , CaretPosition , TextReader ) SqlPromptEngine: Script info after setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 46 ScriptModel: End position (from script provider) = Line: 0; Column: 46 ScriptModel: Last line length (from lines collection) = 46 ScriptModel: Caret position: Line: 0; Column: 42 SqlPromptEngine: Setting script provider with initial caret position at Line: 0; Column: 42 SqlPromptEngine: Script info before setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 46 ScriptModel: End position (from script provider) = Line: 0; Column: 46 ScriptModel: Last line length (from lines collection) = 46 ScriptModel: Caret position: Line: 0; Column: 42 unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _43._1() unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _24._1(CaretPosition , CaretPosition , TextReader ) SqlPromptEngine: Script info after setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 46 ScriptModel: End position (from script provider) = Line: 0; Column: 46 ScriptModel: Last line length (from lines collection) = 46 ScriptModel: Caret position: Line: 0; Column: 42 SqlPromptEngine: Setting script provider with initial caret position at Line: 0; Column: 43 SqlPromptEngine: Script info before setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 46 ScriptModel: End position (from script provider) = Line: 0; Column: 47 ScriptModel: Last line length (from lines collection) = 46 ScriptModel: Caret position: Line: 0; Column: 42 unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _43._1() unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _24._1(CaretPosition , CaretPosition , TextReader ) SqlPromptEngine: Script info after setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 47 ScriptModel: End position (from script provider) = Line: 0; Column: 47 ScriptModel: Last line length (from lines collection) = 47 ScriptModel: Caret position: Line: 0; Column: 43 SqlPromptEngine: Setting script provider with initial caret position at Line: 0; Column: 43 SqlPromptEngine: Script info before setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 47 ScriptModel: End position (from script provider) = Line: 0; Column: 47 ScriptModel: Last line length (from lines collection) = 47 ScriptModel: Caret position: Line: 0; Column: 43 unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _43._1() unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _24._1(CaretPosition , CaretPosition , TextReader ) SqlPromptEngine: Script info after setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 47 ScriptModel: End position (from script provider) = Line: 0; Column: 47 ScriptModel: Last line length (from lines collection) = 47 ScriptModel: Caret position: Line: 0; Column: 43 SqlPromptEngine: Setting script provider with initial caret position at Line: 0; Column: 44 SqlPromptEngine: Script info before setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 47 ScriptModel: End position (from script provider) = Line: 0; Column: 48 ScriptModel: Last line length (from lines collection) = 47 ScriptModel: Caret position: Line: 0; Column: 43 unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _43._1() unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _24._1(CaretPosition , CaretPosition , TextReader ) SqlPromptEngine: Script info after setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 48 ScriptModel: End position (from script provider) = Line: 0; Column: 48 ScriptModel: Last line length (from lines collection) = 48 ScriptModel: Caret position: Line: 0; Column: 44 SqlPromptEngine: Setting script provider with initial caret position at Line: 0; Column: 44 SqlPromptEngine: Script info before setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 48 ScriptModel: End position (from script provider) = Line: 0; Column: 48 ScriptModel: Last line length (from lines collection) = 48 ScriptModel: Caret position: Line: 0; Column: 44 unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _43._1() unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _24._1(CaretPosition , CaretPosition , TextReader ) SqlPromptEngine: Script info after setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 48 ScriptModel: End position (from script provider) = Line: 0; Column: 48 ScriptModel: Last line length (from lines collection) = 48 ScriptModel: Caret position: Line: 0; Column: 44 SqlPromptEngine: Setting script provider with initial caret position at Line: 0; Column: 45 SqlPromptEngine: Script info before setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 48 ScriptModel: End position (from script provider) = Line: 0; Column: 49 ScriptModel: Last line length (from lines collection) = 48 ScriptModel: Caret position: Line: 0; Column: 44 unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _43._1() unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _24._1(CaretPosition , CaretPosition , TextReader ) SqlPromptEngine: Script info after setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 49 ScriptModel: End position (from script provider) = Line: 0; Column: 49 ScriptModel: Last line length (from lines collection) = 49 ScriptModel: Caret position: Line: 0; Column: 45 SqlPromptEngine: Setting script provider with initial caret position at Line: 0; Column: 45 SqlPromptEngine: Script info before setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 ScriptModel: Script length = 49 ScriptModel: End position (from script provider) = Line: 0; Column: 49 ScriptModel: Last line length (from lines collection) = 49 ScriptModel: Caret position: Line: 0; Column: 45 unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _43._1() unexpected char: 0xFFFF antlr.TokenStreamRecognitionException at RedGate.SQLCompare.ASTParser.StructureLexer.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at RedGate.SQLCompare.ASTParser.StructureParser._1(Exception ) at RedGate.SQLCompare.ASTParser.StructureParser.statement() at RedGate.SQLCompare.ASTParser.StructureParser.statementBatch() at RedGate.SQLCompare.ASTParser.StructureParser.expr() at _24._1(CaretPosition , CaretPosition , TextReader ) SqlPromptEngine: Script info after setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines collection) = 1 ScriptModel: Line count (from script provider) = 1 I have the entire file still if you need it. / comments
  1. Community
  2. SQL Prompt 3 Beta
  3. Prompt Failes to start, kills Query analyzer.
also missed the most of the log; here's the important bit. SqlPromptEngine: Script info after setting script provider ScriptModel: Current script information ScriptModel: Line count (from lines...
0 votes
it missed the error log off the bottom of the post: See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown. at System.String.GetStringForStringBuilder(String value, Int32 startIndex, Int32 length, Int32 capacity) at System.Text.StringBuilder.GetNewString(String currentString, Int32 requiredLength) at System.Text.StringBuilder.Append(Char value) at antlr.CharScanner.append(Char c) at antlr.CharScanner.consume() at antlr.CharScanner.matchNot(Int32 c) at antlr.CharScanner.matchNot(Char c) at _41._41(Boolean ) at _41.nextToken() at antlr.TokenBuffer.fill(Int32 amount) at antlr.TokenBuffer.LA(Int32 i) at antlr.LLkParser.LA(Int32 i) at _42._270() at _42._36() at _42._4() at _42._2() at RedGate.SQLCompare.Engine.Database.GetDependencies(String sql, Boolean quotedIdentifiers, Boolean throwExceptions) at _16._1(SqlConnection , Boolean ) at _16._1() at RedGate.SQLCompare.Engine.Database.RegisterForSqlPrompt(ConnectionProperties connectionProperties, Options options, Boolean includeSystemObjects) at _18.Refresh(IAuthenticationTokenProvider provider) at _18._1(IAuthenticationTokenProvider ) at _18.GetMetaData(IAuthenticationTokenProvider provider) at RedGate.SqlPrompt.Engine.Cache.MetaDataCache._1(_18 , _4 , IAuthenticationTokenProvider , Boolean ) at RedGate.SqlPrompt.Engine.Cache.MetaDataCache.GetDatabase(ConnectionProperties conn, IAuthenticationTokenProvider provider, Boolean bleatIfBlacklisted) at RedGate.SqlPrompt.Engine.Cache.MetaDataCache.GetDatabase(ConnectionProperties conn, IAuthenticationTokenProvider provider) at RedGate.SQLPrompt.CommonUI.TaskExecuter.LoadDatabaseTask.DoTask() at RedGate.SQLPrompt.CommonUI.TaskExecuter.TaskExecuter.ExecuteTask() ************** Loaded Assemblies ************** mscorlib Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll ---------------------------------------- RedGate.SQLPrompt.QueryAnalyzerUI Assembly Version: 3.0.0.300 Win32 Version: 3.0.0.300 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203%20Beta/RedGate.SQLPrompt.QueryAnalyzerUI.exe ---------------------------------------- System.Windows.Forms Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll ---------------------------------------- System Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll ---------------------------------------- RedGate.SqlPrompt.Engine Assembly Version: 3.0.0.300 Win32 Version: 3.0.0.300 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203%20Beta/RedGate.SqlPrompt.Engine.DLL ---------------------------------------- RedGate.SQLPrompt.CommonUI Assembly Version: 3.0.0.300 Win32 Version: 3.0.0.300 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203%20Beta/RedGate.SQLPrompt.CommonUI.DLL ---------------------------------------- RedGate.SQL.Shared Assembly Version: 5.3.0.1 Win32 Version: 5.3.0.1 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203%20Beta/RedGate.SQL.Shared.DLL ---------------------------------------- RedGate.SqlPrompt.Engine.Gatekeeper Assembly Version: 3.0.0.300 Win32 Version: 3.0.0.300 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203%20Beta/RedGate.SqlPrompt.Engine.Gatekeeper.DLL ---------------------------------------- System.Drawing Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll ---------------------------------------- Accessibility Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll ---------------------------------------- RedGate.Shared.Utils Assembly Version: 5.3.0.1 Win32 Version: 5.3.0.1 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203%20Beta/RedGate.Shared.Utils.DLL ---------------------------------------- System.Configuration Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll ---------------------------------------- System.Xml Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll ---------------------------------------- RedGate.SQLCompare.ASTParser Assembly Version: 3.0.0.300 Win32 Version: 1.0.0.0 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203%20Beta/RedGate.SQLCompare.ASTParser.DLL ---------------------------------------- System.Data Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll ---------------------------------------- RedGate.SQLCompare.Engine Assembly Version: 5.3.0.13 Win32 Version: 5.3.0.13 CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Prompt%203%20Beta/RedGate.SQLCompare.Engine.DLL ---------------------------------------- System.Transactions Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/Windows/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll ---------------------------------------- System.EnterpriseServices Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/Windows/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll ---------------------------------------- ************** JIT Debugging ************** To enable just-in-time (JIT) debugging, the .config file for this application or computer (machine.config) must have the jitDebugging value set in the system.windows.forms section. The application must also be compiled with debugging enabled. For example: <configuration> <system.windows.forms jitDebugging="true" /> </configuration> When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the computer rather than be handled by this dialog box. / comments
  1. Community
  2. SQL Prompt 3 Beta
  3. Prompt Failes to start, kills Query analyzer.
it missed the error log off the bottom of the post:See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Te...
0 votes
Prompt Failes to start, kills Query analyzer.
  1. Community
  2. SQL Prompt 3 Beta
When using a remote database I've had Prompt fail, which causes both prompt and Query Analyzer to die. This happened on opening of Quer Analyzer, so no script was yet entered. Pentium 4 2.53GHz 248...
2 followers 3 comments 0 votes
Total activity
11
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2