Event Manager error Event 5586 Sharepoint Foundation


  We have Sharepoint foundation 2010. We are keep getting error in event manager regarding SQl and Sharepiont.
" All queries combined using a UNION , INTERSECT or EXCEPT operator must have an equal number of expression in their target list"

Can you please advice to resolve it error ?

Who is Participating?
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.

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>All queries combined using a UNION , INTERSECT or EXCEPT operator must have an equal number of expression in their target list

Show us the SQL code behind this error message.  Guessing that there's one of these three keywords in the statement, and the component queries that they reference do not have the same number of columns.

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
Rainer JeschorCommented:
I have not yet seen this error in OOTB SharePoint boxes.
Do you have any custom / third-party solutions installed?

E.g. I found a knowledge base entry at Bamboo Solutions:

sharepoint0520Author Commented:
Hi ,

  We have bamboo PM central installed. Is there any way to fix it ??
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Rainer JeschorCommented:
yes - then it looks like my mentioned link fits into the error description.
The KB entry has also some steps how to identify and fix it.

sharepoint0520Author Commented:
Thanks i will take a look and will try to follow steps.
Vitor MontalvãoMSSQL Senior EngineerCommented:
sharepoint0520, do you still need help with this question?
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 SharePoint

From novice to tech pro — start learning today.

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.