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
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
> >