SQL Prompt 5 crashes VS 2008

gfrizzlegfrizzle Posts: 3
edited August 31, 2012 12:57PM in SQL Prompt Previous Versions
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...
· Share on Twitter

Comments

  • David_SDavid_S Posts: 2
    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
    · Share on Twitter
  • howarthcdhowarthcd Posts: 70 Bronze 3
    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
    · Share on Twitter
  • David_SDavid_S Posts: 2
    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
    · Share on Twitter
  • Paul StephensonPaul Stephenson Posts: 125
    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
    · Share on Twitter
  • SiO2ySiO2y Posts: 4
    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.
    · Share on Twitter
  • SiO2ySiO2y Posts: 4
    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.
    · Share on Twitter
  • WeeeBobWeeeBob Posts: 16
    :(

    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!!
    · Share on Twitter
  • Bill_RossBill_Ross Posts: 20
    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 ..()
    · Share on Twitter
  • Bill_RossBill_Ross Posts: 20
    I haven't installed your Integration tool... could that be the problem?
    · Share on Twitter
  • Paul StephensonPaul Stephenson Posts: 125
    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
    · Share on Twitter
  • rcampbellwhitercampbellwhite Posts: 1
    issue number SP-4009

    Hi Paul,

    Do you have an ETA on this fix?
    · Share on Twitter
  • Paul StephensonPaul Stephenson Posts: 125
    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
    · Share on Twitter
  • cousinspcousinsp Posts: 29
    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
    · Share on Twitter
  • cwalliscwallis Posts: 6
    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
    · Share on Twitter
  • jlorangerjloranger Posts: 1
    I recently updated to version 5.2.4.1, now getting the VS 2008 crash, as reported by others. I have tried disabling SQL Prompt but still getting a crash when trying to preview a report. Is there any resolution, before I unistall? Been using SQL Prompt for years now, but this is a real problem for me.
    · Share on Twitter
  • cousinspcousinsp Posts: 29
    We managed to get it sorted on one Windows XP machine by installing all Windows Updates (I think the problem was fixed by a .net update). Have another machine with the same problem, which I'll look at today to see if this corrects it.
    Pete Cousins
    · Share on Twitter
  • cousinspcousinsp Posts: 29
    Disabling in BIDS work around still working for us.
    Pete Cousins
    · Share on Twitter
  • pagamecompagamecom Posts: 2 Bronze 1
    I have the same problem from within a VS 2008 report project where the reports are published to SSRS 2008 R2.

    Currently running SQL Prompt 5.3.2.2

    Disabled SQL Prompt add-in within VS 2008


    From "About Microsoft Visual Studio"

    Microsoft Visual Studio 2008
    Version 9.0.30729.4462 QFE

    Microsoft .NET Framework
    Version 3.5 SP1

    Installed Edition: Professional

    Microsoft Visual Basic 2008
    Microsoft Visual C# 2008
    Microsoft Visual C++ 2008
    Microsoft Visual Studio 2008 Tools for Office
    Microsoft Visual Studio Tools for Applications 2.0
    Microsoft Visual Web Developer 2008
    Crystal Reports Basic for Visual Studio 2008

    Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB944899) KB944899
    Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB945282) KB945282
    Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946040) KB946040
    Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946308) KB946308
    Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946344) KB946344
    Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946581) KB946581
    Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947171) KB947171
    Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947173) KB947173
    Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947180) KB947180
    Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947540) KB947540
    Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947789) KB947789
    Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB948127) KB948127
    Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB953256) KB953256
    Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB971091) KB971091
    Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB971092) KB971092
    This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
    Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB973674) KB973674
    Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB974479) KB974479
    Microsoft Visual Studio 2008 Professional Edition - ENU Service Pack 1 (KB945140) KB945140
    Microsoft Visual Studio 2008 Professional Edition - ENU Service Pack 1 (KB947888) KB947888
    This service pack is for Microsoft Visual Studio 2008 Professional Edition - ENU.
    Microsoft Visual Studio 2008 Professional Edition - ENU Service Pack 1 (KB948484) KB948484
    Microsoft Visual Studio 2008 Professional Edition - ENU Service Pack 1 (KB948560) KB948560
    Security Update for Microsoft Visual Studio 2008 Professional Edition - ENU (KB973675) KB973675
    Security Update for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB972222) KB972222

    SQL Server Analysis Services
    Microsoft SQL Server Analysis Services Designer
    Version 10.50.1600.1

    SQL Server Integration Services
    Microsoft SQL Server Integration Services Designer
    Version 10.50.1600.1

    SQL Server Reporting Services
    Microsoft SQL Server Reporting Services Designers
    Version 10.50.1600.1

    Update for Microsoft Visual Studio 2008 Professional Edition - ENU (KB956453) KB956453
    Update for Microsoft Visual Studio 2008 Professional Edition - ENU (KB967143) KB967143
    Update for Microsoft Visual Studio 2008 Professional Edition - ENU (KB972221) KB972221
    Terry
    · Share on Twitter
  • sayntinsayntin Posts: 1
    Im having the exact same problem as the person that posted this.

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

    I have uninstalled it,and now I am not having problems anymore. Guess I wont be using SQL prompt.
    · Share on Twitter
  • pagamecompagamecom Posts: 2 Bronze 1
    I've found that the work around posted by David_S on Mon Jan 03, 2011 1:31 pm works within VS 2008. Doing this allows SQL Prompt to still be used within SSMS.

    Although you may have to do it again when Redgate issues an update to SQL Prompt that installs a new version that resets its use in VS. I wasted a good part of this morning until I figured that out!

    I've further noticed that if a report doesn't have any user selectable parameters VS doesn't crash/vanish. Very odd.
    Terry
    · Share on Twitter
Sign In or Register to comment.