If a report (report A) is set-up for caching and is then used in another
report (report B) as a sub-report, will report A be rendered from cache when
report B is executed?It should be if it is using stored credentials and there is no change in an
query parameters in Report A. As proof, set it to run from a snapshot, it
is the same concept.
--
Douglas McDowell douglas@.nospam.solidqualitylearning.com
"PD" <PD@.discussions.microsoft.com> wrote in message
news:4D8062AC-709B-485C-A63C-502DA2B5AAA4@.microsoft.com...
> If a report (report A) is set-up for caching and is then used in another
> report (report B) as a sub-report, will report A be rendered from cache
> when
> report B is executed?
Showing posts with label caching. Show all posts
Showing posts with label caching. Show all posts
Friday, March 23, 2012
Report Caching
When I attempt to set up an snapshot execution I get this error when clicking
the execution link:
Invalid object name 'ReportServersTempDB.dbo.ExecutionCache'
Background:
IIS running on - Pentium, Server 2003, 1.8GHz
SQL is on - Itanium, Server 2003 64 bit
As far as I've seen everything else is working fine.
ThanksDoes the ReportServersTempDB exists? Are the objects owned by dbo? If they
are not you will need to change the owner to dbo.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
news:C2693B9F-4A0B-44B5-A355-4B9F85DC4C57@.microsoft.com...
> When I attempt to set up an snapshot execution I get this error when
clicking
> the execution link:
> Invalid object name 'ReportServersTempDB.dbo.ExecutionCache'
> Background:
> IIS running on - Pentium, Server 2003, 1.8GHz
> SQL is on - Itanium, Server 2003 64 bit
> As far as I've seen everything else is working fine.
> Thanks|||Sorry - figured it out - the operator ran rsconfig with the TEMPdb and had a
typo.
"Daniel Reib [MSFT]" wrote:
> Does the ReportServersTempDB exists? Are the objects owned by dbo? If they
> are not you will need to change the owner to dbo.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> news:C2693B9F-4A0B-44B5-A355-4B9F85DC4C57@.microsoft.com...
> > When I attempt to set up an snapshot execution I get this error when
> clicking
> > the execution link:
> >
> > Invalid object name 'ReportServersTempDB.dbo.ExecutionCache'
> >
> > Background:
> >
> > IIS running on - Pentium, Server 2003, 1.8GHz
> > SQL is on - Itanium, Server 2003 64 bit
> >
> > As far as I've seen everything else is working fine.
> > Thanks
>
>|||I was wrong again - it is not fixed. The typo is ReportServersTempDB instead
of ReportServerTempDB (extra s before temp). I can't find where this is
stored. The database is correctly named and this is clearly the problem -
where is this name registered'
Since I didn't do the installation I'm not sure where it came from - we've
got a 64 bit box so the install was not traditional.
"NPShinn" wrote:
> Sorry - figured it out - the operator ran rsconfig with the TEMPdb and had a
> typo.
> "Daniel Reib [MSFT]" wrote:
> > Does the ReportServersTempDB exists? Are the objects owned by dbo? If they
> > are not you will need to change the owner to dbo.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> > news:C2693B9F-4A0B-44B5-A355-4B9F85DC4C57@.microsoft.com...
> > > When I attempt to set up an snapshot execution I get this error when
> > clicking
> > > the execution link:
> > >
> > > Invalid object name 'ReportServersTempDB.dbo.ExecutionCache'
> > >
> > > Background:
> > >
> > > IIS running on - Pentium, Server 2003, 1.8GHz
> > > SQL is on - Itanium, Server 2003 64 bit
> > >
> > > As far as I've seen everything else is working fine.
> > > Thanks
> >
> >
> >|||The easiest thing for you to do is rename your TempDB to
ReportServersTempDB. This should get you past this problem.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
news:063F8602-5ADE-41FD-AF52-2DD35669B691@.microsoft.com...
> I was wrong again - it is not fixed. The typo is ReportServersTempDB
instead
> of ReportServerTempDB (extra s before temp). I can't find where this is
> stored. The database is correctly named and this is clearly the problem -
> where is this name registered'
> Since I didn't do the installation I'm not sure where it came from - we've
> got a 64 bit box so the install was not traditional.
> "NPShinn" wrote:
> > Sorry - figured it out - the operator ran rsconfig with the TEMPdb and
had a
> > typo.
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> > > Does the ReportServersTempDB exists? Are the objects owned by dbo?
If they
> > > are not you will need to change the owner to dbo.
> > >
> > > --
> > > -Daniel
> > > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > >
> > >
> > > "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> > > news:C2693B9F-4A0B-44B5-A355-4B9F85DC4C57@.microsoft.com...
> > > > When I attempt to set up an snapshot execution I get this error when
> > > clicking
> > > > the execution link:
> > > >
> > > > Invalid object name 'ReportServersTempDB.dbo.ExecutionCache'
> > > >
> > > > Background:
> > > >
> > > > IIS running on - Pentium, Server 2003, 1.8GHz
> > > > SQL is on - Itanium, Server 2003 64 bit
> > > >
> > > > As far as I've seen everything else is working fine.
> > > > Thanks
> > >
> > >
> > >|||What about all of the stored procedures that point to ReportServerTempDB? I
think I will have many places to change the name.
The box is brand new, we could reinstall especially since the dbs are on a
different server.
"Daniel Reib [MSFT]" wrote:
> The easiest thing for you to do is rename your TempDB to
> ReportServersTempDB. This should get you past this problem.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> news:063F8602-5ADE-41FD-AF52-2DD35669B691@.microsoft.com...
> > I was wrong again - it is not fixed. The typo is ReportServersTempDB
> instead
> > of ReportServerTempDB (extra s before temp). I can't find where this is
> > stored. The database is correctly named and this is clearly the problem -
> > where is this name registered'
> >
> > Since I didn't do the installation I'm not sure where it came from - we've
> > got a 64 bit box so the install was not traditional.
> >
> > "NPShinn" wrote:
> >
> > > Sorry - figured it out - the operator ran rsconfig with the TEMPdb and
> had a
> > > typo.
> > >
> > > "Daniel Reib [MSFT]" wrote:
> > >
> > > > Does the ReportServersTempDB exists? Are the objects owned by dbo?
> If they
> > > > are not you will need to change the owner to dbo.
> > > >
> > > > --
> > > > -Daniel
> > > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > >
> > > >
> > > > "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> > > > news:C2693B9F-4A0B-44B5-A355-4B9F85DC4C57@.microsoft.com...
> > > > > When I attempt to set up an snapshot execution I get this error when
> > > > clicking
> > > > > the execution link:
> > > > >
> > > > > Invalid object name 'ReportServersTempDB.dbo.ExecutionCache'
> > > > >
> > > > > Background:
> > > > >
> > > > > IIS running on - Pentium, Server 2003, 1.8GHz
> > > > > SQL is on - Itanium, Server 2003 64 bit
> > > > >
> > > > > As far as I've seen everything else is working fine.
> > > > > Thanks
> > > >
> > > >
> > > >
>
>|||It sounds like the SPs are already pointing to that DB, isn't that the error
you are receiving?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
news:7F0166CD-1852-4A2F-BD3E-3F00C6E59A00@.microsoft.com...
> What about all of the stored procedures that point to ReportServerTempDB?
I
> think I will have many places to change the name.
> The box is brand new, we could reinstall especially since the dbs are on a
> different server.
> "Daniel Reib [MSFT]" wrote:
> > The easiest thing for you to do is rename your TempDB to
> > ReportServersTempDB. This should get you past this problem.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> > news:063F8602-5ADE-41FD-AF52-2DD35669B691@.microsoft.com...
> > > I was wrong again - it is not fixed. The typo is ReportServersTempDB
> > instead
> > > of ReportServerTempDB (extra s before temp). I can't find where this
is
> > > stored. The database is correctly named and this is clearly the
problem -
> > > where is this name registered'
> > >
> > > Since I didn't do the installation I'm not sure where it came from -
we've
> > > got a 64 bit box so the install was not traditional.
> > >
> > > "NPShinn" wrote:
> > >
> > > > Sorry - figured it out - the operator ran rsconfig with the TEMPdb
and
> > had a
> > > > typo.
> > > >
> > > > "Daniel Reib [MSFT]" wrote:
> > > >
> > > > > Does the ReportServersTempDB exists? Are the objects owned by
dbo?
> > If they
> > > > > are not you will need to change the owner to dbo.
> > > > >
> > > > > --
> > > > > -Daniel
> > > > > This posting is provided "AS IS" with no warranties, and confers
no
> > rights.
> > > > >
> > > > >
> > > > > "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> > > > > news:C2693B9F-4A0B-44B5-A355-4B9F85DC4C57@.microsoft.com...
> > > > > > When I attempt to set up an snapshot execution I get this error
when
> > > > > clicking
> > > > > > the execution link:
> > > > > >
> > > > > > Invalid object name 'ReportServersTempDB.dbo.ExecutionCache'
> > > > > >
> > > > > > Background:
> > > > > >
> > > > > > IIS running on - Pentium, Server 2003, 1.8GHz
> > > > > > SQL is on - Itanium, Server 2003 64 bit
> > > > > >
> > > > > > As far as I've seen everything else is working fine.
> > > > > > Thanks
> > > > >
> > > > >
> > > > >
> >
> >
> >|||None of the stored procedures in ReportServer point to the typo - they are
all correct. here is something from the log file:
w3wp!library!924!09/30/2004-10:25:01:: i INFO: Call to
GetPermissions:/Public/WalMartReportNew
w3wp!library!d64!09/30/2004-10:25:01:: i INFO: Call to GetSystemPermissions
w3wp!library!924!09/30/2004-10:25:01:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Data.SqlClient.SqlException: Invalid object name
'ReportServersTempDB.dbo.ExecutionCache'.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at
Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery()
at
Microsoft.ReportingServices.Library.SchedulingDBInterface.UpdateTaskProperties(Task task, Boolean updateSqlAgentSchedule)
at
Microsoft.ReportingServices.Library.SchedulingDBInterface.SetSchedulesNextRunTime(Task t)
at
Microsoft.ReportingServices.Library.SchedulingDBInterface.CheckTasksNextRunTime(Task t)
at Microsoft.ReportingServices.Library.SchedulingDBInterface.ListTasks()
at
Microsoft.ReportingServices.Library.ScheduleCoordinator.ListTasksAsArray()
at Microsoft.ReportingServices.Library.RSService.ListSchedules()
-- End of inner exception stack trace --
"Daniel Reib [MSFT]" wrote:
> It sounds like the SPs are already pointing to that DB, isn't that the error
> you are receiving?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> news:7F0166CD-1852-4A2F-BD3E-3F00C6E59A00@.microsoft.com...
> > What about all of the stored procedures that point to ReportServerTempDB?
> I
> > think I will have many places to change the name.
> >
> > The box is brand new, we could reinstall especially since the dbs are on a
> > different server.
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> > > The easiest thing for you to do is rename your TempDB to
> > > ReportServersTempDB. This should get you past this problem.
> > >
> > > --
> > > -Daniel
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> > > news:063F8602-5ADE-41FD-AF52-2DD35669B691@.microsoft.com...
> > > > I was wrong again - it is not fixed. The typo is ReportServersTempDB
> > > instead
> > > > of ReportServerTempDB (extra s before temp). I can't find where this
> is
> > > > stored. The database is correctly named and this is clearly the
> problem -
> > > > where is this name registered'
> > > >
> > > > Since I didn't do the installation I'm not sure where it came from -
> we've
> > > > got a 64 bit box so the install was not traditional.
> > > >
> > > > "NPShinn" wrote:
> > > >
> > > > > Sorry - figured it out - the operator ran rsconfig with the TEMPdb
> and
> > > had a
> > > > > typo.
> > > > >
> > > > > "Daniel Reib [MSFT]" wrote:
> > > > >
> > > > > > Does the ReportServersTempDB exists? Are the objects owned by
> dbo?
> > > If they
> > > > > > are not you will need to change the owner to dbo.
> > > > > >
> > > > > > --
> > > > > > -Daniel
> > > > > > This posting is provided "AS IS" with no warranties, and confers
> no
> > > rights.
> > > > > >
> > > > > >
> > > > > > "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> > > > > > news:C2693B9F-4A0B-44B5-A355-4B9F85DC4C57@.microsoft.com...
> > > > > > > When I attempt to set up an snapshot execution I get this error
> when
> > > > > > clicking
> > > > > > > the execution link:
> > > > > > >
> > > > > > > Invalid object name 'ReportServersTempDB.dbo.ExecutionCache'
> > > > > > >
> > > > > > > Background:
> > > > > > >
> > > > > > > IIS running on - Pentium, Server 2003, 1.8GHz
> > > > > > > SQL is on - Itanium, Server 2003 64 bit
> > > > > > >
> > > > > > > As far as I've seen everything else is working fine.
> > > > > > > Thanks
> > > > > >
> > > > > >
> > > > > >
> > >
> > >
> > >
>
>|||The thing is we don't store this name anywhere. It is only referenced via
the SPs, so some sp is referring to the wrong DB.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
news:9BF8553B-2CC1-427D-BE45-F2E6CD9505C2@.microsoft.com...
> None of the stored procedures in ReportServer point to the typo - they are
> all correct. here is something from the log file:
> w3wp!library!924!09/30/2004-10:25:01:: i INFO: Call to
> GetPermissions:/Public/WalMartReportNew
> w3wp!library!d64!09/30/2004-10:25:01:: i INFO: Call to
GetSystemPermissions
> w3wp!library!924!09/30/2004-10:25:01:: e ERROR: Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details., ;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details. --> System.Data.SqlClient.SqlException: Invalid object name
> 'ReportServersTempDB.dbo.ExecutionCache'.
> at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
> at
>
Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery()
> at
>
Microsoft.ReportingServices.Library.SchedulingDBInterface.UpdateTaskProperti
es(Task task, Boolean updateSqlAgentSchedule)
> at
>
Microsoft.ReportingServices.Library.SchedulingDBInterface.SetSchedulesNextRu
nTime(Task t)
> at
>
Microsoft.ReportingServices.Library.SchedulingDBInterface.CheckTasksNextRunT
ime(Task t)
> at
Microsoft.ReportingServices.Library.SchedulingDBInterface.ListTasks()
> at
> Microsoft.ReportingServices.Library.ScheduleCoordinator.ListTasksAsArray()
> at Microsoft.ReportingServices.Library.RSService.ListSchedules()
> -- End of inner exception stack trace --
>
> "Daniel Reib [MSFT]" wrote:
> > It sounds like the SPs are already pointing to that DB, isn't that the
error
> > you are receiving?
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> > news:7F0166CD-1852-4A2F-BD3E-3F00C6E59A00@.microsoft.com...
> > > What about all of the stored procedures that point to
ReportServerTempDB?
> > I
> > > think I will have many places to change the name.
> > >
> > > The box is brand new, we could reinstall especially since the dbs are
on a
> > > different server.
> > >
> > > "Daniel Reib [MSFT]" wrote:
> > >
> > > > The easiest thing for you to do is rename your TempDB to
> > > > ReportServersTempDB. This should get you past this problem.
> > > >
> > > > --
> > > > -Daniel
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > >
> > > >
> > > > "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> > > > news:063F8602-5ADE-41FD-AF52-2DD35669B691@.microsoft.com...
> > > > > I was wrong again - it is not fixed. The typo is
ReportServersTempDB
> > > > instead
> > > > > of ReportServerTempDB (extra s before temp). I can't find where
this
> > is
> > > > > stored. The database is correctly named and this is clearly the
> > problem -
> > > > > where is this name registered'
> > > > >
> > > > > Since I didn't do the installation I'm not sure where it came
from -
> > we've
> > > > > got a 64 bit box so the install was not traditional.
> > > > >
> > > > > "NPShinn" wrote:
> > > > >
> > > > > > Sorry - figured it out - the operator ran rsconfig with the
TEMPdb
> > and
> > > > had a
> > > > > > typo.
> > > > > >
> > > > > > "Daniel Reib [MSFT]" wrote:
> > > > > >
> > > > > > > Does the ReportServersTempDB exists? Are the objects owned by
> > dbo?
> > > > If they
> > > > > > > are not you will need to change the owner to dbo.
> > > > > > >
> > > > > > > --
> > > > > > > -Daniel
> > > > > > > This posting is provided "AS IS" with no warranties, and
confers
> > no
> > > > rights.
> > > > > > >
> > > > > > >
> > > > > > > "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> > > > > > > news:C2693B9F-4A0B-44B5-A355-4B9F85DC4C57@.microsoft.com...
> > > > > > > > When I attempt to set up an snapshot execution I get this
error
> > when
> > > > > > > clicking
> > > > > > > > the execution link:
> > > > > > > >
> > > > > > > > Invalid object name 'ReportServersTempDB.dbo.ExecutionCache'
> > > > > > > >
> > > > > > > > Background:
> > > > > > > >
> > > > > > > > IIS running on - Pentium, Server 2003, 1.8GHz
> > > > > > > > SQL is on - Itanium, Server 2003 64 bit
> > > > > > > >
> > > > > > > > As far as I've seen everything else is working fine.
> > > > > > > > Thanks
> > > > > > >
> > > > > > >
> > > > > > >
> > > >
> > > >
> > > >
> >
> >
> >|||We ended up reinstalling - twice - to resolve our problem. It did point out
an odd thing. Since we're using a 64 bit server, they installed RS by
pointing at our 32 bit development box. Since RS dbs are already on that
box, the operator changed the names of the new dbs to ReportServers and
ReportServersTempDB. The second time he did the install he named them
ReportServer2 and ReportServer2TempDB.
These dbs had to be backed up and restored onto the 64 bit box and thats
when the error change looking for ReportServer2TempDB. So...I went in and
replaced ReportServer2Tempdb back to ReportServerTempdb inall of the stored
procedures. It didn't help, even after restarting all services on both boxes,
with no reference to ReportServer2TempDB in any sp, it was still looking for
it.
We finally solved the problem by installing onto a box that didn't have RS
on it so that we could name the databases correctly. Overall, al pretty odd
day.
If I've left anything out, feel free to ask.
Nancy Shinn
"Daniel Reib [MSFT]" wrote:
> The thing is we don't store this name anywhere. It is only referenced via
> the SPs, so some sp is referring to the wrong DB.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> news:9BF8553B-2CC1-427D-BE45-F2E6CD9505C2@.microsoft.com...
> > None of the stored procedures in ReportServer point to the typo - they are
> > all correct. here is something from the log file:
> >
> > w3wp!library!924!09/30/2004-10:25:01:: i INFO: Call to
> > GetPermissions:/Public/WalMartReportNew
> > w3wp!library!d64!09/30/2004-10:25:01:: i INFO: Call to
> GetSystemPermissions
> > w3wp!library!924!09/30/2004-10:25:01:: e ERROR: Throwing
> >
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > An internal error occurred on the report server. See the error log for
> more
> > details., ;
> > Info:
> >
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > An internal error occurred on the report server. See the error log for
> more
> > details. --> System.Data.SqlClient.SqlException: Invalid object name
> > 'ReportServersTempDB.dbo.ExecutionCache'.
> > at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
> > cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
> > at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
> > at
> >
> Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery()
> > at
> >
> Microsoft.ReportingServices.Library.SchedulingDBInterface.UpdateTaskProperti
> es(Task task, Boolean updateSqlAgentSchedule)
> > at
> >
> Microsoft.ReportingServices.Library.SchedulingDBInterface.SetSchedulesNextRu
> nTime(Task t)
> > at
> >
> Microsoft.ReportingServices.Library.SchedulingDBInterface.CheckTasksNextRunT
> ime(Task t)
> > at
> Microsoft.ReportingServices.Library.SchedulingDBInterface.ListTasks()
> > at
> > Microsoft.ReportingServices.Library.ScheduleCoordinator.ListTasksAsArray()
> > at Microsoft.ReportingServices.Library.RSService.ListSchedules()
> > -- End of inner exception stack trace --
> >
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> > > It sounds like the SPs are already pointing to that DB, isn't that the
> error
> > > you are receiving?
> > >
> > > --
> > > -Daniel
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> > > news:7F0166CD-1852-4A2F-BD3E-3F00C6E59A00@.microsoft.com...
> > > > What about all of the stored procedures that point to
> ReportServerTempDB?
> > > I
> > > > think I will have many places to change the name.
> > > >
> > > > The box is brand new, we could reinstall especially since the dbs are
> on a
> > > > different server.
> > > >
> > > > "Daniel Reib [MSFT]" wrote:
> > > >
> > > > > The easiest thing for you to do is rename your TempDB to
> > > > > ReportServersTempDB. This should get you past this problem.
> > > > >
> > > > > --
> > > > > -Daniel
> > > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > > >
> > > > >
> > > > > "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> > > > > news:063F8602-5ADE-41FD-AF52-2DD35669B691@.microsoft.com...
> > > > > > I was wrong again - it is not fixed. The typo is
> ReportServersTempDB
> > > > > instead
> > > > > > of ReportServerTempDB (extra s before temp). I can't find where
> this
> > > is
> > > > > > stored. The database is correctly named and this is clearly the
> > > problem -
> > > > > > where is this name registered'
> > > > > >
> > > > > > Since I didn't do the installation I'm not sure where it came
> from -
> > > we've
> > > > > > got a 64 bit box so the install was not traditional.
> > > > > >
> > > > > > "NPShinn" wrote:
> > > > > >
> > > > > > > Sorry - figured it out - the operator ran rsconfig with the
> TEMPdb
> > > and
> > > > > had a
> > > > > > > typo.
> > > > > > >
> > > > > > > "Daniel Reib [MSFT]" wrote:
> > > > > > >
> > > > > > > > Does the ReportServersTempDB exists? Are the objects owned by
> > > dbo?
> > > > > If they
> > > > > > > > are not you will need to change the owner to dbo.
> > > > > > > >
> > > > > > > > --
> > > > > > > > -Daniel
> > > > > > > > This posting is provided "AS IS" with no warranties, and
> confers
> > > no
> > > > > rights.
> > > > > > > >
> > > > > > > >
> > > > > > > > "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> > > > > > > > news:C2693B9F-4A0B-44B5-A355-4B9F85DC4C57@.microsoft.com...
> > > > > > > > > When I attempt to set up an snapshot execution I get this
> error
> > > when
> > > > > > > > clicking
> > > > > > > > > the execution link:
> > > > > > > > >
> > > > > > > > > Invalid object name 'ReportServersTempDB.dbo.ExecutionCache'
> > > > > > > > >
> > > > > > > > > Background:
> > > > > > > > >
> > > > > > > > > IIS running on - Pentium, Server 2003, 1.8GHz
> > > > > > > > > SQL is on - Itanium, Server 2003 64 bit
> > > > > > > > >
> > > > > > > > > As far as I've seen everything else is working fine.
> > > > > > > > > Thanks
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>|||At some point you ran rsconfig correct? If not then you were never pointing
at the new DBs. Other then that I am really stumped as to why it didn't
work.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
news:17E68A5B-97AF-4455-AB84-0F78BDA375B0@.microsoft.com...
> We ended up reinstalling - twice - to resolve our problem. It did point
out
> an odd thing. Since we're using a 64 bit server, they installed RS by
> pointing at our 32 bit development box. Since RS dbs are already on that
> box, the operator changed the names of the new dbs to ReportServers and
> ReportServersTempDB. The second time he did the install he named them
> ReportServer2 and ReportServer2TempDB.
> These dbs had to be backed up and restored onto the 64 bit box and thats
> when the error change looking for ReportServer2TempDB. So...I went in and
> replaced ReportServer2Tempdb back to ReportServerTempdb inall of the
stored
> procedures. It didn't help, even after restarting all services on both
boxes,
> with no reference to ReportServer2TempDB in any sp, it was still looking
for
> it.
> We finally solved the problem by installing onto a box that didn't have RS
> on it so that we could name the databases correctly. Overall, al pretty
odd
> day.
> If I've left anything out, feel free to ask.
> Nancy Shinn
> "Daniel Reib [MSFT]" wrote:
> > The thing is we don't store this name anywhere. It is only referenced
via
> > the SPs, so some sp is referring to the wrong DB.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> > news:9BF8553B-2CC1-427D-BE45-F2E6CD9505C2@.microsoft.com...
> > > None of the stored procedures in ReportServer point to the typo - they
are
> > > all correct. here is something from the log file:
> > >
> > > w3wp!library!924!09/30/2004-10:25:01:: i INFO: Call to
> > > GetPermissions:/Public/WalMartReportNew
> > > w3wp!library!d64!09/30/2004-10:25:01:: i INFO: Call to
> > GetSystemPermissions
> > > w3wp!library!924!09/30/2004-10:25:01:: e ERROR: Throwing
> > >
> >
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > > An internal error occurred on the report server. See the error log for
> > more
> > > details., ;
> > > Info:
> > >
> >
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > > An internal error occurred on the report server. See the error log for
> > more
> > > details. --> System.Data.SqlClient.SqlException: Invalid object name
> > > 'ReportServersTempDB.dbo.ExecutionCache'.
> > > at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
> > > cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
> > > at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
> > > at
> > >
> >
Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery()
> > > at
> > >
> >
Microsoft.ReportingServices.Library.SchedulingDBInterface.UpdateTaskProperti
> > es(Task task, Boolean updateSqlAgentSchedule)
> > > at
> > >
> >
Microsoft.ReportingServices.Library.SchedulingDBInterface.SetSchedulesNextRu
> > nTime(Task t)
> > > at
> > >
> >
Microsoft.ReportingServices.Library.SchedulingDBInterface.CheckTasksNextRunT
> > ime(Task t)
> > > at
> > Microsoft.ReportingServices.Library.SchedulingDBInterface.ListTasks()
> > > at
> > >
Microsoft.ReportingServices.Library.ScheduleCoordinator.ListTasksAsArray()
> > > at Microsoft.ReportingServices.Library.RSService.ListSchedules()
> > > -- End of inner exception stack trace --
> > >
> > >
> > > "Daniel Reib [MSFT]" wrote:
> > >
> > > > It sounds like the SPs are already pointing to that DB, isn't that
the
> > error
> > > > you are receiving?
> > > >
> > > > --
> > > > -Daniel
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > >
> > > >
> > > > "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> > > > news:7F0166CD-1852-4A2F-BD3E-3F00C6E59A00@.microsoft.com...
> > > > > What about all of the stored procedures that point to
> > ReportServerTempDB?
> > > > I
> > > > > think I will have many places to change the name.
> > > > >
> > > > > The box is brand new, we could reinstall especially since the dbs
are
> > on a
> > > > > different server.
> > > > >
> > > > > "Daniel Reib [MSFT]" wrote:
> > > > >
> > > > > > The easiest thing for you to do is rename your TempDB to
> > > > > > ReportServersTempDB. This should get you past this problem.
> > > > > >
> > > > > > --
> > > > > > -Daniel
> > > > > > This posting is provided "AS IS" with no warranties, and confers
no
> > > > rights.
> > > > > >
> > > > > >
> > > > > > "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> > > > > > news:063F8602-5ADE-41FD-AF52-2DD35669B691@.microsoft.com...
> > > > > > > I was wrong again - it is not fixed. The typo is
> > ReportServersTempDB
> > > > > > instead
> > > > > > > of ReportServerTempDB (extra s before temp). I can't find
where
> > this
> > > > is
> > > > > > > stored. The database is correctly named and this is clearly
the
> > > > problem -
> > > > > > > where is this name registered'
> > > > > > >
> > > > > > > Since I didn't do the installation I'm not sure where it came
> > from -
> > > > we've
> > > > > > > got a 64 bit box so the install was not traditional.
> > > > > > >
> > > > > > > "NPShinn" wrote:
> > > > > > >
> > > > > > > > Sorry - figured it out - the operator ran rsconfig with the
> > TEMPdb
> > > > and
> > > > > > had a
> > > > > > > > typo.
> > > > > > > >
> > > > > > > > "Daniel Reib [MSFT]" wrote:
> > > > > > > >
> > > > > > > > > Does the ReportServersTempDB exists? Are the objects
owned by
> > > > dbo?
> > > > > > If they
> > > > > > > > > are not you will need to change the owner to dbo.
> > > > > > > > >
> > > > > > > > > --
> > > > > > > > > -Daniel
> > > > > > > > > This posting is provided "AS IS" with no warranties, and
> > confers
> > > > no
> > > > > > rights.
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in
message
> > > > > > > > > news:C2693B9F-4A0B-44B5-A355-4B9F85DC4C57@.microsoft.com...
> > > > > > > > > > When I attempt to set up an snapshot execution I get
this
> > error
> > > > when
> > > > > > > > > clicking
> > > > > > > > > > the execution link:
> > > > > > > > > >
> > > > > > > > > > Invalid object name
'ReportServersTempDB.dbo.ExecutionCache'
> > > > > > > > > >
> > > > > > > > > > Background:
> > > > > > > > > >
> > > > > > > > > > IIS running on - Pentium, Server 2003, 1.8GHz
> > > > > > > > > > SQL is on - Itanium, Server 2003 64 bit
> > > > > > > > > >
> > > > > > > > > > As far as I've seen everything else is working fine.
> > > > > > > > > > Thanks
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >
the execution link:
Invalid object name 'ReportServersTempDB.dbo.ExecutionCache'
Background:
IIS running on - Pentium, Server 2003, 1.8GHz
SQL is on - Itanium, Server 2003 64 bit
As far as I've seen everything else is working fine.
ThanksDoes the ReportServersTempDB exists? Are the objects owned by dbo? If they
are not you will need to change the owner to dbo.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
news:C2693B9F-4A0B-44B5-A355-4B9F85DC4C57@.microsoft.com...
> When I attempt to set up an snapshot execution I get this error when
clicking
> the execution link:
> Invalid object name 'ReportServersTempDB.dbo.ExecutionCache'
> Background:
> IIS running on - Pentium, Server 2003, 1.8GHz
> SQL is on - Itanium, Server 2003 64 bit
> As far as I've seen everything else is working fine.
> Thanks|||Sorry - figured it out - the operator ran rsconfig with the TEMPdb and had a
typo.
"Daniel Reib [MSFT]" wrote:
> Does the ReportServersTempDB exists? Are the objects owned by dbo? If they
> are not you will need to change the owner to dbo.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> news:C2693B9F-4A0B-44B5-A355-4B9F85DC4C57@.microsoft.com...
> > When I attempt to set up an snapshot execution I get this error when
> clicking
> > the execution link:
> >
> > Invalid object name 'ReportServersTempDB.dbo.ExecutionCache'
> >
> > Background:
> >
> > IIS running on - Pentium, Server 2003, 1.8GHz
> > SQL is on - Itanium, Server 2003 64 bit
> >
> > As far as I've seen everything else is working fine.
> > Thanks
>
>|||I was wrong again - it is not fixed. The typo is ReportServersTempDB instead
of ReportServerTempDB (extra s before temp). I can't find where this is
stored. The database is correctly named and this is clearly the problem -
where is this name registered'
Since I didn't do the installation I'm not sure where it came from - we've
got a 64 bit box so the install was not traditional.
"NPShinn" wrote:
> Sorry - figured it out - the operator ran rsconfig with the TEMPdb and had a
> typo.
> "Daniel Reib [MSFT]" wrote:
> > Does the ReportServersTempDB exists? Are the objects owned by dbo? If they
> > are not you will need to change the owner to dbo.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> > news:C2693B9F-4A0B-44B5-A355-4B9F85DC4C57@.microsoft.com...
> > > When I attempt to set up an snapshot execution I get this error when
> > clicking
> > > the execution link:
> > >
> > > Invalid object name 'ReportServersTempDB.dbo.ExecutionCache'
> > >
> > > Background:
> > >
> > > IIS running on - Pentium, Server 2003, 1.8GHz
> > > SQL is on - Itanium, Server 2003 64 bit
> > >
> > > As far as I've seen everything else is working fine.
> > > Thanks
> >
> >
> >|||The easiest thing for you to do is rename your TempDB to
ReportServersTempDB. This should get you past this problem.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
news:063F8602-5ADE-41FD-AF52-2DD35669B691@.microsoft.com...
> I was wrong again - it is not fixed. The typo is ReportServersTempDB
instead
> of ReportServerTempDB (extra s before temp). I can't find where this is
> stored. The database is correctly named and this is clearly the problem -
> where is this name registered'
> Since I didn't do the installation I'm not sure where it came from - we've
> got a 64 bit box so the install was not traditional.
> "NPShinn" wrote:
> > Sorry - figured it out - the operator ran rsconfig with the TEMPdb and
had a
> > typo.
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> > > Does the ReportServersTempDB exists? Are the objects owned by dbo?
If they
> > > are not you will need to change the owner to dbo.
> > >
> > > --
> > > -Daniel
> > > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > >
> > >
> > > "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> > > news:C2693B9F-4A0B-44B5-A355-4B9F85DC4C57@.microsoft.com...
> > > > When I attempt to set up an snapshot execution I get this error when
> > > clicking
> > > > the execution link:
> > > >
> > > > Invalid object name 'ReportServersTempDB.dbo.ExecutionCache'
> > > >
> > > > Background:
> > > >
> > > > IIS running on - Pentium, Server 2003, 1.8GHz
> > > > SQL is on - Itanium, Server 2003 64 bit
> > > >
> > > > As far as I've seen everything else is working fine.
> > > > Thanks
> > >
> > >
> > >|||What about all of the stored procedures that point to ReportServerTempDB? I
think I will have many places to change the name.
The box is brand new, we could reinstall especially since the dbs are on a
different server.
"Daniel Reib [MSFT]" wrote:
> The easiest thing for you to do is rename your TempDB to
> ReportServersTempDB. This should get you past this problem.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> news:063F8602-5ADE-41FD-AF52-2DD35669B691@.microsoft.com...
> > I was wrong again - it is not fixed. The typo is ReportServersTempDB
> instead
> > of ReportServerTempDB (extra s before temp). I can't find where this is
> > stored. The database is correctly named and this is clearly the problem -
> > where is this name registered'
> >
> > Since I didn't do the installation I'm not sure where it came from - we've
> > got a 64 bit box so the install was not traditional.
> >
> > "NPShinn" wrote:
> >
> > > Sorry - figured it out - the operator ran rsconfig with the TEMPdb and
> had a
> > > typo.
> > >
> > > "Daniel Reib [MSFT]" wrote:
> > >
> > > > Does the ReportServersTempDB exists? Are the objects owned by dbo?
> If they
> > > > are not you will need to change the owner to dbo.
> > > >
> > > > --
> > > > -Daniel
> > > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > >
> > > >
> > > > "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> > > > news:C2693B9F-4A0B-44B5-A355-4B9F85DC4C57@.microsoft.com...
> > > > > When I attempt to set up an snapshot execution I get this error when
> > > > clicking
> > > > > the execution link:
> > > > >
> > > > > Invalid object name 'ReportServersTempDB.dbo.ExecutionCache'
> > > > >
> > > > > Background:
> > > > >
> > > > > IIS running on - Pentium, Server 2003, 1.8GHz
> > > > > SQL is on - Itanium, Server 2003 64 bit
> > > > >
> > > > > As far as I've seen everything else is working fine.
> > > > > Thanks
> > > >
> > > >
> > > >
>
>|||It sounds like the SPs are already pointing to that DB, isn't that the error
you are receiving?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
news:7F0166CD-1852-4A2F-BD3E-3F00C6E59A00@.microsoft.com...
> What about all of the stored procedures that point to ReportServerTempDB?
I
> think I will have many places to change the name.
> The box is brand new, we could reinstall especially since the dbs are on a
> different server.
> "Daniel Reib [MSFT]" wrote:
> > The easiest thing for you to do is rename your TempDB to
> > ReportServersTempDB. This should get you past this problem.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> > news:063F8602-5ADE-41FD-AF52-2DD35669B691@.microsoft.com...
> > > I was wrong again - it is not fixed. The typo is ReportServersTempDB
> > instead
> > > of ReportServerTempDB (extra s before temp). I can't find where this
is
> > > stored. The database is correctly named and this is clearly the
problem -
> > > where is this name registered'
> > >
> > > Since I didn't do the installation I'm not sure where it came from -
we've
> > > got a 64 bit box so the install was not traditional.
> > >
> > > "NPShinn" wrote:
> > >
> > > > Sorry - figured it out - the operator ran rsconfig with the TEMPdb
and
> > had a
> > > > typo.
> > > >
> > > > "Daniel Reib [MSFT]" wrote:
> > > >
> > > > > Does the ReportServersTempDB exists? Are the objects owned by
dbo?
> > If they
> > > > > are not you will need to change the owner to dbo.
> > > > >
> > > > > --
> > > > > -Daniel
> > > > > This posting is provided "AS IS" with no warranties, and confers
no
> > rights.
> > > > >
> > > > >
> > > > > "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> > > > > news:C2693B9F-4A0B-44B5-A355-4B9F85DC4C57@.microsoft.com...
> > > > > > When I attempt to set up an snapshot execution I get this error
when
> > > > > clicking
> > > > > > the execution link:
> > > > > >
> > > > > > Invalid object name 'ReportServersTempDB.dbo.ExecutionCache'
> > > > > >
> > > > > > Background:
> > > > > >
> > > > > > IIS running on - Pentium, Server 2003, 1.8GHz
> > > > > > SQL is on - Itanium, Server 2003 64 bit
> > > > > >
> > > > > > As far as I've seen everything else is working fine.
> > > > > > Thanks
> > > > >
> > > > >
> > > > >
> >
> >
> >|||None of the stored procedures in ReportServer point to the typo - they are
all correct. here is something from the log file:
w3wp!library!924!09/30/2004-10:25:01:: i INFO: Call to
GetPermissions:/Public/WalMartReportNew
w3wp!library!d64!09/30/2004-10:25:01:: i INFO: Call to GetSystemPermissions
w3wp!library!924!09/30/2004-10:25:01:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Data.SqlClient.SqlException: Invalid object name
'ReportServersTempDB.dbo.ExecutionCache'.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at
Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery()
at
Microsoft.ReportingServices.Library.SchedulingDBInterface.UpdateTaskProperties(Task task, Boolean updateSqlAgentSchedule)
at
Microsoft.ReportingServices.Library.SchedulingDBInterface.SetSchedulesNextRunTime(Task t)
at
Microsoft.ReportingServices.Library.SchedulingDBInterface.CheckTasksNextRunTime(Task t)
at Microsoft.ReportingServices.Library.SchedulingDBInterface.ListTasks()
at
Microsoft.ReportingServices.Library.ScheduleCoordinator.ListTasksAsArray()
at Microsoft.ReportingServices.Library.RSService.ListSchedules()
-- End of inner exception stack trace --
"Daniel Reib [MSFT]" wrote:
> It sounds like the SPs are already pointing to that DB, isn't that the error
> you are receiving?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> news:7F0166CD-1852-4A2F-BD3E-3F00C6E59A00@.microsoft.com...
> > What about all of the stored procedures that point to ReportServerTempDB?
> I
> > think I will have many places to change the name.
> >
> > The box is brand new, we could reinstall especially since the dbs are on a
> > different server.
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> > > The easiest thing for you to do is rename your TempDB to
> > > ReportServersTempDB. This should get you past this problem.
> > >
> > > --
> > > -Daniel
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> > > news:063F8602-5ADE-41FD-AF52-2DD35669B691@.microsoft.com...
> > > > I was wrong again - it is not fixed. The typo is ReportServersTempDB
> > > instead
> > > > of ReportServerTempDB (extra s before temp). I can't find where this
> is
> > > > stored. The database is correctly named and this is clearly the
> problem -
> > > > where is this name registered'
> > > >
> > > > Since I didn't do the installation I'm not sure where it came from -
> we've
> > > > got a 64 bit box so the install was not traditional.
> > > >
> > > > "NPShinn" wrote:
> > > >
> > > > > Sorry - figured it out - the operator ran rsconfig with the TEMPdb
> and
> > > had a
> > > > > typo.
> > > > >
> > > > > "Daniel Reib [MSFT]" wrote:
> > > > >
> > > > > > Does the ReportServersTempDB exists? Are the objects owned by
> dbo?
> > > If they
> > > > > > are not you will need to change the owner to dbo.
> > > > > >
> > > > > > --
> > > > > > -Daniel
> > > > > > This posting is provided "AS IS" with no warranties, and confers
> no
> > > rights.
> > > > > >
> > > > > >
> > > > > > "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> > > > > > news:C2693B9F-4A0B-44B5-A355-4B9F85DC4C57@.microsoft.com...
> > > > > > > When I attempt to set up an snapshot execution I get this error
> when
> > > > > > clicking
> > > > > > > the execution link:
> > > > > > >
> > > > > > > Invalid object name 'ReportServersTempDB.dbo.ExecutionCache'
> > > > > > >
> > > > > > > Background:
> > > > > > >
> > > > > > > IIS running on - Pentium, Server 2003, 1.8GHz
> > > > > > > SQL is on - Itanium, Server 2003 64 bit
> > > > > > >
> > > > > > > As far as I've seen everything else is working fine.
> > > > > > > Thanks
> > > > > >
> > > > > >
> > > > > >
> > >
> > >
> > >
>
>|||The thing is we don't store this name anywhere. It is only referenced via
the SPs, so some sp is referring to the wrong DB.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
news:9BF8553B-2CC1-427D-BE45-F2E6CD9505C2@.microsoft.com...
> None of the stored procedures in ReportServer point to the typo - they are
> all correct. here is something from the log file:
> w3wp!library!924!09/30/2004-10:25:01:: i INFO: Call to
> GetPermissions:/Public/WalMartReportNew
> w3wp!library!d64!09/30/2004-10:25:01:: i INFO: Call to
GetSystemPermissions
> w3wp!library!924!09/30/2004-10:25:01:: e ERROR: Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details., ;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details. --> System.Data.SqlClient.SqlException: Invalid object name
> 'ReportServersTempDB.dbo.ExecutionCache'.
> at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
> at
>
Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery()
> at
>
Microsoft.ReportingServices.Library.SchedulingDBInterface.UpdateTaskProperti
es(Task task, Boolean updateSqlAgentSchedule)
> at
>
Microsoft.ReportingServices.Library.SchedulingDBInterface.SetSchedulesNextRu
nTime(Task t)
> at
>
Microsoft.ReportingServices.Library.SchedulingDBInterface.CheckTasksNextRunT
ime(Task t)
> at
Microsoft.ReportingServices.Library.SchedulingDBInterface.ListTasks()
> at
> Microsoft.ReportingServices.Library.ScheduleCoordinator.ListTasksAsArray()
> at Microsoft.ReportingServices.Library.RSService.ListSchedules()
> -- End of inner exception stack trace --
>
> "Daniel Reib [MSFT]" wrote:
> > It sounds like the SPs are already pointing to that DB, isn't that the
error
> > you are receiving?
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> > news:7F0166CD-1852-4A2F-BD3E-3F00C6E59A00@.microsoft.com...
> > > What about all of the stored procedures that point to
ReportServerTempDB?
> > I
> > > think I will have many places to change the name.
> > >
> > > The box is brand new, we could reinstall especially since the dbs are
on a
> > > different server.
> > >
> > > "Daniel Reib [MSFT]" wrote:
> > >
> > > > The easiest thing for you to do is rename your TempDB to
> > > > ReportServersTempDB. This should get you past this problem.
> > > >
> > > > --
> > > > -Daniel
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > >
> > > >
> > > > "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> > > > news:063F8602-5ADE-41FD-AF52-2DD35669B691@.microsoft.com...
> > > > > I was wrong again - it is not fixed. The typo is
ReportServersTempDB
> > > > instead
> > > > > of ReportServerTempDB (extra s before temp). I can't find where
this
> > is
> > > > > stored. The database is correctly named and this is clearly the
> > problem -
> > > > > where is this name registered'
> > > > >
> > > > > Since I didn't do the installation I'm not sure where it came
from -
> > we've
> > > > > got a 64 bit box so the install was not traditional.
> > > > >
> > > > > "NPShinn" wrote:
> > > > >
> > > > > > Sorry - figured it out - the operator ran rsconfig with the
TEMPdb
> > and
> > > > had a
> > > > > > typo.
> > > > > >
> > > > > > "Daniel Reib [MSFT]" wrote:
> > > > > >
> > > > > > > Does the ReportServersTempDB exists? Are the objects owned by
> > dbo?
> > > > If they
> > > > > > > are not you will need to change the owner to dbo.
> > > > > > >
> > > > > > > --
> > > > > > > -Daniel
> > > > > > > This posting is provided "AS IS" with no warranties, and
confers
> > no
> > > > rights.
> > > > > > >
> > > > > > >
> > > > > > > "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> > > > > > > news:C2693B9F-4A0B-44B5-A355-4B9F85DC4C57@.microsoft.com...
> > > > > > > > When I attempt to set up an snapshot execution I get this
error
> > when
> > > > > > > clicking
> > > > > > > > the execution link:
> > > > > > > >
> > > > > > > > Invalid object name 'ReportServersTempDB.dbo.ExecutionCache'
> > > > > > > >
> > > > > > > > Background:
> > > > > > > >
> > > > > > > > IIS running on - Pentium, Server 2003, 1.8GHz
> > > > > > > > SQL is on - Itanium, Server 2003 64 bit
> > > > > > > >
> > > > > > > > As far as I've seen everything else is working fine.
> > > > > > > > Thanks
> > > > > > >
> > > > > > >
> > > > > > >
> > > >
> > > >
> > > >
> >
> >
> >|||We ended up reinstalling - twice - to resolve our problem. It did point out
an odd thing. Since we're using a 64 bit server, they installed RS by
pointing at our 32 bit development box. Since RS dbs are already on that
box, the operator changed the names of the new dbs to ReportServers and
ReportServersTempDB. The second time he did the install he named them
ReportServer2 and ReportServer2TempDB.
These dbs had to be backed up and restored onto the 64 bit box and thats
when the error change looking for ReportServer2TempDB. So...I went in and
replaced ReportServer2Tempdb back to ReportServerTempdb inall of the stored
procedures. It didn't help, even after restarting all services on both boxes,
with no reference to ReportServer2TempDB in any sp, it was still looking for
it.
We finally solved the problem by installing onto a box that didn't have RS
on it so that we could name the databases correctly. Overall, al pretty odd
day.
If I've left anything out, feel free to ask.
Nancy Shinn
"Daniel Reib [MSFT]" wrote:
> The thing is we don't store this name anywhere. It is only referenced via
> the SPs, so some sp is referring to the wrong DB.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> news:9BF8553B-2CC1-427D-BE45-F2E6CD9505C2@.microsoft.com...
> > None of the stored procedures in ReportServer point to the typo - they are
> > all correct. here is something from the log file:
> >
> > w3wp!library!924!09/30/2004-10:25:01:: i INFO: Call to
> > GetPermissions:/Public/WalMartReportNew
> > w3wp!library!d64!09/30/2004-10:25:01:: i INFO: Call to
> GetSystemPermissions
> > w3wp!library!924!09/30/2004-10:25:01:: e ERROR: Throwing
> >
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > An internal error occurred on the report server. See the error log for
> more
> > details., ;
> > Info:
> >
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > An internal error occurred on the report server. See the error log for
> more
> > details. --> System.Data.SqlClient.SqlException: Invalid object name
> > 'ReportServersTempDB.dbo.ExecutionCache'.
> > at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
> > cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
> > at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
> > at
> >
> Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery()
> > at
> >
> Microsoft.ReportingServices.Library.SchedulingDBInterface.UpdateTaskProperti
> es(Task task, Boolean updateSqlAgentSchedule)
> > at
> >
> Microsoft.ReportingServices.Library.SchedulingDBInterface.SetSchedulesNextRu
> nTime(Task t)
> > at
> >
> Microsoft.ReportingServices.Library.SchedulingDBInterface.CheckTasksNextRunT
> ime(Task t)
> > at
> Microsoft.ReportingServices.Library.SchedulingDBInterface.ListTasks()
> > at
> > Microsoft.ReportingServices.Library.ScheduleCoordinator.ListTasksAsArray()
> > at Microsoft.ReportingServices.Library.RSService.ListSchedules()
> > -- End of inner exception stack trace --
> >
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> > > It sounds like the SPs are already pointing to that DB, isn't that the
> error
> > > you are receiving?
> > >
> > > --
> > > -Daniel
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> > > news:7F0166CD-1852-4A2F-BD3E-3F00C6E59A00@.microsoft.com...
> > > > What about all of the stored procedures that point to
> ReportServerTempDB?
> > > I
> > > > think I will have many places to change the name.
> > > >
> > > > The box is brand new, we could reinstall especially since the dbs are
> on a
> > > > different server.
> > > >
> > > > "Daniel Reib [MSFT]" wrote:
> > > >
> > > > > The easiest thing for you to do is rename your TempDB to
> > > > > ReportServersTempDB. This should get you past this problem.
> > > > >
> > > > > --
> > > > > -Daniel
> > > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > > >
> > > > >
> > > > > "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> > > > > news:063F8602-5ADE-41FD-AF52-2DD35669B691@.microsoft.com...
> > > > > > I was wrong again - it is not fixed. The typo is
> ReportServersTempDB
> > > > > instead
> > > > > > of ReportServerTempDB (extra s before temp). I can't find where
> this
> > > is
> > > > > > stored. The database is correctly named and this is clearly the
> > > problem -
> > > > > > where is this name registered'
> > > > > >
> > > > > > Since I didn't do the installation I'm not sure where it came
> from -
> > > we've
> > > > > > got a 64 bit box so the install was not traditional.
> > > > > >
> > > > > > "NPShinn" wrote:
> > > > > >
> > > > > > > Sorry - figured it out - the operator ran rsconfig with the
> TEMPdb
> > > and
> > > > > had a
> > > > > > > typo.
> > > > > > >
> > > > > > > "Daniel Reib [MSFT]" wrote:
> > > > > > >
> > > > > > > > Does the ReportServersTempDB exists? Are the objects owned by
> > > dbo?
> > > > > If they
> > > > > > > > are not you will need to change the owner to dbo.
> > > > > > > >
> > > > > > > > --
> > > > > > > > -Daniel
> > > > > > > > This posting is provided "AS IS" with no warranties, and
> confers
> > > no
> > > > > rights.
> > > > > > > >
> > > > > > > >
> > > > > > > > "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> > > > > > > > news:C2693B9F-4A0B-44B5-A355-4B9F85DC4C57@.microsoft.com...
> > > > > > > > > When I attempt to set up an snapshot execution I get this
> error
> > > when
> > > > > > > > clicking
> > > > > > > > > the execution link:
> > > > > > > > >
> > > > > > > > > Invalid object name 'ReportServersTempDB.dbo.ExecutionCache'
> > > > > > > > >
> > > > > > > > > Background:
> > > > > > > > >
> > > > > > > > > IIS running on - Pentium, Server 2003, 1.8GHz
> > > > > > > > > SQL is on - Itanium, Server 2003 64 bit
> > > > > > > > >
> > > > > > > > > As far as I've seen everything else is working fine.
> > > > > > > > > Thanks
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>|||At some point you ran rsconfig correct? If not then you were never pointing
at the new DBs. Other then that I am really stumped as to why it didn't
work.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
news:17E68A5B-97AF-4455-AB84-0F78BDA375B0@.microsoft.com...
> We ended up reinstalling - twice - to resolve our problem. It did point
out
> an odd thing. Since we're using a 64 bit server, they installed RS by
> pointing at our 32 bit development box. Since RS dbs are already on that
> box, the operator changed the names of the new dbs to ReportServers and
> ReportServersTempDB. The second time he did the install he named them
> ReportServer2 and ReportServer2TempDB.
> These dbs had to be backed up and restored onto the 64 bit box and thats
> when the error change looking for ReportServer2TempDB. So...I went in and
> replaced ReportServer2Tempdb back to ReportServerTempdb inall of the
stored
> procedures. It didn't help, even after restarting all services on both
boxes,
> with no reference to ReportServer2TempDB in any sp, it was still looking
for
> it.
> We finally solved the problem by installing onto a box that didn't have RS
> on it so that we could name the databases correctly. Overall, al pretty
odd
> day.
> If I've left anything out, feel free to ask.
> Nancy Shinn
> "Daniel Reib [MSFT]" wrote:
> > The thing is we don't store this name anywhere. It is only referenced
via
> > the SPs, so some sp is referring to the wrong DB.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> > news:9BF8553B-2CC1-427D-BE45-F2E6CD9505C2@.microsoft.com...
> > > None of the stored procedures in ReportServer point to the typo - they
are
> > > all correct. here is something from the log file:
> > >
> > > w3wp!library!924!09/30/2004-10:25:01:: i INFO: Call to
> > > GetPermissions:/Public/WalMartReportNew
> > > w3wp!library!d64!09/30/2004-10:25:01:: i INFO: Call to
> > GetSystemPermissions
> > > w3wp!library!924!09/30/2004-10:25:01:: e ERROR: Throwing
> > >
> >
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > > An internal error occurred on the report server. See the error log for
> > more
> > > details., ;
> > > Info:
> > >
> >
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > > An internal error occurred on the report server. See the error log for
> > more
> > > details. --> System.Data.SqlClient.SqlException: Invalid object name
> > > 'ReportServersTempDB.dbo.ExecutionCache'.
> > > at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
> > > cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
> > > at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
> > > at
> > >
> >
Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery()
> > > at
> > >
> >
Microsoft.ReportingServices.Library.SchedulingDBInterface.UpdateTaskProperti
> > es(Task task, Boolean updateSqlAgentSchedule)
> > > at
> > >
> >
Microsoft.ReportingServices.Library.SchedulingDBInterface.SetSchedulesNextRu
> > nTime(Task t)
> > > at
> > >
> >
Microsoft.ReportingServices.Library.SchedulingDBInterface.CheckTasksNextRunT
> > ime(Task t)
> > > at
> > Microsoft.ReportingServices.Library.SchedulingDBInterface.ListTasks()
> > > at
> > >
Microsoft.ReportingServices.Library.ScheduleCoordinator.ListTasksAsArray()
> > > at Microsoft.ReportingServices.Library.RSService.ListSchedules()
> > > -- End of inner exception stack trace --
> > >
> > >
> > > "Daniel Reib [MSFT]" wrote:
> > >
> > > > It sounds like the SPs are already pointing to that DB, isn't that
the
> > error
> > > > you are receiving?
> > > >
> > > > --
> > > > -Daniel
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > >
> > > >
> > > > "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> > > > news:7F0166CD-1852-4A2F-BD3E-3F00C6E59A00@.microsoft.com...
> > > > > What about all of the stored procedures that point to
> > ReportServerTempDB?
> > > > I
> > > > > think I will have many places to change the name.
> > > > >
> > > > > The box is brand new, we could reinstall especially since the dbs
are
> > on a
> > > > > different server.
> > > > >
> > > > > "Daniel Reib [MSFT]" wrote:
> > > > >
> > > > > > The easiest thing for you to do is rename your TempDB to
> > > > > > ReportServersTempDB. This should get you past this problem.
> > > > > >
> > > > > > --
> > > > > > -Daniel
> > > > > > This posting is provided "AS IS" with no warranties, and confers
no
> > > > rights.
> > > > > >
> > > > > >
> > > > > > "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in message
> > > > > > news:063F8602-5ADE-41FD-AF52-2DD35669B691@.microsoft.com...
> > > > > > > I was wrong again - it is not fixed. The typo is
> > ReportServersTempDB
> > > > > > instead
> > > > > > > of ReportServerTempDB (extra s before temp). I can't find
where
> > this
> > > > is
> > > > > > > stored. The database is correctly named and this is clearly
the
> > > > problem -
> > > > > > > where is this name registered'
> > > > > > >
> > > > > > > Since I didn't do the installation I'm not sure where it came
> > from -
> > > > we've
> > > > > > > got a 64 bit box so the install was not traditional.
> > > > > > >
> > > > > > > "NPShinn" wrote:
> > > > > > >
> > > > > > > > Sorry - figured it out - the operator ran rsconfig with the
> > TEMPdb
> > > > and
> > > > > > had a
> > > > > > > > typo.
> > > > > > > >
> > > > > > > > "Daniel Reib [MSFT]" wrote:
> > > > > > > >
> > > > > > > > > Does the ReportServersTempDB exists? Are the objects
owned by
> > > > dbo?
> > > > > > If they
> > > > > > > > > are not you will need to change the owner to dbo.
> > > > > > > > >
> > > > > > > > > --
> > > > > > > > > -Daniel
> > > > > > > > > This posting is provided "AS IS" with no warranties, and
> > confers
> > > > no
> > > > > > rights.
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > "NPShinn" <NPShinn@.discussions.microsoft.com> wrote in
message
> > > > > > > > > news:C2693B9F-4A0B-44B5-A355-4B9F85DC4C57@.microsoft.com...
> > > > > > > > > > When I attempt to set up an snapshot execution I get
this
> > error
> > > > when
> > > > > > > > > clicking
> > > > > > > > > > the execution link:
> > > > > > > > > >
> > > > > > > > > > Invalid object name
'ReportServersTempDB.dbo.ExecutionCache'
> > > > > > > > > >
> > > > > > > > > > Background:
> > > > > > > > > >
> > > > > > > > > > IIS running on - Pentium, Server 2003, 1.8GHz
> > > > > > > > > > SQL is on - Itanium, Server 2003 64 bit
> > > > > > > > > >
> > > > > > > > > > As far as I've seen everything else is working fine.
> > > > > > > > > > Thanks
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >
Report caching
Hi all,
I have a report that takes about 10 minutes to run for a given date. How can
I cache it some how so that it would run lot faster for the same data input
(date) later on?
Thanks in advance.You can have the report run from the cache... ON the reporting Server,
select the report-Properties... You can set the report to run from cache and
choose the cache refresh schedule... The first person who runs the report
after the cache has expired, must wait... Others during the period get fast
response.
If you do not want to wait the first time, you may run a snapshot for the
report on a schedule and have the report rendered from the snapshot...
However The only reports which will be rendered must be snapshotted with the
appropriate report parameters...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Trisha" <trisha@.nospam.nospam> wrote in message
news:CB6AB88B-40D6-4E26-A40C-9F086B171142@.microsoft.com...
> Hi all,
> I have a report that takes about 10 minutes to run for a given date. How
> can
> I cache it some how so that it would run lot faster for the same data
> input
> (date) later on?
> Thanks in advance.|||Wayne,
What if I want to cache the report for several different input parameters.
What if I have several different reports w/several different parameters.
Would all those reports be cached on the server for each of the executed
input parameters? If thats the case, then it would put lots of load on the
server and I might have to look into a different strategy.
Thanks again..
"Wayne Snyder" wrote:
> You can have the report run from the cache... ON the reporting Server,
> select the report-Properties... You can set the report to run from cache and
> choose the cache refresh schedule... The first person who runs the report
> after the cache has expired, must wait... Others during the period get fast
> response.
> If you do not want to wait the first time, you may run a snapshot for the
> report on a schedule and have the report rendered from the snapshot...
> However The only reports which will be rendered must be snapshotted with the
> appropriate report parameters...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Trisha" <trisha@.nospam.nospam> wrote in message
> news:CB6AB88B-40D6-4E26-A40C-9F086B171142@.microsoft.com...
> > Hi all,
> >
> > I have a report that takes about 10 minutes to run for a given date. How
> > can
> > I cache it some how so that it would run lot faster for the same data
> > input
> > (date) later on?
> >
> > Thanks in advance.
>
>
I have a report that takes about 10 minutes to run for a given date. How can
I cache it some how so that it would run lot faster for the same data input
(date) later on?
Thanks in advance.You can have the report run from the cache... ON the reporting Server,
select the report-Properties... You can set the report to run from cache and
choose the cache refresh schedule... The first person who runs the report
after the cache has expired, must wait... Others during the period get fast
response.
If you do not want to wait the first time, you may run a snapshot for the
report on a schedule and have the report rendered from the snapshot...
However The only reports which will be rendered must be snapshotted with the
appropriate report parameters...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Trisha" <trisha@.nospam.nospam> wrote in message
news:CB6AB88B-40D6-4E26-A40C-9F086B171142@.microsoft.com...
> Hi all,
> I have a report that takes about 10 minutes to run for a given date. How
> can
> I cache it some how so that it would run lot faster for the same data
> input
> (date) later on?
> Thanks in advance.|||Wayne,
What if I want to cache the report for several different input parameters.
What if I have several different reports w/several different parameters.
Would all those reports be cached on the server for each of the executed
input parameters? If thats the case, then it would put lots of load on the
server and I might have to look into a different strategy.
Thanks again..
"Wayne Snyder" wrote:
> You can have the report run from the cache... ON the reporting Server,
> select the report-Properties... You can set the report to run from cache and
> choose the cache refresh schedule... The first person who runs the report
> after the cache has expired, must wait... Others during the period get fast
> response.
> If you do not want to wait the first time, you may run a snapshot for the
> report on a schedule and have the report rendered from the snapshot...
> However The only reports which will be rendered must be snapshotted with the
> appropriate report parameters...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Trisha" <trisha@.nospam.nospam> wrote in message
> news:CB6AB88B-40D6-4E26-A40C-9F086B171142@.microsoft.com...
> > Hi all,
> >
> > I have a report that takes about 10 minutes to run for a given date. How
> > can
> > I cache it some how so that it would run lot faster for the same data
> > input
> > (date) later on?
> >
> > Thanks in advance.
>
>
report caching
here is the deal- i have a bunch of reports to which i need to add a generic
caching plan. i know how to do this through the report manager web
interface on a per-report-basis. my problem is that i am lazy and don't
want to click through every single report individually setting up the
caching plan. is there a way to do this across all reports in a directory?
please tell me there is...
tia,
jtOn May 4, 5:13 pm, "JTL" <j...@.clickstreamtech.com> wrote:
> here is the deal- i have a bunch of reports to which i need to add a generic
> caching plan. i know how to do this through the report manager web
> interface on a per-report-basis. my problem is that i am lazy and don't
> want to click through every single report individually setting up the
> caching plan. is there a way to do this across all reports in a directory?
> please tell me there is...
> tia,
> jt
As far as I know, aside from modifying the caching plan one report at
a time, there is no other way to change the caching plan. Sorry I
could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hello,
You can perform operations on a report server through the use of the rs
utility (RS.exe).
In this way you can programmatically administer a report server using
Microsoft Visual Basic scripts.
I think this is only way to automate setting configuration for many reports.
Regards,
Radoslaw Lebkowski
MCTS
U¿ytkownik "JTL" <jt@.clickstreamtech.com> napisa³ w wiadomo¶ci
news:O3wJllpjHHA.588@.TK2MSFTNGP06.phx.gbl...
> here is the deal- i have a bunch of reports to which i need to add a
> generic caching plan. i know how to do this through the report manager
> web interface on a per-report-basis. my problem is that i am lazy and
> don't want to click through every single report individually setting up
> the caching plan. is there a way to do this across all reports in a
> directory? please tell me there is...
> tia,
> jt
>sql
caching plan. i know how to do this through the report manager web
interface on a per-report-basis. my problem is that i am lazy and don't
want to click through every single report individually setting up the
caching plan. is there a way to do this across all reports in a directory?
please tell me there is...
tia,
jtOn May 4, 5:13 pm, "JTL" <j...@.clickstreamtech.com> wrote:
> here is the deal- i have a bunch of reports to which i need to add a generic
> caching plan. i know how to do this through the report manager web
> interface on a per-report-basis. my problem is that i am lazy and don't
> want to click through every single report individually setting up the
> caching plan. is there a way to do this across all reports in a directory?
> please tell me there is...
> tia,
> jt
As far as I know, aside from modifying the caching plan one report at
a time, there is no other way to change the caching plan. Sorry I
could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hello,
You can perform operations on a report server through the use of the rs
utility (RS.exe).
In this way you can programmatically administer a report server using
Microsoft Visual Basic scripts.
I think this is only way to automate setting configuration for many reports.
Regards,
Radoslaw Lebkowski
MCTS
U¿ytkownik "JTL" <jt@.clickstreamtech.com> napisa³ w wiadomo¶ci
news:O3wJllpjHHA.588@.TK2MSFTNGP06.phx.gbl...
> here is the deal- i have a bunch of reports to which i need to add a
> generic caching plan. i know how to do this through the report manager
> web interface on a per-report-basis. my problem is that i am lazy and
> don't want to click through every single report individually setting up
> the caching plan. is there a way to do this across all reports in a
> directory? please tell me there is...
> tia,
> jt
>sql
Subscribe to:
Posts (Atom)