.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

Two rows passed to error handler instead of one....

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
Scenario: Flat File conneciton manager for import, and another for error exporting OLEDB destination for successful data. Transforms connecting the flat file source to the OLEDB destination on success, and to a script component, and eventually a flat file destination in the event of an error. Goal: Very basic - take rows from a flight file, pipe delimited (CR/LF for rows) source, and map it into a table, exporting records that would error out into an error file. Symptom: Given a 3 row file (just for test), where the first record is missing a column, we wind up with 2 records (the record that we know has the error, plus the following record) in the error file, and only the 3rd record in the success file. One one record is reported as going to each file (so, the error transform shows a single record, even though two wind up in that file). The couple of lines of code that move things over are as follows... _erroredRow = System.Text.Encoding.ASCII.GetString(Row.FlatFileSourceErrorOutputColumn.GetBlobData(0, (int)Row.FlatFileSourceErrorOutputColumn.Length)); Output0Buffer.AddRow(); Output0Buffer.Record = _erroredRow; What I suspect is happening here is that the delimiter at the end of the first (error) record is being missed, and thus what appears as two rows (and they do each have the appropriate CR/LF) is being treated as one. Any hints as to why this is happening a

View Complete Post

More Related Resource Links

Specific Error Handler for Area Controllers



I have an area named CMS on my MVC3 Preview 1 application.

Is it possible to have an error view inside the CMS area to display only errors that occurred on the controllers under the CMS area?

Basically I want the errors inside the area to be handled by a different controller than the errors on the "application root".



C# .NET SqlBulkCopy and redirecting error rows

I am using SqlBulkCopy within a Script Task to extract data from an Oracle server into SQL Server. Is there a way to redirect error rows with code or otherwise from the SqlBulkCopy? I have implemented this before using a regular Copy Column task and redirecting the Destination Error into a different table of all data type varchar. So I am trying to make something similar with the script task and SqlBulkCopy. Any suggestions? ThanksYou are so wise...like a miniature budha covered in fur. -Anchorman

WCF REST and Custom Error Handler

I have a RESTful WCF service, and I am trying to roll a custom behavior that extends the WebHttpBehavior, to provide my service a custom error handler (by implementing IErrorHandler of course). When I debug my service, the only breakpoint I hit is the getter on the BehaviorExtensionElement's BehaviorType property. None of the other methods are ever invoked; BehaviorExtensionElement.CreateBehavior(), WebHttpBehavior.AddServerErrorHandlers(), as well as nothing in my implementation of IErrorHandler. This leads me to believe that something isn't being registered with WCF. My service is defined in the app.config. When I step-through a call to one of my service's operations, I would expect that the process of throwing an exception would force my service to transfer the work to my error handler. But this is not the case... My service stops and throws me an unhandled exception, and nothing is sent to the client as a result. Am I doing something wrong? Am I not understanding this process? If someone could help me out it would be greatly appreciated!My code basically has implementations of IErrorHandler, and classes that derive WebHttpBehavior with an override on AddServerErrorHandlers(), and also BehaviorExtensionElement with an override for the property BehaviorType and method CreateBehavior(). Nothing fancy, but I have a feeling I may be missing something...This is my app.config:&

IIS 7 error Handler "svc-ISAPI-4.0_32bit" has a bad module "IsapiModule" in its module list

Hi experts, I'm trying to  host my WCF(3.5) on IIS7  and I get the below error.  HTTP Error 500.21 - Internal Server Error Handler "svc-ISAPI-4.0_32bit" has a bad module "IsapiModule" in its module list   I tried reinstalling >net 4(Some forum mentioned to do that) and also aspnet_regiis.exe -i in VS 2010 command prompt. Thanks in advance, KP Nothing helped.

Event Handler not picking up error

I have a connection manager which uses a Variable as part of a ConnectionString. I have tried putting an Event handler on the package to capture any errors with the connection string. Unfortunately the event handler does not pick up any errors. I would like to add some screenshot but i am not sure how to do it on this forum.  Mr Shaw

Error executing child request for handler 'System.Web.Mvc.HttpHandlerUtil' in asp.net mvc

I am getting following error in production but the same is not a repro in in local.> Error executing child request for> handler> 'System.Web.Mvc.HttpHandlerUtil+ServerExecuteHttpHandlerWrapper'.> Inner Exception: Exception of type> 'System.Web.HttpUnhandledException'> was thrown.Stack Trace:    at System.Web.HttpServerUtility.ExecuteInternal(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage, VirtualPath path, VirtualPath filePath, String physPath, Exception error, String queryStringOverride)    at System.Web.HttpServerUtility.Execute(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage)     at System.Web.HttpServerUtilityWrapper.Execute(IHttpHandler handler, TextWriter writer, Boolean preserveForm)    at System.Web.Mvc.ViewPage.RenderView(ViewContext viewContext)         at System.Web.Mvc.ViewResultBase.ExecuteResult(ControllerContext context)         at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass14.<InvokeActionResultWithFilters>b__11()    at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilter(IResultFilter filter, ResultExecutingContext preContext, Func`1 continuation)     &

Event Handler returning unexpected Error Code



I am trying to set up an Event Handler to log errors to a table.

So in my Control Flow pane I set an Execute SQL Task with a deliberate error as follows; -

Name; - Execute SQL Task with Deliberate Error

SQLStatement; - SELECT * FROM InvalidTable


Within the Event Handler tab I created a further Execute SQL Statement based on the Event handler OnError

Name : Log

Parameter Mapping
Variable Name System:ErrorCode
Direction Input
Parameter Name 0
Parameter Size 100

SQLStatement INSERT INTO dbo.CustomSSISLog  (ErrorCode) VALUES (?)

Error Output; -

SSIS package "ErrorLogTemplate.dtsx" starting.

Error: 0xC002F210 at Execute SQL Task with Deliberate Error, Execute SQL Task: Executing the query "SELECT * FROM InvalidTable" failed with the following error: "Invalid object name 'InvalidTable'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Task failed: Execute SQL Task with Deliberate Error

Warning: 0x80019002 at ErrorLogTemplate: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of er

Read only error trying to copy and paste rows of records from Excel spreadsheet


I'm using Sharepoint 2010 and trying to open a list in Edit in Datasheet View. The list opens but when I try to paste lines into the sheet I get a Read-only error and it doesn't accept my paste. I removed all required fields.

I'm using XP and IE8

This function was working in SharePOint 2007.


ItemUpdating event handler causes SPRequest object was not disposed error if properties.ListItem is


I have a very simple ItemUpdating event handler that is causing an SPRequest object was not disposed error when it is fired. The event handler is linked to the document library. I have cleaned out all of my code and narrowed it down to this:

    public override void ItemUpdating(SPItemEventProperties properties)
      SPListItem item = properties.ListItem;

When I change the name of a file or folder in my document list the following line is logged in the SP log:

An SPRequest object was not disposed before the end of this thread.  To avoid wasting system resources, dispose of this object or its parent (such as an SPSite or SPWeb) as soon as you are done using it.  This object will now be disposed.  Allocation Id: {D7AA6805-4CA1-458B-9252-E83D32DBD0D3}  To determine where this object was allocated, set Microsoft.SharePoint.Administration.SPWebService.ContentService.CollectSPRequestAllocationCallStacks = true.


As an extra note I have actually set the CollectSPRequestAllocationCallStacks to true, this is all the information that it gives me. If I comment out the pr

IIS 7.5 - HTTP Error 404.17 - Not Found - Static File Handler.


 I'm having an issue with web.config file in my development environment. I had the WCF site running on my local. My local has VS2010 framework 4.0 installed. I published the code and hosted the site in IIS 7.5 2008 R2 on my dev server which has an application pool of framework 2.0. I had an issue which says

HTTP Error 404.17 - Not Found

The requested content appears to be script and will not be served by the static file handler.


These are the few handlers that i've in my web.config file on my dev server. There are other handlers too which are inherited.


      <add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
      <add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />

SQL Server user-defined aggregate returns an error if aggregating 0 rows

I have this SQL Server user-defined aggregate:

[SqlUserDefinedAggregate(Format.UserDefined, Name="median", IsInvariantToDuplicates=false, IsInvariantToNulls=true, IsInvariantToOrder=true, IsNullIfEmpty=true, MaxByteSize=8000)] 
public class MedianCalculator : IBinarySerialize { 
    private List<double> values; 
    public void Init() { 
        values = new List<double>(); 
    public void Accumulate(SqlDouble value) { 
        if (!value.IsNull) 
    public void Merge(MedianCalculator other) { 
    public SqlDouble Terminate() { 
        if (values == null || values.Count == 0) 
            return SqlDouble.Null; 
        return (values[(int)Math.Floor((values.Count - 1) / 2.0)] + values[(int)Math.Ceiling((values.Count - 1) / 2.0)]) / 2.0; 
    public void Read(BinaryReader r) { 
        int c = r.ReadInt32(); 
        values = new List<double>(c); 
        for (int i = 0; i < c; i++) 
    public void Write(BinaryWriter w) { 
        for (int i = 0; i < values.Count; i++) 
After deploying this aggregate, I try to run this query:

SSIS - Derived Column Error Rows will not redirect to table


I am new to SSIS and I have created a package that generally successfully takes a Flat File Source, runs it through a Derived Column transformation and then pushes the data into a SQL Server Database.

I have a Derived Column Error Output set up, but it is not working.  If the data has an error the entire package fails, not just the specific row.  I have tested the package to load successfully and then manually gone into the flat file and changed the data to purposely create an error in one row. Having cleared the load table I rerun the package and it fails entirely rather than redirecting the one bad row.

In the Derived Column Transformation Editor I set the Error and Truncation values to Redirect Row for all the columns.

In SQL Destination Editor for the bad rows I am only mapping the ErrorCode abnd ErrorColumn values to the destination table fields of the same name.  Could this be the problem? Should I map all the fields?  I would like to map all the source (derived) fields into a single text field in the destination table if possible.

The Advanced settings have only the Table Lock and Check constraints boxes checked.  Timeout is 30.

I am not really sure how to set the Advanced Editor properties.  I have left them at the default values.  Any suggestions here?



we write the referd extention to the handler in the address bar , an Error 404 appears.


we have made a httphandler and then compiled it and have added its refrence to my project in VS.NET

When we start VS.NET the referd extention  to then above handler works currectly but at the time that we run the same project in IIS 6 (without running VS.NET)

and we write the referd extention to the handler in the address bar , an Error 404 appears.

Exp. http://mywebsite/default.tttttttt

if .tttttttt is the referd extention.

Event Handler (send mail task) firing multiple times for each dataflow error - How can I stop the da


I've set up an OnError event handler for my package which sends an email containing the name of the file that fails import through my dataflow task. The problem is the dataflow experiences three errors (one for each task it is attempting to complete) which in turn causes three duplicate emails to be sent.

I'd prefer to stop the dataflow task completely rather than allow it to try to complete the remaining tasks after the first error. Is this possible? Alternately, how can I set up my event handler to only send one email regardless of the number of dataflow errors that occur?

Thanks in advance!

Shared Data Set error when no rows returned



I've created a parameterised Shared Data Set and everything is fine when it returns data. However, when I set the parameters so that no data is returned I get the error message:

An error has occurred during report processing. (rsProcessingAborted)
The execution failed for the shared data set '<Data Set Name>'. (rsDataSetExecutionError)
Object reference not set to an instance of an object.

I've looked through the various knowledgebases etc and the only recommendation I've found is to add a NON EMPTY clause to the MDX query so data is always returned. This isn't ideal as I'm looking at activity over a given date range, and it's quite useful that weekends are missed out in the reports (as there is no activity during those days).

Does anyone have any other suggestions?


Adding Dynamic Rows in ASP.NET GridView Control with TextBoxes and with Delete functionality

In my previous examples, I have demonstrated on how to add dynamic rows in GridView control with TextBoxes and how to save the values into the database. Now, seems that most of the developers are asking if how to add a delete functionality with it. So in this example, I'm going to show on how to delete a certain row in the dynamic GridView with TextBoxes.

jQuery: Highlight Gridview Rows with Checkbox

Im learning and experimenting with jQuery and ASP.NET. Below is a simple solution I created to highlight rows in a gridview by clicking on a checkbox next to the row.

Gridview setup:
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