web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Preventing a report from timing out in on premise CRM 2011

(0) ShareShare
ReportReport
Posted on by

We've had a new report developed for us that reports across 3 different entities (one of which is leads with over 1m records) in our on premise CRM 2011. However the report takes a long time to run and often just ends in a timeout after about 15 minutes.

I have read a lot of advice on tuning CRM to improve performance. This article is typical, but there seems to be very little on how to tune for reports.  However I have extended the executionTimeout and maxRequestLength as suggested with no improvement.

 I'm not too bothered that the report takes a long time to run if it produced the report in the end. So the most burning issue for me is how to prevent the report timing out even if it's taking longer than CRM would like? I know there are various other settings I could apply, but different articles seem to contradict each other on what to do.

 Can anyone tell me which settings need to be adjusted to allow a report with two sub reports to run for an hour or so if necessary? 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Sumit Bhatnagar 99 Profile Picture
    1,850 on at

    Hi...

    Is there any way where you can provide us the SSRS logs ?

    Go to SSRS server >> %ProgramFiles%\Microsoft SQL Server\MSSQL.x\Reporting Services\LogFiles

    So that we can narrow down to SQL time out or any other error/issue ?

    thanks.

  • Community Member Profile Picture
    on at

    Sure.  Here is the file for today.  I ran the report today all the way through to timeout, so hopefully this log file will have the necessary in it...

    <Header>
    <Product>Microsoft SQL Server Reporting Services Version 2009.0100.2500.00 ((KJ_PCU_Main).110617-0038 )</Product>
    <Locale>English (United Kingdom)</Locale>
    <TimeZone>GMT Daylight Time</TimeZone>
    <Path>C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\Logfiles\ReportServerService__10_24_2013_03_19_54.log</Path>
    <SystemName>SVRNETT01</SystemName>
    <OSName>Microsoft Windows NT 6.1.7601 Service Pack 1</OSName>
    <OSVersion>6.1.7601</OSVersion>
    <ProcessID>2648</ProcessID>
    <Virtualization>None</Virtualization>
    </Header>
    rshost!rshost!adc!10/24/2013-03:19:54:: i INFO: CLR runtime is initialized.
    rshost!rshost!adc!10/24/2013-03:19:54:: i INFO: Derived memory configuration based on physical memory as 16772032 KB
    appdomainmanager!DefaultDomain!afc!10/24/2013-03:19:54:: i INFO: Entered managed ServiceMain in DefaultDomain.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException' as specified in Configuration file.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Threading.ThreadAbortException,System.Web.UI.ViewStateException,System.OutOfMemoryException,System.Web.HttpException,System.IO.IOException,System.IO.FileLoadException,Microsoft.SharePoint.SPException' as specified in Configuration file.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Initializing AuthenticationTypes to '4' as specified in Configuration file.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Initializing RSWindowsExtendedProtectionLevel to 'Off' as specified in Configuration file.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Initializing RSWindowsExtendedProtectionScenario to 'Proxy' as specified in Configuration file.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Initializing EnableAuthPersistence to 'True' as specified in Configuration file.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Initializing MemorySafetyMargin to '80' percent as specified in Configuration file.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Initializing MemoryThreshold to '90' percent as specified in Configuration file.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: w WARN: Initializing UrlRoot to default value of '' because it was incorrectly specified in Configuration file as ''.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Initializing IsReportManagerEnabled to 'True' as specified in Configuration file.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Initializing MaxConnections to '2' as specified in Configuration file.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Initializing Timeout to '10' second(s) as specified in Configuration file.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Initializing AppID to '(Default)' as specified in Configuration file.
    library!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Initializing CacheLevel to 'Default' as specified in Configuration file.
    resourceutilities!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Reporting Services starting SKU: Enterprise
    configmanager!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Using report server internal url http://localhost:80/ReportServer.
    configmanager!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Using report server external url http://SVRNETT01:80/ReportServer.
    configmanager!DefaultDomain!aec!10/24/2013-03:19:56:: i INFO: Using url root http://SVRNETT01:80/ReportServer.
    rshost!rshost!aec!10/24/2013-03:19:56:: i INFO: Configuring maxPhysicalCpu=8, minLogicalCpu=0
    rshost!rshost!aec!10/24/2013-03:19:56:: i INFO: Logical processor per physical processor 2
    rshost!rshost!aec!10/24/2013-03:19:56:: i INFO: Maximum logical CPU is 4
    library!DefaultDomain!aec!10/24/2013-03:20:02:: e ERROR: Throwing Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: , Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: Cannot open database "ReportServer" requested by the login. The login failed.
    Login failed for user 'NETTSALES\ySQL'.
    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
    at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
    at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
    at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
    at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
    at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
    at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
    at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
    at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
    at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
    at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
    at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
    at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
    at System.Data.SqlClient.SqlConnection.Open()
    at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection()
    --- End of inner exception stack trace ---;
    servicecontroller!DefaultDomain!aec!10/24/2013-03:20:02:: e ERROR: Error initializing configuration from the database: Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: Cannot open database "ReportServer" requested by the login. The login failed.
    Login failed for user 'NETTSALES\ySQL'.
    appdomainmanager!DefaultDomain!aec!10/24/2013-03:20:02:: i INFO: Appdomain:2 WindowsService_0 started.
    library!WindowsService_0!aec!10/24/2013-03:20:02:: e ERROR: Throwing Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: , Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: Cannot open database "ReportServer" requested by the login. The login failed.
    Login failed for user 'NETTSALES\ySQL'.
    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
    at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
    at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
    at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
    at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
    at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
    at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
    at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
    at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
    at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
    at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
    at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
    at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
    at System.Data.SqlClient.SqlConnection.Open()
    at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection()
    --- End of inner exception stack trace ---;
    servicecontroller!WindowsService_0!aec!10/24/2013-03:20:02:: e ERROR: Error initializing configuration from the database: Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: Cannot open database "ReportServer" requested by the login. The login failed.
    Login failed for user 'NETTSALES\ySQL'.
    resourceutilities!WindowsService_0!aec!10/24/2013-03:20:02:: i INFO: Reporting Services starting SKU: Enterprise
    library!WindowsService_0!bb4!10/24/2013-03:20:02:: e ERROR: Throwing Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: , Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: Cannot open database "ReportServer" requested by the login. The login failed.
    Login failed for user 'NETTSALES\ySQL'.
    at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
    at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
    at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
    at System.Data.SqlClient.SqlConnection.Open()
    at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection()
    --- End of inner exception stack trace ---;
    library!WindowsService_0!bb4!10/24/2013-03:20:03:: e ERROR: ServiceStartThread: Exception caught while starting service. Error: Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: Cannot open database "ReportServer" requested by the login. The login failed.
    Login failed for user 'NETTSALES\ySQL'.
    library!WindowsService_0!bb4!10/24/2013-03:20:03:: e ERROR: ServiceStartThread: Attempting to start service again...
    rpcserver!DefaultDomain!bb4!10/24/2013-03:20:03:: i INFO: RPC Server started.
    servicecontroller!DefaultDomain!bb4!10/24/2013-03:20:03:: i INFO: RPC Server started. Endpoint name ='ReportingServices$MSRS10_50.MSSQLSERVER'
    appdomainmanager!DefaultDomain!aec!10/24/2013-03:20:03:: i INFO: SPN for the service account is MSSQLSvc/SVRNETT01.nettsales.local:1433
    appdomainmanager!DefaultDomain!aec!10/24/2013-03:20:03:: i INFO: SPN for the service account is MSSQLSvc/SVRNETT01.nettsales.local
    appdomainmanager!DefaultDomain!aec!10/24/2013-03:20:03:: i INFO: The UserAccountControl value for the service account is 66048
    rshost!rshost!c18!10/24/2013-03:20:03:: i INFO: Registered url=http://+:80/ReportServer/, vdir=/ReportServer, pdir=C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer.
    rshost!rshost!c18!10/24/2013-03:20:03:: i INFO: Currently registered url http://+:80/ReportServer/ on endpoint 2
    appdomainmanager!DefaultDomain!aec!10/24/2013-03:20:03:: i INFO: SPN for the service account is MSSQLSvc/SVRNETT01.nettsales.local:1433
    appdomainmanager!DefaultDomain!aec!10/24/2013-03:20:03:: i INFO: SPN for the service account is MSSQLSvc/SVRNETT01.nettsales.local
    appdomainmanager!DefaultDomain!aec!10/24/2013-03:20:03:: i INFO: The UserAccountControl value for the service account is 66048
    rshost!rshost!c18!10/24/2013-03:20:03:: i INFO: Registered url=http://+:80/Reports/, vdir=/Reports, pdir=C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager.
    rshost!rshost!c18!10/24/2013-03:20:03:: i INFO: Currently registered url http://+:80/Reports/ on endpoint 3
    rshost!rshost!c18!10/24/2013-03:20:03:: i INFO: Endpoint 4 is disabled and no url is registered vdir=/ReportServer/ReportBuilder, pdir=C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\ReportBuilder.
    resourceutilities!DefaultDomain!aec!10/24/2013-03:20:03:: i INFO: Maximum memory limit is 2097152Mb
    rshost!rshost!aec!10/24/2013-03:20:03:: i INFO: Derived memory configuration based on physical memory as 16772032 KB
    servicecontroller!DefaultDomain!8c8!10/24/2013-03:20:03:: i INFO: Total Physical memory: 17174560768
    rpcserver!DefaultDomain!c18!10/24/2013-03:20:03:: i INFO: Process monitoring started.
    configmanager!DefaultDomain!bb4!10/24/2013-03:20:22:: i INFO: Using report server internal url http://localhost:80/ReportServer.
    configmanager!DefaultDomain!bb4!10/24/2013-03:20:22:: i INFO: Using report server external url http://SVRNETT01:80/ReportServer.
    configmanager!DefaultDomain!bb4!10/24/2013-03:20:22:: i INFO: Using url root http://SVRNETT01:80/ReportServer.
    rpcserver!DefaultDomain!bb4!10/24/2013-03:20:22:: i INFO: RPC Server stopped.
    servicecontroller!DefaultDomain!bb4!10/24/2013-03:20:22:: i INFO: RPC Server stopped.
    appdomainmanager!DefaultDomain!8c8!10/24/2013-03:20:22:: i INFO: SPN for the service account is MSSQLSvc/SVRNETT01.nettsales.local:1433
    appdomainmanager!DefaultDomain!8c8!10/24/2013-03:20:22:: i INFO: SPN for the service account is MSSQLSvc/SVRNETT01.nettsales.local
    appdomainmanager!DefaultDomain!8c8!10/24/2013-03:20:22:: i INFO: The UserAccountControl value for the service account is 66048
    rshost!rshost!fbc!10/24/2013-03:20:22:: i INFO: Currently registered url http://+:80/ReportServer/ on endpoint 2
    appdomainmanager!DefaultDomain!8c8!10/24/2013-03:20:22:: i INFO: SPN for the service account is MSSQLSvc/SVRNETT01.nettsales.local:1433
    appdomainmanager!DefaultDomain!8c8!10/24/2013-03:20:22:: i INFO: SPN for the service account is MSSQLSvc/SVRNETT01.nettsales.local
    appdomainmanager!DefaultDomain!8c8!10/24/2013-03:20:22:: i INFO: The UserAccountControl value for the service account is 66048
    rshost!rshost!fec!10/24/2013-03:20:22:: i INFO: Currently registered url http://+:80/Reports/ on endpoint 3
    rshost!rshost!afc!10/24/2013-03:20:22:: i INFO: Endpoint 4 is disabled and no url is registered vdir=/ReportServer/ReportBuilder, pdir=C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\ReportBuilder.
    rshost!rshost!8c8!10/24/2013-03:20:22:: i INFO: Derived memory configuration based on physical memory as 16772032 KB
    servicecontroller!DefaultDomain!8c8!10/24/2013-03:20:22:: i INFO: Recycling the service from the default domain
    library!WindowsService_0!bb4!10/24/2013-03:20:22:: i INFO: Catalog SQL Server Edition = Enterprise
    crypto!WindowsService_0!bb4!10/24/2013-03:20:22:: i INFO: Initializing crypto as user: NETTSALES\ySQL
    crypto!WindowsService_0!bb4!10/24/2013-03:20:22:: i INFO: Exporting public key
    crypto!WindowsService_0!bb4!10/24/2013-03:20:22:: i INFO: Performing sku validation
    crypto!WindowsService_0!bb4!10/24/2013-03:20:22:: i INFO: Importing existing encryption key
    configmanager!WindowsService_0!bb4!10/24/2013-03:20:22:: i INFO: Using report server internal url http://localhost:80/ReportServer.
    configmanager!WindowsService_0!bb4!10/24/2013-03:20:22:: i INFO: Using report server external url http://SVRNETT01:80/ReportServer.
    configmanager!WindowsService_0!bb4!10/24/2013-03:20:22:: i INFO: Using url root http://SVRNETT01:80/ReportServer.
    rshost!rshost!8c8!10/24/2013-03:20:22:: i INFO: Application domain type WindowsService statistics: created: 1, unloaded: 1, failed: 0, timed out: 0.
    appdomainmanager!DefaultDomain!8c8!10/24/2013-03:20:22:: i INFO: Appdomain:3 WindowsService_1 started.
    resourceutilities!WindowsService_1!8c8!10/24/2013-03:20:23:: i INFO: Reporting Services starting SKU: Enterprise
    library!WindowsService_1!bb4!10/24/2013-03:20:23:: i INFO: Catalog SQL Server Edition = Enterprise
    servicecontroller!WindowsService_0!8c8!10/24/2013-03:20:23:: i INFO: Service controller exiting.
    appdomainmanager!DefaultDomain!8c8!10/24/2013-03:20:23:: i INFO: Appdomain:2 unregistered.
    appdomainmanager!DefaultDomain!8c8!10/24/2013-03:20:23:: i INFO: Appdomain:2 WindowsService_0 unloading.
    appdomainmanager!DefaultDomain!fec!10/24/2013-03:20:23:: i INFO: AppDomain:2 0 pending unload(s)
    crypto!WindowsService_1!bb4!10/24/2013-03:20:23:: i INFO: Initializing crypto as user: NETTSALES\ySQL
    crypto!WindowsService_1!bb4!10/24/2013-03:20:23:: i INFO: Exporting public key
    crypto!WindowsService_1!bb4!10/24/2013-03:20:23:: i INFO: Performing sku validation
    crypto!WindowsService_1!bb4!10/24/2013-03:20:23:: i INFO: Importing existing encryption key
    dbpolling!WindowsService_1!bb4!10/24/2013-03:20:23:: i INFO: EventPolling polling service started
    dbpolling!WindowsService_1!bb4!10/24/2013-03:20:23:: i INFO: NotificationPolling polling service started
    dbpolling!WindowsService_1!bb4!10/24/2013-03:20:23:: i INFO: SchedulePolling polling service started
    dbpolling!WindowsService_1!bb4!10/24/2013-03:20:23:: i INFO: UpgradePolling polling service started
    dbpolling!WindowsService_1!afc!10/24/2013-03:20:23:: i INFO: HeartbeatThread(EventPolling): heartbeat thread started.
    dbpolling!WindowsService_1!aec!10/24/2013-03:20:23:: i INFO: HeartbeatThread(NotificationPolling): heartbeat thread started.
    dbpolling!WindowsService_1!fec!10/24/2013-03:20:23:: i INFO: PollingMaintenance: Polling started
    resourceutilities!WindowsService_1!fec!10/24/2013-03:20:23:: i INFO: Maximum memory limit is 2097152Mb
    rpcserver!DefaultDomain!bb4!10/24/2013-03:20:23:: i INFO: RPC Server started.
    servicecontroller!DefaultDomain!bb4!10/24/2013-03:20:23:: i INFO: RPC Server started. Endpoint name ='ReportingServices$MSRS10_50.MSSQLSERVER'
    appdomainmanager!WindowsService_1!bb4!10/24/2013-03:20:23:: i INFO: Appdomain:3 WindowsService_1 initialized.
    library!WindowsService_1!b18!10/24/2013-03:30:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!b18!10/24/2013-03:30:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!b18!10/24/2013-03:30:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!fdc!10/24/2013-03:40:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!fdc!10/24/2013-03:40:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!fdc!10/24/2013-03:40:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!b18!10/24/2013-03:50:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!b18!10/24/2013-03:50:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!b18!10/24/2013-03:50:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!b18!10/24/2013-04:00:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!b18!10/24/2013-04:00:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!b18!10/24/2013-04:00:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!bb4!10/24/2013-04:10:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!bb4!10/24/2013-04:10:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!bb4!10/24/2013-04:10:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!fd8!10/24/2013-04:20:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!fd8!10/24/2013-04:20:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!fd8!10/24/2013-04:20:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!fd8!10/24/2013-04:30:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!fd8!10/24/2013-04:30:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!fd8!10/24/2013-04:30:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!fd8!10/24/2013-04:40:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!fd8!10/24/2013-04:40:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!fd8!10/24/2013-04:40:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!fdc!10/24/2013-04:50:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!fdc!10/24/2013-04:50:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!fdc!10/24/2013-04:50:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!b18!10/24/2013-05:00:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!b18!10/24/2013-05:00:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!b18!10/24/2013-05:00:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!fd8!10/24/2013-05:10:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!fd8!10/24/2013-05:10:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!fd8!10/24/2013-05:10:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!fd8!10/24/2013-05:20:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!fd8!10/24/2013-05:20:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!fd8!10/24/2013-05:20:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!b18!10/24/2013-05:30:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!b18!10/24/2013-05:30:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!b18!10/24/2013-05:30:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!bb4!10/24/2013-05:40:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!bb4!10/24/2013-05:40:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!bb4!10/24/2013-05:40:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!b18!10/24/2013-05:50:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!b18!10/24/2013-05:50:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!b18!10/24/2013-05:50:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!fdc!10/24/2013-06:00:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!fdc!10/24/2013-06:00:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!fdc!10/24/2013-06:00:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!b18!10/24/2013-06:10:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!b18!10/24/2013-06:10:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!b18!10/24/2013-06:10:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!fdc!10/24/2013-06:20:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!fdc!10/24/2013-06:20:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!fdc!10/24/2013-06:20:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!fdc!10/24/2013-06:30:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!fdc!10/24/2013-06:30:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!fdc!10/24/2013-06:30:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!bb4!10/24/2013-06:40:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!bb4!10/24/2013-06:40:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!bb4!10/24/2013-06:40:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!fd8!10/24/2013-06:50:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!fd8!10/24/2013-06:50:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!fd8!10/24/2013-06:50:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!fd8!10/24/2013-07:00:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!fd8!10/24/2013-07:00:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!fd8!10/24/2013-07:00:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!bb4!10/24/2013-07:10:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!bb4!10/24/2013-07:10:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!bb4!10/24/2013-07:10:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!bb4!10/24/2013-07:20:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!bb4!10/24/2013-07:20:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!bb4!10/24/2013-07:20:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!fdc!10/24/2013-07:30:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!fdc!10/24/2013-07:30:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!fdc!10/24/2013-07:30:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!bb4!10/24/2013-07:40:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!bb4!10/24/2013-07:40:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!bb4!10/24/2013-07:40:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!b18!10/24/2013-07:50:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!b18!10/24/2013-07:50:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!b18!10/24/2013-07:50:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!bb4!10/24/2013-08:00:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!bb4!10/24/2013-08:00:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!bb4!10/24/2013-08:00:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!bb4!10/24/2013-08:10:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!bb4!10/24/2013-08:10:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!bb4!10/24/2013-08:10:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!fd8!10/24/2013-08:20:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!fd8!10/24/2013-08:20:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!fd8!10/24/2013-08:20:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!fd8!10/24/2013-08:30:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!fd8!10/24/2013-08:30:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!fd8!10/24/2013-08:30:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!fd8!10/24/2013-08:40:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!fd8!10/24/2013-08:40:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!fd8!10/24/2013-08:40:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!fd8!10/24/2013-08:50:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!fd8!10/24/2013-08:50:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!fd8!10/24/2013-08:50:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!b18!10/24/2013-09:00:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!b18!10/24/2013-09:00:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!b18!10/24/2013-09:00:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!b18!10/24/2013-09:10:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!b18!10/24/2013-09:10:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!b18!10/24/2013-09:10:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!bb4!10/24/2013-09:20:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!bb4!10/24/2013-09:20:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!bb4!10/24/2013-09:20:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!bb4!10/24/2013-09:30:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!bb4!10/24/2013-09:30:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!bb4!10/24/2013-09:30:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!b18!10/24/2013-09:40:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!b18!10/24/2013-09:40:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!b18!10/24/2013-09:40:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!fdc!10/24/2013-09:50:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!fdc!10/24/2013-09:50:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!fdc!10/24/2013-09:50:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!bb4!10/24/2013-10:00:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!bb4!10/24/2013-10:00:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!bb4!10/24/2013-10:00:23:: i INFO: Call to CleanBatch() ends
    appdomainmanager!DefaultDomain!cc8!10/24/2013-10:00:29:: i INFO: Appdomain:4 ReportServer_MSSQLSERVER_0-1-130270788290530725 started.
    appdomainmanager!ReportServer_0-1!cc8!10/24/2013-10:00:45:: i INFO: RS authentication mode is 4; effective ASP.NET authentication mode is Windows. vdir=/ReportServer.
    appdomainmanager!DefaultDomain!cc8!10/24/2013-10:00:45:: i INFO: Appdomain:4 ReportServer_MSSQLSERVER_0-1-130270788290530725 initialized (#1).
    webserver!ReportServer_0-1!cc8!10/24/2013-10:01:32:: i INFO: Reporting Web Server started
    resourceutilities!ReportServer_0-1!cc8!10/24/2013-10:01:32:: i INFO: Reporting Services starting SKU: Enterprise
    resourceutilities!ReportServer_0-1!cc8!10/24/2013-10:01:32:: i INFO: Maximum memory limit is 2097152Mb
    extensionfactory!ReportServer_0-1!cc8!10/24/2013-10:01:34:: e ERROR: Exception caught instantiating TERADATA report server extension: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Teradata.Client.Provider, Version=12.0.0.0, Culture=neutral, PublicKeyToken=76b417ee2e04956c' or one of its dependencies. The system cannot find the file specified.
    File name: 'Teradata.Client.Provider, Version=12.0.0.0, Culture=neutral, PublicKeyToken=76b417ee2e04956c'
    at System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)
    at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
    at System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
    at System.Reflection.Assembly.Load(String assemblyString)
    at Microsoft.ReportingServices.DataExtensions.TeradataConnectionWrapper.LoadTdAssembly()
    at Microsoft.ReportingServices.DataExtensions.TeradataConnectionWrapper.GetTdConnectionType()
    at Microsoft.ReportingServices.DataExtensions.TeradataConnectionWrapper..ctor()

    WRN: Assembly binding logging is turned OFF.
    To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
    Note: There is some performance penalty associated with assembly bind failure logging.
    To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

    --- End of inner exception stack trace ---
    at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck)
    at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache)
    at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache)
    at System.Activator.CreateInstance(Type type, Boolean nonPublic)
    at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
    at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.<>c__DisplayClass2.<CreateExtensionObject>b__0()
    at Microsoft.ReportingServices.Diagnostics.RevertImpersonationContext.<>c__DisplayClass1.<Run>b__0(Object state)
    at System.Security.SecurityContext.runTryCode(Object userData)
    at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
    at System.Security.SecurityContext.Run(SecurityContext securityContext, ContextCallback callback, Object state)
    at Microsoft.ReportingServices.Diagnostics.RevertImpersonationContext.Run(ContextBody callback)
    at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.CreateExtensionObject(Extension extConfig, Boolean typeOnly).
    extensionfactory!ReportServer_0-1!cc8!10/24/2013-10:01:35:: e ERROR: Exception caught instantiating SQLPDW report server extension: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.ArgumentException: Unable to find the requested .Net Framework Data Provider. It may not be installed.
    at System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName)
    at Microsoft.ReportingServices.DataExtensions.SqlDwConnectionWrapper..ctor()
    --- End of inner exception stack trace ---
    at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck)
    at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache)
    at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache)
    at System.Activator.CreateInstance(Type type, Boolean nonPublic)
    at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
    at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.<>c__DisplayClass2.<CreateExtensionObject>b__0()
    at Microsoft.ReportingServices.Diagnostics.RevertImpersonationContext.<>c__DisplayClass1.<Run>b__0(Object state)
    at System.Security.SecurityContext.runTryCode(Object userData)
    at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
    at System.Security.SecurityContext.Run(SecurityContext securityContext, ContextCallback callback, Object state)
    at Microsoft.ReportingServices.Diagnostics.RevertImpersonationContext.Run(ContextBody callback)
    at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.CreateExtensionObject(Extension extConfig, Boolean typeOnly).
    library!ReportServer_0-1!2074!10/24/2013-10:01:35:: Call to GetDataSourceContentsAction(/SharedReports/5.0.xxxx/MSCRM_FetchDataSource).
    library!ReportServer_0-1!2074!10/24/2013-10:01:35:: i INFO: Catalog SQL Server Edition = Enterprise
    crypto!ReportServer_0-1!2074!10/24/2013-10:01:35:: i INFO: Initializing crypto as user: NETTSALES\ySQL
    crypto!ReportServer_0-1!2074!10/24/2013-10:01:35:: i INFO: Exporting public key
    crypto!ReportServer_0-1!2074!10/24/2013-10:01:35:: i INFO: Performing sku validation
    crypto!ReportServer_0-1!2074!10/24/2013-10:01:35:: i INFO: Importing existing encryption key
    library!ReportServer_0-1!cc8!10/24/2013-10:01:36:: Call to GetDataSourceContentsAction(/Nettsales_MSCRM/CustomReports/MSCRM_FetchDataSource).
    library!ReportServer_0-1!2074!10/24/2013-10:01:36:: Call to GetDataSourceContentsAction(/SharedReports/5.0.xxxx/MSCRM_DataSource).
    library!ReportServer_0-1!2074!10/24/2013-10:01:36:: Call to GetDataSourceContentsAction(/Nettsales_MSCRM/CustomReports/MSCRM_DataSource).
    library!ReportServer_0-1!cc8!10/24/2013-10:02:12:: i INFO: RenderForNewSession('/Nettsales_MSCRM/CustomReports/{3232D903-DE37-E311-BE3C-001AA00B89DC}')
    library!WindowsService_1!fdc!10/24/2013-10:10:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!fdc!10/24/2013-10:10:24:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!fdc!10/24/2013-10:10:24:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!fd8!10/24/2013-10:20:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!fd8!10/24/2013-10:20:24:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!fd8!10/24/2013-10:20:24:: i INFO: Call to CleanBatch() ends
    library!ReportServer_0-1!121c!10/24/2013-10:21:11:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.;
    session!ReportServer_0-1!121c!10/24/2013-10:21:11:: e ERROR: Error in GetSnapshotData: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. ---> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
    at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
    at System.Data.SqlClient.SqlDataReader.get_MetaData()
    at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
    at System.Data.SqlClient.SqlCommand.ExecuteReader()
    at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.<ExecuteReader>b__1()
    at Microsoft.ReportingServices.Library.SqlBoundaryWithReturn`1.Invoke(Method m)
    --- End of inner exception stack trace ---
    at Microsoft.ReportingServices.Library.Storage.WrapAndThrowKnownExceptionTypes(Exception e)
    at Microsoft.ReportingServices.Library.SqlBoundaryWithReturn`1.Invoke(Method m)
    at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteReader()
    at Microsoft.ReportingServices.Library.DatabaseSessionStorage.GetSessionData(String sessionId, UserContext userContext, ConnectionManager connMgr)
    library!WindowsService_1!bb4!10/24/2013-10:30:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!bb4!10/24/2013-10:30:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!bb4!10/24/2013-10:30:23:: i INFO: Call to CleanBatch() ends
    library!ReportServer_0-1!cc8!10/24/2013-10:31:59:: Using folder C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\RSTempFiles for temporary files.
    webserver!ReportServer_0-1!cc8!10/24/2013-10:32:01:: i INFO: Processed report. Report='/Nettsales_MSCRM/CustomReports/{3232D903-DE37-E311-BE3C-001AA00B89DC}', Stream=''
    library!WindowsService_1!fd8!10/24/2013-10:40:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!fd8!10/24/2013-10:40:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!fd8!10/24/2013-10:40:23:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!b18!10/24/2013-10:50:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!b18!10/24/2013-10:50:24:: Using folder C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\RSTempFiles for temporary files.
    library!WindowsService_1!b18!10/24/2013-10:50:24:: i INFO: Cleaned 0 batch records, 0 policies, 1 sessions, 0 cache entries, 1 snapshots, 310 chunks, 0 running jobs, 0 persisted streams, 393 segments, 393 segment mappings, 0 edit sessions.
    library!WindowsService_1!b18!10/24/2013-10:50:24:: i INFO: Call to CleanBatch() ends
    library!WindowsService_1!bb4!10/24/2013-11:00:23:: i INFO: Call to CleanBatch()
    library!WindowsService_1!bb4!10/24/2013-11:00:23:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_1!bb4!10/24/2013-11:00:23:: i INFO: Call to CleanBatch() ends 

  • Suggested answer
    Sumit Bhatnagar 99 Profile Picture
    1,850 on at

    Hi..

    We can see :

    Throwing Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: , Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.Data.SqlClient.SqlException: Cannot open database "ReportServer" requested by the login. The login failed.

    Login failed for user 'NETTSALES\ySQL'.

    Can you check whether this user have appropriate permissions ? msdn.microsoft.com/.../hh699825.aspx

    Or create a login for this user in SQL.

    Hope this help !

    thanks !

  • Community Member Profile Picture
    on at

    I've checked and NETTSALES\ySQL seemed to have appropriate permissions for SQL.  But just to be sure, I have added this user to the sysadmin group to see if this makes any difference.  

    Will run the report again and take another look at the log file.

  • Sumit Bhatnagar 99 Profile Picture
    1,850 on at

    Hi..

    Do you still have the same issue ? If yes, then please let me know.

    Thanks.

  • Suggested answer
    Rugved Gokhale Profile Picture
    on at

    Hello,

    There are few error statements in your log which are troubling. Like the one below.

    1. extensionfactory!ReportServer_0-1!cc8!10/24/2013-10:01:34:: e ERROR: Exception caught instantiating TERADATA report server extension: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Teradata.Client.Provider, Version=12.0.0.0, Culture=neutral, PublicKeyToken=76b417ee2e04956c' or one of its dependencies. The system cannot find the file specified.

    2. extensionfactory!ReportServer_0-1!cc8!10/24/2013-10:01:35:: e ERROR: Exception caught instantiating SQLPDW report server extension: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.ArgumentException: Unable to find the requested .Net Framework Data Provider. It may not be installed.

    3. library!ReportServer_0-1!121c!10/24/2013-10:21:11:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.;

    You can check for configurations related to this.

  • Suggested answer
    Sumit Bhatnagar 99 Profile Picture
    1,850 on at

    Hi...

    If still your issue is not resolved then I would suggest you to create a service request with MS Support to look into this.

    Thanks.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans