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

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

tasks suspended all of a sudden

Posted By:      Posted Date: September 14, 2010    Points: 0   Category :Sql Server
Hi.  After about a 9 months of running without issues, I'm seeing 3 early sql engine tasks in our etl suspended hours after the entire package should have completed.  Since I started watching there have been no change in the 3 i-o's but they are at 75797,1178 (the select) and 223275 already.  Earlier today, I had to cancel an engine db backup (to disk) on the same server after it seemed to be running hours longer than expected.  There are two databases on the entire server.  One is an engine db, the other olap.  The engine is about 97 gig.  I see hundreds of gigs available on the c: drive.  I see no blocking reported by sp_who2.  Two of the tasks are bulk inserts.  One is a select.  I believe that even if one or two tables from a separate source server are involved, that they arent preventing my tasks from running because I had no problem running adhoc and count(*) queries on them separately under ssms.  But I dont have security to run  sp_who2 or the dmvs there (the remote server) to be sure. Is it possible that cancelling my backup today left sql in a funny state?  I see SP1 STD 2008 when I run server properties.  Is it possible sql feels that some available disk space threshhold has been hit and it has become somewhat frozen as a result?  I dont thin

View Complete Post

More Related Resource Links

Dialogs and ViewModel - Using Tasks as a Pattern

The ViewModel/MVVM pattern continues to gain popularity, with a blog post showing up every so often, and with tweets and retweets popping up even more often :-). At the same time, there are some interesting topics beyond the core pattern that continue to fuel experimentation. A big one amongst those is how should applications use dialogs when using the view model pattern.

The crux of the problem is the desire to keep the view model independent of UI concerns, and ensure it can be tested in a standalone manner, but that often comes to odds when you want the view model to launch a dialog, and/or do some work after the dialog is closed.

Cutting Edge: Canceling Server Tasks with ASP.NET AJAX


This month Dino explains how to remotely cancel tasks running on the server using ASP.NET AJAX.

Dino Esposito

MSDN Magazine August 2007

Toolbox: Issue and Defect Tracking, Automate IT Tasks, and More


In this issue, issue and defect tracking, automating IT tasks, and more.

Scott Mitchell

MSDN Magazine December 2006

Inside MSBuild: Compile Apps Your Way With Custom Tasks For The Microsoft Build Engine


Learn how you can use MSBuild to customize your builds. Since it ships as a part of the .NET Framework, you don't even need to have Visual Studio installed on your machine.

Sayed Ibrahim Hashimi

MSDN Magazine June 2006

Toolbox: Automated Build Process, Real-World E-Mail Tasks, and More


While the Visual Studio® Build menu's Build Solution option is the usual way developers compile their current work on a project, the process of building the complete solution for testing, deployment, or production often requires many more steps.

Scott Mitchell

MSDN Magazine March 2006

Visual Basic: Simplify Common Tasks by Customizing the My Namespace


Underlying the My namespace's APIs is a fully extensible architecture you can leverage to customize the behavior of My and to add new services to its hierarchy to adapt to specific application needs. the My namespace is optimized to provide simple solutions to common problems. But if your requirements are different, you can use the My namespace's customization model to modify the behavior of individual My namespace members to meet specific application requirements.

Joe Binder

MSDN Magazine July 2005

Generative Programming: Modern Techniques to Automate Repetitive Programming Tasks


Even when developers have recurring computer-readable metadata to process and a clear idea of how code should be structured, they can still find themselves in need of a technique to automatically generate the code to avoid the drudge work of repeatedly writing and tweaking it. Generative programming is a technique that addresses this problem. Using generative programming techniques, you can solve software engineering problems in families, rather than individually, saving time and coding effort. This article describes these techniques, and builds a sample template-driven code generator. The article also lists existing utilities that have been built with generative programming techniques, as well as actual code generators.

Chris Sells

MSDN Magazine December 2001

Errors when interacting with WorkFlow generated tasks through ISA Server


I have a MOSs environment that I have published through ISA Server 2006 and i am getting really strange behavior whentrying to interact with WorkLFow generated tasks when I have connected through ISA. This also seems to affect InfoPath Forms Services. I was wondering if anyone out there is seeing any problems when using ISA Server to interact wih Forms or WorkFlows?


The error I get simply states:

the form cannot be submitted to the web server either because your computer is offline or because the host server is currently unavailable.


Any help would be appreciated.





Creating background tasks.



Actually i'm creating an application in asp.net using c#.

