July 15, 2002 at 2:16 pm
Hi all,
As my user log in to her account to check her report, instead off pulling out a report that she entered by herself, she ended up opening someone else's report. I tried to open the same report logging in as Administrator, the same problem happened. We cleared cache but it didn't help. Is it related to database concistency? Can anyone help me out? Thanks!
dvo
July 15, 2002 at 2:57 pm
I'm not sure what you mean. Can you explain what the "report" is?
Steve Jones
July 15, 2002 at 8:57 pm
Yes the report would have to be the key, what is the query it runs, what type of report is it (things like Crystal Reports have extra stuff they can do). We need more about the report to help you properly.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
July 17, 2002 at 12:49 pm
I mean record but we call it report.
July 17, 2002 at 11:35 pm
What client or application are you using to access the data?
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
July 18, 2002 at 6:44 am
If she is pulling a wrong record and you can tell from the data it shouldn't have pulled then the query would have to have been the issue. If the data meets the criteria then may be a consistancy issue. However I would suggest taking Profiler and doing a trace on SQL:StmtStarting , have her pull the record, and see what query the application ran on the server to see if the answer is in the query.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply