Showing posts with label polling. Show all posts
Showing posts with label polling. Show all posts

Sunday, March 11, 2012

"Polling" problem prevents ReportServer to start/work properly

When I start ReportServer I get error in the "Polling" the following error in the LogFiles:

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
<Locale>en-US</Locale>
<TimeZone>W. Europe Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServerService__01_02_2006_20_16_38.log</Path>
<SystemName>********</SystemName>
<OSName>Microsoft Windows NT 5.0.2195 Service Pack 4</OSName>
<OSVersion>5.0.2195.262144</OSVersion>
</Header>
ReportingServicesService!library!4!1/2/2006-20:16:38:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!configmanager!4!1/2/2006-20:16:39:: w WARN: WebServiceAccount is not specified in the config file. Using default: SEMACLW2K237\ASPNET
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!resourceutilities!4!1/2/2006-20:16:39:: i INFO: Reporting Services starting SKU: Developer
ReportingServicesService!resourceutilities!4!1/2/2006-20:16:39:: i INFO: Evaluation copy: 0 days left
ReportingServicesService!runningjobs!4!1/2/2006-20:16:39:: i INFO: Database Cleanup (NT Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
ReportingServicesService!runningjobs!4!1/2/2006-20:16:39:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!4!1/2/2006-20:16:39:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!4!1/2/2006-20:16:39:: i INFO: Execution Log Entry Expiration timer enabled: Next Event: 20600 seconds. Cycle: 86400 seconds
ReportingServicesService!runningjobs!4!1/2/2006-20:16:39:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!4!1/2/2006-20:16:39:: i INFO: SQM timer timer enabled: Next Event: 24200 seconds. Cycle: 86400 seconds
ReportingServicesService!library!8!1/2/2006-20:16:39:: i INFO: Catalog SQL Server Edition = Developer
ReportingServicesService!crypto!8!1/2/2006-20:16:39:: i INFO: Initializing crypto as user: NT AUTHORITY\SYSTEM
ReportingServicesService!crypto!8!1/2/2006-20:16:39:: i INFO: Exporting public key
ReportingServicesService!crypto!8!1/2/2006-20:16:39:: i INFO: Performing sku validation
ReportingServicesService!crypto!8!1/2/2006-20:16:39:: i INFO: Importing existing encryption key
ReportingServicesService!dbpolling!8!01/02/2006-20:16:39:: EventPolling polling service started
ReportingServicesService!dbpolling!a!1/2/2006-20:16:39:: EventPolling heartbeat thread started.
ReportingServicesService!dbpolling!8!01/02/2006-20:16:40:: NotificationPolling polling service started
ReportingServicesService!dbpolling!b!1/2/2006-20:16:40:: NotificationPolling heartbeat thread started.
ReportingServicesService!dbpolling!8!01/02/2006-20:16:40:: SchedulePolling polling service started
ReportingServicesService!dbpolling!8!01/02/2006-20:16:40:: UpgradePolling polling service started
ReportingServicesService!dbpolling!c!1/2/2006-20:16:40:: Polling started
ReportingServicesService!dbpolling!c!1/2/2006-20:16:40:: Polling caught an exception, restarting polling. Error Message System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetWebConfigAuthenticationAttribute(String attrName)
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetAuthenticationType()
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.get_AuthenticationType()
at Microsoft.ReportingServices.Library.NotificationQueueWorker.get_PollCommand()
at Microsoft.ReportingServices.Library.DBPoll.PollingFunction()
at Microsoft.ReportingServices.Library.DBPoll.PollingStartFunction().

ReportingServicesService!dbpolling!4!1/2/2006-20:24:52:: EventPolling polling service stopped
ReportingServicesService!dbpolling!a!1/2/2006-20:24:52:: EventPolling heartbeat thread exiting for stop.
ReportingServicesService!dbpolling!4!1/2/2006-20:24:52:: NotificationPolling polling service stopped
ReportingServicesService!dbpolling!b!1/2/2006-20:24:52:: NotificationPolling heartbeat thread exiting for stop.
ReportingServicesService!dbpolling!4!1/2/2006-20:24:52:: SchedulePolling polling service stopped
ReportingServicesService!dbpolling!4!1/2/2006-20:24:52:: UpgradePolling polling service stopped
ReportingServicesService!servicecontroller!4!1/2/2006-20:24:52:: Service controller exiting.

Any hints would be most helpful. I'm running on Win2000, SQL 2005 and IIS 5.0.

Thanks in advance

Johan Lindell

I'm having this exact same error.

I am running on Windows XP Pro, IIS 5.1, and SQL 2005.

|||

Can you check if the following attribute is in the web.config file:

xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0

If so, then remove it all (attribute name and value).

|||

I had that... I removed it and it worked perfectly.

Thanks Daniel!

|||Good to hear. This is an issue with VS adding this attribute. If you edit the file in notepad you should not have to worry about this.

"Polling" problem prevents ReportServer to start/work properly

When I start ReportServer I get error in the "Polling" the following error in the LogFiles:

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
<Locale>en-US</Locale>
<TimeZone>W. Europe Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServerService__01_02_2006_20_16_38.log</Path>
<SystemName>********</SystemName>
<OSName>Microsoft Windows NT 5.0.2195 Service Pack 4</OSName>
<OSVersion>5.0.2195.262144</OSVersion>
</Header>
ReportingServicesService!library!4!1/2/2006-20:16:38:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!configmanager!4!1/2/2006-20:16:39:: w WARN: WebServiceAccount is not specified in the config file. Using default: SEMACLW2K237\ASPNET
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!4!1/2/2006-20:16:39:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!resourceutilities!4!1/2/2006-20:16:39:: i INFO: Reporting Services starting SKU: Developer
ReportingServicesService!resourceutilities!4!1/2/2006-20:16:39:: i INFO: Evaluation copy: 0 days left
ReportingServicesService!runningjobs!4!1/2/2006-20:16:39:: i INFO: Database Cleanup (NT Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
ReportingServicesService!runningjobs!4!1/2/2006-20:16:39:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!4!1/2/2006-20:16:39:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!4!1/2/2006-20:16:39:: i INFO: Execution Log Entry Expiration timer enabled: Next Event: 20600 seconds. Cycle: 86400 seconds
ReportingServicesService!runningjobs!4!1/2/2006-20:16:39:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!4!1/2/2006-20:16:39:: i INFO: SQM timer timer enabled: Next Event: 24200 seconds. Cycle: 86400 seconds
ReportingServicesService!library!8!1/2/2006-20:16:39:: i INFO: Catalog SQL Server Edition = Developer
ReportingServicesService!crypto!8!1/2/2006-20:16:39:: i INFO: Initializing crypto as user: NT AUTHORITY\SYSTEM
ReportingServicesService!crypto!8!1/2/2006-20:16:39:: i INFO: Exporting public key
ReportingServicesService!crypto!8!1/2/2006-20:16:39:: i INFO: Performing sku validation
ReportingServicesService!crypto!8!1/2/2006-20:16:39:: i INFO: Importing existing encryption key
ReportingServicesService!dbpolling!8!01/02/2006-20:16:39:: EventPolling polling service started
ReportingServicesService!dbpolling!a!1/2/2006-20:16:39:: EventPolling heartbeat thread started.
ReportingServicesService!dbpolling!8!01/02/2006-20:16:40:: NotificationPolling polling service started
ReportingServicesService!dbpolling!b!1/2/2006-20:16:40:: NotificationPolling heartbeat thread started.
ReportingServicesService!dbpolling!8!01/02/2006-20:16:40:: SchedulePolling polling service started
ReportingServicesService!dbpolling!8!01/02/2006-20:16:40:: UpgradePolling polling service started
ReportingServicesService!dbpolling!c!1/2/2006-20:16:40:: Polling started
ReportingServicesService!dbpolling!c!1/2/2006-20:16:40:: Polling caught an exception, restarting polling. Error Message System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetWebConfigAuthenticationAttribute(String attrName)
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetAuthenticationType()
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.get_AuthenticationType()
at Microsoft.ReportingServices.Library.NotificationQueueWorker.get_PollCommand()
at Microsoft.ReportingServices.Library.DBPoll.PollingFunction()
at Microsoft.ReportingServices.Library.DBPoll.PollingStartFunction().

ReportingServicesService!dbpolling!4!1/2/2006-20:24:52:: EventPolling polling service stopped
ReportingServicesService!dbpolling!a!1/2/2006-20:24:52:: EventPolling heartbeat thread exiting for stop.
ReportingServicesService!dbpolling!4!1/2/2006-20:24:52:: NotificationPolling polling service stopped
ReportingServicesService!dbpolling!b!1/2/2006-20:24:52:: NotificationPolling heartbeat thread exiting for stop.
ReportingServicesService!dbpolling!4!1/2/2006-20:24:52:: SchedulePolling polling service stopped
ReportingServicesService!dbpolling!4!1/2/2006-20:24:52:: UpgradePolling polling service stopped
ReportingServicesService!servicecontroller!4!1/2/2006-20:24:52:: Service controller exiting.

Any hints would be most helpful. I'm running on Win2000, SQL 2005 and IIS 5.0.

Thanks in advance

Johan Lindell

I'm having this exact same error.

I am running on Windows XP Pro, IIS 5.1, and SQL 2005.

|||

Can you check if the following attribute is in the web.config file:

xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0

If so, then remove it all (attribute name and value).

|||

I had that... I removed it and it worked perfectly.

Thanks Daniel!

|||Good to hear. This is an issue with VS adding this attribute. If you edit the file in notepad you should not have to worry about this.