Question

Locked

SQL errors one asingle XP machine

By Oz_Media ·
In an office with 6 users having no issues with a SQL database, one user is repeatedly getting errors. Al machines are XP, SP3, .net framework up to date.

The user is okay for several searches/queries but after a few times, starts getting SQL error about object reference not set to an instance. The database can be searched by name, customer type etc. The user selects a customer type from a drop down box and after a few successful uses, using any drop down box at all returns the same error.

Ex. Line 256 if dropdownlist2.SelectedIten.value = 0 Then Exit Function

However all others users using the exact same drop down box to select the exact same customer group has no issues. Again, this also works SOMETIMES for the user having issues, then gets kicked out and asked to login again or receives the above error. This one machine is new on the network and worked fine for her yesterday but has been failing repeatedly today.

Any ideas? is there perhaps an update needed to handle these scripts? It's seems machine related not database, as others have no issues with the same search system.

Any other 'local' info can be provided if needed but the database is stored off site and was designed several years ago by a programmer who is no longer in the country.

Judging by the error it seems database related, but judging by the occurrence and isolation to a single machine, it is local.

This conversation is currently closed to new comments.

24 total posts (Page 1 of 3)   01 | 02 | 03   Next
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Have you tried

by NexS In reply to SQL errors one asingle X ...

Repairing or uninstalling the client software that this person uses to query the Dbase?

Collapse -

No I haven't

by Oz_Media In reply to Have you tried

It's a remote database accessed through a browser. I have run into the problem using Firefox but I don't know if its there with IE8. Good point, I'll have to see if it is the same with both browsers.

Thank you!

Collapse -

All else apparently equal,

by santeewelding In reply to SQL errors one asingle X ...

This "new on the network" looks like a place to start.

Collapse -

Not necesarily sql server that

by Tony Hopkinson In reply to SQL errors one asingle X ...

but it's unlikely to be a straight program error either as it's only one the one box.

I've be looking for os differences, MDAC and such, or may be network topology, extra latency on it's route. After that it wouldnlt be the first time a .net install has gone wrong.

If not that, then we are dowe to weird and wonderful explanations bordering on small blue rigellians playing a practical joke on you.

PS that line of code should test to see if
dropdownlist2.SelectedItem has a value before it tests to see if it's 0

How it could get into that state I can't say from here , but every now and then it is...

Collapse -

small blue rigellians playing a practical joke on you.

by Oz_Media In reply to Not necesarily sql server ...

That's what I came up with yesterday, still haven't ruled it out yet.

Collapse -

Topology?

by TobiF In reply to SQL errors one asingle X ...

So, are we talking about web-based clients?

If the client depends on some javascript in a separate file, then flushing the browser cache could be useful.

Do all users have the same browser (and version)?

Does the server have any limited storage space for each user?

Does this system use "inline javascript"? If a user starts playing with a drop-down while a large page is still downloading, he may accidentally initiate a new page request, thus thwarting the download of some needed code (included or referenced further down the page that was first being downloaded)

Collapse -

Interesting

by Oz_Media In reply to Topology?

So, are we talking about web-based clients?
YES

Do all users have the same browser (and version)?
SAME BROWSER (FF) WILL CHECK VERSIONS (EDITE: yes, all are the same build)

Does the server have any limited storage space for each user?
NOT THAT I AM AWARE OF, I HAVE NO INFORMATION ABOUT THE REMOTE SERVER YET, WORKING ON THAT, LONG STORY.

Does this system use "inline javascript"?
AS ABOVE

Thank you kindly for your prompt reply.

Collapse -

UPDATE

by Oz_Media In reply to SQL errors one asingle X ...

okay so it is browser dependent, duh, why didn't I think of that!? Getting rusty having been out of IT for so long now.

IE appears okay after a few tries, FF, after complete removal, reboot, install, reboot is still having the error after a couple of searches .

Here's the stack trace:
Line 263: ' Note: - running thru. SqlAdapter, not SqlCommand, so need 'exec spName' - this is to allow use of optional params
Line 264: '----------------------------------------------------------------------------------------------------------
Line 265: If Dropdownlist2.SelectedItem.Value = 0 Then Exit Function
Line 266: If ddlCategoryFilter.SelectedItem.Value = 0 Then Exit Function
Line 267: ViewAllGridGet = False


Source File: c:\inetpub\wwwroot\XXXXXdatabase\PCustomer.aspx.vb Line: 265

Stack Trace:

[NullReferenceException: Object reference not set to an instance of an object.]
XXXXXdatabase.PCustomer.ViewAllGridGet() in c:\inetpub\wwwroot\XXXXXdatabase\PCustomer.aspx.vb:265
LQPdatabase.PCustomer.RankFilterChanged(Object source, EventArgs e) in c:\inetpub\wwwroot\XXXXXdatabase\PCustomer.aspx.vb:998
System.Web.UI.WebControls.ListControl.OnSelectedIndexChanged(EventArgs e) +108
System.Web.UI.WebControls.DropDownList.System.Web.UI.IPostBackDataHandler.RaisePostDataChangedEvent() +26
System.Web.UI.Page.RaiseChangedEvents() +115
System.Web.UI.Page.ProcessRequestMain() +1099


Do you think it has something to do with "Note: - running thru. SqlAdapter, not SqlCommand, so need 'exec spName' - this is to allow use of optional params"


NOTE: XXXXXdatabase simply used to mask database name for this posting

Collapse -

Some thoughts

by TobiF In reply to UPDATE

The expression "Dropdownlist2.SelectedItem.Value" is undefined.
It might be created automatically in IE but needs to be created excplicitly in FF. Or it could be a question about different capitalization. So, you need to find out where and how this object is (supposed to be) created.

Collapse -

Thanks for your input

by Oz_Media In reply to Some thoughts

Unfortunately, as it is an old programmer's scripts I don't have access to the hosting server or scripting. I am not the IT manager here but the sales manager of a small company (20 employees) that outsources such tasks. As this only effects one PC, I cannot justify calling in and paying for tech support on the server side.

Other PC's in the office use the same OS, same updates, same browser and have no such issues though. At this time I have to rule out the script itself and look at the single user who is having issues with a new PC.

Again though, thank you very much for adding your thoughts. I ***** and moan at people's personal, off topic opinions a lot on TR but I have always held it's tech support professionals with the highest regard.

Back to Software Forum
24 total posts (Page 1 of 3)   01 | 02 | 03   Next

Software Forums