sql login permissions: subscription

Showing posts with label subscription. Show all posts

Wednesday, March 28, 2012

long running report can not be rendered in Report Manager or through Subscription

I am using a stored procedure which will run about one hour and ten minutes to return a dataset to reporting services to generate a report. The report generation is OK if I run it inside Visual Studio 2005. Once it is deployed, it can not finish. Both cases I set "Do not timeout report execution". I even try to create a subscription to let it run throught. But it still can not finish. The traces information in ReportServer*.Log is like this:

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
<Locale>en-US</Locale>
<TimeZone>Central Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__06_29_2006_09_58_21.log</Path>
<SystemName>JSONG-XP</SystemName>
<OSName>Microsoft Windows NT 5.1.2600 Service Pack 2</OSName>
<OSVersion>5.1.2600.131072</OSVersion>
</Header>
aspnet_wp!webserver!6!6/29/2006-09:58:21:: i INFO: Reporting Web Server started
aspnet_wp!library!6!6/29/2006-09:58:21:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
aspnet_wp!library!6!6/29/2006-09:58:21:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
aspnet_wp!library!6!6/29/2006-09:58:21:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
aspnet_wp!library!6!6/29/2006-09:58:21:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
aspnet_wp!library!6!6/29/2006-09:58:21:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
aspnet_wp!library!6!6/29/2006-09:58:21:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
aspnet_wp!library!6!6/29/2006-09:58:21:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
aspnet_wp!library!6!6/29/2006-09:58:21:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
aspnet_wp!library!6!6/29/2006-09:58:21:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
aspnet_wp!library!6!6/29/2006-09:58:21:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
aspnet_wp!library!6!6/29/2006-09:58:21:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
aspnet_wp!library!6!6/29/2006-09:58:21:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
aspnet_wp!configmanager!6!6/29/2006-09:58:21:: w WARN: WebServiceAccount is not specified in the config file. Using default: JSONG-XP\ASPNET
aspnet_wp!library!6!6/29/2006-09:58:21:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
aspnet_wp!library!6!6/29/2006-09:58:21:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
aspnet_wp!library!6!6/29/2006-09:58:21:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
aspnet_wp!library!6!6/29/2006-09:58:21:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
aspnet_wp!library!6!6/29/2006-09:58:21:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
aspnet_wp!library!6!6/29/2006-09:58:21:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
aspnet_wp!library!6!6/29/2006-09:58:21:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
aspnet_wp!library!6!6/29/2006-09:58:21:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
aspnet_wp!library!6!6/29/2006-09:58:21:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
aspnet_wp!library!6!6/29/2006-09:58:21:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
aspnet_wp!library!6!6/29/2006-09:58:21:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
aspnet_wp!library!6!6/29/2006-09:58:21:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
aspnet_wp!library!6!6/29/2006-09:58:21:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
aspnet_wp!library!6!6/29/2006-09:58:21:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
aspnet_wp!library!6!6/29/2006-09:58:21:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
aspnet_wp!resourceutilities!6!6/29/2006-09:58:21:: i INFO: Reporting Services starting SKU: Developer
aspnet_wp!resourceutilities!6!6/29/2006-09:58:21:: i INFO: Evaluation copy: 0 days left
aspnet_wp!runningjobs!6!6/29/2006-09:58:21:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
aspnet_wp!runningjobs!6!6/29/2006-09:58:21:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
aspnet_wp!runningjobs!6!6/29/2006-09:58:21:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
aspnet_wp!runningjobs!6!6/29/2006-09:58:21:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
aspnet_wp!library!6!06/29/2006-09:58:23:: i INFO: Call to GetPermissions:/
aspnet_wp!library!6!06/29/2006-09:58:24:: i INFO: Catalog SQL Server Edition = Developer
aspnet_wp!library!6!06/29/2006-09:58:24:: i INFO: Call to GetSystemPermissions
aspnet_wp!library!6!06/29/2006-09:58:40:: i INFO: Call to GetPermissions:/CreditReports
aspnet_wp!library!6!06/29/2006-09:58:40:: i INFO: Call to GetSystemPermissions
aspnet_wp!library!1!06/29/2006-09:58:41:: i INFO: Call to GetPermissions:/CreditReports/ExperienceByCoverageSEDEV
aspnet_wp!library!1!06/29/2006-09:58:41:: i INFO: Call to GetSystemPermissions
aspnet_wp!library!1!06/29/2006-09:58:44:: i INFO: Call to RenderFirst( '/CreditReports/ExperienceByCoverageSEDEV' )
aspnet_wp!runningjobs!5!6/29/2006-09:59:27:: i INFO: Adding: 1 running jobs to the database
aspnet_wp!runningjobs!5!6/29/2006-10:03:36:: i INFO: Adding: 1 running jobs to the database
aspnet_wp!library!5!6/29/2006-10:06:25:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
aspnet_wp!runningjobs!5!6/29/2006-10:06:25:: i INFO: Adding: 1 running jobs to the database
aspnet_wp!runningjobs!5!6/29/2006-10:13:12:: i INFO: Adding: 1 running jobs to the database
aspnet_wp!library!5!6/29/2006-10:16:12:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
aspnet_wp!runningjobs!5!6/29/2006-10:16:12:: i INFO: Adding: 1 running jobs to the database
aspnet_wp!runningjobs!5!6/29/2006-10:23:13:: i INFO: Adding: 1 running jobs to the database
aspnet_wp!library!5!6/29/2006-10:26:13:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
aspnet_wp!runningjobs!5!6/29/2006-10:26:13:: i INFO: Adding: 1 running jobs to the database
aspnet_wp!runningjobs!5!6/29/2006-10:33:11:: i INFO: Adding: 1 running jobs to the database
aspnet_wp!library!5!6/29/2006-10:36:09:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
aspnet_wp!runningjobs!5!6/29/2006-10:36:09:: i INFO: Adding: 1 running jobs to the database
aspnet_wp!runningjobs!5!6/29/2006-10:43:06:: i INFO: Adding: 1 running jobs to the database
aspnet_wp!library!5!6/29/2006-10:46:05:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
aspnet_wp!runningjobs!5!6/29/2006-10:46:05:: i INFO: Adding: 1 running jobs to the database
aspnet_wp!runningjobs!5!6/29/2006-10:53:07:: i INFO: Adding: 1 running jobs to the database
aspnet_wp!library!5!6/29/2006-10:56:07:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
aspnet_wp!runningjobs!5!6/29/2006-10:56:07:: i INFO: Adding: 1 running jobs to the database
aspnet_wp!runningjobs!a!6/29/2006-10:57:07:: i INFO: RunningJobContext.IsClientConnected; found orphaned request
aspnet_wp!runningjobs!c!6/29/2006-10:58:07:: w WARN: Previous request for Running Requests Scavengerstill executing, skipping...
aspnet_wp!runningjobs!c!6/29/2006-10:58:07:: w WARN: Previous request for Running Requests DBstill executing, skipping...
aspnet_wp!runningjobs!c!6/29/2006-10:59:07:: w WARN: Previous request for Running Requests Scavengerstill executing, skipping...
aspnet_wp!runningjobs!c!6/29/2006-10:59:07:: w WARN: Previous request for Running Requests DBstill executing, skipping...
aspnet_wp!runningjobs!c!6/29/2006-11:00:07:: w WARN: Previous request for Running Requests Scavengerstill executing, skipping...
aspnet_wp!runningjobs!c!6/29/2006-11:00:07:: w WARN: Previous request for Running Requests DBstill executing, skipping...
aspnet_wp!runningjobs!c!6/29/2006-11:01:07:: w WARN: Previous request for Running Requests Scavengerstill executing, skipping...
aspnet_wp!runningjobs!c!6/29/2006-11:01:07:: w WARN: Previous request for Running Requests DBstill executing, skipping...
aspnet_wp!runningjobs!c!6/29/2006-11:02:07:: w WARN: Previous request for Running Requests Scavengerstill executing, skipping...
aspnet_wp!runningjobs!c!6/29/2006-11:02:07:: w WARN: Previous request for Running Requests DBstill executing, skipping...
aspnet_wp!runningjobs!c!6/29/2006-11:03:07:: w WARN: Previous request for Running Requests Scavengerstill executing, skipping...
aspnet_wp!runningjobs!c!6/29/2006-11:03:07:: w WARN: Previous request for Running Requests DBstill executing, skipping...
aspnet_wp!runningjobs!c!6/29/2006-11:04:07:: w WARN: Previous request for Running Requests Scavengerstill executing, skipping...
aspnet_wp!runningjobs!c!6/29/2006-11:04:07:: w WARN: Previous request for Running Requests DBstill executing, skipping...
aspnet_wp!runningjobs!c!6/29/2006-11:05:07:: w WARN: Previous request for Running Requests Scavengerstill executing, skipping...
aspnet_wp!runningjobs!c!6/29/2006-11:05:07:: w WARN: Previous request for Running Requests DBstill executing, skipping...
aspnet_wp!library!c!6/29/2006-11:06:07:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
aspnet_wp!runningjobs!c!6/29/2006-11:06:07:: w WARN: Previous request for Running Requests Scavengerstill executing, skipping...
aspnet_wp!runningjobs!c!6/29/2006-11:06:07:: w WARN: Previous request for Running Requests DBstill executing, skipping...
aspnet_wp!session!9!06/29/2006-11:06:52:: e ERROR: Sql Error in GetSnapshotData: 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.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.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()
at Microsoft.ReportingServices.Library.DatabaseSessionStorage.GetSessionData(String sessionId, String userName, ConnectionManager connMgr)
aspnet_wp!library!9!06/29/2006-11:06:52:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.Data.SqlClient.SqlException: 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.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.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()
at Microsoft.ReportingServices.Library.DatabaseSessionStorage.GetSessionData(String sessionId, String userName, ConnectionManager connMgr)
at Microsoft.ReportingServices.Library.DatabaseSessionStorage.GetSessionData(String sessionId, String userName)
at Microsoft.ReportingServices.Library.SessionReportItem.Load(DatabaseSessionStorage sessionStorage, LoadAction loadFlags, String sessionId, String reportPath, DateTime snapshotDate, String userName, String userParams, String imageName, DatasourceCredentialsCollection dataSourceCred)
at Microsoft.ReportingServices.WebServer.HttpClientRequest.LoadFromDB(LoadAction loadFlags, CatalogItemContext context)
at Microsoft.ReportingServices.WebServer.SessionStarterAction.CreateExisting()
End of inner exception stack trace
aspnet_wp!library!6!06/29/2006-11:06:54:: i INFO: Call to GetPermissions:/CreditReports/ExperienceByCoverageSEDEV
aspnet_wp!library!6!06/29/2006-11:06:54:: i INFO: Call to GetSystemPermissions
aspnet_wp!library!6!06/29/2006-11:06:55:: i INFO: Call to GetPermissions:/CreditReports/ExperienceByCoverageSEDEV
aspnet_wp!library!6!06/29/2006-11:06:55:: i INFO: Call to GetSystemPermissions
aspnet_wp!runningjobs!5!6/29/2006-11:07:07:: w WARN: Previous request for Running Requests Scavengerstill executing, skipping...
aspnet_wp!runningjobs!5!6/29/2006-11:07:07:: w WARN: Previous request for Running Requests DBstill executing, skipping...
aspnet_wp!library!8!06/29/2006-11:07:51:: i INFO: Call to GetPermissions:/CreditReports/ExperienceByCoverageSEDEV
aspnet_wp!library!8!06/29/2006-11:07:51:: i INFO: Call to GetSystemPermissions
aspnet_wp!runningjobs!5!6/29/2006-11:08:07:: w WARN: Previous request for Running Requests Scavengerstill executing, skipping...
aspnet_wp!runningjobs!5!6/29/2006-11:08:07:: w WARN: Previous request for Running Requests DBstill executing, skipping...
aspnet_wp!library!8!06/29/2006-11:08:16:: i INFO: Call to GetPermissions:/CreditReports/ExperienceByCoverageSEDEV
aspnet_wp!library!8!06/29/2006-11:08:16:: i INFO: Call to GetSystemPermissions
aspnet_wp!library!8!06/29/2006-11:08:16:: i INFO: Call to GetSnapshotLimit( '/CreditReports/ExperienceByCoverageSEDEV' )
aspnet_wp!library!6!06/29/2006-11:08:19:: i INFO: Call to GetPermissions:/CreditReports/ExperienceByCoverageSEDEV
aspnet_wp!library!6!06/29/2006-11:08:19:: i INFO: Call to GetSystemPermissions
aspnet_wp!library!6!06/29/2006-11:08:19:: i INFO: Call to GetPolicies:/CreditReports/ExperienceByCoverageSEDEV
aspnet_wp!library!8!06/29/2006-11:08:21:: i INFO: Call to GetPermissions:/CreditReports/ExperienceByCoverageSEDEV
aspnet_wp!library!8!06/29/2006-11:08:22:: i INFO: Call to GetSystemPermissions
aspnet_wp!library!6!06/29/2006-11:08:28:: i INFO: Call to GetPermissions:/CreditReports/ExperienceByCoverageSEDEV
aspnet_wp!library!6!06/29/2006-11:08:28:: i INFO: Call to GetSystemPermissions
aspnet_wp!library!8!06/29/2006-11:08:37:: i INFO: Call to GetPermissions:/CreditReports/ExperienceByCoverageSEDEV
aspnet_wp!library!8!06/29/2006-11:08:37:: i INFO: Call to GetSystemPermissions
aspnet_wp!library!6!06/29/2006-11:08:51:: i INFO: Call to GetPermissions:/CreditReports
aspnet_wp!library!6!06/29/2006-11:08:51:: i INFO: Call to GetSystemPermissions
aspnet_wp!library!8!06/29/2006-11:08:55:: i INFO: Call to GetPermissions:/CreditReports/AS400SEDEV
aspnet_wp!library!8!06/29/2006-11:08:55:: i INFO: Call to GetSystemPermissions
aspnet_wp!runningjobs!5!6/29/2006-11:09:07:: w WARN: Previous request for Running Requests Scavengerstill executing, skipping...
aspnet_wp!runningjobs!5!6/29/2006-11:09:07:: w WARN: Previous request for Running Requests DBstill executing, skipping...

I would like know the reason behind it. How to fix that?. I use Sql Server 2005 developer edition.

Thanx

There is a limit for how long a report will run from Report Manager. You can modify the setting at:

Report Manager --> Site Settings-->Report Execution Timeout-->Limit
report execution to the following number of seconds = 3600 (1 hr)

|||

Thank you for your reply.

Actually I set

Report Manager --> Site Settings-->Report Execution Timeout-->Do not timeout report execution. It still can not produce the report.

Another question is after I set localhost/reports and localhost/reportserver session timeout to 3 hrs and these site's asp.net state management session timout to 3hrs, the localhost/reportserver is not accessable. Maybe it is a reporting services bug. Steps to repeat the scenario: Go to IIS, right click localhost/reports-->Properties-->Click Configuration-->Application Configuration-->Options-->Change session timeout to 180 minutes. To set asp.net state management session timout to 3hrs. right click localhost/reports-->Properties-->Report Properties windows-->Click ASP.NET tab-->Edit Configuration-->State Management-->Set Session timout to 180 Minutes.

So far so good. Once repeating above operations to localhost/reportserver, both sites will become unaccessable.

Your response will be appreciated.

|||

The exception you are hitting is the session access timeout. The viewer control will try to ping back to the server every N-1 minutes (where N is basically the session expiration time). The default session access timeout is 10 minutes, so if the report takes over an hour to render, you will hit this timeout.

You can run into problems when the time it takes to render the report is longer than the session timeout, I would recommend altering the following system properties (you will have to do this via the SOAP API or an rs.exe script since they are not exposed in the management studio UI) to be more on the order of what you expect the report execution to be:

SessionAccessTimeout|||

Actually, rendering the long running report in the report manager is just for test purpose. I will create a subscription to deliver the report to a shared folder using SOAP API. Even for the subscription, the timeout issue still exists. Could you provide me some examples to set session timeout via SOAP API or a re.exe.

Thank you very much.

|||Any news? I have the same issue. Can you explain please which values should be used for these parameters in order to get the report running for more than 1 hour?|||There is a blog about it here

http://blogs.msdn.com/jgalla/archive/2006/10/11/session-timeout-during-execution.aspx
So i did change this for a report that needs 20 minutes but it still fail after 5 minutes with this error in the computer application log
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 10/31/2006 10:08:46 AM
Event time (UTC): 10/31/2006 5:08:46 PM
Event ID: c6233c9a2cff498a90cfa4140a3e932a
Event sequence: 1572
Event occurrence: 1
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/Root/Reports-1-128067603886462532
Trust level: RosettaMgr
Application Virtual Path: /Reports
Application Path: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\
Machine name: ATLANTA
Process information:
Process ID: 6452
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: ReportServerException
Exception message: Execution 'fmnjra45tvj15545rxlxt5ec' cannot be found (rsExecutionNotFound)
Request information:
Request URL: http://reporting.onsemi.com/Reports/Reserved.ReportViewerWebControl.axd?ReportSession=fmnjra45tvj15545rxlxt5ec&ControlID=84b2a2bd-4f03-4c5d-9d73-c305e7883b6e&Culture=1033&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl161TouchSession0&CacheSeed=Tue Oct 31 10:08:44 2006
Request path: /Reports/Reserved.ReportViewerWebControl.axd
User host address: 10.253.138.208
User: ONSEMI\R38851
Is authenticated: True
Authentication Type: Negotiate
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 14
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: True
Stack trace: at Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo()
at Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId, Boolean fullReportLoad)
at Microsoft.Reporting.WebForms.ServerReport.LoadFromUrlQuery(NameValueCollection requestParameters, Boolean fullReportLoad)
at Microsoft.Reporting.WebForms.ReportDataOperation..ctor()
at Microsoft.Reporting.WebForms.HttpHandler.GetHandler()
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Any idea?
Thanks,
Philippe

