Sign in
Microsoft.com
 
Microsoft
 
 
 
Note: Forums will be making significant UX changes to address key usability improvements surrounding search, discoverability and navigation. To learn more about these changes please visit the announcement which can be found HERE.
Microsoft >
> 
> 
All system jobs are waiting

Svar All system jobs are waiting

  • 2009年4月2日 15:45
     
     
    登入以投票
    0
    Hi...

    Today, I tried to import some data into crm using Import wizard. 
    After submitting the import, the status reason is showing as Submitted for long time. I double clicked on that and looked at the system jobs and found the status reason of the three jobs as Waiting.
    I checked that Crm Asyn service is running and I restarted it.
    After that I checked all the system jobs and to my surprise all the system jobs have satus reason as waiting for the last 1 week.
    Previously I was able to import data.

    Can anyone have an idea of why am I unable to import the data and why all these system jobs are having status reason WAITING???
    I never faced this kind of issue and your ideas on this is really appreciable!!!


    -Thanks






     

所有回覆

  • 2009年4月2日 15:54
    版主
     
     
    登入以投票
    1
    Hi -

    There is a set of instructions here:
    http://blogs.msdn.com/benlec/archive/2009/02/10/how-to-troubleshoot-system-jobs-failures-using-advanced-find.aspx

    These will help retrieve the 'reason' for the waiting state - Ben also provides some information on other reasons / potential solutions -The failure is possibly that the Asynchronous Service cannot contact the CRM Web Services because of a bad configuration. It could be configuration within the MSCRM_CONFIG database or in the Server MSCRM Registry Hive -  see the configuration details for more information.

    Please have a look at the following articles for more information and for potential solutions:

    950416    System Jobs are in a waiting state and Outlook clients cannot connect after you set the CRM Web site to an assigned IP address
    http://support.microsoft.com/default.aspx?scid=kb;EN-US;950416

    947423    How to update the Microsoft Dynamics CRM Web site port after you install Microsoft Dynamics CRM 4.0
    http://support.microsoft.com/default.aspx?scid=kb;EN-US;947423

    950542    Synchronous plug-ins do not respond to the events that are triggered in Microsoft Dynamics CRM 4.0
    http://support.microsoft.com/default.aspx?scid=kb;EN-US;950542

    Scott Sewell, CustomerEffective | http:\\blog.CustomerEffective.com | Twitter:@ScottSewell
     
  • 2009年4月2日 16:02
     
     
    登入以投票
    0
    Scott, thank you very much for your quick reply.
    I will take a look at them and ping you if I still have any issues.
     
  • 2009年4月2日 16:25
     
     
    登入以投票
    0
    http://blogs.msdn.com/benlec/archive/2009/02/10/how-to-troubleshoot-system-jobs-failures-using-advanced-find.aspx

    Hey, I followed the above link and checked out by using advanced find and the error messages are different from that mentioned in that link.

    Error message:
    "The operation has timed out at System.Web.Services.Protocols.WebClientProtocol.GetWebresponse(Webrequest request) at System.Web.Services.HttpWebClientProtocol.GetWebresponse(Webrequest request) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Microsofoft.Crm.SdkTypeProxy.CrmService.Execute(Request Request) at Microsofoft.Crm.Asynchronous.SdkTypeProxyCrmServiceWrapper.Execute(Object reuest) at Microsoft.Crm.Asynchronous."


    Any ideas???
     
  • 2009年4月2日 16:30
    版主
     
     
    登入以投票
    1
    That's a fairly generic timeout error - do you have any plugins or workflows on the object(s) you are importing?

    Also are there any SQL issues / timeouts that you've experienced?
    Scott Sewell, CustomerEffective | http:\\blog.CustomerEffective.com | Twitter:@ScottSewell
     
  • 2009年4月3日 11:09
     
     已答覆
    登入以投票
    1


    I fixed the issue with the following change in the DB.


    Database name: MSCRM_CONFIG
    Update DeploymentProperties SET NVarCharColumn = '<server>:<port>' WHERE ColumnName = 'AsyncSdkRootDomain'
    ex: Update DeploymentProperties SET NVarCharColumn = 'MyCrmServer:80' WHERE ColumnName = 'AsyncSdkRootDomain'



    -Thanks
     Dinesh,
     RampIndia.


     
  • 2009年4月3日 15:20
    版主
     
     提議的解答
    登入以投票
    0
    I would encourage you to NOT update the config database directly via SQL - rather, The supported method of updating your deployment is to use the Microsoft Dynamics CRM Deployment Configuration tool provided here http://support.microsoft.com/kb/949079/ 

    The Microsoft Dynamics CRM Deployment Configuration tool is a command-line executable program. You can use this tool to update the values in the Microsoft Dynamics CRM configuration (MSCRM_Config) database. Additionally, you can use this tool to send notifications to all the Microsoft Dynamics CRM servers to use the values that you updated.
    Scott Sewell, CustomerEffective | http:\\blog.CustomerEffective.com | Twitter:@ScottSewell
     
  • 2012年5月7日 13:01
     
     
    登入以投票
    0

    Hi Perfectionist

    I am facing teh same problem

    I updated the DeploymentProperties  but it didnt work for me

    is there something that i am missing do let me know

    Thanks

    Pradnya07

     
  • 2012年5月7日 13:49
     
     
    登入以投票
    0

    Hi Pradnya,

    Which version of CRM you are working on? Is it MS CRM 4.0 or 2011?

    Do you have the latest rollup installed? Restart the Microsoft CRM Asynchronous Processing Service once.

    Perfectionist
    wwwdotdinesh.blogspot.com

     
  • 2012年5月7日 13:53
     
     
    登入以投票
    0

    Also check the other column names in the Deployment Properties table and do an update if it is null.

    USE MSCRM_CONFIG
    Update DeploymentProperties SET NVarCharColumn = ‘SERVER:PORT‘ WHERE ColumnName = ‘AsyncSdkRootDomain’
    Update DeploymentProperties SET NvarCharColumn = ‘SERVER:PORT‘ WHERE ColumnName = ‘ADSdkRootDomain’
    Update DeploymentProperties SET NvarCharColumn = ‘SERVER:PORT‘ WHERE ColumnName = ‘ADWebApplicationRootDomain’

    Perfectionist
    wwwdotdinesh.blogspot.com

     
  • 2012年5月8日 8:12
     
     
    登入以投票
    0

    Hi I am using CRM 4.0 i have updated teh CRM to roll up 21

    Restarted teh Asyn service but no progress

    Pradnya07

     
  • 2012年5月8日 8:15
     
     
    登入以投票
    0

    Hi Perfectionist;

    This the result of the query

    ADRootDomainScheme HTTP
    ADSdkRootDomain BLUEOWEB1:5555
    ADWebApplicationRootDomain BLUEOWEB1:5555
    AsyncSdkRootDomain BLUEOWEB1:5555
    IfdRootDomainScheme HTTP
    IfdSdkRootDomain theblueorchid.co.uk
    IfdWebApplicationRootDomain theblueorchid.co.uk

    Pradnya07

     
  • 2012年5月8日 11:42
     
     
    登入以投票
    0

    Hi ;

    I just found that my workflows are actuaaly working but they show status reason as waiting in the system jobs

    Can you please help regarding the same

    Thanks

    P

    Pradnya07

     
  • 2012年5月9日 9:36
     
     
    登入以投票
    0

    Follow the steps in the below link and check for the Error Message.

    http://wwwdotdinesh.blogspot.in/2012/03/ms-crm-workflows-waiting-and-failed-how.html

    Try restarting SQL services as well.

     

    Perfectionist
    wwwdotdinesh.blogspot.com