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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
Fundamentals of JavaScript

Learn the fundamentals of the popular programming language JavaScript so that you can explore the realm of web development.

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
sknoll84Author Commented:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jatin917Commented:
did all the recomanded steps still the same problem persists.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Dynamics

From novice to tech pro — start learning today.