Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-24 : 22:07:56
|
| Ray writes "My people are operating MS WIN 98 and NT 4.0 SP6 with Pivotal Windows Access 3.01 with SQL Server 2000 Service Pack 2.We we open a query to bring up data in a window, the data comes up and then we watch it FAD AWAY IN FRONT OF OUR EYES! This doesn't happen all the time just from time to time.Pivotal says it is a MS SQL Server problem.I searched your knowledge base and could not find anything about data fading away.Thanks." |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2002-02-24 : 22:07:56
|
Does the data just disappear or does is really, actually fade away? This may be the coolest problem I've ever heard of.
Does it fade away over the course of a second or two -- like the fade to black before a commerical after an especially dramatic scene in a made for television movie? Or is it more of a here one instant, gone the next -- like my bank balance after a trip to Barnes & Nobles?
Not that I'm making fun of your problem . . . except that I'm making fun of your problem :) How come I never have cool problems like this! Data that fades away! How cool! Can I use that feature on my boss?
Now, fading away is somewhat of a non-technical term. My first though would be that fading away would have something to do with the user interface and not SQL Server since fading implies "visualness", hence their client app. If it was there one minute and not the next then that may be a SQL Server issue.
An interesting approach might be to use Profiler to log every SQL statement sent to the server. I bet you'll find that the app is either not saving or is deleting the data. It might be kind of hard to track down though.
Can you post some time lapse screenshots of this "fading" data. I'm very intrigued by this.
I'd ask Pivotal to show you which MS knowledge base article documents the "data fading away" issue. If they say there isn't one, I'd ask how they know it's an MS issue and not theirs -- keeping in mind that "We're really good programmers" isn't an acceptable answer. And if they know it's an MS issue ask how they duplicated the situation to prove it's MS. It really sounds like they are blowing smoke out their ears. I'm not aware of any situations other than a server failure that can cause a data loss -- especially data fading away!
I'd also love to see the email or have a copy of a voice mail where they said "data fading away" was an MS SQL Server problem. What a hoot.
Oh and incidentally I did a search at support.microsoft.com on SQL Server and fading and didn't come up with any hits :)
Good luck and keep us posted. This might be the best question we've ever received! I really want to know how it turns out! |
 |
|
|
dave
Starting Member
15 Posts |
Posted - 2002-02-24 : 22:29:41
|
| This is very easy. You said that you had SQL Server 2000 SP2? I would suggest that you didn't actually get Service Pack 2 but rather Spy Pack 2. I'm sure you've heard of invisible ink? Well, the data appears on your screen and then fades away in just the same way. You need to go out and get yourself the MRM1 (Magic Revealer Mouse 1) and then run it over your screen. I think you'll be pleansantly surprised to find that all will be revealed everything is then ok.Best of British Luck 007. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-02-24 : 22:33:04
|
| Are you sure you're not sitting too close to the monitor, and your breath is fogging the screen? |
|
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2002-02-25 : 00:58:48
|
quote:
Are you sure you're not sitting too close to the monitor, and your breath is fogging the screen?
LOLMy bet is SQL Server is dishing up the data so fast it physically melts the screen.. hence the "fading"DavidMTomorrow is the same day as Today was the day before. |
|
|
|
ray smith
Starting Member
1 Post |
Posted - 2002-02-25 : 13:39:06
|
quote:
Does the data just disappear or does is really, actually fade away? This may be the coolest problem I've ever heard of.
Does it fade away over the course of a second or two -- like the fade to black before a commerical after an especially dramatic scene in a made for television movie? Or is it more of a here one instant, gone the next -- like my bank balance after a trip to Barnes & Nobles?
Not that I'm making fun of your problem . . . except that I'm making fun of your problem :) How come I never have cool problems like this! Data that fades away! How cool! Can I use that feature on my boss?
Now, fading away is somewhat of a non-technical term. My first though would be that fading away would have something to do with the user interface and not SQL Server since fading implies "visualness", hence their client app. If it was there one minute and not the next then that may be a SQL Server issue.
An interesting approach might be to use Profiler to log every SQL statement sent to the server. I bet you'll find that the app is either not saving or is deleting the data. It might be kind of hard to track down though.
Can you post some time lapse screenshots of this "fading" data. I'm very intrigued by this.
I'd ask Pivotal to show you which MS knowledge base article documents the "data fading away" issue. If they say there isn't one, I'd ask how they know it's an MS issue and not theirs -- keeping in mind that "We're really good programmers" isn't an acceptable answer. And if they know it's an MS issue ask how they duplicated the situation to prove it's MS. It really sounds like they are blowing smoke out their ears. I'm not aware of any situations other than a server failure that can cause a data loss -- especially data fading away!
I'd also love to see the email or have a copy of a voice mail where they said "data fading away" was an MS SQL Server problem. What a hoot.
Oh and incidentally I did a search at support.microsoft.com on SQL Server and fading and didn't come up with any hits :)
Good luck and keep us posted. This might be the best question we've ever received! I really want to know how it turns out!
The data fades away to quickly to get a screen shot. Also, when we create a note against a company for contact the note sometimes takes and sometimes it doesn't. Then we have to run a query to find the disassociated notes and reassociate them.Other times the notes associate with the company or contact and after various periods of time the note becomes disassociated with the note again.Doesn't happen all the time just sometimes.This has been a problem with SQL version 7 SP1, and SQL version 8 SP2. |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-02-25 : 15:32:56
|
| Ahhh,The old fall back line, "It is an MS problem"[rant]Much easier than ACTUALLY TRYING TO FIGURE OUT THE REAL CAUSE.I bet that is part of the support training for many of these organizations (Not all, some companies have great support). TRAINING 101: If it involves an MS product, blame them and get of the phone ASAP.I have heard it too many times. "I called Company XYZ, but they said it was your problem..."[/rant]Anyway, Ray, if you want real help, call Microsoft Support. Even though, I am sure this has nothing to do with SQL Server, and everything to do with Pivotal, they will help you. They will determine that it is not SQL Server, and then rather than saying, Sorry, this isn't our problem, they wil offer to open a support case with Pivotal. Then they will work with the Pivotal engineer (Or was it just a recording that said, it is an MS issue?) to help resolve the problem.Now, unless your company has a Premier Support contract, this will cost about $245. But hey, we could just hire a couple of guys to say "It is somebody elses problem" and provide free support. It may cost, but at least your data won't be fading away anymore.-Chad |
|
|
|
|
|
|
|
|
MS SQL Server 2000 Data Loss