long running report can not be rendered in Report Manager or through Subscription

I would like know the reason behind it. How to fix that?. I use Sql Server 2005 developer edition.

Thanx

There is a limit for how long a report will run from Report Manager. You can modify the setting at:

Report Manager --> Site Settings-->Report Execution Timeout-->Limit
report execution to the following number of seconds = 3600 (1 hr)

|||

Thank you for your reply.

Actually I set

Report Manager --> Site Settings-->Report Execution Timeout-->Do not timeout report execution. It still can not produce the report.

So far so good. Once repeating above operations to localhost/reportserver, both sites will become unaccessable.

Your response will be appreciated.

|||

SessionAccessTimeout|||

Thank you very much.

|||Any news? I have the same issue. Can you explain please which values should be used for these parameters in order to get the report running for more than 1 hour?|||There is a blog about it here

Any idea?
Thanks,
Philippe

long running report can not be rendered in Report Manager or through Subscription

I would like know the reason behind it. How to fix that?. I use Sql Server 2005 developer edition.

Thanx

There is a limit for how long a report will run from Report Manager. You can modify the setting at:

Report Manager --> Site Settings-->Report Execution Timeout-->Limit
report execution to the following number of seconds = 3600 (1 hr)

|||

Thank you for your reply.

Actually I set

Report Manager --> Site Settings-->Report Execution Timeout-->Do not timeout report execution. It still can not produce the report.

So far so good. Once repeating above operations to localhost/reportserver, both sites will become unaccessable.

Your response will be appreciated.

|||

SessionAccessTimeout|||

Thank you very much.

|||Any news? I have the same issue. Can you explain please which values should be used for these parameters in order to get the report running for more than 1 hour?|||There is a blog about it here

Any idea?
Thanks,
Philippesql

Wednesday, March 21, 2012

Logreader agent not being created

