SQL Prompt 5 crashes VS 2008

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

SQL Prompt 5 crashes VS 2008

Postby gfrizzle » Mon Dec 20, 2010 8:13 pm

After installing SQL Prompt 5, I was unable to open .aspx or .ascx files in Visual Studio 2008 - the whole app would just disappear. I tried unchecking "Use SQL Prompt", but that didn't help. I had to uninstall it to get VS working again. Back to v4.0...
gfrizzle
 
Posts: 2
Joined: Tue Jun 26, 2007 3:40 pm

VS 2008 building Reporting services reports

Postby David_S » Tue Dec 21, 2010 9:58 am

Hi!

I'm having the same kind of problems, after installing "SQL Prompt 5", whenever I try to preview a report that I'm building in BIDS 2008 (the "SQL Server 2008 R2" edition), the Visual Studio environment completly vanished and everything is gone.

::David
Stockholm, Sweden
David_S
 
Posts: 2
Joined: Tue Dec 21, 2010 9:54 am

Re: VS 2008 building Reporting services reports

Postby howarthcd » Thu Dec 30, 2010 9:57 am

David_S wrote:Hi!

I'm having the same kind of problems, after installing "SQL Prompt 5", whenever I try to preview a report that I'm building in BIDS 2008 (the "SQL Server 2008 R2" edition), the Visual Studio environment completly vanished and everything is gone.

::David
Stockholm, Sweden



Just to add that I'm experiencing the same problem as David following an upgrade to SQL Prompt 5. I have to uninstall SQL Prompt 5 in order to be able to preview reports.

Following such a crash the Windows Application event log contains the following event:

Event Type: Error
Event Source: .NET Runtime
Event Category: None
Event ID: 1023
Date: 30/12/2010
Time: 08:46:51
User: N/A
Computer: DEVDT54
Description:
.NET Runtime version 2.0.50727.3615 - Fatal Execution Engine Error (7A0360B0) (80131506)

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


I'm looking forward to a resolution of this issue so that we can confidently upgrade the version of SQL Prompt that our dev team is currently using.

Chris
howarthcd
 
Posts: 50
Joined: Wed May 16, 2007 10:30 am

work-around

Postby David_S » Mon Jan 03, 2011 9:31 am

Hi!

I found a work-around for this in another thread here in this forum.

What you need to do is go into Tools > Add-Ons in BIDS, and unchecked "SQL Prompt 5", and then restart BIDS. Then it works again.

http://www.red-gate.com/MessageBoard/vi ... hp?t=12430

What you do is disable the plugin, so after that, it will not work within BIDS (though - I don't see any reason for using it within BIDS anyways, but I just wanted to point it out). Also - even if you uncheck it in BIDS, it still works in SSMS (SQL Management Studio).

::David_S
David_S
 
Posts: 2
Joined: Tue Dec 21, 2010 9:54 am

Postby Paul Stephenson » Tue Jan 04, 2011 9:01 am

Thanks for the BIDS workaround, and for confirming that SQL Prompt 5 still works in SSMS afterwards!

Regards,
Paul
Paul Stephenson
Project Manager, Red Gate
Paul Stephenson
 
Posts: 109
Joined: Fri Jul 23, 2010 9:22 am
Location: Cambridge, UK

Still happens in 5.1 (and it's worse!)

Postby SiO2y » Fri May 13, 2011 2:42 pm

I've recently upgraded SQL prompt to version 5.1 (build 5.1.4.11).
Beforehand I'd disabled SQL Prompt in BIDS and everything worked fine.
Since the upgrade, every time I load BIDS the checkbox is ticked (even if I unticked it then restarted BIDS properly) and previews still crash BIDS regardless.
SiO2y
 
Posts: 4
Joined: Wed Mar 09, 2011 11:28 am
Location: London, UK

Re: Still happens in 5.1 (and it's worse!)

Postby SiO2y » Tue May 17, 2011 9:56 am

Worked out the problem. I didn't have admin rights so when I tried to update Visual Studio to remove the add-in, the settings weren't saved.
Ran VS as admin and made the changes, now it all works fine.
SiO2y
 
Posts: 4
Joined: Wed Mar 09, 2011 11:28 am
Location: London, UK

Version 5.1.6.35 Still has problem

Postby WeeeBob » Tue Jun 21, 2011 1:35 pm

:(

Just installed SQL prompt 5.1.6.35 , and it caused same problems with VS2008 crashing out when trying to preview SQL2008R2 report.

Disabled as described above and at least I can get on with my work now!!
WeeeBob
 
Posts: 12
Joined: Thu Jun 14, 2007 4:16 pm

Sql Prompt crashes VS2010 when I add a snippet in SSMS!

Postby Bill_Ross » Thu Jul 07, 2011 8:21 pm

To reproduce... I have VS2010 open while creating a snippet. This the from the Event Viewer:

- System

- Provider

[ Name] SSMS Integration Pack 1

- EventID 16

[ Qualifiers] 0

Level 3

Task 0

Keywords 0x80000000000000

- TimeCreated

[ SystemTime] 2011-07-07T19:04:34.000000000Z

EventRecordID 43

Channel Red Gate Software

Computer junk.junk.net

Security


- EventData

ngWrapper.LogManager #18:Unhandled Exception: Common Language Runtime detected an invalid program.. IsTerminating : False System.InvalidProgramException: Common Language Runtime detected an invalid program. at RedGate.SqlPrompt.Engine.Snippets.SnippetManager.<m_Sentinel_Changed>b__4(Object ) at System.Threading._ThreadPoolWaitCallback.WaitCallback_Context(Object state) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading._ThreadPoolWaitCallback.PerformWaitCallbackInternal(_ThreadPoolWaitCallback tpWaitCallBack) at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback(Object state)


This event is not displayed correctly because the underlying XML is not well formed. Below is the raw text of the event.

32200x8000000000000044Red Gate Softwarejunk.junk.net. #1:Failed to initialize IPC System.Runtime.Remoting.RemotingException: Failed to create an IPC Port: Access is denied. at System.Runtime.Remoting.Channels.Ipc.IpcServerChannel.StartListening(Object data) at System.Runtime.Remoting.Channels.Ipc.IpcServerChannel..ctor(IDictionary properties, IServerChannelSinkProvider sinkProvider, CommonSecurityDescriptor securityDescriptor) at ..()


This event is not displayed correctly because the underlying XML is not well formed. Below is the raw text of the event.

32200x8000000000000045Red Gate Softwarejunk.junk.net. #1:Failed to acquire mutex - IPNService quitting System.Runtime.Remoting.RemotingException: Failed to create an IPC Port: Access is denied. at System.Runtime.Remoting.Channels.Ipc.IpcServerChannel.StartListening(Object data) at System.Runtime.Remoting.Channels.Ipc.IpcServerChannel..ctor(IDictionary properties, IServerChannelSinkProvider sinkProvider, CommonSecurityDescriptor securityDescriptor) at ..() at ...ctor(Timer timer,  requestHandler, EventHandler exitHandler) at ...ctor() at ..() at RedGate.IPNShared.CommonUtils.DoWithMutex(MutexType mutexType, TimeSpan delay, Action action) at RedGate.IPNShared.CommonUtils.DoWithMutex(MutexType mutexType, Action action) at ..()
Bill_Ross
 
Posts: 14
Joined: Mon Mar 22, 2010 6:49 pm

Additional info

Postby Bill_Ross » Thu Jul 07, 2011 8:25 pm

I haven't installed your Integration tool... could that be the problem?
Bill_Ross
 
Posts: 14
Joined: Mon Mar 22, 2010 6:49 pm

Postby Paul Stephenson » Wed Jul 13, 2011 9:01 am

Hi Bill,

Thanks for the report about Visual Studio crashing when adding a snippet. I can confirm that this is an issue with SQL Prompt 5.1.6 when running inside Visual Studio (it doesn't happen on SSMS). This has been assigned issue number SP-4009 and we'll address it in the next bug-fix release.

Apologies for the inconvenience.

Regards,
Paul
Paul Stephenson
Project Manager, Red Gate
Paul Stephenson
 
Posts: 109
Joined: Fri Jul 23, 2010 9:22 am
Location: Cambridge, UK

Postby rcampbellwhite » Thu Aug 18, 2011 11:20 am

issue number SP-4009


Hi Paul,

Do you have an ETA on this fix?
rcampbellwhite
 
Posts: 1
Joined: Thu Aug 18, 2011 11:17 am
Location: London, UK

Postby Paul Stephenson » Thu Aug 18, 2011 11:31 am

Hi rcampbellwhite,

Yes, I'm pleased to say that SP-4009 was fixed in SQL Prompt 5.1.8 and is now available. Please see my announcement.

Regards,
Paul
Paul Stephenson
Project Manager, Red Gate
Paul Stephenson
 
Posts: 109
Joined: Fri Jul 23, 2010 9:22 am
Location: Cambridge, UK

BIDS still crashing

Postby cousinsp » Thu Sep 29, 2011 2:31 pm

I have SQL Prompt 5.1.8.2 installed, but still having the same problem in BIDS 2008. When adding an expression to define the colour of a text field, previewing the report causes BIDS to crash. I've disabled SQL Prompt in BIDS, and everything is fine.
Pete Cousins
cousinsp
 
Posts: 22
Joined: Thu May 21, 2009 1:15 pm
Location: Bournemouth, UK

BIDS 2008 R2 crashing

Postby cwallis » Mon Nov 14, 2011 4:18 pm

Just updated to the latest version SQL Prompt 5.2.0.5 and still getting crashes in BIDS 2008 R2 when you click Previrew to view a report. Again disabling SQL Prompt in BIDS is a work around
cwallis
 
Posts: 4
Joined: Fri Jul 31, 2009 1:02 pm
Location: London

Next

Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 1 guest