Resources for IT Professionals >
Dynamics Forums
>
CRM
>
I have 1000's of System Jobs in the Waiting state
I have 1000's of System Jobs in the Waiting state
- I'm running CRM 4.0 (rollup 7) on Server 2008 and SQL Server 2008, in Hyper-V. The domain controller is Small Business Server 2008 also running as a virtual server on the same Hyper-V box.
I can access and use CRM using Internet Explorer, both from a Domain client and from outside the domain. I can also use the Outlook CRM connector without a problem. However, CRM's performance is starting to slow down, and I've noticed 1000's of System Jobs in the waiting state.
I've searched lots of blogs and checked several things. I'm pretty convinced that my problem is to do with SPN's, but my knowledge of such things is zero!
I've looked at the following links to help with this problem:
http://support.microsoft.com/kb/950416
http://social.microsoft.com/Forums/en-US/crm/thread/443eda5d-b5b4-4cee-99d3-5170b9882b49
http://support.microsoft.com/default.aspx?scid=kb;EN-US;950542
http://social.microsoft.com/Forums/en-US/crmdeployment/thread/ccf10f23-989f-4a86-8849-648c6affe4bd
I've run setspn -L and the command had returned the following entries:
MSSQLSvc/<SQL Server computer name>:1433
MSSQLSvc/<SQL Server computer name>
MSSQLSvc/<SQL Server computer name>:SQLEXPRESS
TERMSRV/<hostname>
TERMSRV/<SQL Server computer name>
HOST/<hostname>
HOST/<SQL Server computer name>
But I would assume that I also need SPN entries for the http url's as well, am I correct in thinking this? And if so can anyone give me an idea as to what the correct syntax should be to add them.
Thank you
Answers
- Hi Nick,
It sounds like you have an all in one box ie. CRM4 + SQL + RS on all the same box?
Are you running your IIS App Pool and MSSQL service using domain accounts? If not, SPN shouldnt be your issue here.
Otherwise, have a look at this post, its really informative on SPN:
http://rc.crm.dynamics.com/rc/regcont/en_us/op/articles/configurespn.aspx?WTT.rss_f=CRMRC_OP
The other thing you might want to do is turn on tracing and see whats going on with the Async Service etc.
Hope this helps and good luck!
Cheers
DC
- Marked As Answer byDonna EdwardsMVP, ModeratorSunday, November 15, 2009 5:13 PM
All Replies
- Hi,
Are you saying that your Async service is not able to start? Do you see any Windows event log related to CRM Async Service?
Daniel Cai | http://danielcai.blogspot.com - Hi Nick,
It sounds like you have an all in one box ie. CRM4 + SQL + RS on all the same box?
Are you running your IIS App Pool and MSSQL service using domain accounts? If not, SPN shouldnt be your issue here.
Otherwise, have a look at this post, its really informative on SPN:
http://rc.crm.dynamics.com/rc/regcont/en_us/op/articles/configurespn.aspx?WTT.rss_f=CRMRC_OP
The other thing you might want to do is turn on tracing and see whats going on with the Async Service etc.
Hope this helps and good luck!
Cheers
DC
- Marked As Answer byDonna EdwardsMVP, ModeratorSunday, November 15, 2009 5:13 PM
- Hi DC
And thank you, that's a really useful link and it's helped me set the correct SPNs. I think the problem is now almost resolved. I just need to clear up the 1000's of "waiting" system jobs now, and have this link to help me with that - Sweet~ Glad to know that its all good! :)
