Notes Error: Database already contains a document with this ID

Hi,

When I receive a meeting invitation from an Outlook user, I get the message above. If I open the invitation I cannot accept it, I can do nothing with it.

I noticed that there is a $Ref field in the meeting invitation.

If I delete this field from the meeting invitation, I can open the meeting and accept it.

What is the process that creates a $Ref field ?

Invitations I received from other people don’t have the $Ref field.

Thanks in advance for your help.

Jean-Marc

Subject: Ical Source?

Is there a $ICAL_ORIG_STREAM item on the invite? If so, can you post the content here?

Also, is the meeting recurring?

I would guess that this is a problem stemming from a known interoperability issue around a specific flavor of recurring meeting updates but looking at the data should hopefully be able to confirm that…

Thanks

Nate

Subject: Here is a Meeting invitation I receive

Here is the $ICAL_ORIG_STREAM from the meeting I receive (I am John Doe ;-)) from Bill SmithIt is a brand new meeting invitation.

Not a repeating entry.

Nom du champ : $ICAL_ORIG_STREAM

Type de données : Texte

Longueur des données : 2206 octets

Numéro d’ordre : 1

ID d’élément en double : 0

Indicateurs de champ :

"BEGIN:VCALENDAR

METHOD:REQUEST

PRODID:Microsoft Exchange Server 2007

VERSION:2.0

BEGIN:VTIMEZONE

TZID:Romance Standard Time

BEGIN:STANDARD

DTSTART:16010101T030000

TZOFFSETFROM:+0200

TZOFFSETTO:+0100

RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=-1SU;BYMONTH=10

END:STANDARD

BEGIN:DAYLIGHT

DTSTART:16010101T020000

TZOFFSETFROM:+0100

TZOFFSETTO:+0200

RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=-1SU;BYMONTH=3

END:DAYLIGHT

END:VTIMEZONE

BEGIN:VEVENT

ORGANIZER;CN=SMITH BILL:MAILTO:bill.smith@cig.com

ATTENDEE;ROLE=REQ-PARTICIPANT;PARTSTAT=NEEDS-ACTION;RSVP=TRUE;CN=“‘DOE, John’”:MAILTO:john.doe@acme.org

DESCRIPTION;LANGUAGE=fr-FR:Quand : samedi 9 octobre 2010 10:00-10:30 (GMT+0

1:00) Bruxelles, Copenhague, Madrid, Paris.\nEmplacement : bureau\n\n*~

~~~~~~~~*\n\ntest 3\n\n\n\n ________________________________\nLe

pr├®sent message et ses pi├¿ces jointes sont ├®tablis ├á l’attention des d

estinataires indiqu├®s. Si vous recevez ce message par erreur, veuillez i

mm├®diatement en avertir l’exp├®diteur par retour de mail puis d├®truire l

e message. Toute autre utilisation de ce message est strictement interdite

.\n\nThis e-mail and its attachments are intented solely for the named add

ressees. If you received this e-mail in error, please immediately notify

the sender by reply e-mail and then delete the e-mail. Any other use of th

e e-mail by you is prohibited.\n

SUMMARY;LANGUAGE=fr-FR:test 3

DTSTART;TZID=Romance Standard Time:20101009T100000

DTEND;TZID=Romance Standard Time:20101009T103000

UID:040000008200E00074C5B7101A82E0080000000020B685902B66CB01000000000000000

0100000007E1FFE65E52BB14F836185EF5B38A630

CLASS:PUBLIC

PRIORITY:5

DTSTAMP:20101007T122600Z

TRANSP:OPAQUE

STATUS:CONFIRMED

SEQUENCE:0

LOCATION;LANGUAGE=fr-FR:bureau

X-MICROSOFT-CDO-APPT-SEQUENCE:0

X-MICROSOFT-CDO-OWNERAPPTID:944220122

X-MICROSOFT-CDO-BUSYSTATUS:TENTATIVE

X-MICROSOFT-CDO-INTENDEDSTATUS:BUSY

X-MICROSOFT-CDO-ALLDAYEVENT:FALSE

X-MICROSOFT-CDO-IMPORTANCE:1

X-MICROSOFT-CDO-INSTTYPE:0

BEGIN:VALARM

ACTION:DISPLAY

DESCRIPTION:REMINDER

TRIGGER;RELATED=START:-PT15M

END:VALARM

END:VEVENT

END:VCALENDAR

"

Subject: Mail rules?

Also, do you have any mail rules that could be messing with these?Thanks

Nate

Subject: No rules

Hi Nate,

We are not using rules.

Regards,

Jean-Marc

Subject: Automatically accept meetings

We have noticed a strange behaviour of the notes client : if my mail file is set up to automatically accept invitations, the problem does not occur.

But if the meeting is sent to me, and so I receive it in my inbox, the problem occurs.

I think there is something that happens when the invitation arrives in the inbox. Maybe the creation of a $Ref field…

