System.NullReferenceException: Object reference not set to an inst

Guest · Feb 1, 2005

I have several pages written in aspx, but sometime the aspx page return the
following error. And it hapeen, the whole web application gives this error,
that means all the aspx files get affected. Any ideas?
Here is the error:

Server Error in '/' Application.
--------------------------------------------------------------------------------

Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set
to an instance of an object.

ASPX CODE:

<%@ Page Language="JScript" Aspcompat="true" Debug="false"
Inherits="PETestTimeMSP" Src="source/pettmailmsp.js" %>
<%
pettMailMSP();
%>

<html>
<head>
<title>SCReliabilityServices Emailer</title>
</head>
<body>
SCReliabilityServices Emailer - Sent!
</body>
</html>

SOURCE CODE:
import System;
import System.Data;
import System.Data.OleDb;
import System.Web.UI;
import System.Web.UI.WebControls;
import System.Web.UI.HtmlControls;
import System.Text;
import System.Web.Mail;
import DBConn;
import LDAPCOM;

public class PETestTimeMSP extends Page {
public function sendMail(message : String, to : String) : void {
var Mailer : MailMessage = new MailMessage();
Mailer.Priority = MailPriority.Normal;
Mailer.BodyFormat = MailFormat.Html;
Mailer.From = "(e-mail address removed)";
Mailer.To = to;
Mailer.Subject = "(MSP) DRTL PE Test Time Forecast - " + (new
Date().getMonth()+1) + "/" + new Date().getDate() + "/" + new
Date().getYear();
//Mailer.Body = "Starting today, you
will be receiving a daily report that should be beneficial in planning test
time for jobs being stressed in DRTL. The first part of the report
â€œCompleted Stress â€“ Pending Testâ€ shows jobs that have completed stress
and are pending test. For jobs in this status, electrical test has not
yet been completed - according to our database. These will continue to
stay open, until data is provided to close. If you have contacted our lab
on some of these jobs for closure, we are working on them. Otherwise,
please contact Jennifer McClellan. The second part of the report
â€œForecast Readpoints for Testâ€ is a forecast for jobs that are in stress
and are expected to be completed within the next 5 days. The time out on
the expected day is the end of the day. Regards, David
Kaase DRTL Manager " + message;
Mailer.Body = message;
SmtpMail.SmtpServer = "smtp.mail.ti.com";
SmtpMail.Send(Mailer);
}

public function pettMailMSP() : String {
var DBConnUtil : DBConnQDW = new DBConnQDW();
var dbconn : OleDbConnection = DBConnUtil.connectQDW();
var sql : String = "select d.relcode, d.jobtitle, d.pengrname,
d.pengremail, d.priority, t.testtype, t.testnum, r.grp, r.readnum, r.hrcy,
r.qty, to_char(k.sent, 'MM/DD/YYYY') sent, to_char(k.expecteddate,
'MM/DD/YYYY') expecteddate, k.location from rel_device d, rel_tests t,
rel_reads r, rel_track k where d.relcode = t.relcode and t.relcode =
r.relcode and t.testnum = r.testnum and r.relcode = k.relcode and r.testnum =
k.testnum and r.grp = k.grp and r.readnum = k.readnum and d.dbname = 'MSPREL'
and t.status = 'Active' and UPPER(t.programno) like 'ENG%' and k.complete is
null and k.location = 'PE Test'"
+ " union "
+ "select d.relcode, d.jobtitle, d.pengrname,
d.pengremail, d.priority, t.testtype, t.testnum, r.grp, r.readnum, r.hrcy,
r.qty, to_char(k.sent, 'MM/DD/YYYY') sent, to_char(k.expecteddate,
'MM/DD/YYYY') expecteddate, k.location from rel_device d, rel_tests t,
rel_reads r, rel_track k where d.relcode = t.relcode and t.relcode =
r.relcode and t.testnum = r.testnum and r.relcode = k.relcode and r.testnum =
k.testnum and r.grp = k.grp and r.readnum = k.readnum and d.dbname = 'MSPREL'
and t.status = 'Active' and ((t.testnum >= 0001 and t.testnum <= 0104) or
(t.testnum >= 1000 and t.testnum <= 1615) or (t.testnum >= 2000 and t.testnum
<= 2750) or (t.testnum >= 3000 and t.testnum <= 3240) or (t.testnum >= 3500
and t.testnum <= 3800) or (t.testnum >= 4075 and t.testnum <= 4322) or
(t.testnum = 9001)) and UPPER(t.programno) like 'ENG%' and k.expecteddate is
not null and k.expecteddate <= sysdate+5 and k.complete is null and
k.location like 'DRTL-%' order by 3, 5, 1, 6, 8, 12, 13";
var dbcmd : OleDbCommand = new OleDbCommand(sql, dbconn);
var dbRecords : OleDbDataReader = dbcmd.ExecuteReader();

var tableA : StringBuilder = new StringBuilder();
var tableB : StringBuilder = new StringBuilder();
var tableC : StringBuilder = new StringBuilder();
var tableS1 : StringBuilder = new StringBuilder();
var tableS2 : StringBuilder = new StringBuilder();
var tableS3 : StringBuilder = new StringBuilder();
var pengremail : String;
var relcodeA : String;
var relcodeB : String;
var expecteddate : String;
var tempdate : Date;
var ldaputil : LDAP = new LDAP();
while( dbRecords.Read() ) {
if( String.Compare(pengremail, dbRecords("pengremail")) != 0 ) {
if( String.Compare(pengremail, null) != 0 ) {
if( String.Compare(tableA.ToString(), "") != 0 ) {
tableA.Append("</table>");
tableC.Append(tableA.ToString());
tableC.Append(" ");
}

if( String.Compare(tableB.ToString(), "") != 0 ) {
tableB.Append("</table>");
tableC.Append(tableB.ToString());
}

if( String.Compare(ldaputil.getLDAPValue('MAIL', pengremail,
'mail'), "") != 0 &&
String.Compare(tableC.ToString(), "") != 0 ) {
tableC.Append(" NOTE: This is an auto-generated
message! ");
sendMail(tableC.ToString(), pengremail);
}
}

pengremail = dbRecords("pengremail").ToString();
tableA = new StringBuilder();
tableB = new StringBuilder();
tableC = new StringBuilder();
}

if( String.Compare(dbRecords("location").ToString(), 'PE Test') == 0 ) {
if( String.Compare(tableS1.ToString(), "") == 0 ) {
tableS1.Append("<h2>Completed Stress - Pending
Test</h2>");
tableS1.Append("<table width=75%>");
}

if( String.Compare(tableA.ToString(), "") == 0 ) {
tableA.Append("<h2>Completed Stress - Pending
Test</h2>");
tableA.Append("<table width=75%>");
tableA.Append("<tr>");
tableA.Append("<td colspan=7>PE: " +
dbRecords("pengrname").ToString() + ":</td>");
tableA.Append("</tr>");

tableS1.Append("<tr>");
tableS1.Append("<td colspan=7>PE: " +
dbRecords("pengrname").ToString() + ":</td>");
tableS1.Append("</tr>");
}

if( String.Compare(relcodeA, dbRecords("relcode").ToString()) != 0 ) {
relcodeA = dbRecords("relcode").ToString();
tableA.Append("<tr>");
tableA.Append("<td colspan=5> <a
href='http://reldb.sc.ti.com/reldb/reldbmain.nsf/ShowJobDetail?OpenAgent&Relcode="
+ relcodeA + "'>" + relcodeA + "  â€” " +
dbRecords("jobtitle").ToString() + "</a></td>");
tableA.Append("</tr>");
tableA.Append("<tr>");
tableA.Append("<td align=center>Test_Type</td>");
tableA.Append("<td align=center>Hr/Cy</td>");
tableA.Append("<td align=center>Grp</td>");
tableA.Append("<td align=center>Qty</td>");
tableA.Append("<td align=center>PE_Test</td>");
tableA.Append("</tr>");

tableS1.Append("<tr>");
tableS1.Append("<td colspan=5> <a
href='http://reldb.sc.ti.com/reldb/reldbmain.nsf/ShowJobDetail?OpenAgent&Relcode="
+ relcodeA + "'>" + relcodeA + "  â€” " +
dbRecords("jobtitle").ToString() + "</a></td>");
tableS1.Append("</tr>");
tableS1.Append("<tr>");
tableS1.Append("<td align=center>Test_Type</td>");
tableS1.Append("<td align=center>Hr/Cy</td>");
tableS1.Append("<td align=center>Grp</td>");
tableS1.Append("<td align=center>Qty</td>");
tableS1.Append("<td align=center>PE_Test</td>");
tableS1.Append("</tr>");
}

tableA.Append("<tr>");
tableA.Append("<td align=center>" +
dbRecords("testtype").ToString() + "</td>");
tableA.Append("<td align=center>" +
dbRecords("hrcy").ToString() + "</td>");
tableA.Append("<td align=center>" +
dbRecords("grp").ToString() + "</td>");
tableA.Append("<td align=center>" +
dbRecords("qty").ToString() + "</td>");
tableA.Append("<td align=center>" +
dbRecords("sent").ToString() + "</td>");
tableA.Append("</tr>");

tableS1.Append("<tr>");
tableS1.Append("<td align=center>" +
dbRecords("testtype").ToString() + "</td>");
tableS1.Append("<td align=center>" +
dbRecords("hrcy").ToString() + "</td>");
tableS1.Append("<td align=center>" +
dbRecords("grp").ToString() + "</td>");
tableS1.Append("<td align=center>" +
dbRecords("qty").ToString() + "</td>");
tableS1.Append("<td align=center>" +
dbRecords("sent").ToString() + "</td>");
tableS1.Append("</tr>");
}
else {
expecteddate = dbRecords("expecteddate").ToString();
if( parseInt(dbRecords("testnum")) >= 1 &&
parseInt(dbRecords("testnum")) <= 104 ) {
sql = "select r_user from rel_reads where relcode = '" +
dbRecords("relcode") + "' and testnum = '" + dbRecords("testnum") + "' and
grp = '" + dbRecords("grp") + "' and readnum <= '" + dbRecords("readnum") +
"' and r_user like '%Soak%'";
var dbconnPrecon : OleDbConnection = DBConnUtil.connectQDW();
var dbcmdPrecon : OleDbCommand = new OleDbCommand(sql,
dbconnPrecon);
var dbRecordsPrecon : OleDbDataReader = dbcmdPrecon.ExecuteReader();
if( !dbRecordsPrecon.Read() ) {
dbRecordsPrecon.Close();
DBConnUtil.closeQDW(dbconnPrecon);
continue;
}
else {
tempdate = new Date(expecteddate);
tempdate.setHours(48);
if( tempdate > new Date().setHours(120) ) {
dbRecordsPrecon.Close();
DBConnUtil.closeQDW(dbconnPrecon);
continue;
}
else {
expecteddate = (new Date(tempdate).getMonth()+1) + "/" + new
Date(tempdate).getDate() + "/" + new Date(tempdate).getYear();
dbRecordsPrecon.Close();
DBConnUtil.closeQDW(dbconnPrecon);
}
}
}

if( String.Compare(tableS2.ToString(), "") == 0 ) {
tableS2.Append("<h2>Forecast Readpoints for
Test</h2>");
tableS2.Append("<table width=75%>");
}

if( String.Compare(tableB.ToString(), "") == 0 ) {
tableB.Append("<h2>Forecast Readpoints for
Test</h2>");
tableB.Append("<table width=75%>");
tableB.Append("<tr>");
tableB.Append("<td colspan=7>PE: " +
dbRecords("pengrname").ToString() + ":</td>");
tableB.Append("</tr>");

tableS2.Append("<tr>");
tableS2.Append("<td colspan=7>PE: " +
dbRecords("pengrname").ToString() + ":</td>");
tableS2.Append("</tr>");
}

if( String.Compare(relcodeB, dbRecords("relcode").ToString()) != 0 ) {
relcodeB = dbRecords("relcode").ToString();
tableB.Append("<tr>");
tableB.Append("<td colspan=5> <a
href='http://reldb.sc.ti.com/reldb/reldbmain.nsf/ShowJobDetail?OpenAgent&Relcode="
+ relcodeB + "'>" + relcodeB + "  â€” " +
dbRecords("jobtitle").ToString() + "</a></td>");
tableB.Append("</tr>");
tableB.Append("<tr>");
tableB.Append("<td align=center>Test_Type</td>");
tableB.Append("<td align=center>Hr/Cy</td>");
tableB.Append("<td align=center>Grp</td>");
tableB.Append("<td align=center>Qty</td>");
tableB.Append("<td align=center>Expected_Date</td>");
tableB.Append("</tr>");

tableS2.Append("<tr>");
tableS2.Append("<td colspan=5> <a
href='http://reldb.sc.ti.com/reldb/reldbmain.nsf/ShowJobDetail?OpenAgent&Relcode="
+ relcodeB + "'>" + relcodeB + "  â€” " +
dbRecords("jobtitle").ToString() + "</a></td>");
tableS2.Append("</tr>");
tableS2.Append("<tr>");
tableS2.Append("<td align=center>Test_Type</td>");
tableS2.Append("<td align=center>Hr/Cy</td>");
tableS2.Append("<td align=center>Grp</td>");
tableS2.Append("<td align=center>Qty</td>");
tableS2.Append("<td align=center>Expected_Date</td>");
tableS2.Append("</tr>");
}

tableB.Append("<tr>");
tableB.Append("<td align=center>" +
dbRecords("testtype").ToString() + "</td>");
tableB.Append("<td align=center>" +
dbRecords("hrcy").ToString() + "</td>");
tableB.Append("<td align=center>" +
dbRecords("grp").ToString() + "</td>");
tableB.Append("<td align=center>" +
dbRecords("qty").ToString() + "</td>");
tableB.Append("<td align=center>" + expecteddate +
"</td>");
tableB.Append("</tr>");

tableS2.Append("<tr>");
tableS2.Append("<td align=center>" +
dbRecords("testtype").ToString() + "</td>");
tableS2.Append("<td align=center>" +
dbRecords("hrcy").ToString() + "</td>");
tableS2.Append("<td align=center>" +
dbRecords("grp").ToString() + "</td>");
tableS2.Append("<td align=center>" +
dbRecords("qty").ToString() + "</td>");
tableS2.Append("<td align=center>" + expecteddate +
"</td>");
tableS2.Append("</tr>");
}
}

if( String.Compare(tableA.ToString(), "") != 0 ) {
tableA.Append("</table>");
tableC.Append(tableA.ToString());
tableC.Append(" ");
}

if( String.Compare(tableB.ToString(), "") != 0 ) {
tableB.Append("</table>");
tableC.Append(tableB.ToString());
}

if( String.Compare(ldaputil.getLDAPValue('MAIL', pengremail, 'mail'),
"") != 0 &&
String.Compare(tableC.ToString(), "") != 0 ) {
tableC.Append(" NOTE: This is an auto-generated message! ");
sendMail(tableC.ToString(), pengremail);
}

if( String.Compare(tableS1.ToString(), "") != 0 ) {
tableS1.Append("</table>");
tableS3.Append(tableS1.ToString());
tableS3.Append(" ");
}

if( String.Compare(tableS2.ToString(), "") != 0 ) {
tableS2.Append("</table>");
tableS3.Append(tableS2.ToString());
}

tableS3.Append(" NOTE: This is an auto-generated message! ");
sendMail("***Summary to Lab Manager*** " + tableS3.ToString(),
'(e-mail address removed)');

dbRecords.Close();
DBConnUtil.closeQDW(dbconn);
}
}

Kevin Spencer · Feb 1, 2005

A couple of things:

Note the following in the error message:

Please review the stack trace for more information about
the error and where it originated in the code.

Note the following in your @Page directive:

<%@ Page Language="JScript" Aspcompat="true" Debug="false"
Inherits="PETestTimeMSP" Src="source/pettmailmsp.js" %>

Turing Debugging ON should give you the stack trace that will indicate the
line of code that threw the exception. From there it's simple.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

Guest · Feb 2, 2005

Kevin,

Thanks for helping out.
When I turn it on, the stack shows error during compiling and assembly
permissions issue. I cannot get the error back, because our server guy reboot
the .net service, and the pages are working again.
It happen so many times that every time it happen, all the aspx pages get
affected and the .net service return the same error for every aspx pages. And
every time I have to ask our server guy to reboot the .net service, and then
everything works again... We couldn't find out what the root cause is.
Any ideas?

Thanks,
Ben

Can someone tell me if this a real tracker? Or is it one designed to show you a different message at certain times, ie. acting like one?	0	Jan 10, 2021
How to have two html audio players on one page?	0	May 3, 2022
Image shifts to the right when export the page to pdf	4	May 5, 2023
Uncaught ReferenceError: item is not defined at HTMLButtonElement.onclick in the: <button onclick="item.inserir()">Inserir dados</button>	1	Apr 22, 2023
Angularjs newbie - second JSON datasource does not display	0	May 18, 2022
Help with my responsive home page	2	Dec 14, 2022
Help with code	0	Jun 12, 2022
I need help fixing my website	2	Oct 15, 2023

System.NullReferenceException: Object reference not set to an inst

Guest

Kevin Spencer

Guest

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads