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

Top 5 Contributors of the Month
Gaurav Pal

Home >> Forum >> VB.Net >> Post New QuestionBookmark and Share Subscribe to Forum

exception while iterating through the records

Posted By: awasthsr     Posted Date: March 22, 2013    Points:5   Category :VB.Net

I am trying to loop through a dataset's values and call a oracle package for every iteration.

For i = 0 To ds_SecAlias.Tables(0).Rows.Count - 1
ds_output = GetTHInKAcctPositionDetails(ds_SecAlias.Tables(0).Rows(i)(0).ToString(), "12-jun-2010", "User ID=PROC_ID;Password=tbcam2008;Data Source=TBCPRD2;Persist Security Info=False")

GetTHInKAcctPositionDetails is a function that calls that package and returns results which I am saving in the dataset.

but while this happens i get the following message followed by an exception stated below :

Microsoft Visual Studio
No symbols are loaded for any call stack frame. The source code cannot be displayed.
and the exception that appears is:

The CLR has been unable to transition from COM context 0x1b7d70 to COM context 0x1b7c00 for 60 seconds. The thread that owns the destination context/apartment is most likely either doing a non pumping wait or processing a very long running operation without pumping Windows messages. This situation generally has a negative performance impact and may even lead to the application becoming non responsive or memory usage accumulating continually over time. To avoid this problem, all single threaded apartment (STA) threads should use pumping wait primitives (such as CoWaitForMultipleHandles) and routinely pump messages during long running operations.

Please help and let me know if any other information is required.

Author: Narayanan             
Posted Date: April 08, 2013     Points: 20   

Post Reply

You must Sign In To post reply
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery

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