I'm working with a client on a problem where they setup transactional
replication publications, push out a subscription, the snap shots are
created, the data is initially pushed out to the subscriber but no Logreader
agent is created - So no transactional replication occurs.
The Sql server, agent, and application and system logs show no errors.
If I script out the replication the sp_addpublication is being called
without the @.logreader_job_name parameter. I could try installing the agent
manually using logread.exe but I want to understand why the agent is not
being created the way it normally should.
Any help would be appreciated,
J
can you script out your publication and post it here.
Also sometimes the agent folders get a little scrambled and the agents don't
show up there. Could you perhaps check to see if there aren't any logreader
processes showing up in task manger, or check to see if you can create
another transactional publication in a different database. Make sure you use
a unique name for the publication.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Jim Young" <thorium48@.hotmail.com> wrote in message
news:uKsSQxAqEHA.376@.TK2MSFTNGP14.phx.gbl...
> I'm working with a client on a problem where they setup transactional
> replication publications, push out a subscription, the snap shots are
> created, the data is initially pushed out to the subscriber but no
Logreader
> agent is created - So no transactional replication occurs.
> The Sql server, agent, and application and system logs show no errors.
> If I script out the replication the sp_addpublication is being called
> without the @.logreader_job_name parameter. I could try installing the
agent
> manually using logread.exe but I want to understand why the agent is not
> being created the way it normally should.
> Any help would be appreciated,
> J
>
|||Thank's for the response,
Attached is the replication script with the beginning part that sets up the
distributor and the setup for one of the publications that is failing to
create a Log Reader agent.
As you can see the logreader_job_name parameter is absent. Also I checked in
the server and the logread.exe executable is there in its proper place.
The server is running Sql Server 2000 Standard SP3 on Microsoft Windows
Server 2003 Standard, replicating to a server with the same configuraton
(except 2500 miles away).
This same replication worked just fine on previous servers that the
application was migrated from: Sql Server 7.0 on Windows 2000 Server
Advanced (clustered).
Jim
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:ec33qHCqEHA.3464@.TK2MSFTNGP14.phx.gbl...
> can you script out your publication and post it here.
> Also sometimes the agent folders get a little scrambled and the agents
don't
> show up there. Could you perhaps check to see if there aren't any
logreader
> processes showing up in task manger, or check to see if you can create
> another transactional publication in a different database. Make sure you
use
> a unique name for the publication.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "Jim Young" <thorium48@.hotmail.com> wrote in message
> news:uKsSQxAqEHA.376@.TK2MSFTNGP14.phx.gbl...
> Logreader
> agent
>
begin 666 Assoc.sql
M+RHJ*BHJ*B!38W)I<'1I;F<@.=&AE(')E<&QI8V%T:6]N('-E='5P(&]F('-E
M<G9E<B!-0E!34TE344PP,2X@.4V-R:7!T($1A=&4Z(#$P+S$O,C P-" S.C0Y
M.C(X(%!-("HJ*BHJ*B\-"B\J*BHJ*BH@.4&QE87-E(&YO=&4Z($%N>2!P87-S
M=V]R9"!P87)A;65T97(@.=V%S('-C<FEP=&5D('=I=&@.@.3E5,3"!O<B!E;7!T
M>2!S=')I;F<@.9F]R('-E8W5R:71Y(')E87-O;BX@.*BHJ*BHJ+PT*#0HO*BHJ
M*BHJ($)E9VEN.B!38W)I<'0@.=&\@.8F4@.<G5N(&%T($1I<W1R: 6)U=&]R.B!-
M0E!34TE344PP,2 J*BHJ*BHO#0HO*BHJ*BHJ($EN<W1A;&QI;F<@.=&AE('-E
M<G9E<B!-0E!34TE344PP,2!A<R!A($1I<W1R:6)U=&]R+B!38W)I<'0@.1&%T
M93H@.,3 O,2\R,# T(#,Z-#DZ,C@.@.4$T@.*BHJ*BHJ+PT*=7-E(&UA<W1E<@.T*
M1T\-"@.T*97AE8R!S<%]A9&1D:7-T<FEB=71O<B @.0&1I<W1R:6)U=&]R(#T@.
M3B=-0E!34TE344PP,2<L($!P87-S=V]R9" ]($XG)PT*1T\-"@.T*+2T@.57!D
M871I;F<@.=&AE(&%G96YT('!R;V9I;&4@.9&5F875L=',-"G-P7TU3=7!D871E
M7V%G96YT='EP95]D969A=6QT($!P<F]F:6QE7VED(#T@.,0T*1T\-"G-P7TU3
M=7!D871E7V%G96YT='EP95]D969A=6QT($!P<F]F:6QE7VED(#T@.,@.T*1T\-
M"G-P7TU3=7!D871E7V%G96YT='EP95]D969A=6QT($!P<F]F:6QE7VED(#T@.
M- T*1T\-"G-P7TU3=7!D871E7V%G96YT='EP95]D969A=6QT($!P<F]F:6QE
M7VED(#T@.-@.T*1T\-"G-P7TU3=7!D871E7V%G96YT='EP95]D969A=6QT($!P
M<F]F:6QE7VED(#T@.,3$-"D=/#0H-"BTM($%D9&EN9R!T:&4@.9&ES=')I8G5T
M:6]N(&1A=&%B87-E#0IE>&5C('-P7V%D9&1I<W1R:6)U=&EO;F1B("! 9&%T
M86)A<V4@./2!.)V1I<W1R:6)U=&EO;B<L($!D871A7V9O;&1E<B ]($XG13I<
M4U%,,DM<35-344Q$051!7$U34U%,7$1A=&$G+"! 9&%T85]F:6QE(#T@.3B=D
M:7-T<FEB=71I;VXN341&)RP@.0&1A=&%?9FEL95]S:7IE(#T@.,S,S+"! ;&]G
M7V9O;&1E<B ]($XG13I<4U%,,DM<35-344Q$051!7$U34U%,7$1A=&$G+"!
M;&]G7V9I;&4@./2!.)V1I<W1R:6)U=&EO;BY,1$8G+"! ;&]G7V9I;&5?<VEZ
M92 ](#4V+"! ;6EN7V1I<W1R971E;G1I;VX@./2 P+"! ;6%X7V1I<W1R971E
M;G1I;VX@./2 W,BP@.0&AI<W1O<GE?<F5T96YT:6]N(#T@.-#@.L($!S96-U<FET
M>5]M;V1E(#T@.,0T*1T\-"@.T*+2T@.061D:6YG('1H92!D:7-T<FEB=71I;VX@.
M<'5B;&ES:&5R#0IE>&5C('-P7V%D9&1I<W1P=6)L:7-H97(@.($!P=6)L:7-H
M97(@./2!.)TU"4%-325-13# Q)RP@.0&1I<W1R:6)U=&EO;E]D8B ]($XG9&ES
M=')I8G5T:6]N)RP@.0'-E8W5R:71Y7VUO9&4@./2 Q+"! =V]R:VEN9U]D:7)E
M8W1O<GD@./2!.)UQ<34)04U-)4U%,,#%<4D503$1!5$$G+"! =')U<W1E9" ]
M($XG9F%L<V4G+"! =&AI<F1P87)T>5]F;&%G(#T@., T*1T\-"@.T*+RHJ*BHJ
M*B!%;F0Z(%-C<FEP="!T;R!B92!R=6X@.870@.1&ES=')I8G5T;W(Z($U"4%-3
M25-13# Q("HJ*BHJ*B\-"@.T*+RHJ*BHJ*B!"96=I;CH@.4V-R:7!T('1O(&)E
M(')U;B!A="!0=6)L:7-H97(Z($U"4%-325-13# Q("HJ*BHJ*B\-"BTM($%D
M9&EN9R!T:&4@.<F5G:7-T97)E9"!S=6)S8W)I8F5R#0IE>&5C('-P7V%D9'-U
M8G-C<FEB97(@.0'-U8G-C<FEB97(@./2!.)TA"4%-325-13# Q)RP@.0'1Y<&4@.
M/2 P+"! <V5C=7)I='E?;6]D92 ](#$L($!F<F5Q=65N8WE?='EP92 ](#8T
M+"! 9G)E<75E;F-Y7VEN=&5R=F%L(#T@.,2P@.0&9R97%U96YC>5]R96QA=&EV
M95]I;G1E<G9A;" ](#(L($!F<F5Q=65N8WE?<F5C=7)R96YC95]F86-T;W(@.
M/2 P+"! 9G)E<75E;F-Y7W-U8F1A>2 ](#@.L($!F<F5Q=65N8WE?<W5B9&%Y
M7VEN=&5R=F%L(#T@.,2P@.0&%C=&EV95]S=&%R=%]D871E(#T@.,"P@.0&%C=&EV
M95]E;F1?9&%T92 ](# L($!A8W1I=F5?<W1A<G1?=&EM95]O9E]D87D@./2 P
M+"! 86-T:79E7V5N9%]T:6UE7V]F7V1A>2 ](#(S-3DP,"P@.0&1E<V-R:7!T
M:6]N(#T@.3B<G#0H@.97AE8R!S<%]C:&%N9V5S=6)S8W)I8F5R7W-C:&5D=6QE
M($!S=6)S8W)I8F5R(#T@.3B=(0E!34TE344PP,2<L($!A9V5N= %]T>7!E(#T@.
M,2P@.0&%C=&EV95]E;F1?9&%T92 ](# -"D=/#0H-"BTM($5N86)L:6YG('1H
M92!R97!L:6-A=&EO;B!D871A8F%S90T*=7-E(&UA<W1E<@.T*1T\-"@.T*97AE
M8R!S<%]R97!L:6-A=&EO;F1B;W!T:6]N($!D8FYA;64@./2!.)T]21$5214Y4
M4EDG+"! ;W!T;F%M92 ]($XG<'5B;&ES:"<L($!V86QU92 ]($XG=')U92<-
M"D=/#0H-"G5S92!;3U)$15)%3E1265T-"D=/#0H-"BTM($%D9&EN9R!T:&4@.
M=')A;G-A8W1I;VYA;"!P=6)L:6-A=&EO;@.T*97AE8R!S<%]A9&1P=6)L:6-A
M=&EO;B! <'5B;&EC871I;VX@./2!.)T%S<V]C7TQO9R<L($!R97-T<FEC=&5D
M(#T@.3B=F86QS92<L($!S>6YC7VUE=&AO9" ]($XG;F%T:79E)RP@.0')E<&Q?
M9G)E<2 ]($XG8V]N=&EN=6]U<R<L($!D97-C<FEP=&EO;B ]($XG5')A;G-A
M8W1I;VYA;"!P=6)L:6-A=&EO;B!O9B!/4D1%4D5.5%)9(&1A=&%B87-E(&9R
M;VT@.4'5B;&ES:&5R($U"4%-325-13# Q+B<L($!S=&%T=7,@./2!.)V%C=&EV
M92<L($!A;&QO=U]P=7-H(#T@.3B=T<G5E)RP@.0&%L;&]W7W!U;&P@./2!.)W1R
M=64G+"! 86QL;W=?86YO;GEM;W5S(#T@.3B=F86QS92<L($!E;F%B;&5D7V 9O
M<E]I;G1E<FYE=" ]($XG9F%L<V4G+"! :6YD97!E;F1E;G1?86=E;G0@./2!.
M)W1R=64G+"! :6UM961I871E7W-Y;F,@./2!.)V9A;'-E)RP@.0&%L;&]W7W-Y
M;F-?=')A;B ]($XG=')U92<L($!A=71O9V5N7W-Y;F-?<')O8W,@./2!.)W1R
M=64G+"! <F5T96YT:6]N(#T@.,S,V+"! 86QL;W=?<75E=65D7W1R86X@./2!.
M)V9A;'-E)RP@.0'-N87!S:&]T7VEN7V1E9F%U;'1F;VQD97(@./2!.)W1R=64G
M+"! 8V]M<')E<W-?<VYA<'-H;W0@./2!.)V9A;'-E)RP@.0&9T<%]P;W)T(#T@.
M,C$L($!F='!?;&]G:6X@./2!.)V%N;VYY;6]U<R<L($!A;&QO=U]D=',@./2!.
M)V9A;'-E)RP@.0&%L;&]W7W-U8G-C<FEP=&EO;E]C;W!Y(#T@.3B=F86QS92<L
M($!A9&1?=&]?86-T:79E7V1I<F5C=&]R>2 ]($XG9F%L<V4G+"! <7)E861E
M<E]J;V)?;F%M92 ]($XG6TU"4%-325-13# Q72XV)PT*97AE8R!S<%]A9&1P
M=6)L:6-A=&EO;E]S;F%P<VAO="! <'5B;&EC871I;VX@./2!.)T%S<V]C7TQO
M9R<L0&9R97%U96YC>5]T>7!E(#T@.-"P@.0&9R97%U96YC>5]I;G1E<G9A;" ]
M(#$L($!F<F5Q=65N8WE?<F5L871I=F5?:6YT97)V86P@./2 Q+"! 9G)E<75E
M;F-Y7W)E8W5R<F5N8V5?9F%C=&]R(#T@.,"P@.0&9R97%U96YC>5]S=6)D87D@.
M/2 X+"! 9G)E<75E;F-Y7W-U8F1A>5]I;G1E<G9A;" ](#$L($!A8W1I=F5?
M<W1A<G1?9&%T92 ](# L($!A8W1I=F5?96YD7V1A=&4@./2 P+"! 86-T:79E
M7W-T87)T7W1I;65?;V9?9&%Y(#T@.,"P@.0&%C=&EV95]E;F1?=&EM95]O9E]D
M87D@./2 R,S4Y-3DL($!S;F%P<VAO=%]J;V)?;F%M92 ]($XG34)04U-)4U%,
M,#$M3U)$15)%3E1262U!<W-O8U],;V<M,34G#0I'3PT*#0IE>&5C('-P7V=R
M86YT7W!U8FQI8V%T:6]N7V%C8V5S<R! <'5B;&EC871I;VX@./2!.)T%S<V]C
M7TQO9R<L($!L;V=I;B ]($XG0E5)3%1)3EQ!9&UI;FES=')A=&]R<R<-"D=/
M#0IE>&5C('-P7V=R86YT7W!U8FQI8V%T:6]N7V%C8V5S<R! <'5B;&EC871I
M;VX@./2!.)T%S<V]C7TQO9R<L($!L;V=I;B ]($XG9&ES=')I8G5T;W)?861M
M:6XG#0I'3PT*97AE8R!S<%]G<F%N=%]P=6)L:6-A=&EO;E]A8V-E<W,@.0'!U
M8FQI8V%T:6]N(#T@.3B=!<W-O8U],;V<G+"! ;&]G:6X@./2!.)W-A)PT*1T\-
M"@.T*+2T@.061D:6YG('1H92!T<F%N<V%C=&EO;F%L(&%R=&EC; &5S#0IE>&5C
M('-P7V%D9&%R=&EC;&4@.0'!U8FQI8V%T:6]N(#T@.3B=!<W-O8U],;V<G+"!
M87)T:6-L92 ]($XG;&]G7V%T=&5N9&%N8V4G+"! <V]U<F-E7V]W;F5R(#T@.
M3B=D8F\G+"! <V]U<F-E7V]B:F5C=" ]($XG;&]G7V%T=&5N9&%N8V4G+"!
M9&5S=&EN871I;VY?=&%B;&4@./2!.)VQO9U]A='1E;F1A;F-E)RP@.0'1Y<&4@.
M/2!.)VQO9V)A<V5D)RP@.0&-R96%T:6]N7W-C<FEP=" ](&YU;&PL($!D97-C
M<FEP=&EO;B ](&YU;&PL($!P<F5?8W)E871I;VY?8VUD(#T@.3B=D<F]P)RP@.
M0'-C:&5M85]O<'1I;VX@./2 P># P,# P,# P,# P,$-%1C,L($!S=&%T=7,@.
M/2 Q-BP@.0'9E<G1I8V%L7W!A<G1I=&EO;B ]($XG9F%L<V4G+"! :6YS7V-M
M9" ]($XG0T%,3"!S<%]-4VEN<U]L;V=?871T96YD86YC92<L($!D96Q?8VUD
M(#T@.3B=#04Q,('-P7TU39&5L7VQO9U]A='1E;F1A;F-E)RP@.0'5P9%]C;60@.
M/2!.)TU#04Q,('-P7TU3=7!D7VQO9U]A='1E;F1A;F-E)RP@.0&9I;'1E<B ]
M(&YU;&PL($!S>6YC7V]B:F5C=" ](&YU;&PL($!A=71O7VED96YT:71Y7W)A
M;F=E(#T@.3B=F86QS92<-"D=/#0IE>&5C('-P7V%D9&%R=&EC;&4@.0'!U8FQI
M8V%T:6]N(#T@.3B=!<W-O8U],;V<G+"! 87)T:6-L92 ]($XG;&]G7V1E<&5N
M9&5N=',G+"! <V]U<F-E7V]W;F5R(#T@.3B=D8F\G+"! <V]U<F-E7V]B:F5C
M=" ]($XG;&]G7V1E<&5N9&5N=',G+"! 9&5S=&EN871I;VY?=&%B;&4@./2!.
M)VQO9U]D97!E;F1E;G1S)RP@.0'1Y<&4@./2!.)VQO9V)A<V5D)RP@.0&-R96%T
M:6]N7W-C<FEP=" ](&YU;&PL($!D97-C<FEP=&EO;B ](&YU;&PL($!P<F5?
M8W)E871I;VY?8VUD(#T@.3B=D<F]P)RP@.0'-C:&5M85]O<'1I;VX@./2 P># P
M,# P,# P,# P,$-%1C,L($!S=&%T=7,@./2 Q-BP@.0'9E<G1I8V%L7W!A<G1I
M=&EO;B ]($XG9F%L<V4G+"! :6YS7V-M9" ]($XG0T%,3"!S<%]-4VEN<U]L
M;V=?9&5P96YD96YT<R<L($!D96Q?8VUD(#T@.3B=#04Q,('-P7TU39&5L7VQO
M9U]D97!E;F1E;G1S)RP@.0'5P9%]C;60@./2!.)TU#04Q,('-P7TU3=7!D7VQO
M9U]D97!E;F1E;G1S)RP@.0&9I;'1E<B ](&YU;&PL($!S>6YC7V]B:F5C=" ]
M(&YU;&PL($!A=71O7VED96YT:71Y7W)A;F=E(#T@.3B=F86QS9 2<-"D=/#0IE
M>&5C('-P7V%D9&%R=&EC;&4@.0'!U8FQI8V%T:6]N(#T@.3B=!<W-O8U],;V<G
M+"! 87)T:6-L92 ]($XG;&]G7V1E=&%I;',G+"! <V]U<F-E7V]W;F5R(#T@.
M3B=D8F\G+"! <V]U<F-E7V]B:F5C=" ]($XG;&]G7V1E=&%I;',G+"! 9&5S
M=&EN871I;VY?=&%B;&4@./2!.)VQO9U]D971A:6QS)RP@.0'1Y<&4@./2!.)VQO
M9V)A<V5D)RP@.0&-R96%T:6]N7W-C<FEP=" ](&YU;&PL($!D97-C<FEP=&EO
M;B ](&YU;&PL($!P<F5?8W)E871I;VY?8VUD(#T@.3B=D<F]P)RP@.0'-C:&5M
M85]O<'1I;VX@./2 P># P,# P,# P,# P,$-%1C,L($!S=&%T=7,@./2 Q-BP@.
M0'9E<G1I8V%L7W!A<G1I=&EO;B ]($XG9F%L<V4G+"! :6YS7V-M9" ]($XG
M0T%,3"!S<%]-4VEN<U]L;V=?9&5T86EL<R<L($!D96Q?8VUD(#T@.3B=#04Q,
M('-P7TU39&5L7VQO9U]D971A:6QS)RP@.0'5P9%]C;60@./2!.)TU#04Q,('-P
M7TU3=7!D7VQO9U]D971A:6QS)RP@.0&9I;'1E<B ](&YU;&PL($!S>6YC7V]B
M:F5C=" ](&YU;&PL($!A=71O7VED96YT:71Y7W)A;F=E(#T@.3B=F86QS92 <-
M"D=/#0IE>&5C('-P7V%D9&%R=&EC;&4@.0'!U8FQI8V%T:6]N(#T@.3B=!<W-O
M8U],;V<G+"! 87)T:6-L92 ]($XG;&]G7VYO4F5H:7)E)RP@.0'-O=7)C95]O
M=VYE<B ]($XG9&)O)RP@.0'-O=7)C95]O8FIE8W0@./2!.)VQO9U]N;U)E:&ER
M92<L($!D97-T:6YA=&EO;E]T86)L92 ]($XG;&]G7VYO4F5H:7)E)RP@.0'1Y
M<&4@./2!.)VQO9V)A<V5D)RP@.0&-R96%T:6]N7W-C<FEP=" ](&YU;&PL($!D
M97-C<FEP=&EO;B ](&YU;&PL($!P<F5?8W)E871I;VY?8VUD(#T@.3B=D<F]P
M)RP@.0'-C:&5M85]O<'1I;VX@./2 P># P,# P,# P,# P,$-%1C,L($!S=&%T
M=7,@./2 Q-BP@.0'9E<G1I8V%L7W!A<G1I=&EO;B ]($XG9F%L<V4G+"! :6YS
M7V-M9" ]($XG0T%,3"!S<%]-4VEN<U]L;V=?;F]296AI<F4G+"! 9&5L7V-M
M9" ]($XG0T%,3"!S<%]-4V1E;%]L;V=?;F]296AI<F4G+"! =7!D7V-M9" ]
M($XG34-!3$P@.<W!?35-U<&1?;&]G7VYO4F5H:7)E)RP@.0&9I;'1E<B ](&YU
M;&PL($!S>6YC7V]B:F5C=" ](&YU;&PL($!A=71O7VED96YT:71Y7W)A;F=E
M(#T@.3B=F86QS92<-"D=/#0IE>&5C('-P7V%D9&%R=&EC;&4@.0'!U8FQI8V%T
M:6]N(#T@.3B=!<W-O8U],;V<G+"! 87)T:6-L92 ]($XG;&]G7W-E<&%R871I
M;VYS)RP@.0'-O=7)C95]O=VYE<B ]($XG9&)O)RP@.0'-O=7)C95]O8FIE8W0@.
M/2!.)VQO9U]S97!A<F%T:6]N<R<L($!D97-T:6YA=&EO;E]T86)L92 ]($XG
M;&]G7W-E<&%R871I;VYS)RP@.0'1Y<&4@./2!.)VQO9V)A<V5D)RP@.0&-R96%T
M:6]N7W-C<FEP=" ](&YU;&PL($!D97-C<FEP=&EO;B ](&YU;&PL($!P<F5?
M8W)E871I;VY?8VUD(#T@.3B=D<F]P)RP@.0'-C:&5M85]O<'1I;VX@./2 P># P
M,# P,# P,# P,$-%1C,L($!S=&%T=7,@./2 Q-BP@.0'9E<G1I8V%L7W!A<G1I
M=&EO;B ]($XG9F%L<V4G+"! :6YS7V-M9" ]($XG0T%,3"!S<%]-4VEN<U]L
M;V=?<V5P87)A=&EO;G,G+"! 9&5L7V-M9" ]($XG0T%,3"!S<%]-4V1E;%]L
M;V=?<V5P87)A=&EO;G,G+"! =7!D7V-M9" ]($XG34-!3$P@.<W!?35-U<&1?
M;&]G7W-E<&%R871I;VYS)RP@.0&9I;'1E<B ](&YU;&PL($!S>6YC7V]B:F5C
M=" ](&YU;&PL($!A=71O7VED96YT:71Y7W)A;F=E(#T@.3B=F86QS92 <-"D=/
M#0H-"BTM($%D9&EN9R!T:&4@.=')A;G-A8W1I;VYA;"!S=6)S8W)I<'1I;VX-
M"F5X96,@.<W!?861D<W5B<V-R:7!T:6]N($!P=6)L:6-A=&EO;B ]($XG07-S
M;V-?3&]G)RP@.0&%R=&EC;&4@./2!.)V%L;"<L($!S=6)S8W)I8F5R(#T@.3B=(
M0E!34TE344PP,2<L($!D97-T:6YA=&EO;E]D8B ]($XG3U)$15)%3E1262<L
M($!S>6YC7W1Y<&4@./2!.)V%U=&]M871I8R<L($!U<&1A=&5?;6]D92 ]($XG
M<WEN8R!T<F%N)RP@.0&]F9FQO861A9V5N=" ](# L($!D='-?<&%C:V%G95]L
<;V-A=&EO;B ]($XG9&ES=')I8G5T;W(G#0I'3P``
`
end
|||You are using Updateable Subscriptions with Queued Updating.
the log reader agent name should (but doesn't have to be blank). Any value
you put in here will be ignored.
I just want to confirm that the log reader agent is not showing up in the
publisher. It should not show up on the subscriber.
Also can you check your jobs folder (under the management folder) to see if
a log reader agent/job is not created for this job,
Sometimes the agents will not show up in the replication agents folder but
are actually there, and you can only see them in the jobs folder. When this
happens it is difficult to administer your agents, but you will have a
working solution.
"Jim Young" <thorium48@.hotmail.com> wrote in message
news:%238DZmWDqEHA.3668@.TK2MSFTNGP15.phx.gbl...
> Thank's for the response,
> Attached is the replication script with the beginning part that sets up
> the
> distributor and the setup for one of the publications that is failing to
> create a Log Reader agent.
> As you can see the logreader_job_name parameter is absent. Also I checked
> in
> the server and the logread.exe executable is there in its proper place.
> The server is running Sql Server 2000 Standard SP3 on Microsoft Windows
> Server 2003 Standard, replicating to a server with the same configuraton
> (except 2500 miles away).
> This same replication worked just fine on previous servers that the
> application was migrated from: Sql Server 7.0 on Windows 2000 Server
> Advanced (clustered).
> Jim
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:ec33qHCqEHA.3464@.TK2MSFTNGP14.phx.gbl...
> don't
> logreader
> use
>
>
|||It was setup for Immediate Updating and Queued Updating as a failover. Even
still, doesn't there need to be a Log Reader agent to pickup any
transactions to replicate?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:eZ48JFJqEHA.3244@.tk2msftngp13.phx.gbl...
> You are using Updateable Subscriptions with Queued Updating.
> the log reader agent name should (but doesn't have to be blank). Any value
> you put in here will be ignored.
> I just want to confirm that the log reader agent is not showing up in the
> publisher. It should not show up on the subscriber.
> Also can you check your jobs folder (under the management folder) to see
if
> a log reader agent/job is not created for this job,
> Sometimes the agents will not show up in the replication agents folder but
> are actually there, and you can only see them in the jobs folder. When
this[vbcol=seagreen]
> happens it is difficult to administer your agents, but you will have a
> working solution.
>
> "Jim Young" <thorium48@.hotmail.com> wrote in message
> news:%238DZmWDqEHA.3668@.TK2MSFTNGP15.phx.gbl...
checked[vbcol=seagreen]
you[vbcol=seagreen]
errors.
>
|||The log reader agent is not showing up at the publisher or the subscriber.
There is also no agent job listed.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:eZ48JFJqEHA.3244@.tk2msftngp13.phx.gbl...
> You are using Updateable Subscriptions with Queued Updating.
> the log reader agent name should (but doesn't have to be blank). Any value
> you put in here will be ignored.
> I just want to confirm that the log reader agent is not showing up in the
> publisher. It should not show up on the subscriber.
> Also can you check your jobs folder (under the management folder) to see
if
> a log reader agent/job is not created for this job,
> Sometimes the agents will not show up in the replication agents folder but
> are actually there, and you can only see them in the jobs folder. When
this[vbcol=seagreen]
> happens it is difficult to administer your agents, but you will have a
> working solution.
>
> "Jim Young" <thorium48@.hotmail.com> wrote in message
> news:%238DZmWDqEHA.3668@.TK2MSFTNGP15.phx.gbl...
checked[vbcol=seagreen]
you[vbcol=seagreen]
errors.
>
|||yes, there will be a log reader agent on the publisher.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Jim Young" <thorium48@.hotmail.com> wrote in message
news:%23oQdcIKqEHA.1576@.TK2MSFTNGP12.phx.gbl...
> It was setup for Immediate Updating and Queued Updating as a failover.
Even[vbcol=seagreen]
> still, doesn't there need to be a Log Reader agent to pickup any
> transactions to replicate?
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:eZ48JFJqEHA.3244@.tk2msftngp13.phx.gbl...
value[vbcol=seagreen]
the[vbcol=seagreen]
> if
but[vbcol=seagreen]
> this
up[vbcol=seagreen]
to[vbcol=seagreen]
> checked
place.[vbcol=seagreen]
Windows[vbcol=seagreen]
configuraton[vbcol=seagreen]
agents[vbcol=seagreen]
create[vbcol=seagreen]
> you
transactional[vbcol=seagreen]
are[vbcol=seagreen]
> errors.
called[vbcol=seagreen]
the[vbcol=seagreen]
is
>
|||I tried your script. It works on my machine. I think there is something
wrong with your machine. Can you try to disable replication, recreate it,
and then recreate your publication and subscription.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uFdQI6KqEHA.3712@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> yes, there will be a log reader agent on the publisher.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "Jim Young" <thorium48@.hotmail.com> wrote in message
> news:%23oQdcIKqEHA.1576@.TK2MSFTNGP12.phx.gbl...
> Even
> value
> the
see[vbcol=seagreen]
> but
[vbcol=seagreen]
> up
failing[vbcol=seagreen]
> to
> place.
> Windows
> configuraton
> agents
> create
sure[vbcol=seagreen]
> transactional
> are
no
> called
> the
> is
>
|||That's what I feared. There is definitely something wrong with the way
replication was installed on this box. Unfortunately I was not the one who
installed Sql Server and replication. I was called in after the fact when it
looked like replication was not working. It may be an issue of permissions
and rights during the setup of replication on the server, as this company
does not want to give the Sql Server DBAs admin rights to their servers.
Thanks for all your help!
Jim
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:ejcXuBOqEHA.3244@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> I tried your script. It works on my machine. I think there is something
> wrong with your machine. Can you try to disable replication, recreate it,
> and then recreate your publication and subscription.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:uFdQI6KqEHA.3712@.TK2MSFTNGP15.phx.gbl...
in[vbcol=seagreen]
> see
folder[vbcol=seagreen]
When[vbcol=seagreen]
a[vbcol=seagreen]
sets[vbcol=seagreen]
> failing
the[vbcol=seagreen]
Server[vbcol=seagreen]
> sure
shots[vbcol=seagreen]
> no
installing[vbcol=seagreen]
agent
>
|||I don't think it is a problem with the way the previous dba installed
replication, rather there is something wrong with the SQL Server
environment; ie missing stored procedures, or an inconsistent application of
SP 3. I suggest you reapply SP 3 and try again.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Jim Young" <thorium48@.hotmail.com> wrote in message
news:uiosaiOqEHA.2588@.TK2MSFTNGP12.phx.gbl...
> That's what I feared. There is definitely something wrong with the way
> replication was installed on this box. Unfortunately I was not the one who
> installed Sql Server and replication. I was called in after the fact when
it[vbcol=seagreen]
> looked like replication was not working. It may be an issue of permissions
> and rights during the setup of replication on the server, as this company
> does not want to give the Sql Server DBAs admin rights to their servers.
> Thanks for all your help!
> Jim
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:ejcXuBOqEHA.3244@.tk2msftngp13.phx.gbl...
it,[vbcol=seagreen]
failover.[vbcol=seagreen]
Any[vbcol=seagreen]
> in
to[vbcol=seagreen]
> folder
> When
have[vbcol=seagreen]
> a
> sets
I[vbcol=seagreen]
> the
> Server
any[vbcol=seagreen]
> shots
but[vbcol=seagreen]
no[vbcol=seagreen]
being
> installing
> agent
>

Monday, March 19, 2012

Logon Failed and Subscriptions

Anyone know why I keep getting a logon failed when my email subscription
runs? I have used all users imaginable on my data source and none seems to
work.
SQLServer Agent is running and my users have RSExec role enabled.Is the logon failure an SMTP error? Perhaps you do not have your SMTP
settings correct. Can you post the error message?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"dillig" <dillig@.discussions.microsoft.com> wrote in message
news:6B033AF7-7476-4DDC-9873-BA6F2A6F1CF9@.microsoft.com...
> Anyone know why I keep getting a logon failed when my email subscription
> runs? I have used all users imaginable on my data source and none seems to
> work.
> SQLServer Agent is running and my users have RSExec role enabled.
>|||Below is my Report services file errors. But to add to by question.
I created a system user named reportuser. reportUser has access to Report
Server and the database I am making my query. this user has RSExec
permissions. This user is also setup in Report Manager to store credential
securely in Report Server on my shared datasource. I don't know what I have
to do next. Can you help me?
Report Services file is as follows:
ReportingServicesService!dbpolling!16e4!12/9/2005-15:17:07:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!1994!12/9/2005-15:17:07:: EventPolling
processing item 3c2cd2c9-3606-4fd4-9496-a755e9c893d6
ReportingServicesService!library!1994!12/9/2005-15:17:08:: Schedule
e4d454cf-4bae-44f6-bd2b-32b14ac12347 executed at 12/9/2005 3:17:08 PM.
ReportingServicesService!schedule!1994!12/9/2005-15:17:08:: Creating Time
based subscription notification for subscription:
7d229c62-b339-471b-8622-358857f2870a
ReportingServicesService!library!1994!12/9/2005-15:17:08:: Schedule
e4d454cf-4bae-44f6-bd2b-32b14ac12347 execution completed at 12/9/2005 3:17:08
PM.
ReportingServicesService!dbpolling!1994!12/9/2005-15:17:08:: EventPolling
finished processing item 3c2cd2c9-3606-4fd4-9496-a755e9c893d6
ReportingServicesService!dbpolling!16e4!12/9/2005-15:17:08::
NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!1994!12/9/2005-15:17:08::
NotificationPolling processing item 70a496c4-b071-44c5-8f7d-f2e063dc41dc
ReportingServicesService!library!1994!12/09/2005-15:17:11:: i INFO:
Initializing EnableIntegratedSecurity to 'True' as specified in Server
system properties.
ReportingServicesService!library!1994!12/09/2005-15:17:12:: e ERROR:
Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon
failed., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon
failed. --> System.Runtime.InteropServices.COMException (0x8007052E): Logon
failure: unknown user name or bad password.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pUserName,
String pDomain, String pPassword, Boolean bTryRemote, IntPtr& pImpToken)
at
Microsoft.ReportingServices.Diagnostics.DatasourceRuntimeContext.MakeUserToken(String userName, String userPwd, String domain)
-- End of inner exception stack trace --
ReportingServicesService!notification!1994!12/09/2005-15:17:12:: e ERROR:
Error occured processing notification. Logon failed.
ReportingServicesService!notification!1994!12/09/2005-15:17:12::
Notification 70a496c4-b071-44c5-8f7d-f2e063dc41dc completed. Success: False,
Status: Logon failed., DeliveryExtension: Report Server Email, Report:
Incomplete Loan Applications, Attempt 0
ReportingServicesService!dbpolling!1994!12/09/2005-15:17:12::
NotificationPolling finished processing item
70a496c4-b071-44c5-8f7d-f2e063dc41dc
ReportingServicesService!library!1994!12/09/2005-15:19:04:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
"Daniel Reib [MSFT]" wrote:
> Is the logon failure an SMTP error? Perhaps you do not have your SMTP
> settings correct. Can you post the error message?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "dillig" <dillig@.discussions.microsoft.com> wrote in message
> news:6B033AF7-7476-4DDC-9873-BA6F2A6F1CF9@.microsoft.com...
> > Anyone know why I keep getting a logon failed when my email subscription
> > runs? I have used all users imaginable on my data source and none seems to
> > work.
> > SQLServer Agent is running and my users have RSExec role enabled.
> >
> >
>
>|||For some reason the system is not able to use the username and password that
you supplied. RS is attempting to logon using these credentials. Is this a
valid user on the computer that RS is installed on? Have you tried to
logon to that computer with these credentials? If all of these things are
correct then I would ensure that you have correctly set the password in the
datasource.
Can you view the report just fine? I would think you could not view it as
well.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"dillig" <dillig@.discussions.microsoft.com> wrote in message
news:F18FFFED-2D43-4AAA-970E-BDDE5164A79D@.microsoft.com...
> Below is my Report services file errors. But to add to by question.
> I created a system user named reportuser. reportUser has access to Report
> Server and the database I am making my query. this user has RSExec
> permissions. This user is also setup in Report Manager to store credential
> securely in Report Server on my shared datasource. I don't know what I
> have
> to do next. Can you help me?
> Report Services file is as follows:
> ReportingServicesService!dbpolling!16e4!12/9/2005-15:17:07:: EventPolling
> processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!1994!12/9/2005-15:17:07:: EventPolling
> processing item 3c2cd2c9-3606-4fd4-9496-a755e9c893d6
> ReportingServicesService!library!1994!12/9/2005-15:17:08:: Schedule
> e4d454cf-4bae-44f6-bd2b-32b14ac12347 executed at 12/9/2005 3:17:08 PM.
> ReportingServicesService!schedule!1994!12/9/2005-15:17:08:: Creating Time
> based subscription notification for subscription:
> 7d229c62-b339-471b-8622-358857f2870a
> ReportingServicesService!library!1994!12/9/2005-15:17:08:: Schedule
> e4d454cf-4bae-44f6-bd2b-32b14ac12347 execution completed at 12/9/2005
> 3:17:08
> PM.
> ReportingServicesService!dbpolling!1994!12/9/2005-15:17:08:: EventPolling
> finished processing item 3c2cd2c9-3606-4fd4-9496-a755e9c893d6
> ReportingServicesService!dbpolling!16e4!12/9/2005-15:17:08::
> NotificationPolling processing 1 more items. 1 Total items in internal
> queue.
> ReportingServicesService!dbpolling!1994!12/9/2005-15:17:08::
> NotificationPolling processing item 70a496c4-b071-44c5-8f7d-f2e063dc41dc
> ReportingServicesService!library!1994!12/09/2005-15:17:11:: i INFO:
> Initializing EnableIntegratedSecurity to 'True' as specified in Server
> system properties.
> ReportingServicesService!library!1994!12/09/2005-15:17:12:: e ERROR:
> Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException:
> Logon
> failed., ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException:
> Logon
> failed. --> System.Runtime.InteropServices.COMException (0x8007052E):
> Logon
> failure: unknown user name or bad password.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pUserName,
> String pDomain, String pPassword, Boolean bTryRemote, IntPtr& pImpToken)
> at
> Microsoft.ReportingServices.Diagnostics.DatasourceRuntimeContext.MakeUserToken(String
> userName, String userPwd, String domain)
> -- End of inner exception stack trace --
> ReportingServicesService!notification!1994!12/09/2005-15:17:12:: e ERROR:
> Error occured processing notification. Logon failed.
> ReportingServicesService!notification!1994!12/09/2005-15:17:12::
> Notification 70a496c4-b071-44c5-8f7d-f2e063dc41dc completed. Success:
> False,
> Status: Logon failed., DeliveryExtension: Report Server Email, Report:
> Incomplete Loan Applications, Attempt 0
> ReportingServicesService!dbpolling!1994!12/09/2005-15:17:12::
> NotificationPolling finished processing item
> 70a496c4-b071-44c5-8f7d-f2e063dc41dc
> ReportingServicesService!library!1994!12/09/2005-15:19:04:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> "Daniel Reib [MSFT]" wrote:
>> Is the logon failure an SMTP error? Perhaps you do not have your SMTP
>> settings correct. Can you post the error message?
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "dillig" <dillig@.discussions.microsoft.com> wrote in message
>> news:6B033AF7-7476-4DDC-9873-BA6F2A6F1CF9@.microsoft.com...
>> > Anyone know why I keep getting a logon failed when my email
>> > subscription
>> > runs? I have used all users imaginable on my data source and none seems
>> > to
>> > work.
>> > SQLServer Agent is running and my users have RSExec role enabled.
>> >
>> >
>>|||The rptuser I set up is a SQL user not a domain user. It is able to connect
to the server and view the report, but doesn't email and I get a logon failed
error. I do see the Job ran successfully under the SQLServer Agent jobs in
Enterprise manager. Does The rpt user I set up have to be a domain user?
"Daniel Reib [MSFT]" wrote:
> For some reason the system is not able to use the username and password that
> you supplied. RS is attempting to logon using these credentials. Is this a
> valid user on the computer that RS is installed on? Have you tried to
> logon to that computer with these credentials? If all of these things are
> correct then I would ensure that you have correctly set the password in the
> datasource.
>
> Can you view the report just fine? I would think you could not view it as
> well.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "dillig" <dillig@.discussions.microsoft.com> wrote in message
> news:F18FFFED-2D43-4AAA-970E-BDDE5164A79D@.microsoft.com...
> > Below is my Report services file errors. But to add to by question.
> > I created a system user named reportuser. reportUser has access to Report
> > Server and the database I am making my query. this user has RSExec
> > permissions. This user is also setup in Report Manager to store credential
> > securely in Report Server on my shared datasource. I don't know what I
> > have
> > to do next. Can you help me?
> >
> > Report Services file is as follows:
> >
> > ReportingServicesService!dbpolling!16e4!12/9/2005-15:17:07:: EventPolling
> > processing 1 more items. 1 Total items in internal queue.
> > ReportingServicesService!dbpolling!1994!12/9/2005-15:17:07:: EventPolling
> > processing item 3c2cd2c9-3606-4fd4-9496-a755e9c893d6
> > ReportingServicesService!library!1994!12/9/2005-15:17:08:: Schedule
> > e4d454cf-4bae-44f6-bd2b-32b14ac12347 executed at 12/9/2005 3:17:08 PM.
> > ReportingServicesService!schedule!1994!12/9/2005-15:17:08:: Creating Time
> > based subscription notification for subscription:
> > 7d229c62-b339-471b-8622-358857f2870a
> > ReportingServicesService!library!1994!12/9/2005-15:17:08:: Schedule
> > e4d454cf-4bae-44f6-bd2b-32b14ac12347 execution completed at 12/9/2005
> > 3:17:08
> > PM.
> > ReportingServicesService!dbpolling!1994!12/9/2005-15:17:08:: EventPolling
> > finished processing item 3c2cd2c9-3606-4fd4-9496-a755e9c893d6
> > ReportingServicesService!dbpolling!16e4!12/9/2005-15:17:08::
> > NotificationPolling processing 1 more items. 1 Total items in internal
> > queue.
> > ReportingServicesService!dbpolling!1994!12/9/2005-15:17:08::
> > NotificationPolling processing item 70a496c4-b071-44c5-8f7d-f2e063dc41dc
> > ReportingServicesService!library!1994!12/09/2005-15:17:11:: i INFO:
> > Initializing EnableIntegratedSecurity to 'True' as specified in Server
> > system properties.
> > ReportingServicesService!library!1994!12/09/2005-15:17:12:: e ERROR:
> > Throwing
> > Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException:
> > Logon
> > failed., ;
> > Info:
> > Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException:
> > Logon
> > failed. --> System.Runtime.InteropServices.COMException (0x8007052E):
> > Logon
> > failure: unknown user name or bad password.
> > at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> > errorCode, IntPtr errorInfo)
> > at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pUserName,
> > String pDomain, String pPassword, Boolean bTryRemote, IntPtr& pImpToken)
> > at
> > Microsoft.ReportingServices.Diagnostics.DatasourceRuntimeContext.MakeUserToken(String
> > userName, String userPwd, String domain)
> > -- End of inner exception stack trace --
> > ReportingServicesService!notification!1994!12/09/2005-15:17:12:: e ERROR:
> > Error occured processing notification. Logon failed.
> > ReportingServicesService!notification!1994!12/09/2005-15:17:12::
> > Notification 70a496c4-b071-44c5-8f7d-f2e063dc41dc completed. Success:
> > False,
> > Status: Logon failed., DeliveryExtension: Report Server Email, Report:
> > Incomplete Loan Applications, Attempt 0
> > ReportingServicesService!dbpolling!1994!12/09/2005-15:17:12::
> > NotificationPolling finished processing item
> > 70a496c4-b071-44c5-8f7d-f2e063dc41dc
> > ReportingServicesService!library!1994!12/09/2005-15:19:04:: i INFO:
> > Cleaned
> > 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> > chunks, 0 running jobs
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> Is the logon failure an SMTP error? Perhaps you do not have your SMTP
> >> settings correct. Can you post the error message?
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "dillig" <dillig@.discussions.microsoft.com> wrote in message
> >> news:6B033AF7-7476-4DDC-9873-BA6F2A6F1CF9@.microsoft.com...
> >> > Anyone know why I keep getting a logon failed when my email
> >> > subscription
> >> > runs? I have used all users imaginable on my data source and none seems
> >> > to
> >> > work.
> >> > SQLServer Agent is running and my users have RSExec role enabled.
> >> >
> >> >
> >>
> >>
> >>
>
>|||No report user does not need to be a domain user. You may want to use
rsconfig.exe to set an unattended account. Perhaps this account was set
incorrectly.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"dillig" <dillig@.discussions.microsoft.com> wrote in message
news:BC2653B2-59A1-4141-ADD6-CB203A7F34F3@.microsoft.com...
> The rptuser I set up is a SQL user not a domain user. It is able to
> connect
> to the server and view the report, but doesn't email and I get a logon
> failed
> error. I do see the Job ran successfully under the SQLServer Agent jobs in
> Enterprise manager. Does The rpt user I set up have to be a domain user?
> "Daniel Reib [MSFT]" wrote:
>> For some reason the system is not able to use the username and password
>> that
>> you supplied. RS is attempting to logon using these credentials. Is
>> this a
>> valid user on the computer that RS is installed on? Have you tried to
>> logon to that computer with these credentials? If all of these things
>> are
>> correct then I would ensure that you have correctly set the password in
>> the
>> datasource.
>>
>> Can you view the report just fine? I would think you could not view it
>> as
>> well.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "dillig" <dillig@.discussions.microsoft.com> wrote in message
>> news:F18FFFED-2D43-4AAA-970E-BDDE5164A79D@.microsoft.com...
>> > Below is my Report services file errors. But to add to by question.
>> > I created a system user named reportuser. reportUser has access to
>> > Report
>> > Server and the database I am making my query. this user has RSExec
>> > permissions. This user is also setup in Report Manager to store
>> > credential
>> > securely in Report Server on my shared datasource. I don't know what I
>> > have
>> > to do next. Can you help me?
>> >
>> > Report Services file is as follows:
>> >
>> > ReportingServicesService!dbpolling!16e4!12/9/2005-15:17:07::
>> > EventPolling
>> > processing 1 more items. 1 Total items in internal queue.
>> > ReportingServicesService!dbpolling!1994!12/9/2005-15:17:07::
>> > EventPolling
>> > processing item 3c2cd2c9-3606-4fd4-9496-a755e9c893d6
>> > ReportingServicesService!library!1994!12/9/2005-15:17:08:: Schedule
>> > e4d454cf-4bae-44f6-bd2b-32b14ac12347 executed at 12/9/2005 3:17:08 PM.
>> > ReportingServicesService!schedule!1994!12/9/2005-15:17:08:: Creating
>> > Time
>> > based subscription notification for subscription:
>> > 7d229c62-b339-471b-8622-358857f2870a
>> > ReportingServicesService!library!1994!12/9/2005-15:17:08:: Schedule
>> > e4d454cf-4bae-44f6-bd2b-32b14ac12347 execution completed at 12/9/2005
>> > 3:17:08
>> > PM.
>> > ReportingServicesService!dbpolling!1994!12/9/2005-15:17:08::
>> > EventPolling
>> > finished processing item 3c2cd2c9-3606-4fd4-9496-a755e9c893d6
>> > ReportingServicesService!dbpolling!16e4!12/9/2005-15:17:08::
>> > NotificationPolling processing 1 more items. 1 Total items in internal
>> > queue.
>> > ReportingServicesService!dbpolling!1994!12/9/2005-15:17:08::
>> > NotificationPolling processing item
>> > 70a496c4-b071-44c5-8f7d-f2e063dc41dc
>> > ReportingServicesService!library!1994!12/09/2005-15:17:11:: i INFO:
>> > Initializing EnableIntegratedSecurity to 'True' as specified in Server
>> > system properties.
>> > ReportingServicesService!library!1994!12/09/2005-15:17:12:: e ERROR:
>> > Throwing
>> > Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException:
>> > Logon
>> > failed., ;
>> > Info:
>> > Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException:
>> > Logon
>> > failed. --> System.Runtime.InteropServices.COMException (0x8007052E):
>> > Logon
>> > failure: unknown user name or bad password.
>> > at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
>> > errorCode, IntPtr errorInfo)
>> > at RSRemoteRpcClient.RemoteLogon.GetRemoteImpToken(String pUserName,
>> > String pDomain, String pPassword, Boolean bTryRemote, IntPtr&
>> > pImpToken)
>> > at
>> > Microsoft.ReportingServices.Diagnostics.DatasourceRuntimeContext.MakeUserToken(String
>> > userName, String userPwd, String domain)
>> > -- End of inner exception stack trace --
>> > ReportingServicesService!notification!1994!12/09/2005-15:17:12:: e
>> > ERROR:
>> > Error occured processing notification. Logon failed.
>> > ReportingServicesService!notification!1994!12/09/2005-15:17:12::
>> > Notification 70a496c4-b071-44c5-8f7d-f2e063dc41dc completed. Success:
>> > False,
>> > Status: Logon failed., DeliveryExtension: Report Server Email, Report:
>> > Incomplete Loan Applications, Attempt 0
>> > ReportingServicesService!dbpolling!1994!12/09/2005-15:17:12::
>> > NotificationPolling finished processing item
>> > 70a496c4-b071-44c5-8f7d-f2e063dc41dc
>> > ReportingServicesService!library!1994!12/09/2005-15:19:04:: i INFO:
>> > Cleaned
>> > 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots,
>> > 0
>> > chunks, 0 running jobs
>> >
>> > "Daniel Reib [MSFT]" wrote:
>> >
>> >> Is the logon failure an SMTP error? Perhaps you do not have your SMTP
>> >> settings correct. Can you post the error message?
>> >>
>> >> --
>> >> -Daniel
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "dillig" <dillig@.discussions.microsoft.com> wrote in message
>> >> news:6B033AF7-7476-4DDC-9873-BA6F2A6F1CF9@.microsoft.com...
>> >> > Anyone know why I keep getting a logon failed when my email
>> >> > subscription
>> >> > runs? I have used all users imaginable on my data source and none
>> >> > seems
>> >> > to
>> >> > work.
>> >> > SQLServer Agent is running and my users have RSExec role enabled.
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>

Wednesday, March 28, 2012

long running report can not be rendered in Report Manager or through Subscription

long running report can not be rendered in Report Manager or through Subscription

long running report can not be rendered in Report Manager or through Subscription

Wednesday, March 21, 2012

Logreader agent not being created

Monday, March 19, 2012

Logon Failed and Subscriptions

sql login permissions

Blog Archive

About Me