Subject: Some more questions

I can reproduce the problem with the data you sent. As you suspect, it is due to the $Ref item and the question is WHY is that item on the note at all.

According to the item I can see that an 8.5.1 server processed the item - I am not personally aware of any related problems on 8.5.1. “iCal Created Invitation[Local] by Router on SILML002(Release 8.5.1|September 28, 2009) at 10/07/2010 14:26:07”

There are not any tracked changes that happened after the iCalendar was converted to an invitation on your 8.5.1 router. It is not yet accepted.

Can we do some additional troubleshooting?

  1. Send one of these test invites to my gmail user: nrbarry0704@gmail.com. Gmail preserves the raw MIME so I can see if there is anything there that might be causing this, and potentially reproduce the $Ref item being created.

  2. To rule out your client, can you see if the $Ref is added before your client opens the message? Turn off your preview pane and check the doc properties in the inbox before opening the meeting. Is the $Ref there at that point? If not, please send me that message prior to opening. If so, then it is some problem that is happening on your server.

Other questions to ask:

-Do you have any non-standard processes going on your server that might impact the delivery of this message (maybe a third party spam checker?)

-Do you by any chance have access to the server log files at the time of delivery?

Thanks

Nate

Subject: Some more information

Hi Nate,

The end user just sent you an invitation at your gmail address.

From my side, I can see the $Ref before I open the invitation.

I also did the test to stop the router at my server and asked the end user to send me an invitation. I opened the mail.box at the server, and in the document properties for his email, I could see a $Ref field

We have a Symantec antivirus, but I stopped it for our tests and it doesn’t change anything.

In the log, I can only see this :

10/20/2010 10:36:03 Router: Message 002F3E77, 815B8651 delivered to John Doe/ACME from Bill Smith@cig.fr Size: 9K Time: 00:00:00 Hop Count: 2

Thanks in advance for your help,

Jean-Marc

Subject: Mystery $Ref

Jean-Marc,If I take the exact same MIME stream and send it to my domino users, I am not seeing any $Ref. Further, I am not seeing any $Ref item if I stop it at my server’s mail.box.

So, it appears that something is putting the $Ref on the item before it arrives at the mail.box. This is done prior to the iCalendar->Notes processing and as such should be independent of any Domino version.

I would probably start by taking a look at the server console code around the delivery line. See if you see any sort of program that is running on Domino and might be modifying the message. I have seen third party add-ons like MAILMGR etc cause this, and usually they leave some sort of trace in the Domino logs.

Specifically, I would look into what happens when this arrives at:

CN=SILGW001/OU=SRV/OU=SILCA/O=GCA

This server revises the note, but SILGW002 actually does the delivery and conversion - could this be where $ref is added?

Thanks

Nate

Subject: Mail path

What happens when the message arrives at:CN=SILGW001/OU=SRV/OU=SILCA/O=GCA

It already gets the $Ref field.

Upper is the mail hub but there is no reason why the mail hub would add a $Ref field which is typically a Notes field.

The field is added before it gets to SILML002.

The mail path is exchange - internet - mail hub - SILGW001 (Domino SMTP server) - SILML002 (Domino mail server)

Subject: Response from our routing guys

I forwarded the question of how this $Ref might be added at this point and got this response:

The SMTP server, when importing the message, can add $Ref if the message has RFC822 headers indicating the message is a response (References or In-Reply-To).

Could that be the case here?

Thanks

Nate

Subject: In_Reply_To

Hi Nate,

I can see a In_Reply_To field in the meeting I receive.

It is not present in the “good” meetings.

But its value is “null”.

Nom du champ : In_Reply_To

Type de données : Texte

Longueur des données : 4 octets

Numéro d’ordre : 2

ID d’élément en double : 0

Indicateurs de champ : SUMMARY

“null”

Subject: References

And there is also a References field in the bad meetings which is not present in the good meetings I receive.

Nom du champ : References

Type de données : Texte

Longueur des données : 4 octets

Numéro d’ordre : 2

ID d’élément en double : 0

Indicateurs de champ : SUMMARY

“null”

Subject: Re: Exchange config

I don’t really know about the Exchange config - you could have to work with Microsoft there.

I am simultaneously looking into this on our side to see if there is something we can do to prevent this. No news yet.

Thanks

Nate

Subject: Simple emails

Hi Nate,

I noticed that the emails I receive from the user (Outlook+Exchange) contain the two fields In_Reply_To and References plus the $Ref field. So those fields are not used only for meetings.

Subject: Exchange configuration

Hi Nate,

Do you know if Exchange can be set up to not send the in_reply_to and references fields for standard emails (not response) and meetings ?

Jean-Marc

Subject: Solved

Rules from the Exchange server was set to put a null value in the fieds references et in-reply-to.

Subject: debug parameters

Hi Nate,

Do you know some debug parameters which could help us to solve the problem ?

Jean-Marc