Internal Connection Fatal Error

  • Thread starter SteveoAtilla via DotNetMonster.com
  • Start date
S

SteveoAtilla via DotNetMonster.com

Hello!

I have just started getting this error (trapped by a try...catch...end try
structure) in an app that has been functioning well for over 18 months.

I am getting this in my development environment (Windows XP machine with a
Windows Server 2003 SQL virtual machine), and since I am trapping the error,
I don't get the full stack trace. Anyway, I don't believe that there is a
single set of commands that trigger the error, since I can comment out one of
the subs with DB access, and I still get the error.

Just for reference, here is one of the DB routines anyway:

Dim ProductionBOMCmdText As String
Dim ProductionBOMCommand As New SqlCommand

ProductionBOMCmdText = "UPDATE dbo.ProductionBOM SET WorkcenterNumber =
40600425 WHERE (SerialNumberProfile <> '') AND (WorkcenterNumber = '') AND
(MachineMasterPK = ViewState("MachineMasterPK") & ")"

ConnectionAlpha.ConnectionString = ViewState("ConnectionString")
ConnectionAlpha.Open()
Try
ProductionBOMCommand = New SqlCommand(ProductionBOMCmdText,
ConnectionAlpha)
Dim ra As Integer = ProductionBOMCommand.ExecuteNonQuery()
Catch ex As Exception
DisplayAlert("UNEXPECTED ERROR!\nPage: InitiateMachine.aspx\nSubroutine:
FixTheBOM\nLine: 2376\nError Message: " & Replace(ex.Message, vbCrLf, "\n") &
"\nCommand Text:\n" & ProductionBOMCmdText)
End Try
ConnectionAlpha.Close()

I tried to change all the SQL Connections, have re-booted the SQL server, and
went ahead and did the KB fix for .NET 2.0, even though this app uses 1.4.

What's going on? The rest of the application works fine. It's just this one
page that is now throwing errors. Unfortunately, this is kind of the core of
the app, and does literally hundreds of SQL transactions every time it is
used.

What might be going on? I didn't change all that much...

Thanks,

Steveo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,755
Messages
2,569,536
Members
45,009
Latest member
GidgetGamb

Latest Threads

Top