Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

CRM 4 Import Data - import sits in System Job queue with "waiting" status

Posted on 2008-11-13
10
Medium Priority
?
3,932 Views
Last Modified: 2012-05-05
When using the Import Data function in CRM 4, the mappings and setting up the import is pretty straight forward.  However, after submitting the Import - the job sits there with a "waiting" status.  I can't force the job and no matter how long we wait, it never imports.

Also, when running ONE import, it creates THREE identical system jobs.

I am trying to import a pretty simple .csv with the following column headers:
CampaignName,MemberStatus,FirstName,LastName,Company,Phone,Email,Title,

Record type:  customer
crm.jpg
0
Comment
Question by:sknoll84
10 Comments
 
LVL 15

Expert Comment

by:WilyGuy
ID: 22958600
Any event logs?

Is the Async service running?
0
 

Author Comment

by:sknoll84
ID: 22960468
There are a ton of event logs.  Here are two examples:

Error
MSCRMKeyGenerator
18949
Current active key (KeyType : CrmTicketKey) is expired.  This can indicate that a key is not being regenerated properly.  Current Active Key : CrmKey(Id:83acb6fb-9daf-dd11-b0cb-00221912222e, ScaleGroupId:00000000-0000-0000-0000-000000000000, KeyType:CrmTicketKey, Expired:True, ValidOn:11/11/2008 03:08:16, ExpiresOn:11/13/2008 03:08:16, CreatedOn:11/11/2008 03:08:16, CreatedBy:NT AUTHORITY\NETWORK SERVICE.  Key Setting :

Error
MSCRMKeyGenerator
18949
Current active key (KeyType : CrmTicketKey) is expired.  This can indicate that a key is not being regenerated properly.  Current Active Key : CrmKey(Id:83acb6fb-9daf-dd11-b0cb-00221912222e, ScaleGroupId:00000000-0000-0000-0000-000000000000, KeyType:CrmTicketKey, Expired:True, ValidOn:11/11/2008 03:08:16, ExpiresOn:11/13/2008 03:08:16, CreatedOn:11/11/2008 03:08:16, CreatedBy:NT AUTHORITY\NETWORK SERVICE.  Key Setting :


And yes, the async processing service is running
0
 
LVL 1

Expert Comment

by:Jez3652
ID: 22966329
Do you have any event logs specifically regarding the CRM Async service.

If you've followed WilyGuys suggestion and checked the async service, two things spring to mind:

Check that the account running the async service has access to the database (normally you'd have an event log entry giving you a clue about this)

If your installed version of crm4 is an old one then you could run an uninstall/reinstall but allow the installer to update the install files. This has the trick of downloading all the latest patches and fixes prior to installation. You can then re-connect your installed version to your existing database and will have an updated crm4 install. This has fixed some workflow issues for me in the past..
0
Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

 
LVL 15

Expert Comment

by:WilyGuy
ID: 23028378
Are you able to restart the Async Service?

As Jez asks, what are you running that as? (Network Service, Local System, domain user?)
Looks like it thinks Network Service.

Also, do an IISRESET -stop, then stop the service, then IISRESET -start and start the service.

You may have to delete the old import jobs as well and try to re-import.

0
 

Author Comment

by:sknoll84
ID: 23029136
Async service is automatic running as Network Service.
I performed an IIS Reset as suggested and deleted the jobs that were hung.

I tried to do a reimport and again, three jobs are created with a "waiting" status.
0
 
LVL 15

Expert Comment

by:WilyGuy
ID: 23037855
http://support.microsoft.com/kb/950680/en-us

See if that works for you.  Basically in looking at your history, you upgraded and may have even imported the 4.0 database.  Very possible that this applies.

Workflow works in the background to do data duplication checking etc.

Do you have any plug-ins that might be trying to fire?
0
 

Author Comment

by:sknoll84
ID: 23047830
Opened a case with Microsoft and after they looked at my issue it was suggested I try this:  http://support.microsoft.com/kb/950416

I will give that KB a shot next week.
0
 
LVL 1

Expert Comment

by:Ronny Stijns
ID: 23084730
Have you resolved this issue? I have the same issue and curious whether or not you solved it.
0
 

Accepted Solution

by:
sknoll84 earned 0 total points
ID: 23116898
0
 

Expert Comment

by:Jatin917
ID: 23588992
did all the recomanded steps still the same problem persists.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

On Sep 22nd 2014 Microsoft released Update Rollup 1 for Microsoft Dynamics CRM 2013 Service Pack 1 and back in July Update Rollup 3 was released.  So we now have:   Update Rollup 1Update Rollup 2Update Rollup 3Service Pack 1Update Rollup 1 for S…
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part I
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses
Course of the Month21 days, 1 hour left to enroll

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question