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?

[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.

Jim HornMicrosoft SQL Server Data DudeCommented:
>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 ??
SolarWinds® Network Configuration Manager (NCM)

SolarWinds® Network Configuration Manager brings structure and peace of mind to configuration management. Bulk config deployment, automatic backups, change detection, vulnerability assessments, and config change templates reduce the time needed for repetitive tasks.

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.