sql server reporting services:
Yes, it is running against SQL Server, one way to recreate this problem is to
query a somewhat large result in the data window then hide the data to work
with scripts or the diagram window, if you wait long enough or go to the
design window and work for a while, the result set that was queried will
cause the system to halt, it opens an invisible dialog window that cannot be
closed, therefore freezing the program and any unsaved work that goes with it.
[quoted text, click to view] "Bruce L-C [MVP]" wrote:
> Are you going against SQL Server? I have never seen this. What I have seen
> (and is a bug) is that RS sometimes does not automatically save or does not
> realize the query has changed. The work around is to go to the layout and
> save. So, if I make a change in the data tab, I go to the layout tab and
> save.
>
> Not really sure what is different about what you are doing but this thread
> is the first I have seen of this on the newsgroups (in all the months since
> release).
>
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
"Edward" wrote:
> I HAVE THE SAME PROBLEM!!!! FREAKING IRRITATING!!
[quoted text, click to view] > "DragonVic" <DragonVic@discussions.microsoft.com> wrote in message
> news:841FDF08-6D95-49FD-AED2-9F30CF62F263@microsoft.com...
> > No, I haven't found a fix for it, I keep getting ignored, I am sick and
> > tired
> > of this BUG, I love Reporting Services, but it is costing me time and it
> > is
> > going to make it very difficult to convince my Boss that Reporting
> > Services
> > is "the" reporting tool.
> >
> > "MJ Taft" wrote:
> >
> >> DID YOU GET A FIX FOR IT??? I have been having the problem too but I
> >> have
> >> been blaming it on visual studio!!! Now I think you're on to
> >> something!!!
> >> Have you called microsoft (since it appears no one here has answered
> >> yet). I
> >> am VERY interested in this because I am not able to save the files that I
> >> have been working on ... and YES .. I save OFTEN ... still doesnt help.
> >> Maybe a memory leak????
> >>
> >> "DragonVic" wrote:
> >>
> >> > ditto: Ihave had the same problem and come to the same conclusion as
> >> > dragonvic regarding the invisible window ...
> >> >
> >> > "DragonVic" wrote:
> >> >
> >> > > I need to re-poen this issue and would like to get immediate
> >> > > attention on this.
> >> > > Please see history below.
> >> > >
> >> > > "DragonVic" wrote:
> >> > >
> >> > > > I need to know if you've had other cases like this, and just tell
> >> > > > me how to
> >> > > > fix it for Windows XP Professional, everytime I query data in the
> >> > > > data
> >> > > > window and then proceed in design mode, a dialog box comes to life
> >> > > > (not
> >> > > > visible), probably asking to close the query to minimize overhead
> >> > > > like SQL
> >> > > > Enterprize does, however, this window seems to be blocked by
> >> > > > another process
> >> > > > and cannot be seen or accessed, causing the application to stop and
> >> > > > eventually losing all unsaved work. This has been going on for a
> >> > > > long time
> >> > > > already, I thought that the service packs would have fixed that.
> >> > > > This needs
> >> > > > immediate attention.
> >> > > >
> >> > > > VZ
> >> > > >
> >> > > > "DragonVic" wrote:
> >> > > >
> >> > > > > I already installed SP1 and SP2 for Reporting Services,
> >> > > > > why do I need SP1 for Windows 2003 if I am not using 2003?
> >> > > > >
> >> > > > > The system still haults!!!
> >> > > > >
> >> > > > > VZ
> >> > > > >
> >> > > > > "kowalsky" wrote:
> >> > > > >
> >> > > > > > i was talking about SERVICE PACKS:
> >> > > > > >
> >> > > > > > there is a SP1(service pack 1) for Windows 2003 and a
> >> > > > > > SP2(service pack 2)
> >> > > > > > for Microsoft Reporting Services. Also check if you have all
> >> > > > > > Updates
> >> > > > > > installed (if you do that first, you will probably be advised
> >> > > > > > to install SP1
> >> > > > > > for W2K3 anyway).
> >> > > > > >
> >> > > > > > kowalsky
> >> > > > > >
> >> > > > > > "DragonVic" wrote:
> >> > > > > >
> >> > > > > > > Reporting Services is still freezing up, on a daily basis,
> >> > > > > > > should I report
> >> > > > > > > this problem with someone else? This is pretty serious, I
> >> > > > > > > keep losing files!!
> >> > > > > > >
> >> > > > > > > VZ
> >> > > > > > >
> >> > > > > > > "DragonVic" wrote:
> >> > > > > > >
> >> > > > > > > > This is the version I have...
> >> > > > > > > >
> >> > > > > > > > Microsoft SQL Server Reporting Services Version 8.00.743.00
> >> > > > > > > >
> >> > > > > > > > I beleive it is the latest.
> >> > > > > > > >
> >> > > > > > > > VZ
> >> > > > > > > >
> >> > > > > > > >
> >> > > > > > > >
> >> > > > > > > > "kowalsky" wrote:
> >> > > > > > > >
> >> > > > > > > > > there is be a SP1 for W2K3 and a SP2 for MRS; have you
> >> > > > > > > > > checked if you got
> >> > > > > > > > > these?
> >> > > > > > > > >
> >> > > > > > > > > kowalsky
> >> > > > > > > > >
> >> > > > > > > > > "DragonVic" wrote:
> >> > > > > > > > >
> >> > > > > > > > > > Everyday since I have gotten SRS, it freezes up and
> >> > > > > > > > > > cannot save or close it.
> >> > > > > > > > > > When I attempt to close it with ALT+F4, I get the
> >> > > > > > > > > > following error message...
> >> > > > > > > > > >
> >> > > > > > > > > > "Microsoft Development Environment cannot shut down
> >> > > > > > > > > > because a modal dialog
> >> > > > > > > > > > is active. Close the dialog and try again"
> >> > > > > > > > > >
> >> > > > > > > > > > The dialog is not visible to be closed, I do not see it
> >> > > > > > > > > > on the task manager,
> >> > > > > > > > > > I do not not which service it uses to kill it, the only
> >> > > > > > > > > > thin I can do is to
> >> > > > > > > > > > KILL SRS and lose my work in progress, this is a very
> >> > > > > > > > > > anoying bug, I keep
> >> > > > > > > > > > losing valuable time spent.
> >> > > > > > > > > >
> >> > > > > > > > > > Is there a patch for this? I know I am not the only
> >> > > > > > > > > > one, because it has
> >> > > > > > > > > > happened to me for ove a year now, in multiple
> >> > > > > > > > > > computers, so it is not my
> >> > > > > > > > > > computer.
> >> > > > > > > > > >
> >> > > > > > > > > > Please respond to this one, this is important to all
> >> > > > > > > > > > SRS users. You should
> >> > > > > > > > > > send a survey to all SRS users about this.
> >> > > > > > > > > >
> >> > > > > > > > > > VZ
By the way, if you are seeing this message too often, that is because I will
post a new one everytime it happens to me and hard work is lost.
[quoted text, click to view] "DragonVic" wrote:
> Yes, it is running against SQL Server, one way to recreate this problem is to
> query a somewhat large result in the data window then hide the data to work
> with scripts or the diagram window, if you wait long enough or go to the
> design window and work for a while, the result set that was queried will
> cause the system to halt, it opens an invisible dialog window that cannot be
> closed, therefore freezing the program and any unsaved work that goes with it.
>
> "Bruce L-C [MVP]" wrote:
>
> > Are you going against SQL Server? I have never seen this. What I have seen
> > (and is a bug) is that RS sometimes does not automatically save or does not
> > realize the query has changed. The work around is to go to the layout and
> > save. So, if I make a change in the data tab, I go to the layout tab and
> > save.
> >
> > Not really sure what is different about what you are doing but this thread
> > is the first I have seen of this on the newsgroups (in all the months since
> > release).
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
>
> "Edward" wrote:
>
> > I HAVE THE SAME PROBLEM!!!! FREAKING IRRITATING!!
>
>
> > "DragonVic" <DragonVic@discussions.microsoft.com> wrote in message
> > news:841FDF08-6D95-49FD-AED2-9F30CF62F263@microsoft.com...
> > > No, I haven't found a fix for it, I keep getting ignored, I am sick and
> > > tired
> > > of this BUG, I love Reporting Services, but it is costing me time and it
> > > is
> > > going to make it very difficult to convince my Boss that Reporting
> > > Services
> > > is "the" reporting tool.
> > >
> > > "MJ Taft" wrote:
> > >
> > >> DID YOU GET A FIX FOR IT??? I have been having the problem too but I
> > >> have
> > >> been blaming it on visual studio!!! Now I think you're on to
> > >> something!!!
> > >> Have you called microsoft (since it appears no one here has answered
> > >> yet). I
> > >> am VERY interested in this because I am not able to save the files that I
> > >> have been working on ... and YES .. I save OFTEN ... still doesnt help.
> > >> Maybe a memory leak????
> > >>
> > >> "DragonVic" wrote:
> > >>
> > >> > ditto: Ihave had the same problem and come to the same conclusion as
> > >> > dragonvic regarding the invisible window ...
> > >> >
> > >> > "DragonVic" wrote:
> > >> >
> > >> > > I need to re-poen this issue and would like to get immediate
> > >> > > attention on this.
> > >> > > Please see history below.
> > >> > >
> > >> > > "DragonVic" wrote:
> > >> > >
> > >> > > > I need to know if you've had other cases like this, and just tell
> > >> > > > me how to
> > >> > > > fix it for Windows XP Professional, everytime I query data in the
> > >> > > > data
> > >> > > > window and then proceed in design mode, a dialog box comes to life
> > >> > > > (not
> > >> > > > visible), probably asking to close the query to minimize overhead
> > >> > > > like SQL
> > >> > > > Enterprize does, however, this window seems to be blocked by
> > >> > > > another process
> > >> > > > and cannot be seen or accessed, causing the application to stop and
> > >> > > > eventually losing all unsaved work. This has been going on for a
> > >> > > > long time
> > >> > > > already, I thought that the service packs would have fixed that.
> > >> > > > This needs
> > >> > > > immediate attention.
> > >> > > >
> > >> > > > VZ
> > >> > > >
> > >> > > > "DragonVic" wrote:
> > >> > > >
> > >> > > > > I already installed SP1 and SP2 for Reporting Services,
> > >> > > > > why do I need SP1 for Windows 2003 if I am not using 2003?
> > >> > > > >
> > >> > > > > The system still haults!!!
> > >> > > > >
> > >> > > > > VZ
> > >> > > > >
> > >> > > > > "kowalsky" wrote:
> > >> > > > >
> > >> > > > > > i was talking about SERVICE PACKS:
> > >> > > > > >
> > >> > > > > > there is a SP1(service pack 1) for Windows 2003 and a
> > >> > > > > > SP2(service pack 2)
> > >> > > > > > for Microsoft Reporting Services. Also check if you have all
> > >> > > > > > Updates
> > >> > > > > > installed (if you do that first, you will probably be advised
> > >> > > > > > to install SP1
> > >> > > > > > for W2K3 anyway).
> > >> > > > > >
> > >> > > > > > kowalsky
> > >> > > > > >
> > >> > > > > > "DragonVic" wrote:
> > >> > > > > >
> > >> > > > > > > Reporting Services is still freezing up, on a daily basis,
> > >> > > > > > > should I report
> > >> > > > > > > this problem with someone else? This is pretty serious, I
> > >> > > > > > > keep losing files!!
> > >> > > > > > >
> > >> > > > > > > VZ
> > >> > > > > > >
> > >> > > > > > > "DragonVic" wrote:
> > >> > > > > > >
> > >> > > > > > > > This is the version I have...
> > >> > > > > > > >
> > >> > > > > > > > Microsoft SQL Server Reporting Services Version 8.00.743.00
> > >> > > > > > > >
> > >> > > > > > > > I beleive it is the latest.
> > >> > > > > > > >
> > >> > > > > > > > VZ
> > >> > > > > > > >
> > >> > > > > > > >
> > >> > > > > > > >
> > >> > > > > > > > "kowalsky" wrote:
> > >> > > > > > > >
> > >> > > > > > > > > there is be a SP1 for W2K3 and a SP2 for MRS; have you
> > >> > > > > > > > > checked if you got
> > >> > > > > > > > > these?
> > >> > > > > > > > >
> > >> > > > > > > > > kowalsky
> > >> > > > > > > > >
> > >> > > > > > > > > "DragonVic" wrote:
> > >> > > > > > > > >
> > >> > > > > > > > > > Everyday since I have gotten SRS, it freezes up and
> > >> > > > > > > > > > cannot save or close it.
> > >> > > > > > > > > > When I attempt to close it with ALT+F4, I get the
> > >> > > > > > > > > > following error message...
> > >> > > > > > > > > >
> > >> > > > > > > > > > "Microsoft Development Environment cannot shut down
> > >> > > > > > > > > > because a modal dialog
> > >> > > > > > > > > > is active. Close the dialog and try again"
> > >> > > > > > > > > >
> > >> > > > > > > > > > The dialog is not visible to be closed, I do not see it
> > >> > > > > > > > > > on the task manager,
> > >> > > > > > > > > > I do not not which service it uses to kill it, the only
> > >> > > > > > > > > > thin I can do is to
> > >> > > > > > > > > > KILL SRS and lose my work in progress, this is a very
> > >> > > > > > > > > > anoying bug, I keep
> > >> > > > > > > > > > losing valuable time spent.
> > >> > > > > > > > > >
> > >> > > > > > > > > > Is there a patch for this? I know I am not the only
> > >> > > > > > > > > > one, because it has
> > >> > > > > > > > > > happened to me for ove a year now, in multiple
> > >> > > > > > > > > > computers, so it is not my
> > >> > > > > > > > > > computer.
> > >> > > > > > > > > >
> > >> > > > > > > > > > Please respond to this one, this is important to all
Don't see what you're looking for? Try a search.