Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Error on Scheduling Re...
Microsoft Dynamics CRM (Archived)

Error on Scheduling Report

(0) ShareShare
ReportReport
Posted on by Abdul Wahab 12,070 Super User 2024 Season 1

Hi all,

I go to the 

2450.Enable-rule-1.png

than

5164.Enable-rule.png

than

3426.Untitled2.png

than

7230.Untitled3.png

than 

1854.Untitled4.png

than

8306.Untitled5.png

than

Untitled-1.png

than

1362.Untitled6.png

than it is giving me error. I do not know where i am wrong. Please help.

4186.Untitled7.png

Thank you

*This post is locked for comments

  • Abdul Wahab Profile Picture
    Abdul Wahab 12,070 Super User 2024 Season 1 on at
    RE: Error on Scheduling Report

    Hi all

    No one is there to answer my Question.

    Thank you

  • Abdul Wahab Profile Picture
    Abdul Wahab 12,070 Super User 2024 Season 1 on at
    RE: Error on Scheduling Report

    Hi all

    This is my trace log 

    0317.14.png

    and description for the selected one 

    at CrmReportingException..ctor(String message, Exception innerException, Int32 errorCode) ilOffset = 0x9
    at RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) ilOffset = 0xFFFFFFFF
    at RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) ilOffset = 0xEE
    at RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, StackCrawlMark& stackMark) ilOffset = 0x1C8
    at Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) ilOffset = 0xAB
    at Activator.CreateInstance(Type type, Object[] args) ilOffset = 0x0
    at VersionedPluginProxyStepBase.WrapExceptionToThrow(CrmException exception) ilOffset = 0x63
    at VersionedPluginProxyStepBase.Execute(PipelineExecutionContext context) ilOffset = 0x65
    at Pipeline.Execute(PipelineExecutionContext context) ilOffset = 0x6C
    at MessageProcessor.Execute(PipelineExecutionContext context) ilOffset = 0x1CB
    at InternalMessageDispatcher.Execute(PipelineExecutionContext context) ilOffset = 0xE4
    at ExternalMessageDispatcher.ExecuteInternal(IInProcessOrganizationServiceFactory serviceFactory, IPlatformMessageDispatcherFactory dispatcherFactory, String messageName, String requestName, Int32 primaryObjectTypeCode, Int32 secondaryObjectTypeCode, ParameterCollection fields, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId, Guid transactionContextId, Int32 invocationSource, Nullable`1 requestId, Version endpointVersion) ilOffset = 0x156
    at OrganizationSdkServiceInternal.ExecuteRequest(OrganizationRequest request, CorrelationToken correlationToken, CallerOriginToken callerOriginToken, WebServiceType serviceType, UserAuth userAuth, Guid targetUserId, Boolean traceRequest, OrganizationContext context, Boolean returnResponse) ilOffset = 0x0
    at OrganizationSdkServiceInternal.ExecuteRequest(OrganizationRequest request, CorrelationToken correlationToken, CallerOriginToken callerOriginToken, WebServiceType serviceType) ilOffset = 0x34
    at OrganizationSdkServiceInternal.Execute(OrganizationRequest request, CorrelationToken correlationToken, CallerOriginToken callerOriginToken, WebServiceType serviceType) ilOffset = 0x0
    at InprocessServiceProxy.ExecuteCore(OrganizationRequest request) ilOffset = 0x34
    at PlatformCommand.XrmExecuteInternal() ilOffset = 0xBC
    at CreateScheduleCommand.Execute() ilOffset = 0x0
    at ScheduleService.ProcessWizardData(String xmlWizardData, Boolean takeSnapshotNow) ilOffset = 0x1AE
    at RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) ilOffset = 0xFFFFFFFF
    at RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) ilOffset = 0x16
    at RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) ilOffset = 0x6C
    at LogicalMethodInfo.Invoke(Object target, Object[] values) ilOffset = 0x3F
    at WebServiceHandler.Invoke() ilOffset = 0xAE
    at WebServiceHandler.CoreProcessRequest() ilOffset = 0x134
    at SyncSessionlessHandler.ProcessRequest(HttpContext context) ilOffset = 0x3F
    at HandlerWrapper.ProcessRequest(HttpContext context) ilOffset = 0xC
    at CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() ilOffset = 0x187
    at HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) ilOffset = 0x15
    at ApplicationStepManager.ResumeSteps(Exception error) ilOffset = 0xF6
    at HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData) ilOffset = 0x5C
    at HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) ilOffset = 0x15B
    at HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr) ilOffset = 0x32
    at ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType) ilOffset = 0x4B
    Crm Exception: Message: Error occurred while setting execution options., ErrorCode: -2147187931, InnerException: Microsoft.Crm.CrmReportingException: Error occurred while setting execution options. ---> System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: The SQL Agent service is not running. This operation requires the SQL Agent service. ---> Microsoft.ReportingServices.Diagnostics.Utilities.SchedulerNotRespondingException: The SQL Agent service is not running. This operation requires the SQL Agent service.
    at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetExecutionOptions(String Report, ExecutionSettingEnum ExecutionSetting, ScheduleDefinitionOrReference Schedule)
    at Microsoft.ReportingServices.WebServer.ReportingService2005.SetExecutionOptions(String Report, ExecutionSettingEnum ExecutionSetting, ScheduleDefinitionOrReference Schedule)
    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
    at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
    at Microsoft.Crm.Reporting.RuntimeReportServer.SetSchedule(String reportNameOnSrs, String scheduleXml, TimeZone schedulerTimeZone, Boolean isSharedReport)
    --- End of inner exception stack trace ---
    at Microsoft.Crm.Reporting.RuntimeReportServer.SetSchedule(String reportNameOnSrs, String scheduleXml, TimeZone schedulerTimeZone, Boolean isSharedReport)
    at Microsoft.Crm.ObjectModel.ReportServiceInternal`1.UpdateReportServer(Report report, String scheduleXml, String parameterXml, ExecutionContext context)
    at Microsoft.Crm.ObjectModel.ReportServiceInternal`1.CreateSchedule(Guid originalReportId, String scheduleXml, String parameterXml, String scheduledReportName, ExecutionContext context)

    Thank you

  • Abdul Wahab Profile Picture
    Abdul Wahab 12,070 Super User 2024 Season 1 on at
    RE: Error on Scheduling Report

    Hi Prashant Shukla

    I follow community.dynamics.com/.../report-scheduling-and-email-subscription-in-crm-2011 to make schedule which is giving me error. Is it any configuration require to run this.? If I delete all the filters than still It is not working. Giving me error

    Thank you

  • Suggested answer
    PS Profile Picture
    PS 23,577 on at
    RE: Error on Scheduling Report

    Remove the opportunity product filter, its not required.

    Remove won and lost from status

    Add Modified on opportunity- Last x days 30

  • Suggested answer
    PS Profile Picture
    PS 23,577 on at
    RE: Error on Scheduling Report

    community.dynamics.com/.../report-scheduling-and-email-subscription-in-crm-2011

    Try this for email scheduling

  • Abdul Wahab Profile Picture
    Abdul Wahab 12,070 Super User 2024 Season 1 on at
    RE: Error on Scheduling Report

    Hi Prashant Shukla

    I use these filters

    6505.Untitled8.png.

    It is still giving error.

    Thank you

  • Suggested answer
    PS Profile Picture
    PS 23,577 on at
    RE: Error on Scheduling Report

    In your 6th screenshot, change your query to:

    Est.close date 'next x month'  enter value 1 or 2 or 3 or 4 anything

    Rating equals - select all hot, warm,cold

    Then try, i guess it should resolve

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans