Web Development

21-Jun-07 3:33

Hi!
i am having problem in window service that has to send an email using "System.Net.Mail.SmtpClient". the service code stops unexpectidly when email code runs, in the event log following entry is made:

Event Type: Error
Event Source: .NET Runtime 2.0 Error Reporting
Event Category: None
Event ID: 5000
Date: 6/21/2007
Time: 8:07:28 AM
User: N/A
Computer: xyz
Description:
EventType clr20r3, P1 ejadspmscheduler.exe, P2 1.0.0.0, P3 467a6ece, P4 ejadspmscheduler, P5 1.0.0.0, P6 467a6ece, P7 19, P8 1a13, P9 system.nullreferenceexception, P10 NIL.

The email is using network authentication, if we run service under "network service" then the execution stops at email code, and rest of code is never executed and service dose'nt terminates.

Kindly help me in solving this prbolem. also guide me if i posted this question in wrong forum..

Thanks in advance...

Regards,
Affan Ahmad Toor

..................
QUAIDIAN FOR ONCE, QUAIDIAN FOR EVER!

kubben22-Jun-07 1:54

22-Jun-07 1:54

First you should put a Try Catch around your email logic so you can catch the expection and log it and keep your windows service from going into a bad state. You can even choose to stop the service in the Catch code if that makes sense for you. Anyway, Usually with the mail componants you need a valid email address to be used to authenticate to the email server. Often you can do it from using the correct email address in the from address of your email address. Based off your error message I am guessing that you perhaps didn't even add a from address to the email message. If you want to post your email code we might be able to help more.

Hope that helps.

Ben

Affan Toor22-Jun-07 3:19

22-Jun-07 3:19

Hi!
Thanks for reply,

I have done extensive logging and debugging. the email code is b/w 4 nested try catch statements. but this exception is not cathed by try/catch block, it straight away blocks the application and exists.

i found that the service stops when email is to be sent to any email address that is not local (email account not on the server) like gmail,hotmail, etc. if email is to be sent to local email address it works fine.

any ideas? any kind of help or guidence is appriciated...

Regards,
Affan Ahmad Toor

..................
QUAIDIAN FOR ONCE, QUAIDIAN FOR EVER!

kubben22-Jun-07 3:23

22-Jun-07 3:23

I am pretty sure if you have a base exeception you should be able to catch this exeception. I am guessing that the email server you are trying to use needs some credientials that you are not passing it or doesn't allow email to be sent through it. I would create a simple windows app that has only your email code. Try to get the simple windows app to work with the email stuff first, then once you get it working copy the code into your windows service.

Ben

Affan Toor22-Jun-07 3:32

22-Jun-07 3:32

Thanks for reply,

i have already tried every thing you mentioned above, i turned on/off the credentials, tested the email code in separate application which was working fine there. but when i put it in window service it stops working.

any ideas whats the problem...? am i missing some thing?

Regards,
Affan Ahmad Toor

..................
QUAIDIAN FOR ONCE, QUAIDIAN FOR EVER!

kubben22-Jun-07 3:43

22-Jun-07 3:43

If you got it working in a windows app, but it doesn't work in the windows service the only possibility is the user login you are running the windows service as. Try running the windows service as your login and I am guessing it will work. Which ever login you are using for your windows service (I think you said network service) it doesn't have the correct rights on the PC to do email. If your login works, you should be able to set up a new local or domain user account to run the windows service as. That is normally what I do when I use windows services.

Ben

Affan Toor22-Jun-07 4:25

22-Jun-07 4:25

Thanks for reply...

I am afraid this is also not the problem...! i am using my own local user account with full rights. if i must set some special account setting/rights then please guide me what to do?

Regards,
Affan Ahmad Toor

..................
QUAIDIAN FOR ONCE, QUAIDIAN FOR EVER!

kubben22-Jun-07 4:26

22-Jun-07 4:26

Have you tried running the windows service as your login? If your login works with the windows app, it should cause the windows service to work.

Ben

Affan Toor22-Jun-07 4:55

22-Jun-07 4:55

Thanks for reply,

I tried both window application and window service on local user account. one more thing just came to my notice that previously this was running fine but few days ago i changed some setting of SMTP to block spams and probably after that this problem startd to occure.

Do you think it is because of change in SMTP settings...? if yes then how can i reset the setting or enable window service to run on new setting?

Regards,
Affan Ahmad Toor

..................
QUAIDIAN FOR ONCE, QUAIDIAN FOR EVER!

kubben22-Jun-07 4:57

Still problems with dropdownlist

22-Jun-07 4:57

So I think you are saying that your windows app doesn't work anymore. I am not sure how you changed your SMTP settings, so I am not sure how to reset them either. If that is what changed then that is most likely what needs to be fixed. Note if you are sending lots of emails to a certain server, you will get marked as a spammer which could also be your problem.

Ben

matjame21-Jun-07 3:16

matjame

21-Jun-07 3:16

Hi guys.
Me again with the dropdownlist.I have a dropdownlist prepopulated with items from a database.Select a record from the dropdown, compare it with another record from the database aswell then display the values on a datagrid.

So far I have managed to load the data onto the dropdown, but Im struggling to compare and display the values onto a datagrid.Each time someone refers me to another site, its in c#, vb.net.Those I have done already.Im a vb.net/C#/J# developer, but they are not very neat.So, I need some help with this guys.PLEASE. A sample code would be appreciated.

I can send my vb.net code to get a clearer picture if you want. Cry | :((

kagiso

N a v a n e e t h21-Jun-07 3:34

N a v a n e e t h

21-Jun-07 3:34

Well, In which area you are facing problem ? Loading data to the drop down ? Or getting data and binding the grid when drop down changes ? Have you made autopostback=true ? Sending sample code will be easy to understand the problem

Navaneeth
My Website

matjame21-Jun-07 3:42

matjame

21-Jun-07 3:42

I have managed to load data onto the dropdown, but binding the datagrid when something is selected from the dropdown.

Here is some code from a working vb.net page.

Protected Sub DropDownList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DropDownList1.SelectedIndexChanged
con = New OleDbConnection("Provider = Microsoft.Jet.oledb.4.0; data source = C:\TelephoneList.mdb")
con.Open()
'Dim str As String = "Select Branch,[Contact Name], [Telephone Number], [Telephone Extension], [Fax Number], [Fax Extension] from [Other Branches] Where Branch = '" & DropDownList1.SelectedValue & "'"
' Dim con As New OleDbConnection
Dim comx As New OleDbCommand
comx = New OleDbCommand("Select [Contact Name],[Telephone Number], [Telephone Extension], [Fax Number], [Fax Extension] from [Other Branches] where Branch = '" & DropDownList1.SelectedValue & "'", con)
comx.Connection = con
If con.State = ConnectionState.Open Then
con.Close()
End If
con.Open()
'Dim cm As New OleDbCommand(str, con)
GridView1.DataSource = comx.ExecuteReader(CommandBehavior.CloseConnection)
GridView1.DataBind()
If con.State = ConnectionState.Open Then
con.Close()
End If

' ***********Now Im allocating data to the second datagrid
Dim comxx As New OleDbCommand
comxx = New OleDbCommand("Select [Alternative Contact], [Second Alternative], [Alt Telephone], [Alternative Ext] from [Other Branches] Where [Branch] = '" & DropDownList1.SelectedValue & "'", con)
'Dim str2 As String = "Select Branch, [Alternative Contact], [Second Alternative], [Alternative TelNumber], [Alternative TelExtension], [Cell] Where [Branch] = '" & DropDownList1.SelectedValue & "'"
comxx.Connection = con
If con.State = ConnectionState.Closed Then
con.Open()
End If
'con.Open()
'Dim command As New OleDbCommand(str2, con)
GridView2.DataSource = comxx.ExecuteReader(CommandBehavior.CloseConnection)
GridView2.DataBind()
con.Close()

If DropDownList1.SelectedValue = "UNITRANS" Then

lblMessage.Text = "Here Are Other Users For " & DropDownList1.SelectedValue
Dim Comxxx As New OleDbCommand
Comxxx = New OleDbCommand("Select User, Telephone, Notes from [Other Users] where Branch = '" & DropDownList1.SelectedValue & "'", con)
If con.State = ConnectionState.Closed Then
con.Open()
End If
GridView3.DataSource = Comxxx.ExecuteReader(CommandBehavior.CloseConnection)
GridView3.DataBind()
con.Close()
Else
If DropDownList1.SelectedValue = "A.HAK Industrial Services" Then

lblMessage.Text = "Here Are Other Users For " & DropDownList1.SelectedValue
Dim Comxxx As New OleDbCommand
Comxxx = New OleDbCommand("Select User, Telephone, Notes from [Other Users] where Branch = '" & DropDownList1.SelectedValue & "'", con)
If con.State = ConnectionState.Closed Then
con.Open()
End If
GridView3.DataSource = Comxxx.ExecuteReader(CommandBehavior.CloseConnection)
GridView3.DataBind()
con.Close()
End If

End If
End Sub

kagiso

N a v a n e e t h21-Jun-07 4:02

N a v a n e e t h

21-Jun-07 4:02

What error you are getting here ? Are you getting values to all datareader ?

Navaneeth
My Website