Skip to Content
author's profile photo Former Member
Former Member

Outlook Integration - Case of the missing snapshots

Hey all,

Here's the issue:

SBO 2007A PL 35

The snapshots are being created on the server, and they showing on the SBO server (say
SBOHOST).

I created the snapshots for EN(GB), EN(US), and NL.

For reference, the actual database is on a dedicated SQL server (
SQL_SERVER)

All files are there, and permissions are set so that they can be written.

I went onto the terminal server (
TERMINAL) that connects through to the main server database (
SQLSERVER) and to the SAP files B1_SHR on
SBOHOST

The templates were missing in the "Define Snapshot Templates" under EN(GB), EN(US), and NL.

I checked the paths, and they are fine so there are no permission issues.

I then installed, from TERMINAL, the Czech snapshots. They work. I can see them under the "Define Snapshot Templates" on TERMINAL

...but not on SBOHOST where I can see the others...

They are sitting right beside each other in the
SBOHOST\B1_SHR\Addon\Microsoft Outlook Integration\Templates\[DATABASE]\Default

I can see CS (Czech), NL (Dutch), EN (Enlish) folders.

I had a look in the [@BOOSTP] and found if I changed the "host name", in a test database of course, from TERMINAL to SBOHOST they appeared on the respective computers snapshot list under the respective language. Hopefully I haven't lost you.

Any help with this would be good, as so far all the notes on this tell me to re-create the snapshots, which hasn't helped so far.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2008 at 10:35 PM

    Ok, I have figured out why it is happening. Seems to be an SAP unfortunately overlooked error.

    Comparing to the SAP 2005 version of Outlook Integration. I have found a new field on both tables @BOOADM and @BDOSTP called HOST which relate to the computer the snapshots are created on.

    This is a good idea, as now the snapshots can be created in a place other than the system default e.g. on your C: or even somewhere on the network.

    The problem is the combined unique key: (U_TplName, U_Language , U_CatID) and the fact that the Templates are looked up by current Host.

    When a new host is added to the Outlook Integration server and the host created in the @BOOADM table, the snapshots are copied to the correct directory, but the entries in the @BOOSTP are not created due to the combined UNIQUE KEY constraint (The new entry's Template Names, Language Code, Category Id are identical to the ones already in the table if using the same language) .

    I can think of two easy ways to fix this:

    1) Remove Unique Key restriction

    2) Include Host name in the combined key

    Anyway, I will put this to SAP

    Edited by: Daniel Blackwell on Jun 9, 2008 1:00 AM

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      SAP is going to apply a fix themselves, so I would think that you probably have to contact SAP as it may be handled on a case by case basis.

      If I do get any more information, I will let you know of course.

      I have referred SAP to this thread, so maybe they will contact you themselves.

      Daniel

  • author's profile photo Former Member
    Former Member
    Posted on Jul 20, 2008 at 09:34 PM

    SAP remoted to the system and fixed the indexes. U_HOST was changed to VARCHAR(200) and added to the culmulative index

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.