Results 1 to 2 of 2

Thread: Business Contact Manager - Strange SQL-Queries

  1. #1
    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

  2. #2
    Join Date
    Jul 2011
    Posts
    642

    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

Similar Threads

  1. I cannot repair or uninstall Business Contact Manager
    By supremer in forum Office Setup
    Replies: 3
    Last Post: 11-01-2014, 08:59 AM
  2. Replies: 3
    Last Post: 05-12-2011, 01:22 AM
  3. error in downloading Business Contact Manager 2010
    By Rily in forum Windows Software
    Replies: 3
    Last Post: 27-10-2010, 06:03 AM
  4. How to disable Business Contact Manager in Outlook
    By abbase in forum Windows Software
    Replies: 3
    Last Post: 08-10-2009, 09:17 AM
  5. Replies: 3
    Last Post: 03-06-2007, 07:48 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •