.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

Thread being aborted Error -- while using sqlldr

Posted By:      Posted Date: September 04, 2010    Points: 0   Category :ASP.Net
public sub LoaddataIntotable() _errorLogFilePath = something _badLogFilePath = something _discardLogFilePath = something credentialTokens = "connection string" objCommand.UserName = "scott" objCommand.Password = "tiger" objCommand.Host = "oracle" objCommand.ControlFile = "test.ctl" objCommand.LogFile = _errorLogFilePath objCommand.BadFile = _badLogFilePath objCommand.DataFile = _dataFilePath objCommand.DiscardFile = _discardLogFilePath objCommand.IsParallel = False objCommand.IsDirectLoad = True _objShell.Command = "SQLLDR" _objShell.Arguments = objCommand.ToString AddHandler _objShell.Exited, AddressOf OnProcessExit _objShell.Start() end sub Private Sub OnProcessExit(ByVal sender As Object, ByVal e As CommandLineProcess.ExitedEventArgs) Try If Not e Is Nothing Then If _processExited = False Then _processExited = True CommandCompleted(e.ExitCode) Exit Sub Else ' Event raised again

View Complete Post

More Related Resource Links

Why i am getting error ==> ".NET Framework execution was aborted. The UDP/UDF/UDT did not end thread


Good evening all,

I developed a C# class libray code. Under which i called a third party .asmx web service. I used "CREATE ASSEMBLY" command to register all my custom assembly and needed .net core assemblies. I did register all needed .net dll's. for Ex:-


C:\Program Files\Reference Assemblies\Microsoft\Framework\v3.5\System.Core.dll

I created a procedure and called my class libray methods from SQL analyzer. See Ex:- code below. But when i executed the code method i see the error ".NET Framework execution was aborted. The UDP/UDF/UDT did not end thread affinity.". For testing purpose i logged the flow of my code and the flow of code is good and it even fetched the miles i wanted, except the error. What possibley could be going wrong? Could somebody help me?

@strXML nvarchar(3000),
@blnSkipMilesCalcByZip bit,
@bLogProcessFlow bit,
@calledFrom nvarchar(3),
@distance nvarchar(15)OUTPUT
AS EXTERNAL NAME CalculateMilesPCM.[CalculateMilesPCM.clsMiles].CalcMilesGetcitystate

DECLARE @distance nvarchar(15)
declare @testval nvarchar(15)
 EXEC usp_GetCalcMilesTest '<int_Loads BtLoadid="508952996" SHID="2480" Routetype="HB" SkipMil

How to prevent thread form being stopped/aborted?

I'm not sure if it's a CLR related issue but at the same time i can't say it isn't. The problem is as follows: I have created a windows forms user control that spawns a thread(running a form). The thread is not a background thread and it's not supposed to exit until the form gets closed. It works as desired when the control is hosted in a windows forms application. The problem starts when i want to host it inside a html page. All works fine as long as the page containing the control is opened. Things get a bit weird when i redirect or close the tab(not the window; more tabs are opened). Exactly 1 minute from this moment the thread gets aborted. public partial class IEControl : UserControl { public IEControl() { InitializeComponent(); } private System.Threading.Thread t; private MainForm mf; private void IEControl_Load(object sender, EventArgs e) { GoThread(); } public void GoThread() { try { t = new System.Threading.Thread(RunForm); t.IsBackground = false; t.Start(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } private void RunForm() { mf = new MainForm(); Application.Run(mf); GC.KeepAlive(mf); GC.KeepAlive(this); } } I'm a bit confused at this point. Where could I get any information on this topic if it's not a CLR/GC related issue.

Server failed with error code 0xc0000000 to spawn a thread to process a new login or connection

Hello All, Suddenly, the sql server is down, in the log file, C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG, I found the record as follows, 2007-03-05 15:40:31.59 Logon       Error: 17189, Severity: 16, State: 1.2007-03-05 15:40:31.59 Logon       SQL Server failed with error code 0xc0000000 to spawn a thread to process a new login or connection. Check the SQL Server error log and the Windows event logs for information about possible related problems. [CLIENT:] What else I can do to further investigate? Thanks Spencer

Blob Cache Event ID 7888 Runtime Exception Thread was being aborted

HI, We have 3WFE and we are getting error Events 788 and 5538 on all three servers at same time. Any thoughts on what is causing this error? Event Type: Error Event Source: Office SharePoint Server Event Category: Office Server General Event ID: 7888 Date:  9/14/2010 Time:  2:31:08 PM User:  N/A Computer: MOSS2007A Description: A runtime exception was detected. Details follow. Message: Thread was being aborted. Techinal Details: System.Threading.ThreadAbortException: Thread was being aborted.    at System.Threading.ReaderWriterLock.AcquireWriterLockInternal(Int32 millisecondsTimeout)    at Microsoft.SharePoint.Publishing.BlobCache.<>c__DisplayClass14.<>c__DisplayClass17.<FetchItemFromWss>b__11()    at Microsoft.Office.Server.Diagnostics.FirstChanceHandler.ExceptionFilter(Boolean fRethrowException, TryBlock tryBlock, FilterBlock filter, CatchBlock catchBlock, FinallyBlock finallyBlock) For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.   Event Type: Error Event Source: Office SharePoint Server Event Category: Publishing Cache Event ID: 5538 Date:  9/14/2010 Time:  2:31:08 PM User:  N/A Computer: MOSS2007A Description: An error occured in the blob cache.  The ex

ORA-00255: error archiving log of thread , sequence #



I have the above error when filling a dataset from an oledbconnection into a dataset


 I have had a shorter version of the query working fine


the query works fine in the oracle client


any ideas


thanks in advance

Thread was being aborted



I hit the above error, and below is the stack trace. Any ideas? It doesn't happen regularly.

Thank you

    Stack trace:    at System.Web.Configuration.HttpModuleAction.get_Entry()
   at System.Web.Configuration.HttpModulesSection.CreateModules()
   at System.Web.HttpApplication.InitModules()
   at System.Web.HttpApplication.InitInternal(HttpContext context, HttpApplicationState state, MethodInfo[] handlers)
   at System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpContext context)

Unable to cast COM object error when calling COM from .NET C# worker thread


I'm having an issue calling a COM object function from .NET C# client program. The COM object is written in C++ unmanaged. The problem only appears when I'm calling from a worker thread, it works fine if I call it from the UI thread. This is the error:

Unable to cast COM object of type 'gvAgileFileReaderLib.gvAgileFileReaderClass' to interface type 'gvAgileFileReaderLib.IgvMpiRead'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{616B5C39-C7FB-4C8C-85D4-27559DD83304}' failed due to the following error: Unspecified error (Exception from HRESULT: 0x80004005 (E_FAIL)).

I have tried the following methods but all of them fails:

1) Create the COM object on UI thread, and call its function via its interface (IgvMpiRead) in the worker thread

2) Create the COM object on the worker thread & access its function from worker thread

3) Tried with worker thread set to STA & MTA

I need to use the COM function is a worker thread to prevent a long processing from holding up my UI, but it just doesn't work when I try to call the COM function inside the worker thread.

The weird thing is that doing the same from a unmanaged C++ client works fine (I can create the com object on UI, and then call its function from worker thread). Is this problem caused by inter

Error 17120 - SQL Server could not spawn process_loginread thread



Some how my web server is going down every time I got this error on SQL Server (Error 17120 - SQL Server could not spawn process_loginread thread). I read the related topic but none of those similar issues are related to me (i.e. my protocols are not disabled)

Here is the complete detail of Event Viewer Log:
Event Type: Error
Event Category: (2)
Event ID: 17055
Date:  12/23/2009
Time:  6:27:22 AM
User:  N/A
Computer: EBS_SERVER
17120 :
SQL Server could not spawn process_loginread thread.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Byte Data:
0000: e0 42 00 00 10 00 00 00   àB......
0008: 0b 00 00 00 45 00 42 00   ....E.B.
0010: 53 00 5f 00 53 00 45 00   S._.S.E.
0018: 52 00 56 00 45 00 52 00   R.V.E.R.
0020: 00 00 00 00 00 00         ...... 
Words Data:
0000: 000042e0 00000010 0000000b 00420045
0010: 005f0053 00450053 00560052 00520045
0020: 00000000 0000

The only thing to do in order to get my website up and working again is to restart the computer. Neither rest

Current thread is not STA error


On creating media player control in my winforms whose main() function is marked as mtathread... i get below error

ActiveX control '6bf52a52-394a-11d3-b153-00c04f79faa6' cannot be instantiated because the current thread is not in a single-threaded apartment.

But I dont want to change my threading model as some other activex controls are involved...

How to fix this issue... 

- Rajesh K http://thoughtsontechies.blogspot.com/

System.Threading.ThreadAbortException: Thread was being aborted


In my ASP.Net web application, one of the function is calling the WCF service that has been developed by .Net framework 3.0 using VS2005.It works fine on production and user can make request 8 times(calls) between client and service after that the web application got hanged and generated the following error message. But it works fine on development even more than 8 requests.

I given the proxy time out 20 min in the client side proxy setting.

Error message:

WebService Thread was being aborted



i have a windows service that listens to a directory with FileSystemWatcher.

i listen to xml files that are being copied to the directory.

when a xml is copied i call an WS that runs thrue the Xml File and dose what it has to do...

now i have 2 problems that maybe someone can assist:

1.in my PROD Server i get an timeout or Thread was being aborted (Exception message) after 2 minutes exactly!! when on my DEV or TEST Server this is not happening...

2.how can i throw into the directory 2 huge Xml Files without getting timeout from Window service?

it takes about 2 hours working on 1 xml file..



IsapiModule Error 500 Issue


I am about exhausted trying to figure out this error:

HTTP Error 500.0 - Internal Server Error

Description: The page cannot be displayed because an internal server error has occurred.

Error Code: 0x8007007b

Notification: ExecuteRequestHandler

Module: IsapiModule

Requested URL: http://localhost:80/ReportServer

Physical Path: c:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer

When I enable Failed Request Tracing Rules and view the log output I am supposing that the actual problem is in the 2nd call where there are 2 backslashes before the actual filename in the specified path:


CALL_ISAPI_EXTENSION DllName="C:\Windows\Microsoft.NET\Framework\v2.0.50727\\aspnet_isapi.dll"


Handling 404 page not found with Error page



      How do i handle 404 page not found?

Inserting personal error message in ValidationSummary



I am creating a web form that requires a lot of validation. I use many of the validation control in asp.net already like RequiredFieldValidator and CompareValidator. 

My Problem: after my custom validation for the value entered return an error message, and I pressed enter key when the field is empty, my custom error message is overlapped by my ValidationSummary. 

Setting my custom error to visible = false on button click also does not seem to work as it requires for me to enter the value first.

This made me think, is there a way to insert my custom validation inside the ValidationSummary as an error message like for other validation control?

Thanks in advance

Sys.Net.WebServiceFailedException: The server method '' failed with the following error:



Let's say we have 2 time consuming functions, aaa and aaa1 inside a aspx page.

        public static string aaa(int i)
            return i.ToString();

        public static string aaa1(int i)
            return i.ToString();



        <asp:ScriptManager ID="ScriptManager1" runat="server" EnablePageMethods="true">
        <span id="displayspan"></span>
        <br />
        <input type="button" value=

Jscript error: Object does not support property or method


 Hi, i have little knowledge on javascript but i need to use this code get from somewhere for a jquery to work.

I face this "Jscript runtime error: Object does not support property or method" whenever im trying to run this page.

In my experience, im get this error msg 9 out of 10 times i use javascript in my system.

Im using Microsoft Visual web developer 2008, i wonder if this is related to my problem, i not sure there is anything i need to add as reference or update anything.

But anyway, in short, i just couldn't use javascript code when using this development tool because of this sort of error.

Anyway, it happen that last time i tried use the same type of jquery code in another project and it seems to work well without an error.

But now when im try to use it again in this recent project i created, it come out with this error and i have no idea how to solve it even look through google and this forum.

It doesn't really seems like its the code problem itself although im not sure, because any javascript code just couldn't work.

So below is my code that i need to use.

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js" ></script>
<script type="text/javascript" src=&quo

Type or namespace error.


A couple of days ago I started getting an unusual behavior when compiling Website projects. I have referenced class libraries added to my bin folder that are also correctely referenced in using statements in my aspx.cs code behind. When I compile, I get the 

Error 4 The type or namespace name 'CommonClassLibrary' could not be found (are you missing a using directive or an assembly reference?) C:\Dev\Fiscal_Portal\Implementation\FMS Portal Site_new\App_Code\BLL\DataTables.cs 1 7 C:\...\FMS Portal Site_new\

The type or namespace name 'CommonClassLibrary' could not be found (are you missing a using directive or an assembly reference?)

error message that would typically be received when the dll has not been added as a reference or added in a using statement.

I can eliminate the error by adding an


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