Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Business Contact Manager - Strange SQL-Queries

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 28-02-2012
Member
 
Join Date: Feb 2012
Posts: 1
Business Contact Manager - Strange SQL-Queries

Hello

We are using Business Contact Manager 2007 on a SQL Server 2005 and have some performance problems with it.

I have noticed, that it executes thousands and thousands of the same or similar queries. One of them is the following. It performs queries like that about 10 times a second and sometimes from multiple users.

Can anybody tell me where this query comes from and what it does?

BeginReadTransaction; select top 100 percent Field12296, Field3591, Field4089, EntityTypeCode, ActivityType, ViewRowID, IsCAO From (Select Field12296, Field3591, Field4089, EntityTypeCode, ActivityType, ViewRowID, IsCAO from OpportunityIMAPIViewForActivity v where IsDeletedLocally = 0 AND ((((IsCAO = 0) AND (ViewRowID in (160911,38964,10822,142665,11007,160087,109983,93034,66111,22157))))) UNION ALL Select Field12296, Field3591, Field4089, EntityTypeCode, ActivityType, ViewRowID, IsCAO from ProjectIMAPIViewForActivity v where IsDeletedLocally = 0 AND ((((IsCAO = 0) AND (ViewRowID in (160911,38964,10822,142665,11007,160087,109983,93034,66111,22157))))) UNION ALL Select Field12296, Field3591, Field4089, EntityTypeCode, ActivityType, ViewRowID, IsCAO from ActivityIMAPIView v where IsDeletedLocally = 0 AND ((((IsCAO = 0) AND (ViewRowID in (160911,38964,10822,142665,11007,160087,109983,93034,66111,22157)))))) as bs

Reply With Quote
  #2  
Old 18-06-2012
Member
 
Join Date: Jul 2011
Posts: 631
Re: Business Contact Manager - Strange SQL-Queries

I cannot provide you detailed information on that, as it is not possible to find the issue just buy reading those random queries. What I can provide you is a troubleshooting link below which has number of common issues that you face mostly with Business Contact Manager. In that link below you can look for database operation troubleshooting. This has more number of sub topics which is based on various errors. So just have a look on the same.


http://office.microsoft.com/en-us/bu...010222781.aspx
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Business Contact Manager - Strange SQL-Queries"
Thread Thread Starter Forum Replies Last Post
I cannot repair or uninstall Business Contact Manager supremer Office Setup 3 11-01-2014 08:59 AM
unable to sync business contacts in Business contact manager with Windows Mobile 5 in MIcrosoft outlook 2010. Shinu Windows Software 3 05-12-2011 01:22 AM
error in downloading Business Contact Manager 2010 Rily Windows Software 3 27-10-2010 06:03 AM
How to disable Business Contact Manager in Outlook abbase Windows Software 3 08-10-2009 09:17 AM
cannot install business contact manager for outlook 2007 Leo Pold Office Setup 3 03-06-2007 07:48 AM


All times are GMT +5.5. The time now is 05:45 PM.