sql2k sp3
Is there a way to attach the files of a db to a newly
created box? No backups as these are QA db's not
production.
TIA, ChrisR"ChrisR" <anonymous@.discussions.microsoft.com> wrote in message
news:c6fe01c48a03$56389420$a401280a@.phx.gbl...
> sql2k sp3
> Is there a way to attach the files of a db to a newly
> created box? No backups as these are QA db's not
> production.
Assuming that these files are now in use by SQL Server there are several
methods. You can detach the database, copy the *.mdf & *.ldf file to the new
server and reattach the files. Or, use the BACKUP command, then RESTORE on
your target server.
The following reference covers your options fairly well:
http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
Steve
Showing posts with label sp3. Show all posts
Showing posts with label sp3. Show all posts
Thursday, March 29, 2012
Wednesday, March 7, 2012
Assertion failed!
I'm connecting to a SQL Server 2000, sp3 running on Win2k
Server, SP3, english version from a workstation with
Win2k, sp 3, english version.
The client software is written in C# and I'm using ADO.NET
to connect.
Occasionally I get this fault:
Assertion failed!
Program: ...\..\..\Myprog.exe
File: ..\..\..\nt\ssock\src\ntsockc.c
Line: 1053 (sometimes other lines...)
Expression: 1 == pConnectionObject->fCallCheck
Any suggestions what could be wrong?
/MattiasHi Mattias,
If the Assertion is thrown by the C# application, you need to post in C# or
ADO.NET newsgroup for accurate information, e.g.
microsoft.public.dotnet.languages.csharp,
microsoft.public.dotnet.framework.adonet. The problem should be related to
SQL Server.
When the problem occurs, I suggest that you use Query Analyzer to connect
to the SQL Server from the computer where the problem occurs. If the
problem does not occur, it indicates that the problem is with the
application.
In addition, since it is a random problem, it could be quite complex. You
could also contact Microsoft Product Support Services via
http://support.microsoft.com/default.aspx?scid=fh;EN-US;CNTACTMS, so that
we can have dedicated engineer to assist you.
This posting is provided "AS IS" with no warranties, and confers no rights.
Regards,
Bill Cheng
Microsoft Support Engineer
--
| Content-Class: urn:content-classes:message
| From: "Mattias Andersson" <mattias.andersson@.ip-consult.se>
| Sender: "Mattias Andersson" <mattias.andersson@.ip-consult.se>
| Subject: Assertion failed!
| Date: Mon, 30 Jun 2003 00:17:00 -0700
| Lines: 18
| Message-ID: <067701c33ed7$9931e2e0$a101280a@.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcM+15kxvfxven3cQMytFjuuieMjcA==| Newsgroups: microsoft.public.sqlserver.server
| Path: cpmsftngxa09.phx.gbl
| Xref: cpmsftngxa09.phx.gbl microsoft.public.sqlserver.server:22143
| NNTP-Posting-Host: TK2MSFTNGXA09 10.40.1.161
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I'm connecting to a SQL Server 2000, sp3 running on Win2k
| Server, SP3, english version from a workstation with
| Win2k, sp 3, english version.
|
| The client software is written in C# and I'm using ADO.NET
| to connect.
|
| Occasionally I get this fault:
| Assertion failed!
| Program: ...\..\..\Myprog.exe
| File: ..\..\..\nt\ssock\src\ntsockc.c
| Line: 1053 (sometimes other lines...)
|
| Expression: 1 == pConnectionObject->fCallCheck
|
| Any suggestions what could be wrong?
|
| /Mattias
|
Server, SP3, english version from a workstation with
Win2k, sp 3, english version.
The client software is written in C# and I'm using ADO.NET
to connect.
Occasionally I get this fault:
Assertion failed!
Program: ...\..\..\Myprog.exe
File: ..\..\..\nt\ssock\src\ntsockc.c
Line: 1053 (sometimes other lines...)
Expression: 1 == pConnectionObject->fCallCheck
Any suggestions what could be wrong?
/MattiasHi Mattias,
If the Assertion is thrown by the C# application, you need to post in C# or
ADO.NET newsgroup for accurate information, e.g.
microsoft.public.dotnet.languages.csharp,
microsoft.public.dotnet.framework.adonet. The problem should be related to
SQL Server.
When the problem occurs, I suggest that you use Query Analyzer to connect
to the SQL Server from the computer where the problem occurs. If the
problem does not occur, it indicates that the problem is with the
application.
In addition, since it is a random problem, it could be quite complex. You
could also contact Microsoft Product Support Services via
http://support.microsoft.com/default.aspx?scid=fh;EN-US;CNTACTMS, so that
we can have dedicated engineer to assist you.
This posting is provided "AS IS" with no warranties, and confers no rights.
Regards,
Bill Cheng
Microsoft Support Engineer
--
| Content-Class: urn:content-classes:message
| From: "Mattias Andersson" <mattias.andersson@.ip-consult.se>
| Sender: "Mattias Andersson" <mattias.andersson@.ip-consult.se>
| Subject: Assertion failed!
| Date: Mon, 30 Jun 2003 00:17:00 -0700
| Lines: 18
| Message-ID: <067701c33ed7$9931e2e0$a101280a@.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcM+15kxvfxven3cQMytFjuuieMjcA==| Newsgroups: microsoft.public.sqlserver.server
| Path: cpmsftngxa09.phx.gbl
| Xref: cpmsftngxa09.phx.gbl microsoft.public.sqlserver.server:22143
| NNTP-Posting-Host: TK2MSFTNGXA09 10.40.1.161
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I'm connecting to a SQL Server 2000, sp3 running on Win2k
| Server, SP3, english version from a workstation with
| Win2k, sp 3, english version.
|
| The client software is written in C# and I'm using ADO.NET
| to connect.
|
| Occasionally I get this fault:
| Assertion failed!
| Program: ...\..\..\Myprog.exe
| File: ..\..\..\nt\ssock\src\ntsockc.c
| Line: 1053 (sometimes other lines...)
|
| Expression: 1 == pConnectionObject->fCallCheck
|
| Any suggestions what could be wrong?
|
| /Mattias
|
Assertion failed on subscription email send
Hello, I have installed a fresh new Reporting Service sp1, on a Windows 2003
Server, SQL 2000 sp3, IIS 6.0 and am getting an error when trying to send out
emails via subscriptions. Cannot decipher the error. Log file is below:
--
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.878.00</Product>
<Locale>en-US</Locale>
<TimeZone>Pacific Daylight Time</TimeZone>
<Path>D:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerService__10_26_2004_18_45_47.log</Path>
<SystemName>XXX</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing ConnectionType to '1' as specified in Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing IsSchedulingService to 'True' as specified in Configuration
file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing IsNotificationService to 'True' as specified in Configuration
file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing PollingInterval to '10' second(s) as specified in Configuration
file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing RecycleTime to '720' minute(s) as specified in Configuration
file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing MaximumMemoryLimit to '80' percent as specified in Configuration
file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration
file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing MaxScheduleWait to '5' second(s) as specified in Configuration
file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing DatabaseQueryTimeout to '120' second(s) as specified in
Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration
file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing RunningRequestsDbCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing RunningRequestsAge to '30' second(s) as specified in
Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing CleanupCycleMinutes to '10' minute(s) as specified in
Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing WebServiceUseFileShareStorage to default value of 'False'
because it was not specified in Configuration file.
ReportingServicesService!resourceutilities!ea4!10/26/2004-18:45:47:: i INFO:
Running on 2 physical processors, 4 logical processors
ReportingServicesService!resourceutilities!ea4!10/26/2004-18:45:47:: i INFO:
Reporting Services starting SKU: Standard
ReportingServicesService!runningjobs!ea4!10/26/2004-18:45:47:: i INFO:
Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
ReportingServicesService!runningjobs!ea4!10/26/2004-18:45:47:: i INFO:
Running Requests Scavenger timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!ea4!10/26/2004-18:45:47:: i INFO:
Running Requests DB timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!ea4!10/26/2004-18:45:47:: i INFO:
Execution Log Entry Expiration timer enabled: Cycle: 26052 seconds
ReportingServicesService!runningjobs!ea4!10/26/2004-18:45:47:: i INFO:
Memory stats update timer enabled: Cycle: 60 seconds
ReportingServicesService!crypto!d4c!10/26/2004-18:45:47:: i INFO:
Initializing crypto as user: NT AUTHORITY\NETWORK SERVICE
ReportingServicesService!crypto!d4c!10/26/2004-18:45:47:: i INFO: Exporting
public key
ReportingServicesService!crypto!d4c!10/26/2004-18:45:47:: i INFO: Performing
sku validation
ReportingServicesService!crypto!d4c!10/26/2004-18:45:47:: i INFO: Importing
existing encryption key
ReportingServicesService!dbpolling!d4c!10/26/2004-18:45:47:: EventPolling
polling service started
ReportingServicesService!dbpolling!d4c!10/26/2004-18:45:47::
NotificationPolling polling service started
ReportingServicesService!dbpolling!d4c!10/26/2004-18:45:47:: SchedulePolling
polling service started
ReportingServicesService!dbpolling!c2c!10/26/2004-18:45:47::
NotificationPolling heartbeat thread started.
ReportingServicesService!dbpolling!1464!10/26/2004-18:45:47:: EventPolling
heartbeat thread started.
ReportingServicesService!dbpolling!1254!10/26/2004-18:45:47:: Polling started
ReportingServicesService!library!1590!10/26/2004-18:55:47:: Using folder
D:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\RSTempFiles
for temporary files.
ReportingServicesService!library!1590!10/26/2004-18:55:47:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 3 snapshots, 10
chunks, 0 running jobs
ReportingServicesService!dbpolling!1254!10/26/2004-19:04:09:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!13c!10/26/2004-19:04:09:: EventPolling
processing item 91cd2565-e05c-4157-accf-8ac92b1b24c8
ReportingServicesService!library!13c!10/26/2004-19:04:09:: Schedule
23b76016-934c-4b5c-bcb1-4ebe8d981694 executed at 10/26/2004 7:04:09 PM.
ReportingServicesService!schedule!13c!10/26/2004-19:04:09:: Creating Time
based subscription notification for subscription:
d680d144-e89e-4dd2-8be7-3f365310eb4f
ReportingServicesService!library!13c!10/26/2004-19:04:09:: Schedule
23b76016-934c-4b5c-bcb1-4ebe8d981694 execution completed at 10/26/2004
7:04:09 PM.
ReportingServicesService!dbpolling!13c!10/26/2004-19:04:09:: EventPolling
finished processing item 91cd2565-e05c-4157-accf-8ac92b1b24c8
ReportingServicesService!dbpolling!1254!10/26/2004-19:04:09::
NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!13c!10/26/2004-19:04:09::
NotificationPolling processing item af68ce86-9586-4feb-b332-3019e012eda7
ReportingServicesService!library!13c!10/26/2004-19:04:09:: i INFO:
Initializing EnableIntegratedSecurity to 'True' as specified in Server
system properties.
ReportingServicesService!library!13c!10/26/2004-19:04:10:: i INFO: Call to
RenderFirst( '/Ahl Reports/QualityOfImages' )
ReportingServicesService!library!13c!10/26/2004-19:04:10:: i INFO:
Initializing SessionTimeout to '600' second(s) as specified in Server system
properties.
ReportingServicesService!library!13c!10/26/2004-19:04:10:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!library!fe8!10/26/2004-19:04:10:: i INFO:
Initializing SqlStreamingBufferSize to default value of '64640' Bytes because
it was not specified in Server system properties.
ReportingServicesService!library!fe8!10/26/2004-19:04:10:: i INFO:
Initializing SnapshotCompression to 'SQL' as specified in Server system
properties.
ReportingServicesService!library!13c!10/26/2004-19:04:10:: i INFO:
Initializing SessionAccessTimeout to default value of '600' seconds because
it was not specified in Server system properties.
ReportingServicesService!session!13c!10/26/2004-19:04:10:: i INFO:
LoadSnapshot: Item with session: d5x5c355p2lstn45rxfewd55, reportPath: /Ahl
Reports/QualityOfImages, userName: AHLCENTRAL\XXX not found in the database
ReportingServicesService!chunks!13c!10/26/2004-19:04:10:: i INFO: ###
GetReportChunk('QualityOfImages_style', 1), chunk was not found!
this=0b55a7a3-80b8-4761-b0c7-22bb5f291c0b
ReportingServicesService!chunks!13c!10/26/2004-19:04:10:: i INFO: ###
GetReportChunk('Main', 0), chunk was not found!
this=0b55a7a3-80b8-4761-b0c7-22bb5f291c0b
ReportingServicesService!processing!13c!10/26/2004-19:04:10:: a ASSERT:
Assertion failed! Call stack:
Microsoft.ReportingServices.ReportProcessing.Persistence.f.b(Boolean A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream
A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, CreateReportChunk A_1, Hashtable& A_2, a& A_3, Boolean& A_4)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshotStream(CreateReportChunk
createChunkCallback, String streamName, RenderingContext rc, GetResource
getResourceCallback)
Microsoft.ReportingServices.Library.RSService.InternalGetReportImageLive(ClientRequest session, CatalogItemContext itemContext, String imageId)
Microsoft.ReportingServices.Library.RSService.InternalGetReportImage(ClientRequest session, CatalogItemContext itemContext)
Microsoft.ReportingServices.Library.RSService.GetReportImage(ClientRequest
session, CatalogItemContext itemContext)
Microsoft.ReportingServices.Library.RenderedOutputFileImpl.GetRsStream()
Microsoft.ReportingServices.Library.RenderedOutputFileImpl.get_FileName()
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.EmbedReport(IMessage
message, RenderedOutputFile[] reportData, Notification notification,
SubscriptionData data)
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
Microsoft.ReportingServices.Library.NotificationQueueWorker.HandleNotification(QueueItem item)
Microsoft.ReportingServices.Library.NotificationQueueWorker.QueueWorker(QueueItem item)
Microsoft.ReportingServices.Library.QueuePollWorker.WorkItemStart(Object
state)
ReportingServicesService!processing!13c!10/26/2004-19:04:10:: e ERROR:
Throwing
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
unexpected error occurred in Report Processing., ;
Info:
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
unexpected error occurred in Report Processing.
ReportingServicesService!emailextension!13c!10/26/2004-19:04:10:: Error
sending email.
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
unexpected error occurred in Report Processing.
at Microsoft.ReportingServices.ReportProcessing.Persistence.f.b(Boolean
A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
at
Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, CreateReportChunk A_1, Hashtable& A_2, a& A_3, Boolean& A_4)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshotStream(CreateReportChunk
createChunkCallback, String streamName, RenderingContext rc, GetResource
getResourceCallback)
at
Microsoft.ReportingServices.Library.RSService.InternalGetReportImageLive(ClientRequest session, CatalogItemContext itemContext, String imageId)
at
Microsoft.ReportingServices.Library.RSService.InternalGetReportImage(ClientRequest session, CatalogItemContext itemContext)
at
Microsoft.ReportingServices.Library.RSService.GetReportImage(ClientRequest
session, CatalogItemContext itemContext)
at Microsoft.ReportingServices.Library.RenderedOutputFileImpl.GetRsStream()
at
Microsoft.ReportingServices.Library.RenderedOutputFileImpl.get_FileName()
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.EmbedReport(IMessage
message, RenderedOutputFile[] reportData, Notification notification,
SubscriptionData data)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
ReportingServicesService!notification!13c!10/26/2004-19:04:10:: Notification
af68ce86-9586-4feb-b332-3019e012eda7 completed. Success: False, Status:
Failure sending mail: An unexpected error occurred in Report Processing.,
DeliveryExtension: Report Server Email, Report: QualityOfImages, Attempt 0
ReportingServicesService!dbpolling!13c!10/26/2004-19:04:10::
NotificationPolling finished processing item
af68ce86-9586-4feb-b332-3019e012eda7
ReportingServicesService!library!13c!10/26/2004-19:05:47:: i INFO: Cleaned 0
batch records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 2
chunks, 0 running jobs
ReportingServicesService!library!13c4!10/26/2004-19:15:47:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 2 snapshots, 8
chunks, 0 running jobs
ReportingServicesService!library!168!10/26/2004-19:25:47:: i INFO: Cleaned 0
batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!11f8!10/26/2004-19:35:47:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobsI had it installed on D:\. I uninstalled, reinstalled on C:\ and now it
works. Must have been some permission thing.
"Bhavin" wrote:
> Hello, I have installed a fresh new Reporting Service sp1, on a Windows 2003
> Server, SQL 2000 sp3, IIS 6.0 and am getting an error when trying to send out
> emails via subscriptions. Cannot decipher the error. Log file is below:
> --
> <Header>
> <Product>Microsoft SQL Server Reporting Services Version
> 8.00.878.00</Product>
> <Locale>en-US</Locale>
> <TimeZone>Pacific Daylight Time</TimeZone>
> <Path>D:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\LogFiles\ReportServerService__10_26_2004_18_45_47.log</Path>
> <SystemName>XXX</SystemName>
> <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> <OSVersion>5.2.3790.0</OSVersion>
> </Header>
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing ConnectionType to '1' as specified in Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing IsSchedulingService to 'True' as specified in Configuration
> file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing IsNotificationService to 'True' as specified in Configuration
> file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing IsEventService to 'True' as specified in Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing PollingInterval to '10' second(s) as specified in Configuration
> file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing MemoryLimit to '60' percent as specified in Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing RecycleTime to '720' minute(s) as specified in Configuration
> file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing MaximumMemoryLimit to '80' percent as specified in Configuration
> file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
> Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration
> file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
> Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing MaxScheduleWait to '5' second(s) as specified in Configuration
> file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing DatabaseQueryTimeout to '120' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration
> file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing RunningRequestsDbCycle to '60' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing RunningRequestsAge to '30' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing CleanupCycleMinutes to '10' minute(s) as specified in
> Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing SecureConnectionLevel to '0' as specified in Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing DisplayErrorLink to 'True' as specified in Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing WebServiceUseFileShareStorage to default value of 'False'
> because it was not specified in Configuration file.
> ReportingServicesService!resourceutilities!ea4!10/26/2004-18:45:47:: i INFO:
> Running on 2 physical processors, 4 logical processors
> ReportingServicesService!resourceutilities!ea4!10/26/2004-18:45:47:: i INFO:
> Reporting Services starting SKU: Standard
> ReportingServicesService!runningjobs!ea4!10/26/2004-18:45:47:: i INFO:
> Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
> ReportingServicesService!runningjobs!ea4!10/26/2004-18:45:47:: i INFO:
> Running Requests Scavenger timer enabled: Cycle: 60 seconds
> ReportingServicesService!runningjobs!ea4!10/26/2004-18:45:47:: i INFO:
> Running Requests DB timer enabled: Cycle: 60 seconds
> ReportingServicesService!runningjobs!ea4!10/26/2004-18:45:47:: i INFO:
> Execution Log Entry Expiration timer enabled: Cycle: 26052 seconds
> ReportingServicesService!runningjobs!ea4!10/26/2004-18:45:47:: i INFO:
> Memory stats update timer enabled: Cycle: 60 seconds
> ReportingServicesService!crypto!d4c!10/26/2004-18:45:47:: i INFO:
> Initializing crypto as user: NT AUTHORITY\NETWORK SERVICE
> ReportingServicesService!crypto!d4c!10/26/2004-18:45:47:: i INFO: Exporting
> public key
> ReportingServicesService!crypto!d4c!10/26/2004-18:45:47:: i INFO: Performing
> sku validation
> ReportingServicesService!crypto!d4c!10/26/2004-18:45:47:: i INFO: Importing
> existing encryption key
> ReportingServicesService!dbpolling!d4c!10/26/2004-18:45:47:: EventPolling
> polling service started
> ReportingServicesService!dbpolling!d4c!10/26/2004-18:45:47::
> NotificationPolling polling service started
> ReportingServicesService!dbpolling!d4c!10/26/2004-18:45:47:: SchedulePolling
> polling service started
> ReportingServicesService!dbpolling!c2c!10/26/2004-18:45:47::
> NotificationPolling heartbeat thread started.
> ReportingServicesService!dbpolling!1464!10/26/2004-18:45:47:: EventPolling
> heartbeat thread started.
> ReportingServicesService!dbpolling!1254!10/26/2004-18:45:47:: Polling started
> ReportingServicesService!library!1590!10/26/2004-18:55:47:: Using folder
> D:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\RSTempFiles
> for temporary files.
> ReportingServicesService!library!1590!10/26/2004-18:55:47:: i INFO: Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 3 snapshots, 10
> chunks, 0 running jobs
> ReportingServicesService!dbpolling!1254!10/26/2004-19:04:09:: EventPolling
> processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!13c!10/26/2004-19:04:09:: EventPolling
> processing item 91cd2565-e05c-4157-accf-8ac92b1b24c8
> ReportingServicesService!library!13c!10/26/2004-19:04:09:: Schedule
> 23b76016-934c-4b5c-bcb1-4ebe8d981694 executed at 10/26/2004 7:04:09 PM.
> ReportingServicesService!schedule!13c!10/26/2004-19:04:09:: Creating Time
> based subscription notification for subscription:
> d680d144-e89e-4dd2-8be7-3f365310eb4f
> ReportingServicesService!library!13c!10/26/2004-19:04:09:: Schedule
> 23b76016-934c-4b5c-bcb1-4ebe8d981694 execution completed at 10/26/2004
> 7:04:09 PM.
> ReportingServicesService!dbpolling!13c!10/26/2004-19:04:09:: EventPolling
> finished processing item 91cd2565-e05c-4157-accf-8ac92b1b24c8
> ReportingServicesService!dbpolling!1254!10/26/2004-19:04:09::
> NotificationPolling processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!13c!10/26/2004-19:04:09::
> NotificationPolling processing item af68ce86-9586-4feb-b332-3019e012eda7
> ReportingServicesService!library!13c!10/26/2004-19:04:09:: i INFO:
> Initializing EnableIntegratedSecurity to 'True' as specified in Server
> system properties.
> ReportingServicesService!library!13c!10/26/2004-19:04:10:: i INFO: Call to
> RenderFirst( '/Ahl Reports/QualityOfImages' )
> ReportingServicesService!library!13c!10/26/2004-19:04:10:: i INFO:
> Initializing SessionTimeout to '600' second(s) as specified in Server system
> properties.
> ReportingServicesService!library!13c!10/26/2004-19:04:10:: i INFO:
> Initializing EnableExecutionLogging to 'True' as specified in Server system
> properties.
> ReportingServicesService!library!fe8!10/26/2004-19:04:10:: i INFO:
> Initializing SqlStreamingBufferSize to default value of '64640' Bytes because
> it was not specified in Server system properties.
> ReportingServicesService!library!fe8!10/26/2004-19:04:10:: i INFO:
> Initializing SnapshotCompression to 'SQL' as specified in Server system
> properties.
> ReportingServicesService!library!13c!10/26/2004-19:04:10:: i INFO:
> Initializing SessionAccessTimeout to default value of '600' seconds because
> it was not specified in Server system properties.
> ReportingServicesService!session!13c!10/26/2004-19:04:10:: i INFO:
> LoadSnapshot: Item with session: d5x5c355p2lstn45rxfewd55, reportPath: /Ahl
> Reports/QualityOfImages, userName: AHLCENTRAL\XXX not found in the database
> ReportingServicesService!chunks!13c!10/26/2004-19:04:10:: i INFO: ###
> GetReportChunk('QualityOfImages_style', 1), chunk was not found!
> this=0b55a7a3-80b8-4761-b0c7-22bb5f291c0b
> ReportingServicesService!chunks!13c!10/26/2004-19:04:10:: i INFO: ###
> GetReportChunk('Main', 0), chunk was not found!
> this=0b55a7a3-80b8-4761-b0c7-22bb5f291c0b
> ReportingServicesService!processing!13c!10/26/2004-19:04:10:: a ASSERT:
> Assertion failed! Call stack:
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.b(Boolean A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream
> A_0)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, CreateReportChunk A_1, Hashtable& A_2, a& A_3, Boolean& A_4)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshotStream(CreateReportChunk
> createChunkCallback, String streamName, RenderingContext rc, GetResource
> getResourceCallback)
> Microsoft.ReportingServices.Library.RSService.InternalGetReportImageLive(ClientRequest session, CatalogItemContext itemContext, String imageId)
> Microsoft.ReportingServices.Library.RSService.InternalGetReportImage(ClientRequest session, CatalogItemContext itemContext)
> Microsoft.ReportingServices.Library.RSService.GetReportImage(ClientRequest
> session, CatalogItemContext itemContext)
> Microsoft.ReportingServices.Library.RenderedOutputFileImpl.GetRsStream()
> Microsoft.ReportingServices.Library.RenderedOutputFileImpl.get_FileName()
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.EmbedReport(IMessage
> message, RenderedOutputFile[] reportData, Notification notification,
> SubscriptionData data)
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
> Microsoft.ReportingServices.Library.NotificationQueueWorker.HandleNotification(QueueItem item)
> Microsoft.ReportingServices.Library.NotificationQueueWorker.QueueWorker(QueueItem item)
> Microsoft.ReportingServices.Library.QueuePollWorker.WorkItemStart(Object
> state)
> ReportingServicesService!processing!13c!10/26/2004-19:04:10:: e ERROR:
> Throwing
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
> unexpected error occurred in Report Processing., ;
> Info:
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
> unexpected error occurred in Report Processing.
> ReportingServicesService!emailextension!13c!10/26/2004-19:04:10:: Error
> sending email.
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
> unexpected error occurred in Report Processing.
> at Microsoft.ReportingServices.ReportProcessing.Persistence.f.b(Boolean
> A_0)
> at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
> at
> Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, CreateReportChunk A_1, Hashtable& A_2, a& A_3, Boolean& A_4)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshotStream(CreateReportChunk
> createChunkCallback, String streamName, RenderingContext rc, GetResource
> getResourceCallback)
> at
> Microsoft.ReportingServices.Library.RSService.InternalGetReportImageLive(ClientRequest session, CatalogItemContext itemContext, String imageId)
> at
> Microsoft.ReportingServices.Library.RSService.InternalGetReportImage(ClientRequest session, CatalogItemContext itemContext)
> at
> Microsoft.ReportingServices.Library.RSService.GetReportImage(ClientRequest
> session, CatalogItemContext itemContext)
> at Microsoft.ReportingServices.Library.RenderedOutputFileImpl.GetRsStream()
> at
> Microsoft.ReportingServices.Library.RenderedOutputFileImpl.get_FileName()
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.EmbedReport(IMessage
> message, RenderedOutputFile[] reportData, Notification notification,
> SubscriptionData data)
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
> ReportingServicesService!notification!13c!10/26/2004-19:04:10:: Notification
> af68ce86-9586-4feb-b332-3019e012eda7 completed. Success: False, Status:
> Failure sending mail: An unexpected error occurred in Report Processing.,
> DeliveryExtension: Report Server Email, Report: QualityOfImages, Attempt 0
> ReportingServicesService!dbpolling!13c!10/26/2004-19:04:10::
> NotificationPolling finished processing item
> af68ce86-9586-4feb-b332-3019e012eda7
> ReportingServicesService!library!13c!10/26/2004-19:05:47:: i INFO: Cleaned 0
> batch records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 2
> chunks, 0 running jobs
> ReportingServicesService!library!13c4!10/26/2004-19:15:47:: i INFO: Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 2 snapshots, 8
> chunks, 0 running jobs
> ReportingServicesService!library!168!10/26/2004-19:25:47:: i INFO: Cleaned 0
> batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!11f8!10/26/2004-19:35:47:: i INFO: Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
>
Server, SQL 2000 sp3, IIS 6.0 and am getting an error when trying to send out
emails via subscriptions. Cannot decipher the error. Log file is below:
--
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.878.00</Product>
<Locale>en-US</Locale>
<TimeZone>Pacific Daylight Time</TimeZone>
<Path>D:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerService__10_26_2004_18_45_47.log</Path>
<SystemName>XXX</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing ConnectionType to '1' as specified in Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing IsSchedulingService to 'True' as specified in Configuration
file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing IsNotificationService to 'True' as specified in Configuration
file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing PollingInterval to '10' second(s) as specified in Configuration
file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing RecycleTime to '720' minute(s) as specified in Configuration
file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing MaximumMemoryLimit to '80' percent as specified in Configuration
file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration
file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing MaxScheduleWait to '5' second(s) as specified in Configuration
file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing DatabaseQueryTimeout to '120' second(s) as specified in
Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration
file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing RunningRequestsDbCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing RunningRequestsAge to '30' second(s) as specified in
Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing CleanupCycleMinutes to '10' minute(s) as specified in
Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
Initializing WebServiceUseFileShareStorage to default value of 'False'
because it was not specified in Configuration file.
ReportingServicesService!resourceutilities!ea4!10/26/2004-18:45:47:: i INFO:
Running on 2 physical processors, 4 logical processors
ReportingServicesService!resourceutilities!ea4!10/26/2004-18:45:47:: i INFO:
Reporting Services starting SKU: Standard
ReportingServicesService!runningjobs!ea4!10/26/2004-18:45:47:: i INFO:
Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
ReportingServicesService!runningjobs!ea4!10/26/2004-18:45:47:: i INFO:
Running Requests Scavenger timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!ea4!10/26/2004-18:45:47:: i INFO:
Running Requests DB timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!ea4!10/26/2004-18:45:47:: i INFO:
Execution Log Entry Expiration timer enabled: Cycle: 26052 seconds
ReportingServicesService!runningjobs!ea4!10/26/2004-18:45:47:: i INFO:
Memory stats update timer enabled: Cycle: 60 seconds
ReportingServicesService!crypto!d4c!10/26/2004-18:45:47:: i INFO:
Initializing crypto as user: NT AUTHORITY\NETWORK SERVICE
ReportingServicesService!crypto!d4c!10/26/2004-18:45:47:: i INFO: Exporting
public key
ReportingServicesService!crypto!d4c!10/26/2004-18:45:47:: i INFO: Performing
sku validation
ReportingServicesService!crypto!d4c!10/26/2004-18:45:47:: i INFO: Importing
existing encryption key
ReportingServicesService!dbpolling!d4c!10/26/2004-18:45:47:: EventPolling
polling service started
ReportingServicesService!dbpolling!d4c!10/26/2004-18:45:47::
NotificationPolling polling service started
ReportingServicesService!dbpolling!d4c!10/26/2004-18:45:47:: SchedulePolling
polling service started
ReportingServicesService!dbpolling!c2c!10/26/2004-18:45:47::
NotificationPolling heartbeat thread started.
ReportingServicesService!dbpolling!1464!10/26/2004-18:45:47:: EventPolling
heartbeat thread started.
ReportingServicesService!dbpolling!1254!10/26/2004-18:45:47:: Polling started
ReportingServicesService!library!1590!10/26/2004-18:55:47:: Using folder
D:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\RSTempFiles
for temporary files.
ReportingServicesService!library!1590!10/26/2004-18:55:47:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 3 snapshots, 10
chunks, 0 running jobs
ReportingServicesService!dbpolling!1254!10/26/2004-19:04:09:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!13c!10/26/2004-19:04:09:: EventPolling
processing item 91cd2565-e05c-4157-accf-8ac92b1b24c8
ReportingServicesService!library!13c!10/26/2004-19:04:09:: Schedule
23b76016-934c-4b5c-bcb1-4ebe8d981694 executed at 10/26/2004 7:04:09 PM.
ReportingServicesService!schedule!13c!10/26/2004-19:04:09:: Creating Time
based subscription notification for subscription:
d680d144-e89e-4dd2-8be7-3f365310eb4f
ReportingServicesService!library!13c!10/26/2004-19:04:09:: Schedule
23b76016-934c-4b5c-bcb1-4ebe8d981694 execution completed at 10/26/2004
7:04:09 PM.
ReportingServicesService!dbpolling!13c!10/26/2004-19:04:09:: EventPolling
finished processing item 91cd2565-e05c-4157-accf-8ac92b1b24c8
ReportingServicesService!dbpolling!1254!10/26/2004-19:04:09::
NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!13c!10/26/2004-19:04:09::
NotificationPolling processing item af68ce86-9586-4feb-b332-3019e012eda7
ReportingServicesService!library!13c!10/26/2004-19:04:09:: i INFO:
Initializing EnableIntegratedSecurity to 'True' as specified in Server
system properties.
ReportingServicesService!library!13c!10/26/2004-19:04:10:: i INFO: Call to
RenderFirst( '/Ahl Reports/QualityOfImages' )
ReportingServicesService!library!13c!10/26/2004-19:04:10:: i INFO:
Initializing SessionTimeout to '600' second(s) as specified in Server system
properties.
ReportingServicesService!library!13c!10/26/2004-19:04:10:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!library!fe8!10/26/2004-19:04:10:: i INFO:
Initializing SqlStreamingBufferSize to default value of '64640' Bytes because
it was not specified in Server system properties.
ReportingServicesService!library!fe8!10/26/2004-19:04:10:: i INFO:
Initializing SnapshotCompression to 'SQL' as specified in Server system
properties.
ReportingServicesService!library!13c!10/26/2004-19:04:10:: i INFO:
Initializing SessionAccessTimeout to default value of '600' seconds because
it was not specified in Server system properties.
ReportingServicesService!session!13c!10/26/2004-19:04:10:: i INFO:
LoadSnapshot: Item with session: d5x5c355p2lstn45rxfewd55, reportPath: /Ahl
Reports/QualityOfImages, userName: AHLCENTRAL\XXX not found in the database
ReportingServicesService!chunks!13c!10/26/2004-19:04:10:: i INFO: ###
GetReportChunk('QualityOfImages_style', 1), chunk was not found!
this=0b55a7a3-80b8-4761-b0c7-22bb5f291c0b
ReportingServicesService!chunks!13c!10/26/2004-19:04:10:: i INFO: ###
GetReportChunk('Main', 0), chunk was not found!
this=0b55a7a3-80b8-4761-b0c7-22bb5f291c0b
ReportingServicesService!processing!13c!10/26/2004-19:04:10:: a ASSERT:
Assertion failed! Call stack:
Microsoft.ReportingServices.ReportProcessing.Persistence.f.b(Boolean A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream
A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, CreateReportChunk A_1, Hashtable& A_2, a& A_3, Boolean& A_4)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshotStream(CreateReportChunk
createChunkCallback, String streamName, RenderingContext rc, GetResource
getResourceCallback)
Microsoft.ReportingServices.Library.RSService.InternalGetReportImageLive(ClientRequest session, CatalogItemContext itemContext, String imageId)
Microsoft.ReportingServices.Library.RSService.InternalGetReportImage(ClientRequest session, CatalogItemContext itemContext)
Microsoft.ReportingServices.Library.RSService.GetReportImage(ClientRequest
session, CatalogItemContext itemContext)
Microsoft.ReportingServices.Library.RenderedOutputFileImpl.GetRsStream()
Microsoft.ReportingServices.Library.RenderedOutputFileImpl.get_FileName()
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.EmbedReport(IMessage
message, RenderedOutputFile[] reportData, Notification notification,
SubscriptionData data)
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
Microsoft.ReportingServices.Library.NotificationQueueWorker.HandleNotification(QueueItem item)
Microsoft.ReportingServices.Library.NotificationQueueWorker.QueueWorker(QueueItem item)
Microsoft.ReportingServices.Library.QueuePollWorker.WorkItemStart(Object
state)
ReportingServicesService!processing!13c!10/26/2004-19:04:10:: e ERROR:
Throwing
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
unexpected error occurred in Report Processing., ;
Info:
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
unexpected error occurred in Report Processing.
ReportingServicesService!emailextension!13c!10/26/2004-19:04:10:: Error
sending email.
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
unexpected error occurred in Report Processing.
at Microsoft.ReportingServices.ReportProcessing.Persistence.f.b(Boolean
A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
at
Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, CreateReportChunk A_1, Hashtable& A_2, a& A_3, Boolean& A_4)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshotStream(CreateReportChunk
createChunkCallback, String streamName, RenderingContext rc, GetResource
getResourceCallback)
at
Microsoft.ReportingServices.Library.RSService.InternalGetReportImageLive(ClientRequest session, CatalogItemContext itemContext, String imageId)
at
Microsoft.ReportingServices.Library.RSService.InternalGetReportImage(ClientRequest session, CatalogItemContext itemContext)
at
Microsoft.ReportingServices.Library.RSService.GetReportImage(ClientRequest
session, CatalogItemContext itemContext)
at Microsoft.ReportingServices.Library.RenderedOutputFileImpl.GetRsStream()
at
Microsoft.ReportingServices.Library.RenderedOutputFileImpl.get_FileName()
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.EmbedReport(IMessage
message, RenderedOutputFile[] reportData, Notification notification,
SubscriptionData data)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
ReportingServicesService!notification!13c!10/26/2004-19:04:10:: Notification
af68ce86-9586-4feb-b332-3019e012eda7 completed. Success: False, Status:
Failure sending mail: An unexpected error occurred in Report Processing.,
DeliveryExtension: Report Server Email, Report: QualityOfImages, Attempt 0
ReportingServicesService!dbpolling!13c!10/26/2004-19:04:10::
NotificationPolling finished processing item
af68ce86-9586-4feb-b332-3019e012eda7
ReportingServicesService!library!13c!10/26/2004-19:05:47:: i INFO: Cleaned 0
batch records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 2
chunks, 0 running jobs
ReportingServicesService!library!13c4!10/26/2004-19:15:47:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 2 snapshots, 8
chunks, 0 running jobs
ReportingServicesService!library!168!10/26/2004-19:25:47:: i INFO: Cleaned 0
batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!11f8!10/26/2004-19:35:47:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobsI had it installed on D:\. I uninstalled, reinstalled on C:\ and now it
works. Must have been some permission thing.
"Bhavin" wrote:
> Hello, I have installed a fresh new Reporting Service sp1, on a Windows 2003
> Server, SQL 2000 sp3, IIS 6.0 and am getting an error when trying to send out
> emails via subscriptions. Cannot decipher the error. Log file is below:
> --
> <Header>
> <Product>Microsoft SQL Server Reporting Services Version
> 8.00.878.00</Product>
> <Locale>en-US</Locale>
> <TimeZone>Pacific Daylight Time</TimeZone>
> <Path>D:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\LogFiles\ReportServerService__10_26_2004_18_45_47.log</Path>
> <SystemName>XXX</SystemName>
> <OSName>Microsoft Windows NT 5.2.3790.0</OSName>
> <OSVersion>5.2.3790.0</OSVersion>
> </Header>
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing ConnectionType to '1' as specified in Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing IsSchedulingService to 'True' as specified in Configuration
> file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing IsNotificationService to 'True' as specified in Configuration
> file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing IsEventService to 'True' as specified in Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing PollingInterval to '10' second(s) as specified in Configuration
> file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing MemoryLimit to '60' percent as specified in Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing RecycleTime to '720' minute(s) as specified in Configuration
> file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing MaximumMemoryLimit to '80' percent as specified in Configuration
> file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
> Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration
> file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
> Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing MaxScheduleWait to '5' second(s) as specified in Configuration
> file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing DatabaseQueryTimeout to '120' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration
> file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing RunningRequestsDbCycle to '60' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing RunningRequestsAge to '30' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing CleanupCycleMinutes to '10' minute(s) as specified in
> Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing SecureConnectionLevel to '0' as specified in Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing DisplayErrorLink to 'True' as specified in Configuration file.
> ReportingServicesService!library!ea4!10/26/2004-18:45:47:: i INFO:
> Initializing WebServiceUseFileShareStorage to default value of 'False'
> because it was not specified in Configuration file.
> ReportingServicesService!resourceutilities!ea4!10/26/2004-18:45:47:: i INFO:
> Running on 2 physical processors, 4 logical processors
> ReportingServicesService!resourceutilities!ea4!10/26/2004-18:45:47:: i INFO:
> Reporting Services starting SKU: Standard
> ReportingServicesService!runningjobs!ea4!10/26/2004-18:45:47:: i INFO:
> Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
> ReportingServicesService!runningjobs!ea4!10/26/2004-18:45:47:: i INFO:
> Running Requests Scavenger timer enabled: Cycle: 60 seconds
> ReportingServicesService!runningjobs!ea4!10/26/2004-18:45:47:: i INFO:
> Running Requests DB timer enabled: Cycle: 60 seconds
> ReportingServicesService!runningjobs!ea4!10/26/2004-18:45:47:: i INFO:
> Execution Log Entry Expiration timer enabled: Cycle: 26052 seconds
> ReportingServicesService!runningjobs!ea4!10/26/2004-18:45:47:: i INFO:
> Memory stats update timer enabled: Cycle: 60 seconds
> ReportingServicesService!crypto!d4c!10/26/2004-18:45:47:: i INFO:
> Initializing crypto as user: NT AUTHORITY\NETWORK SERVICE
> ReportingServicesService!crypto!d4c!10/26/2004-18:45:47:: i INFO: Exporting
> public key
> ReportingServicesService!crypto!d4c!10/26/2004-18:45:47:: i INFO: Performing
> sku validation
> ReportingServicesService!crypto!d4c!10/26/2004-18:45:47:: i INFO: Importing
> existing encryption key
> ReportingServicesService!dbpolling!d4c!10/26/2004-18:45:47:: EventPolling
> polling service started
> ReportingServicesService!dbpolling!d4c!10/26/2004-18:45:47::
> NotificationPolling polling service started
> ReportingServicesService!dbpolling!d4c!10/26/2004-18:45:47:: SchedulePolling
> polling service started
> ReportingServicesService!dbpolling!c2c!10/26/2004-18:45:47::
> NotificationPolling heartbeat thread started.
> ReportingServicesService!dbpolling!1464!10/26/2004-18:45:47:: EventPolling
> heartbeat thread started.
> ReportingServicesService!dbpolling!1254!10/26/2004-18:45:47:: Polling started
> ReportingServicesService!library!1590!10/26/2004-18:55:47:: Using folder
> D:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\RSTempFiles
> for temporary files.
> ReportingServicesService!library!1590!10/26/2004-18:55:47:: i INFO: Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 3 snapshots, 10
> chunks, 0 running jobs
> ReportingServicesService!dbpolling!1254!10/26/2004-19:04:09:: EventPolling
> processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!13c!10/26/2004-19:04:09:: EventPolling
> processing item 91cd2565-e05c-4157-accf-8ac92b1b24c8
> ReportingServicesService!library!13c!10/26/2004-19:04:09:: Schedule
> 23b76016-934c-4b5c-bcb1-4ebe8d981694 executed at 10/26/2004 7:04:09 PM.
> ReportingServicesService!schedule!13c!10/26/2004-19:04:09:: Creating Time
> based subscription notification for subscription:
> d680d144-e89e-4dd2-8be7-3f365310eb4f
> ReportingServicesService!library!13c!10/26/2004-19:04:09:: Schedule
> 23b76016-934c-4b5c-bcb1-4ebe8d981694 execution completed at 10/26/2004
> 7:04:09 PM.
> ReportingServicesService!dbpolling!13c!10/26/2004-19:04:09:: EventPolling
> finished processing item 91cd2565-e05c-4157-accf-8ac92b1b24c8
> ReportingServicesService!dbpolling!1254!10/26/2004-19:04:09::
> NotificationPolling processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!13c!10/26/2004-19:04:09::
> NotificationPolling processing item af68ce86-9586-4feb-b332-3019e012eda7
> ReportingServicesService!library!13c!10/26/2004-19:04:09:: i INFO:
> Initializing EnableIntegratedSecurity to 'True' as specified in Server
> system properties.
> ReportingServicesService!library!13c!10/26/2004-19:04:10:: i INFO: Call to
> RenderFirst( '/Ahl Reports/QualityOfImages' )
> ReportingServicesService!library!13c!10/26/2004-19:04:10:: i INFO:
> Initializing SessionTimeout to '600' second(s) as specified in Server system
> properties.
> ReportingServicesService!library!13c!10/26/2004-19:04:10:: i INFO:
> Initializing EnableExecutionLogging to 'True' as specified in Server system
> properties.
> ReportingServicesService!library!fe8!10/26/2004-19:04:10:: i INFO:
> Initializing SqlStreamingBufferSize to default value of '64640' Bytes because
> it was not specified in Server system properties.
> ReportingServicesService!library!fe8!10/26/2004-19:04:10:: i INFO:
> Initializing SnapshotCompression to 'SQL' as specified in Server system
> properties.
> ReportingServicesService!library!13c!10/26/2004-19:04:10:: i INFO:
> Initializing SessionAccessTimeout to default value of '600' seconds because
> it was not specified in Server system properties.
> ReportingServicesService!session!13c!10/26/2004-19:04:10:: i INFO:
> LoadSnapshot: Item with session: d5x5c355p2lstn45rxfewd55, reportPath: /Ahl
> Reports/QualityOfImages, userName: AHLCENTRAL\XXX not found in the database
> ReportingServicesService!chunks!13c!10/26/2004-19:04:10:: i INFO: ###
> GetReportChunk('QualityOfImages_style', 1), chunk was not found!
> this=0b55a7a3-80b8-4761-b0c7-22bb5f291c0b
> ReportingServicesService!chunks!13c!10/26/2004-19:04:10:: i INFO: ###
> GetReportChunk('Main', 0), chunk was not found!
> this=0b55a7a3-80b8-4761-b0c7-22bb5f291c0b
> ReportingServicesService!processing!13c!10/26/2004-19:04:10:: a ASSERT:
> Assertion failed! Call stack:
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.b(Boolean A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
> Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream
> A_0)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, CreateReportChunk A_1, Hashtable& A_2, a& A_3, Boolean& A_4)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshotStream(CreateReportChunk
> createChunkCallback, String streamName, RenderingContext rc, GetResource
> getResourceCallback)
> Microsoft.ReportingServices.Library.RSService.InternalGetReportImageLive(ClientRequest session, CatalogItemContext itemContext, String imageId)
> Microsoft.ReportingServices.Library.RSService.InternalGetReportImage(ClientRequest session, CatalogItemContext itemContext)
> Microsoft.ReportingServices.Library.RSService.GetReportImage(ClientRequest
> session, CatalogItemContext itemContext)
> Microsoft.ReportingServices.Library.RenderedOutputFileImpl.GetRsStream()
> Microsoft.ReportingServices.Library.RenderedOutputFileImpl.get_FileName()
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.EmbedReport(IMessage
> message, RenderedOutputFile[] reportData, Notification notification,
> SubscriptionData data)
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
> Microsoft.ReportingServices.Library.NotificationQueueWorker.HandleNotification(QueueItem item)
> Microsoft.ReportingServices.Library.NotificationQueueWorker.QueueWorker(QueueItem item)
> Microsoft.ReportingServices.Library.QueuePollWorker.WorkItemStart(Object
> state)
> ReportingServicesService!processing!13c!10/26/2004-19:04:10:: e ERROR:
> Throwing
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
> unexpected error occurred in Report Processing., ;
> Info:
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
> unexpected error occurred in Report Processing.
> ReportingServicesService!emailextension!13c!10/26/2004-19:04:10:: Error
> sending email.
> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
> unexpected error occurred in Report Processing.
> at Microsoft.ReportingServices.ReportProcessing.Persistence.f.b(Boolean
> A_0)
> at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
> at
> Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, CreateReportChunk A_1, Hashtable& A_2, a& A_3, Boolean& A_4)
> at
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshotStream(CreateReportChunk
> createChunkCallback, String streamName, RenderingContext rc, GetResource
> getResourceCallback)
> at
> Microsoft.ReportingServices.Library.RSService.InternalGetReportImageLive(ClientRequest session, CatalogItemContext itemContext, String imageId)
> at
> Microsoft.ReportingServices.Library.RSService.InternalGetReportImage(ClientRequest session, CatalogItemContext itemContext)
> at
> Microsoft.ReportingServices.Library.RSService.GetReportImage(ClientRequest
> session, CatalogItemContext itemContext)
> at Microsoft.ReportingServices.Library.RenderedOutputFileImpl.GetRsStream()
> at
> Microsoft.ReportingServices.Library.RenderedOutputFileImpl.get_FileName()
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.EmbedReport(IMessage
> message, RenderedOutputFile[] reportData, Notification notification,
> SubscriptionData data)
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
> ReportingServicesService!notification!13c!10/26/2004-19:04:10:: Notification
> af68ce86-9586-4feb-b332-3019e012eda7 completed. Success: False, Status:
> Failure sending mail: An unexpected error occurred in Report Processing.,
> DeliveryExtension: Report Server Email, Report: QualityOfImages, Attempt 0
> ReportingServicesService!dbpolling!13c!10/26/2004-19:04:10::
> NotificationPolling finished processing item
> af68ce86-9586-4feb-b332-3019e012eda7
> ReportingServicesService!library!13c!10/26/2004-19:05:47:: i INFO: Cleaned 0
> batch records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 2
> chunks, 0 running jobs
> ReportingServicesService!library!13c4!10/26/2004-19:15:47:: i INFO: Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 2 snapshots, 8
> chunks, 0 running jobs
> ReportingServicesService!library!168!10/26/2004-19:25:47:: i INFO: Cleaned 0
> batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!11f8!10/26/2004-19:35:47:: i INFO: Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
>
Assertion Errors, temdb guest account, and other errors
Last night, we had a sql server (2000, sp3) whose transaction logs get
backed up to a share have the log backup jobs fail. At the same time, a
database that is a replication publisher became unavailable. We were getting
the following errors in the sql server error log but this error was written
only once to the W2003 Application event log:
Error: 3624, Severity: 20, State: 1.
SQL Server Assertion: File: <sysscan.cpp>, line=565
Failed Assertion = 'xdes->GetDbId () == sDbid'.
I'm still researching this error.
The replicated database showed up in EM but there were no tables (not even
system tables). We tried to detach it to see if we could perhaps re-attach
the files and return it to availability but since it was being replicated,
it would not allow us to do so. We tried various ways of dropping the
publication but since the database was unavailable, we were unable to drop
it.
Since regardless of our resolution to bringing this database back on-line
(restore, etc.) was going to require that we get rid of it as it is, we
restarted the sql server service. The database showed up again and seemed to
be fine. However, this morning, after numerous reports from people unable to
see the databases on this server and errors related to invalid login in
tempdb, I discovered that the guest account was disabled. I granted access
to tempdb to the guest account and that resolved this problem.
We have also had a number of problems with the linked servers that were
previously functional to and from this server.
We recreated the replication of the database that had the problem last night
and the conflict tables are named aonflict% instead of conflict%. We're not
sure if this is related or not but the other problems certainly seem to be
related.
Everything seems to be functional now but I am faced with the task of
putting all of these pieces together in order to determine the cause and to
prevent it from happening again. Any advice on any of these possibly related
issues would be appreciated.It appears as if guest was disabled in model which would explain why it was
disabled in tempdb after restarting the sql server service. I'm not sure why
it was disabled in model.
We're calling MS PSS regarding the assertion errors.
It appears as if the funny conflict table names are due to the failure to
clean up the old publication and/or subscription.
"michelle" <michelle@.nospam.com> wrote in message
news:uUP169kdEHA.1604@.TK2MSFTNGP11.phx.gbl...
> Last night, we had a sql server (2000, sp3) whose transaction logs get
> backed up to a share have the log backup jobs fail. At the same time, a
> database that is a replication publisher became unavailable. We were
getting
> the following errors in the sql server error log but this error was
written
> only once to the W2003 Application event log:
> Error: 3624, Severity: 20, State: 1.
> SQL Server Assertion: File: <sysscan.cpp>, line=565
> Failed Assertion = 'xdes->GetDbId () == sDbid'.
> I'm still researching this error.
> The replicated database showed up in EM but there were no tables (not even
> system tables). We tried to detach it to see if we could perhaps re-attach
> the files and return it to availability but since it was being replicated,
> it would not allow us to do so. We tried various ways of dropping the
> publication but since the database was unavailable, we were unable to drop
> it.
> Since regardless of our resolution to bringing this database back on-line
> (restore, etc.) was going to require that we get rid of it as it is, we
> restarted the sql server service. The database showed up again and seemed
to
> be fine. However, this morning, after numerous reports from people unable
to
> see the databases on this server and errors related to invalid login in
> tempdb, I discovered that the guest account was disabled. I granted access
> to tempdb to the guest account and that resolved this problem.
> We have also had a number of problems with the linked servers that were
> previously functional to and from this server.
> We recreated the replication of the database that had the problem last
night
> and the conflict tables are named aonflict% instead of conflict%. We're
not
> sure if this is related or not but the other problems certainly seem to be
> related.
> Everything seems to be functional now but I am faced with the task of
> putting all of these pieces together in order to determine the cause and
to
> prevent it from happening again. Any advice on any of these possibly
related
> issues would be appreciated.
>
backed up to a share have the log backup jobs fail. At the same time, a
database that is a replication publisher became unavailable. We were getting
the following errors in the sql server error log but this error was written
only once to the W2003 Application event log:
Error: 3624, Severity: 20, State: 1.
SQL Server Assertion: File: <sysscan.cpp>, line=565
Failed Assertion = 'xdes->GetDbId () == sDbid'.
I'm still researching this error.
The replicated database showed up in EM but there were no tables (not even
system tables). We tried to detach it to see if we could perhaps re-attach
the files and return it to availability but since it was being replicated,
it would not allow us to do so. We tried various ways of dropping the
publication but since the database was unavailable, we were unable to drop
it.
Since regardless of our resolution to bringing this database back on-line
(restore, etc.) was going to require that we get rid of it as it is, we
restarted the sql server service. The database showed up again and seemed to
be fine. However, this morning, after numerous reports from people unable to
see the databases on this server and errors related to invalid login in
tempdb, I discovered that the guest account was disabled. I granted access
to tempdb to the guest account and that resolved this problem.
We have also had a number of problems with the linked servers that were
previously functional to and from this server.
We recreated the replication of the database that had the problem last night
and the conflict tables are named aonflict% instead of conflict%. We're not
sure if this is related or not but the other problems certainly seem to be
related.
Everything seems to be functional now but I am faced with the task of
putting all of these pieces together in order to determine the cause and to
prevent it from happening again. Any advice on any of these possibly related
issues would be appreciated.It appears as if guest was disabled in model which would explain why it was
disabled in tempdb after restarting the sql server service. I'm not sure why
it was disabled in model.
We're calling MS PSS regarding the assertion errors.
It appears as if the funny conflict table names are due to the failure to
clean up the old publication and/or subscription.
"michelle" <michelle@.nospam.com> wrote in message
news:uUP169kdEHA.1604@.TK2MSFTNGP11.phx.gbl...
> Last night, we had a sql server (2000, sp3) whose transaction logs get
> backed up to a share have the log backup jobs fail. At the same time, a
> database that is a replication publisher became unavailable. We were
getting
> the following errors in the sql server error log but this error was
written
> only once to the W2003 Application event log:
> Error: 3624, Severity: 20, State: 1.
> SQL Server Assertion: File: <sysscan.cpp>, line=565
> Failed Assertion = 'xdes->GetDbId () == sDbid'.
> I'm still researching this error.
> The replicated database showed up in EM but there were no tables (not even
> system tables). We tried to detach it to see if we could perhaps re-attach
> the files and return it to availability but since it was being replicated,
> it would not allow us to do so. We tried various ways of dropping the
> publication but since the database was unavailable, we were unable to drop
> it.
> Since regardless of our resolution to bringing this database back on-line
> (restore, etc.) was going to require that we get rid of it as it is, we
> restarted the sql server service. The database showed up again and seemed
to
> be fine. However, this morning, after numerous reports from people unable
to
> see the databases on this server and errors related to invalid login in
> tempdb, I discovered that the guest account was disabled. I granted access
> to tempdb to the guest account and that resolved this problem.
> We have also had a number of problems with the linked servers that were
> previously functional to and from this server.
> We recreated the replication of the database that had the problem last
night
> and the conflict tables are named aonflict% instead of conflict%. We're
not
> sure if this is related or not but the other problems certainly seem to be
> related.
> Everything seems to be functional now but I am faced with the task of
> putting all of these pieces together in order to determine the cause and
to
> prevent it from happening again. Any advice on any of these possibly
related
> issues would be appreciated.
>
Subscribe to:
Posts (Atom)