• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1493
  • Last Modified:

Microsoft CRM 4 Import - Job progress could not start and still in 'waiting' status

Hello,
I'm trying to Import Data in MS CRM 4, but after submitting the job, but my job's Status Reason in Settings / System is 'Waiting' and the Job progress will not start.

I saw the related post about my problem at http://www.experts-exchange.com/Microsoft/Applications/Microsoft_Dynamics/Q_23904221.html and configure my server as http://support.microsoft.com/kb/950416 , but my problem still exist.

'Microsoft CRM Asynchronous Processing Service' is up and running and there isn't any more information on error log on the Server.

Please help...
0
mbprogrammer
Asked:
mbprogrammer
  • 6
  • 5
1 Solution
 
Feridun KadirPrincipal ConsultantCommented:
check that the asynchronous service is running on the server
0
 
mbprogrammerAuthor Commented:
thanks for reply,
As my prev post, i say 'Microsoft CRM Asynchronous Processing Service' is up and running...
0
 
Feridun KadirPrincipal ConsultantCommented:
Oops sorry about that. I just saw the headline on my mobile.

It seems that you checked all the things that I would have mentioned. If you look at the list in Settings | System Jobs do you see other types of jobs stuck at waiting?

0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
mbprogrammerAuthor Commented:
Don't worry about that,
When try to import 1 file, MS CRM generate 3 jobs like attached screenshot.
CRM.png
0
 
Feridun KadirPrincipal ConsultantCommented:
Let's see if we can get more info about what is happening.

In the System Jobs list, would you please use Advanced Find to create a new view, criteria System Job Type Equals Import File Parse and add the columns Error Code and Message.

The message might just help us work out where to look next.

0
 
mbprogrammerAuthor Commented:
Ok, i found my Jobs Error code and message:

Error Code:
2,147,204,346-

Error Message:
System.Net.WebException: The request failed with HTTP status 400: Bad Request. 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.SdkTypeProxy.CrmService.Execute(Request Request) at Microsoft.Crm.Asynchronous.SdkTypeProxyCrmServiceWrapper.Execute(Object request) at Microsoft.Crm.Asynchronous.UserSettingsCacheLoader.RetrieveUserSettings(ICrmService crmService, Guid userId) at Microsoft.Crm.Asynchronous.UserSettingsCacheLoader.LoadCacheData(Guid userId, IOrganizationContext context) at Microsoft.Crm.Caching.BasicCrmCache`2.CreateEntry(TKey key, IOrganizationContext context) at Microsoft.Crm.Caching.BasicCrmCache`2.LookupEntry(TKey key, IOrganizationContext context) at Microsoft.Crm.Asynchronous.ImportOperation.GetUserLanguage(AsyncEvent asyncEvent) at Microsoft.Crm.Asynchronous.ImportOperation.InternalExecute(AsyncEvent asyncEvent) at Microsoft.Crm.Asynchronous.AsyncOperationCommand.Execute(AsyncEvent asyncEvent) at Microsoft.Crm.Asynchronous.QueueManager.PoolHandler.ProcessAsyncEvent(AsyncEvent asyncEvent)
0
 
Feridun KadirPrincipal ConsultantCommented:
:( That error message isn't too helpful.

Would you mind running Advanced Find again please and changing the System Job Type criteria to just Import and posting the error message?

0
 
mbprogrammerAuthor Commented:
Thank you for helping me, but i got same result


AdvancedFind.png
0
 
Feridun KadirPrincipal ConsultantCommented:
OK. Here are some questions:

1. Has anyone succesfully imported data into CRM?
2. Have you applied any Update Rollups to the system?
3. What account is the Microsoft CRM Asynchronous Service running as?  (Network Service is recommended)
4. Can you please run the following query on the MSCRM_CONFIG database:

select columnname, nvarcharcolumn from deploymentproperties
where nvarcharcolumn is not null

The entry against AsyncSdkRootDomain should be the base URL for your CRM deployment e,g, http:.//crm
0
 
mbprogrammerAuthor Commented:
Hi feridun,

Thank you for helping me; My problem solved by changing AsyncSdkRootDomain from my CRM server's NETBIOS name to FQDN. Because my CRM's website only working with Host Header.
0
 
mbprogrammerAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now