Slowness Happens While Trying to Sync Group of Contacts with OutlookConnector in Combination with Contacts Server (Doc ID 2283148.1)

Last updated on JULY 10, 2017

Applies to:

Oracle Communications Contacts Server - Version 8.0.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Customer recently migrated from PAB to Contacts Server and are seeing some performance issues after the server is running for a bit which is affecting ALL users. Slowness occurs through Outlook Connector.

After making sure that patch from 8.0.0.2.0 to 8.0.0.3.0 was applied to eliminate the possibility of the following BUG:


Bug 22082847 - fetchcomps taking more than 30sec for groups


Slowness  still occurs and it was observed that this slowness happens while trying to sync group of contacts.

This is a first sync:

    <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<  REQUEST [2017-05-31T09:56:52.677+0200]
    GET /nabserver/rest/home/referencement@pompac-dev.fr/e1551551fd296d/?format=json&fetchprops=X-ORCL-ALLPROPS&httpError=0&synctoken= HTTP/1.1
    host: contact.whatever.messaging.net
    accept: */*
    authorization: *****
    user-agent: rest
    cache-control: no-cache
    x-forwarded-for: xxx.xxx.xxx.xxx
    x-forwarded-host: contact.whatever.messaging.net
    x-forwarded-server: contact.b2gwhatever.internal.tld
    connection: Keep-Alive
    content-length: 0

    -----------------------------------------------------------------
    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>  RESPONSE [2022 ms]
    0
    Content-Type: application/json;charset=utf-8

    {}&&{"entry":[{"uri":"/nabserver/rest/home/info@domain.com/e1551551fd296d/e1554d6f710b11d.vcf","type":"contact"...,"syncToken":"1496154641000","totalResults":"1458"}
    -----------------------------------------------------------------

The response comes back rather fast given that it contains almost  1500 contacts (2 seconds),

What follows is a series of GET request on each the entries returned in the previous request that happen to be groups (type=contactgroup).

For example:

    <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<  REQUEST [2017-05-31T09:57:02.540+0200]
    GET /nabserver/rest/home/referencement@pompac-dev.fr/e1551551fd296d/e1554d7090b01ae.vcf?fetchcomps=contact&fetchprops=X-ORCL-ALLPROPS HTTP/1.1
    host: contact.whatever.messaging.net
    accept: */*
    authorization: *****
    user-agent: rest
    cache-control: no-cache
    x-forwarded-for: xxx.xxx.xxx.xxx
    x-forwarded-host: contact.whatever.messaging.net
    x-forwarded-server: contact.b2gwhatever.internal.tld
    connection: Keep-Alive
    content-length: 0

    -----------------------------------------------------------------
    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>  RESPONSE [7291 ms]
    200
    ETag: "1496154129000.9"
    Content-Type: application/json;charset=utf-8

    {}&&{"entry":[{"uri":"/nabserver/rest/home/info@domain.com/e1551551fd296d/e1554d774e5c4f3.vcf","typ...,"totalResults":"7"}
    -----------------------------------------------------------------

This is true for every contact group.

Those responses are rather slow because the server has to make an extra SQL query for each member of the group. We have pretty much response time in seconds = number of members in the group.

Changes

Migrated from PAB to Contacts Server and using Outlook Connector 9.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms