how to resovle MS project 2007 - CICONotCheckedOut - Failed But Not Blocking Correlation - Project Checkin issue

I have googled around for this perticular one no one has fix for this, i tried removing my project professional sp2 on client and applying sp1 with april CU but still same issue, i deleted the proejct recreated same... also i have full configured in house mail server, when i assign a resource and commit him for job he dont get email notification nor does that show in hi my tasks on PWA. what can i do to resovle the issue.

Error summary/areas:
Error details:

<?xml version="1.0" encoding="utf-16"?>
    <class name="CICONotCheckedOut">
      <error id="10102" name="CICONotCheckedOut" uid="3018192b-a28a-4dde-8608-a768cfe442ad" />
    <class name="Queue">
      <error id="26000" name="GeneralQueueJobFailed" uid="e5489849-01cf-42e3-90f2-f929af6bdeb1" JobUID="8990ca5d-8b6a-414a-81fb-d3b48f884854" ComputerName="OL-SRV-DM" GroupType="ProjectCheckIn" MessageType="FailIfNotCheckedOutMessage" MessageId="2" Stage="" />
Who is Participating?

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

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.

Dr. Thomas HenkelmannDirector Consulting ServicesCommented:

this error really has been around a long time (actually since the release of 2007) and to my knowledge only has been resolved with last year's August Cumulative Update. This is a lot newer than SP2 and please be aware that this error is caused by the combination of project server and project client. You ALWAYS should apply exactly the same patch level to the server AND to the client to get a reliable configuration.


immipathanAuthor Commented:
well i have sp2 on server and sp1 april cumuletive on project pro on client, thats what i found on google to get fixed, but could not worked out,, i will give it a shot to upgrdade my client to sp2 too which it was aready prior to this error... it should work but i have no idea where can i clear the  queue that is stuck .... i have no options even in admin mode to delete the queue... must be possible in sql if some one can link or guide me how i have admin rights to get it done.

Please help
immipathanAuthor Commented:
i resolve the issue with MS support, never use the _ in project name this stops the project to publish and queue crashes, after renaming the project publish the project again and the failed queue log will eventually go after some time.

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
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
Project Management Software

From novice to tech pro — start learning today.