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.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Issues Running SubReports

Author  Topic 

pareshmotiwala
Constraint Violating Yak Guru

323 Posts

Posted - 2011-03-08 : 09:00:57
Team
I have a report1, that in turn calls report2. on SQL 2008 Rel 1.(no sp) running on Windows 2008 Server.
At this point in time it creates a whole bunch of blockages with reportserver.dbo.writelocksession and reportserver.dbo.createchunksegment.

Needless to say haven't found anything meaningful on MSDN or otehr places.

Has any one run into this problem and solved it without a brain surgery?
It also gave an error message to the tune of "An error occurred within report server database. This may be due to a connection failure, timeout or low disk condition within the database. For more information about this error navigate to the report server on the local server machine, or enable remote errors."

Any help is welcome.
Cheers

Regards
Paresh Motiwala
Boston, USA

pareshmotiwala
Constraint Violating Yak Guru

323 Posts

Posted - 2011-03-10 : 11:02:13
let me ask a more generic part of the question again
on a sql 2008 box, a large report creates a whole bunch of blockages with reportserver.dbo.writelocksession and reportserver.dbo.createchunksegment.
anybody experience this?

Regards
Paresh Motiwala
Boston, USA
Go to Top of Page
   

- Advertisement -