I upload a powerpoint file and convert it to wmv format.Since the process of conversion is huge process(depends on the size of the file.Usually around 5 to 10 minutes.)i want to do in the background.So i upload a file and copy it to the server.(i using mysql as the database).In the server i just want to do the conversion.Once the conversion is finished.it should update the table.The user can use the file some time later or the next time.How could i do this ? Could somebody help me ? 

How do I add two XML tasks to a Data FLow task?

I am new to SSIS and am developing a package which takes input from an XML file and then populates an existing SQL table with these records.  However, this is a very large XML file.  I keep getting an Out of Memory exception.  (This file is 210 MB)!  So what I tried doing was separating this XML file into 8 smaller files.  Now, I can successfully load data from these smaller files one at a time.  But how can I do all of them in the same package?  I connected two XML tasks to the Data Flow task and get the error below.  I also increased my timeout and number of errors to no avail.  Advice? Error: 0xC002F304 at XML Task 1, XML Task: An error occurred with the following error message: "Exception of type 'System.OutOfMemoryException' was thrown.". Task failed: XML Task 1 Warning: 0x80019002 at zSkywardEnrollment: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. Error: 0xC002F304 at XML Task, XML Task: An error occurred with the following error message: "Exception of type 'System.OutOfMemoryException' was thrown.". Task failed: XML Task SSIS package "

VS.NET 2010 Not opening all associated projects with solution all of the sudden

I have a VS.NET 2010 solution (.sln) containing (3) separate projects (.vbproj).  All of the sudden today when I open the solution (manually navigate to the .sln file of the solution; not a quick link), only 1 of the projects is opening.  Before I totally mess this thing up, anyone know of the proper process to get all of the projects and the solution itself to open up and display in the 'Solution Explorer' window?

Query for Workflow tasks?

HI All, I need a CAML query which will retrieve all the workflow tasks from all the site collections in a web application, which are assigned to the current logged in user and whose status is NOT STARTED.  I.e., ASSIGNED TO = CurrentLoggedInUser STATUS=”Not Started” Workflow Name is not null Can any one of you help me regarding this Issue. Regards, Kumar.

Async Tasks: Simplify Asynchronous Programming with Tasks

Asynchronous programming lets you run expensive operations concurrently without blocking the UI thread. We'll show you three simple techniques for implementing asynchronous operations in your code.Igor OstrovskyMSDN Magazine September 2010

What is best way to aggregate tasks in Intranet?

A lot of Intranet users are challenged to keep track of tasks across multiple team sites. Anyone find a technique that works? It seems like it would make sense to live in a user's My Site on SP2010.  Anyone doing it that way?      

Sharepoint Calender and Tasks

Hi friends, Thanks for your previous responses, now i ahve a problem with sharepoint 2010 calender and tasks. My site designed on formbase authentication.Is there any option  to configure calender and tasks to Outlook 2003. I added Calender As well Tasks webparts to my page and i gave Exchange server url and mailbox in the webpart properties  First time it was connected, when i connected second time it was giving error is Access denied. And is there any other way to configure to outlook. Could you please any one help me ,to find the solution. Solution must be appriciated........ Thanks Prasad

Workflow tasks viewable by most, but not all task owners.

I have a simple SharePoint Designer workflow that starts when a new list item is created.  The task owner is defined by a 'user/group' field selected from a sharepoint list.  Of 150+ users, only 4 are not able to see the tasks when assigned.  I have the task list set so they only see their own.  These 4 users do not see any tasks, where as everyone else does see only their own tasks.  To test, I changed the list settings to show all.  The users saw all tasks, but are not able to edit the tasks assigned to them. I feel the problem lies with how the workflow is assigning ownership of the task.  When I use the sharepoint task list to manually create a task for these 4 users, they can see and edit them, but when the workflow creates the task - they can't. Is there something special about how workflows assign task ownership based off Active Directory versus manually assigning tasks coming from the cached SharePoint profile?  (As a test I deleted the user from the All People list of the site, and manually added them back - no luck).Greg Appelt

displaying microsoft project tasks in dashboards?

I understand that you can have task lists created in SharePoint and have them display on a dashboard with something like % complete, etc.  However, we have a client that has many different projects they manage that each have their own Microsoft Project file.  They want to know when the milestones on the project are due and what the % complete is based off of the contents of the project file.  Is there a way to pull this info from the project files and have it display in a dashboard or some other format?  We don't want to have to manually enter the tasks in SharePoint - it should be automated. Thanks, Robert
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