Assertion Failed Error

Question

some times when user try to upload data in database the application pop up comes and users application tool stop working. after clicking on retry or ignore ,its work fine.

 

What is the  issue

 

 

Application popup: Assertion Failed: Abort=Quit, Retry=Debug, Ignore=Continue :


    at STrace.ReadTraceValues()
    at STrace..cctor() 
    at STrace.Trace(String strComponentName, String strFormat, Object[] arg) 
    at Application.LoadPackage(String fileName, IDTSEvents events, Boolean loadNeutral) 
    at Application.LoadPackage(String fileName, IDTSEvents events) 
    at Reco_Test1BBBSUpload.executeBankBookDTSX(String strSheetName)  f:\Fiction2Fact\PublishedBankReco\Reco\BBBSUpload.aspx.cs(485)
    at Reco_Test1BBBSUpload.uploadBankBook()  f:\Fiction2Fact\PublishedBankReco\Reco\BBBSUpload.aspx.cs(401)
    at Reco_Test1BBBSUpload.btnProcess_Click(Object sender, EventArgs e)  f:\Fiction2Fact\PublishedBankReco\Reco\BBBSUpload.aspx.cs(82)
    at Button.OnClick(EventArgs e) 
    at Button.RaisePostBackEvent(String eventArgument) 
    at Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) 
    at Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) 
    at Page.RaisePostBackEvent(NameValueCollection postData) 
    at Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 
    at Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 
    at Page.ProcessRequest() 
    at Page.ProcessRequestWithNoAssert(HttpContext context) 
    at Page.ProcessRequest(HttpContext context) 
    at reco_bbbsupload_aspx.ProcessRequest(HttpContext context)  c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\bankrecosystem\618beb39\b2c8478d\App_Web_bbbsupload.aspx.b7b4d495.uuhavfbq.0.cs
    at CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() 
    at HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) 
    at ApplicationStepManager.ResumeSteps(Exception error) 
    at HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData) 
    at HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) 
    at HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr) 
    at ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType) 

-

Sanket

Answer 1

This is most likely a problem with the application code, but to be safe you should check the sql server engine logs to make sure there are no errors or warnings that could be indicitive of this issue.

-Sean

Answer 2

I feel the same Sean as its may be application issue , but still im facing the same error while uploading data file and just want to know if anything from sql or windows side causing the problem..

user tries to upload excel file into sql server through bulk insert via DTS package .

my windows config are

windows server 2003  sp2

8 GB Ram .

virtual memory : 15 GB

/3GB enabled

database size approx . 10 GB

sql server 2008 sp2 .

excel file max size upto 33 MB

in event log its showing

Application popup - event id 26

..

---

-Sanket

Answer 3

Sanket,

If there are no errors in the SQL Server errorlog but there are errors in the event viewer pertaining to this application then that would point me to the direction of the application.

You said DTS package which is from SQL Server 2000, is it really a DTS package or is it an SSIS package? There is a pretty big difference. If it actually is a DTS package it should be rewritten using SSIS.

After checking the logs, I would try to manually import the excel file through BCP or TSQL to see if the excel file is formatted properly and the correct drivers are loaded to read it (in the case of openrowset). Depending on if this would fail or succeed would dtermine your next steps.

-Sean

Answer 4

Thanks for your help Sean , Lets see if my application team will follow this .

---

-Sanket