.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SSIS Debug Host has stopped working

Posted By:      Posted Date: September 16, 2010    Points: 0   Category :Sql Server
The error code that's output with the SSIS Debug Host has stopped working popup is: Problem signature:   Problem Event Name:    APPCRASH   Application Name:    DtsDebugHost.exe   Application Version:    2007.100.1600.22   Application Timestamp:    48753d31   Fault Module Name:    StackHash_23cc   Fault Module Version:    6.1.7600.16559   Fault Module Timestamp:    4ba9b21e   Exception Code:    c0000374   Exception Offset:    000c2913   OS Version:    6.1.7600.   Locale ID:    1033   Additional Information 1:    23cc   Additional Information 2:    23cc9330c2de3c407e38eb60a3c201e4   Additional Information 3:    10bd   Additional Information 4:    10bdb3132e81c1ecfd041615b784b3fd In the output for the BIDS debugger: SSIS package "Package.dtsx" starting. Information: 0x4004300A at Sg Clients to NewCP stgClients, SSIS.Pipeline: Validation phase is beginning. Warning: 0x80049304 at Sg Clients to NewCP stgClients, SSIS.Pipeline: Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available.  To

View Complete Post

More Related Resource Links

Executing a job from a stored procedure stopped working

I've got a stored procedure in database A that calls the sp_start_job stored procedure in msdb as follows:   CREATE PROCEDURE xxxxx WITH EXECUTE AS 'domain\username'   AS   EXEC msdb.dbo.sp_start_job B'jobname' ;   RETURN   The domain\username is the in the database sysadmin role and the owner of the job.  To make this work originally, I had to change the msdb database to be trusted.   This worked for the past several months.   Now it doesn't work (perhaps after a reboot but not sure).  The error I get is "The EXECUTE permission was denied on the object 'sp_start_job', database 'msdb', schema 'dbo'   I looked to make sure that the account had grant execute rights and it does.  I tried setting it via GRANT statement and it was granted successfully yet the error still occurs.  I've tried changing accounts and anything else I can think of to no avail.   Any ideas how to troubleshoot this issue.  I've tried all the tricks I can think of.   Thanks - SM

SSIS Package working on SQL Client Machine but when trying to run on SQL Server machine giving error

Hi We are trying to run SSIS package on sql server machine but sometimes it is giving error for data flow task containing Script Component. Error is - [SSIS.Pipeline] Error: component "SCR DimensionRelation" (1) failed the post-execute phase and returned error code 0x80004002. This error is not coming continuously. And also not for specific DFT. It comes for different DFTs as we rerun the package. Can anybody help me on this? We are using SQL server 2008. We are not getting any error on client machine :(:(

Breakpoints stopped working during debugging in vs.net 2005

I had the strangest bug yesterday while trying to debug in vs.net 2005.... I had an '05 web application.  I clicked the "Run" button to start debugging, and the webpage popped up fine.  I could run through the pages fine.  Everything seemed fine....UNTIL!   Until I tried to start inserting breakpoints into my code.  The application ignored them.  In addition, I noticed my little green visual studio "Start Debugging" arrow (which is normally greyed out while in debug mode) was green.  It was as if visual studio completely detached itself from my website I was trying to debug. After playing around with it for a while, I realized I also had a vs.net 2008 solution open as well.  My '08 solution wasn't in debug mode or anything, it was just sitting there open.  I just happened to close it, not thinking anything of it, and presto!  My 2005 debugger started working again! So basically, I can't debug an '05 solution (or at least a web solution, as that's all I tried) while I also have an '08 solution open.  Anyone know why?  Is there anything I can do to prevent this?   Thanks.  

Suite Integration Toolkit executable has stopped working On Windows 2008 R2

I am not sure what else I can say about this except I seem to run into this error each time I attempt to install any .NET Related tool above 1.1. I have tried clean out all .NET installs to reinstall but I run up against this and at this point, I have a machine that is clean of .NET 2.0 through 4.0. I am unable to reinstall because I keep running up against this problem. I am not certain where to go from here Problem signature:   Problem Event Name: APPCRASH   Application Name: setup.exe_Microsoft® Visual Studio® 2008   Application Version: 9.0.30729.1   Application Timestamp: 488f1f5c   Fault Module Name: urlmon.dll   Fault Module Version: 8.0.7600.16385   Fault Module Timestamp: 4a5bdf64   Exception Code: 80000003   Exception Offset: 0008b5df   OS Version: 6.1.7600.   Locale ID: 1033   Additional Information 1: 3da0   Additional Information 2: 3da0da3513034f247aa571ff6433c6a8   Additional Information 3: efee   Additional Information 4: efee7faa0523fea9d1582687f878296e Read our privacy statement online:   http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409 If the online privacy statement is not available, please read our privacy statement offline:   C:\Windows\system32\en-US\erofflps.txtN

webserver40.exe has stopped working

I've just upgraded a visual studio.net 2003 project (asp.net 1.1) to visual studio.net 2010 (asp.net 4.0). I'm encountering a problem with viewing Crystal reports. I'm using Visual Studio Development Server as a Web Server. When I try to create a new report (via code that worked fine previously) the line below causes the webserver40.exe to crash. Protected WithEvents MyRep As New CrystalDecisions.CrystalReports.Engine.ReportDocument I've got Crystal Reports 11 installed. Thanks in advance for your help with this matter. Lee    

Katmai SSMS - Intellisense stopped working

HiI was wondering if anyone has had a similar problem. I have been happily using the Intellisense features of Katmai without any problems for a month now. However, a couple of days ago, it stopped working. I have tried numerous things to revive it including deleting everything under: -%appdata%\Microsoft\Microsoft SQL Server%userprofile%\Local Settings\Application Data\Microsoft\Microsoft SQL ServerHKCU\Software\Microsoft\Microsoft SQL Serverand restarting SMSS but I had no success. Tbh, I am not even sure where Intellisense cache is kept?Anyone have any suggestions?Thanks in advance.Blair

webmatrix and nopcommerce debug not working

Hi All, I installed Web Matrix and then installed the NopCommerce site from the web gallery. I set a break point in the default.aspx page_load but when I try to debug it skips the break point because it says "~no symbols loaded..." When I pressed play button initially it asked if I wanted to enable debugging and I answered yes. Am I missing something else?   Thanks,   rod.

vs 2010 stopped working when i close website

Hi, i have installed latest vs 2010 ultimate on windows 7 it works fine but as i want to close a website  it sayas vs has stopped working restart/debug what should i do?

Windows Forms application Stopped Working message in Windows Vista



A Windows Forms application developed with VB2008 Express that has been successfully run on two Windows XP systems and a Windows 7 system fails to run on two of two Windows Vista systems tried so far.


Attempting to run the app on a Windows Vista system results in a system dialog box titled, Microsoft Windows, with the message, A problem caused the program to stop working correctly.  Windows will close the program and notify you if a solution is available.  A single button at the lower right of the dialog contains the text, Close Program.
The initial form of the application never displayed and the dialog above appeared with little delay after attempting to start the program.

The program uses an SQL Server Compact Edition 3.5 database and the program is compiled to include the following .DLL files so the user does not need to install SQL ServerCE.

The Load event of the initial form causes a DataSet to be filled from the SQL CE DB.

I have the System Informa

VS2010 has stopped working error adding new item to folders in MVC2



   I am using VS2010 Pro in 64 bit Windows 7. When I add a new item to a folder in an ASP.NET MVC2 project, VS frequently crashes with a "Visual Studio has stopped working" error and then closes down. If I re-open the project the item is not visible in the MVC project folder, (but it is visible to windows explorer although I think it's corrupted). If I then try to add the item again, it warns me that it already exists and asks to overwrite, choosing yes to overwrite usually works OK.  When adding an .edmx item it is more problematic, I can't overwrite it but because I know that there actually is a file in the folder, (although not visible and albeit corrupted), I can add it as an existing item and then choose "update model from database" to get it to work. This error is happening more and more frequently.

Problem with Debugging - Cannot communicate with the debug host process


I'm trying to run (with debug) an SSIS  project and getting the following error


"Failed to start project


Cannot communicate with the debug host process. The IDtsHost interface is not registered. (Microsoft.DataTransformationServices.VsIntegration)"


It does run if I run without debug.


Any ideas?

Calling Oracle procedure from SSIS 'Execute SQl task' is not working


Hi ,


Iam using 'Execute SQl task' which calls a stored procedure located in sql server database.The task's SQL source type is variable and the variable has the follwoing expression "EXEC PROC_SEL_MBO_REPORT "+@[User::V_SP_Job_Date]after evaluation it is like EXEC PROC_SEL_MBO_REPORT '01/NOV/2007'.It is working fine

Now the procedure is changed to Oracle.So I have changed it to "BEGIN  PROC_SEL_MBO_REPORT " + "("+ @[User::V_SP_Job_Date]+")"+"; END"+";" after evaluation it is like BEGIN  PROC_SEL_MBO_REPORT ('01/NOV/2007') END;.It is sucessfully executing from the task but no data is loaded into the tables which are used by the procedure internally.
Executing  'execute BEGIN  PROC_SEL_MBO_REPORT ('01/NOV/2007') END;' is perfectly alright from SQl developer or sql plus.

Please help me.. thanks in advance




Usage Reports / Graphical User Statistics stopped working


Hi all,

our usage reports (e.g. at /_layouts/SpUsageSite.aspx ) stopped working after we migrated the database from one server to another. The "raw statistics" (_layouts/usagedetails.aspx), however, are still showing some numbers.

All services are still running, all relevant settings in Central Admin (SSP, Operations) are still active. Does anyone knoe what could be the cause for this?


My user controls stopped working in Design mode! Why?


I have a few user controls that I have been using for months but now whenever I open a page in Blend that uses one of the controls I get an invalid xaml error. The project still compiles and runs and behaves just like it's supposed to but I can't edit xaml in Design view because of this error.


In the page I have

<local:ACAVariableWidth x:Name="CIDCloseButton" HorizontalAlignment="Right" Margin="0,0,17.54,15" VerticalAlignment="Bottom" Width="174" Height="89" MouseLeftButtonDown="callerID_close" Text="Close"/>

The error is: The member "Text" is not recognized or is not accessible

In the user control xaml I have:

		<StackPanel x:Name="TopSP" Orientation="Horizontal" VerticalAlignment="Top" HorizontalAlignment="Center" Height="76" d:IsLocked="True">
			<TextBlock x:Name="ACATB" Margin="8,8,8.5,9.5" FontFamily="APHont" FontSize="32" Padding="5,0" Foreground="White" TextAlignment="Center" VerticalAlignment="Center" Text="{Binding ElementName=UserControl, Path=Text}" d:IsLocked="True">
					<DropShadowEffect Direction=&

Visual Studio WebBrowser control's PrintPreviewDialog generates "VSHost32.exe has stopped working"


I'm getting a problem with a VS 2008 application when I use the WebBrowser control's .ShowPrintPreviewDialog method and either print or close the dialog box.  I'm working on a 64-bit Windows 7 computer and using Visual Studio's default Debug option settings.  The problem happens both when running from the IDE in debug mode and after compiling in x86 mode as a stand-alone.

The control is central to as an otherwise effective report management system, so on btnPrint_Click I assign HTML code to .DocumentText and then call .ShowPrintPreviewDialog, which works fine, other than it does need 2 clicks so it seems both stages have to happen as separate events? 

Although when I go to print, the document prints okay, the print preview dialog form closes itself and whole program crashes with the above message.  I've also tried separating those stages to avoid the 2-click issue, but I still get the crash.

If I turn Project>Properties>Debug>"Enable unmanaged code debugging" ON, I get this message instead "Unhandled exception at 0x752c77df (urlmon.dll) in PMPos.exe: 0xC0000005: Access violation reading location 0x00000001."

The control's other print dialog methods work fine.   Is there a solution that I can rely on when distributing the application or am I best abondoning this particular

Dynamic compilation of aspx-files stopped working!



I recently ran into some strange problems. Changes to files that are not code-behind (and not gets compiled to a DLL) should not require you to recompile the whole website, and this has never been I problem for me. These should actually get compiled dynamically when you first access the resource, e.g. the first time when browsing an updated aspx-page in the browser. 

But yesterday, during development of a website, I noticed that even the smallest changes in html, javascript or anything in the .aspx-files doesn't get reflected when I save and reload the page in my browser. Rebuilding doesn't help either, actually I'll have to do a "Rebuild All" (in Visual Studio 2008) in order to see the changes. This applies to all aspx-files in my project.

I tried with minor changes on files in another web application project on the same server, and there it works as it should. Something must has happened to this particular application, but I cannot figure out what.
Do you have any ideas on how to solve this?

Best regards

XAML intellisense stopped working for project

We are working on a WPF-based application and have recently lost XAML intellisense on the project. Here's what we've discovered:

  1. XAML intellisense only fails to work in XAML files where we reference a CLR namespace inside the current assembly (using xmlns:s="clr-namespace=Namespace.Name"). 
  2. If we clean the solution, XAML intellisense works for all XAML files no matter what namespace is referenced - even for custom controls
  3. If we then rebuild the solution, intellisense stops working again 
  4. If after building we add an assembly reference pointing to the current assembly to the namespace references (using xmlns:s="clr-namespace=Namespace.Name;assembly=CurrentAssemblyName"), intellisense works again, but building fails (I'm assuming because we're trying to reference an assembly that hasn't been built yet)

Has anyone experienced anything like this before?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend