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

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
sknoll84Asked:
Who is Participating?
 
sknoll84Connect With a Mentor Author Commented:
0
 
WilyGuyCommented:
Any event logs?

Is the Async service running?
0
 
sknoll84Author Commented:
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
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
Jez3652Commented:
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
 
WilyGuyCommented:
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
 
sknoll84Author Commented:
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
 
WilyGuyCommented:
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
 
sknoll84Author Commented:
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
 
Ronny StijnsCommented:
Have you resolved this issue? I have the same issue and curious whether or not you solved it.
0
 
Jatin917Commented:
did all the recomanded steps still the same problem persists.
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.

All Courses

From novice to tech pro — start learning today.