Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

strange strings such as "04000000..." are populated at Google calendar #1839

Open
mrdantzig opened this issue Apr 18, 2024 · 20 comments
Open
Labels
bug Something's not working right

Comments

@mrdantzig
Copy link

mrdantzig commented Apr 18, 2024

OGCS Version: v2.10.0.0
Edition: Installed / Portable
Sync Direction: O<->G

Bug Description
At Google Calendar, strange strings such as 040000008200E00074C5B7101A82E00800000000902F05A11585DA010000000000000000100000002A9C8797659215499157664B8762996B are populated. Please check attached screenshots. These strings are not entered at my Outlook calendar and I create schedules at Outlook and sync bidirectionally(O <=> G).

Screenshots

OGCS_20240418_104410284
OGCS_20240418_104410284_01
OGCS 2024-04-18 104227
OGCS 2024-04-18 104200
OGCS 2024-04-18 104130
OGCS 2024-04-18 104046

OGcalsync.log
OGcalsync.log.zip

Steps to Reproduce the Issue

  1. Go to...
  2. Click on...

Any other information
Any additional information that may help troubleshoot the issue.
📎 Attach your OGcalsync.log file.

@mrdantzig mrdantzig added the bug Something's not working right label Apr 18, 2024
@phw198
Copy link
Owner

phw198 commented Apr 27, 2024

The 2.10.0 beta was released almost a year ago, and I think you were using that version of OGCS without issue before this started to happen? Have you always synced the description attribute when syncing?

That string being added to your Google description looks like the Outlook Global ID value - it's not something that OGCS ever puts in the description, so I think some other change or software has done this. If you create a brand new Outlook item with an empty body/description, what does OGCS sync to Google - does it still contains that string?

@mrdantzig
Copy link
Author

mrdantzig commented Apr 27, 2024 via email

@phw198
Copy link
Owner

phw198 commented Apr 27, 2024

I've upgraded OGCS to the latest alpha version but the problem is not resolved.

I wouldn't expect it to be, as I don't believe this is directly due to OGCS - the same version 10.2.0 can't suddenly start exhibiting new behaviour if you haven't changed its configuration at all...

You'll need to do some testing to narrow down the behaviour and hopefully the cause, eg:

  • Uncheck sync of Description by OGCS in settings
  • Create a new Outlook appointment with no description
  • Sync O->G, confirm the description in Google is empty
  • Add a description in Outlook, resync, confirm Google description is still empty

  • Check sync of Description by OGCS in settings
  • Create a new Outlook appointment with no description
  • Sync O->G, confirm the description in Google is empty
  • Add a description in Outlook, resync, confirm Google description matches

  • Turn logging level up to ULTRA-FINE - this will log the values of the calendar attributes.
  • Edit one of the Outlook test items
  • Sync and check the logs to see what is has for
Comparing Description
Google  attribute: ??
Outlook attribute: ??

@mrdantzig
Copy link
Author

mrdantzig commented Apr 29, 2024 via email

@mrdantzig

This comment was marked as outdated.

@mrdantzig
Copy link
Author

mrdantzig commented Apr 29, 2024 via email

@phw198
Copy link
Owner

phw198 commented Apr 29, 2024

For me to troubleshoot this:

  1. Please refrain from replying my email - attachments are not possible
  2. Apply the hotfix on Cannot determine Outlook appointment body format #1844 to resolve the "The length of the string cannot be zero" error
  3. Repeat the tests and login to GitHub to upload log file etc.

From the limited evidence I can see from the emails, it looks like the description is only being updated with the string from Google into Outlook. This isn't what you originally reported and not any of the tests I asked you to carried out.

If you can't reproduce the problem with the tests I asked, the problem does not originate from OGCS.

Another test would be:

  1. For an item that has the correct Outlook description, but incorrect Google description
  2. Open the Outlook item and edit it somehow (eg add a space to the Location field); Save and Close
  3. Sync to Google; confirm Google was updated
  4. Confirm the Google description is now correct and matches Outlook.

When updating this ticket, please make it clear what test you have performed and the outcome.

@mrdantzig
Copy link
Author

mrdantzig commented Apr 30, 2024

Thanks Paul,

I'm attaching the screenshots and log files here again. I didn't know that those files attached at email is not uploaded to Github. Please find these files. Thanbks.

OGcalsync_latest.log v2.10.4.0

Screenshots

G after changing desc 2024-04-29 091559
G after changing desc 2024-04-29 091559

sync error message after bidirectional sync 2024-04-29 093117
sync error message after bidirectional sync 2024-04-29 093117

sync error message after bidirectional sync 2024-04-29 093021
sync error message after bidirectional sync 2024-04-29 093021

O after resync w desc 2024-04-29 091702
O after resync w desc 2024-04-29 091702

O after sync w desc 2024-04-29 091627
O after sync w desc 2024-04-29 091627

G after resync w description 2024-04-29 091530
G after resync w description 2024-04-29 091530

sync set w desc 2024-04-29 091354
sync set w desc 2024-04-29 091354

G after sync 2024-04-29 091149
G after sync 2024-04-29 091149

O w Desc 2024-04-29 091054
O w Desc 2024-04-29 091054

G after sync 2024-04-29 090950
G after sync 2024-04-29 090950

O w no desc 2024-04-29 090837
O w no desc 2024-04-29 090837

app behavior 2024-04-29 090738
app behavior 2024-04-29 090738

sync setting 2024-04-29 090708
sync setting 2024-04-29 090708

g w 0400 not chaged 2024-04-29 090320
g w 0400 not chaged 2024-04-29 090320

@mrdantzig
Copy link
Author

For me to troubleshoot this:

  1. Please refrain from replying my email - attachments are not possible
  2. Apply the hotfix on Cannot determine Outlook appointment body format #1844 to resolve the "The length of the string cannot be zero" error
  3. Repeat the tests and login to GitHub to upload log file etc.

From the limited evidence I can see from the emails, it looks like the description is only being updated with the string from Google into Outlook. This isn't what you originally reported and not any of the tests I asked you to carried out.

If you can't reproduce the problem with the tests I asked, the problem does not originate from OGCS.

Another test would be:

  1. For an item that has the correct Outlook description, but incorrect Google description
  2. Open the Outlook item and edit it somehow (eg add a space to the Location field); Save and Close
  3. Sync to Google; confirm Google was updated
  4. Confirm the Google description is now correct and matches Outlook.

When updating this ticket, please make it clear what test you have performed and the outcome.

Thanks,

I've applied the hotfix 1844. I expect it will work.
Let me try 'Another test' and get back to you.

Thanks

@mrdantzig
Copy link
Author

mrdantzig commented Apr 30, 2024

For me to troubleshoot this:

  1. Please refrain from replying my email - attachments are not possible
  2. Apply the hotfix on Cannot determine Outlook appointment body format #1844 to resolve the "The length of the string cannot be zero" error
  3. Repeat the tests and login to GitHub to upload log file etc.

From the limited evidence I can see from the emails, it looks like the description is only being updated with the string from Google into Outlook. This isn't what you originally reported and not any of the tests I asked you to carried out.

If you can't reproduce the problem with the tests I asked, the problem does not originate from OGCS.

Another test would be:

  1. For an item that has the correct Outlook description, but incorrect Google description
  2. Open the Outlook item and edit it somehow (eg add a space to the Location field); Save and Close
  3. Sync to Google; confirm Google was updated
  4. Confirm the Google description is now correct and matches Outlook.

When updating this ticket, please make it clear what test you have performed and the outcome.

Please find the attached screenshots and log file after 'Another test':

Screenshots

incorrect at G after sync 2024-04-30 130755
incorrect at G after sync 2024-04-30 130755

sync setting 2024-04-30 130244
sync setting 2024-04-30 130244

editted at O 2024-04-30 130126
editted at O 2024-04-30 130126

correct at O 2024-04-30 130005
correct at O 2024-04-30 130005

incorrect at G 2024-04-30 125932
incorrect at G 2024-04-30 125932

OGcalsync.log

@mrdantzig
Copy link
Author

mrdantzig commented Apr 30, 2024

Paul,

I'm not sure if my issue is related to these Googling results with the keyword "040000008200E":

Kopano Community Forum
https://forum.kopano.io › topic
It usually starts with 040000008200E… It shouldn't be an issue but Outlook is quite picky about the data it receives, so if after solving the above issue it ...

Get eventMessage - Microsoft Graph v1.0

Learn Microsoft
https://learn.microsoft.com › en-us › graph › api › event...
2024. 3. 14. — ... ", "iCalUId":"040000008200E00074C5B7101A82E00800000000A2A6F3535D7FD3010000000000000000100000003D770E2E8974F44B9471BDB348097FE3 ...

Update event - Microsoft Graph v1.0

Learn Microsoft
https://learn.microsoft.com › en-us › graph › api › group...
2023. 11. 17. — ... ", "iCalUId": "040000008200E00074C5B7101A82E00800000000B7CA7D517BECD40100000000000000001000000011E38F935AD4FF41BDAB12A2F3E15103 ...

Delphi DLL MS Graph Calendar List Events

Chilkat Example Code
https://www.example-code.com › delphiDll › ms_graph_...
(Delphi DLL) MS Graph Calendar List Events. Retrieve a list of events in a calendar. The list contains single instance meetings and series masters.

VBScript MS Graph Calendar List Events

Chilkat Example Code
https://www.example-code.com › vbscript › ms_graph_c...
2019. 4. 26. — ... 040000008200E ... A230FEBFE5F7486A", ' "reminderMinutesBeforeStart": 15, ' "isReminderOn": true, ' "hasAttachments": false, ' "subject ...

The seem to contain the sentences with "iCalUId": "040000008..." and related to outlook calendar as you can see at the attached screenshots.

Thanks,
Stephen
040000008200E 2024-04-30 152417
040000008200E 2024-04-30 152309
040000008200E 2024-04-30 152214

@phw198
Copy link
Owner

phw198 commented May 2, 2024

Your logfile doesn't seem to capture the entire sync - maybe it was spread across multiple files?

You only seem to have run the last test in my previous comment, where you've turned on ULTRA-FINE logging and edited the item.

This has shown however that some items are having their Body reported correctly from Outlook and others are apparently not. You'll need to work out how to reproduce the problem on-demand - ie what are the steps to create an Outlook appointment which syncs incorrectly to Google. That what my earlier test steps where prompting you to do.

  • Are you able to reproduce this issue on a different machine?
  • Please could you uncheck "Word Obfuscation" - you don't seem to have any rules defined anyway, so there's no value in checking it and would be helpful to rule this out.
  • Why do your Google screenshots show the time in the location field? eg 9:30~ 10:30 - I don't know where this is coming from either.
    incorrect at G 2024-04-30 125932

@mrdantzig
Copy link
Author

mrdantzig commented May 2, 2024

google calendar 2024-05-03 082505
Hi Paul

I'm attaching most of the recent log files.
Here are my answers to your 3 comments:

Are you able to reproduce this issue on a different machine? => I only use OGCS at one PC at my office.
Please could you uncheck "Word Obfuscation" - you don't seem to have any rules defined anyway, so there's no value in checking it and would be helpful to rule this out. => Unchecked it. Let me check if there are any changes when I sync again.
Why do your Google screenshots show the time in the location field? eg 9:30~ 10:30 - I don't know where this is coming from either. => There's nothing at the location field of the above screenshot. It's at time field. Please find the attached screenshot.

Thanks

@mrdantzig
Copy link
Author

OGcalsync_0503.zip
zipped log files

@mrdantzig
Copy link
Author

outlook_appointments.csv
google_events.csv
In case these file give you any clue.

@mrdantzig
Copy link
Author

mrdantzig commented May 3, 2024

google calendar 2024-05-03 082505 Hi Paul

I'm attaching most of the recent log files. Here are my answers to your 3 comments:

Are you able to reproduce this issue on a different machine? => I only use OGCS at one PC at my office. Please could you uncheck "Word Obfuscation" - you don't seem to have any rules defined anyway, so there's no value in checking it and would be helpful to rule this out. => Unchecked it. Let me check if there are any changes when I sync again. Why do your Google screenshots show the time in the location field? eg 9:30~ 10:30 - I don't know where this is coming from either. => There's nothing at the location field of the above screenshot. It's at time field. Please find the attached screenshot.

Thanks

Screenshots

G Desc null 2024-05-03 120454
G Desc null 2024-05-03 120454

G Desc 04000 2024-05-03 120140
G Desc 04000 2024-05-03 120140

G Desc 04000 2024-05-03 120140
G Desc 04000 2024-05-03 120140

O2G word obf off 2024-05-03 115637
O2G word obf off 2024-05-03 115637

O Desc changed 2024-05-03 115543
O Desc changed 2024-05-03 115543

O Desc changed 2024-05-03 115410
O Desc changed 2024-05-03 115410

I've tested with 2 schedules, 1 recurring and 1 non-recurring, again by simply adding "(???)" to Outlook descriptions.
The description at Recurring schedule was removed at Google while the description of non-recurring changed to "04000..." string.
I've set 'word obf..' off and sync direction was set to 'O => G".
Please check the attached log file and screenshots.

Thanks
Stephen

@phw198
Copy link
Owner

phw198 commented May 4, 2024

Why do your Google screenshots show the time in the location field? eg 9:30~ 10:30 - I don't know where this is coming from either. => There's nothing at the location field of the above screenshot. It's at time field. Please find the attached screenshot.

Thanks - sorry, rather confusing in a language I have zero ability to read I'm afraid 🙂

outlook_appointments.csv
google_events.csv
In case these file give you any clue.

This is actually super useful - the outlook_appointments file shows that none of the descriptions have any of these strings in them, only the GlobalID field for which I would expect. And the GlobalID for Cha 이주호 does indeed match the description you are seeing in Google. However, Cha 이주호 actually has no description at all in Outlook, but this doesn't match with your screenshot?? Also your zipped log files don't cover the tests you carried out - last log is at 09:59 on 2-May, but your tests were done at midday? Can you provide those logs?

@mrdantzig
Copy link
Author

OGcalsync.log.2024-05-30.zip
Hi Paul

Attached please find the log files since Apr. 29. Hope these contain what you are expecting.

Thanks
Stephen

@mrdantzig
Copy link
Author

Hi Paul,

Uploading 2 new screenshots and log files created today. As you can see the highlighted status at the screenshots, Outlook descriptions are changed to the strings "04000000..." when synchronizing Outlook calendar to Google calendar.

OGcalsync.log 2024-05-07.zip
sync 2024-05-07 192334
Sync 2024-05-07 150332

All the bests,
Stephen

@phw198
Copy link
Owner

phw198 commented May 16, 2024

This is the log for the first highlighted changes - it shows the same description as per your screenshot. But you didn't provide the outlook_appointments.csv so I don't know what that was reporting for the Description field. Please provide all of the evidence from the same point in time when you see this issue happen.

2024-05-07 19:22:52,479 DEBUG  13 OutlookGoogleCalendarSync.GoogleOgcs.Calendar [797] -  Processing >> 2024-05-08 오후 12:00 => "고영신 부소장"
2024-05-07 19:22:52,480 FINE  13 OutlookGoogleCalendarSync.Sync.Engine [261] -  Comparing Start time
2024-05-07 19:22:52,480 ULTRA-FINE  13 OutlookGoogleCalendarSync.Sync.Engine [262] -  Google  attribute: 2024-05-08 오후 12:00:00
2024-05-07 19:22:52,481 ULTRA-FINE  13 OutlookGoogleCalendarSync.Sync.Engine [263] -  Outlook attribute: 2024-05-08 오후 12:00:00
2024-05-07 19:22:52,481 FINE  13 OutlookGoogleCalendarSync.Sync.Engine [261] -  Comparing End time
2024-05-07 19:22:52,481 ULTRA-FINE  13 OutlookGoogleCalendarSync.Sync.Engine [262] -  Google  attribute: 2024-05-08 오후 1:00:00
2024-05-07 19:22:52,482 ULTRA-FINE  13 OutlookGoogleCalendarSync.Sync.Engine [263] -  Outlook attribute: 2024-05-08 오후 1:00:00
2024-05-07 19:22:52,492 FINE  13 OutlookGoogleCalendarSync.OutlookOgcs.OutlookNew [831] -  Timezone "(UTC+09:00) 서울" mapped to "Asia/Seoul"
2024-05-07 19:22:52,504 FINE  13 OutlookGoogleCalendarSync.OutlookOgcs.OutlookNew [831] -  Timezone "(UTC+09:00) 서울" mapped to "Asia/Seoul"
2024-05-07 19:22:52,505 FINE  13 OutlookGoogleCalendarSync.Sync.Engine [229] -  Comparing Start Timezone
2024-05-07 19:22:52,505 ULTRA-FINE  13 OutlookGoogleCalendarSync.Sync.Engine [230] -  Google  attribute: Asia/Seoul
2024-05-07 19:22:52,505 ULTRA-FINE  13 OutlookGoogleCalendarSync.Sync.Engine [230] -  Outlook attribute: Asia/Seoul
2024-05-07 19:22:52,506 FINE  13 OutlookGoogleCalendarSync.Sync.Engine [229] -  Comparing End Timezone
2024-05-07 19:22:52,506 ULTRA-FINE  13 OutlookGoogleCalendarSync.Sync.Engine [230] -  Google  attribute: Asia/Seoul
2024-05-07 19:22:52,506 ULTRA-FINE  13 OutlookGoogleCalendarSync.Sync.Engine [230] -  Outlook attribute: Asia/Seoul
2024-05-07 19:22:52,507 FINE  13 OutlookGoogleCalendarSync.Sync.Engine [229] -  Comparing Subject
2024-05-07 19:22:52,508 ULTRA-FINE  13 OutlookGoogleCalendarSync.Sync.Engine [230] -  Google  attribute: 고영신
2024-05-07 19:22:52,508 ULTRA-FINE  13 OutlookGoogleCalendarSync.Sync.Engine [230] -  Outlook attribute: 고영신 부소장
2024-05-07 19:22:52,508 FINE  13 OutlookGoogleCalendarSync.Sync.Engine [239] -  Attributes differ.
2024-05-07 19:22:52,509 FINE  13 OutlookGoogleCalendarSync.Sync.Engine [229] -  Comparing Description
2024-05-07 19:22:52,509 ULTRA-FINE  13 OutlookGoogleCalendarSync.Sync.Engine [230] -  Google  attribute: 
2024-05-07 19:22:52,510 ULTRA-FINE  13 OutlookGoogleCalendarSync.Sync.Engine [230] -  Outlook attribute: 040000008200E00074C5B7101A82E00800000000E0A0307DB3A0DA0100000000000000001000000040C4159F998F9C4DAA83D9AC574A0AFF
2024-05-07 19:22:52,510 FINE  13 OutlookGoogleCalendarSync.Sync.Engine [239] -  Attributes differ.
2024-05-07 19:22:52,510 FINE  13 OutlookGoogleCalendarSync.Sync.Engine [229] -  Comparing Location
2024-05-07 19:22:52,511 ULTRA-FINE  13 OutlookGoogleCalendarSync.Sync.Engine [230] -  Google  attribute: 
2024-05-07 19:22:52,511 ULTRA-FINE  13 OutlookGoogleCalendarSync.Sync.Engine [230] -  Outlook attribute: 
2024-05-07 19:22:52,512 FINE  13 OutlookGoogleCalendarSync.Sync.Engine [229] -  Comparing Privacy
2024-05-07 19:22:52,512 ULTRA-FINE  13 OutlookGoogleCalendarSync.Sync.Engine [230] -  Google  attribute: default
2024-05-07 19:22:52,513 ULTRA-FINE  13 OutlookGoogleCalendarSync.Sync.Engine [230] -  Outlook attribute: default
2024-05-07 19:22:52,513 FINE  13 OutlookGoogleCalendarSync.Sync.Engine [229] -  Comparing Free/Busy
2024-05-07 19:22:52,514 ULTRA-FINE  13 OutlookGoogleCalendarSync.Sync.Engine [230] -  Google  attribute: opaque
2024-05-07 19:22:52,514 ULTRA-FINE  13 OutlookGoogleCalendarSync.Sync.Engine [230] -  Outlook attribute: opaque
2024-05-07 19:22:52,515 FINE  13 OutlookGoogleCalendarSync.Sync.Engine [229] -  Comparing Reminder Default
2024-05-07 19:22:52,515 ULTRA-FINE  13 OutlookGoogleCalendarSync.Sync.Engine [230] -  Google  attribute: True
2024-05-07 19:22:52,515 ULTRA-FINE  13 OutlookGoogleCalendarSync.Sync.Engine [230] -  Outlook attribute: False
2024-05-07 19:22:52,516 FINE  13 OutlookGoogleCalendarSync.Sync.Engine [239] -  Attributes differ.
2024-05-07 19:22:52,609 DEBUG  13 OutlookGoogleCalendarSync.Console [348] -  Subject: 고영신 => 고영신 부소장
2024-05-07 19:22:52,610 ULTRA-FINE  1 OutlookGoogleCalendarSync.Console [193] -  Console navigating.
2024-05-07 19:22:52,611 DEBUG  13 OutlookGoogleCalendarSync.Console [348] -  Description:  => 040000008200E00074C5B7101A82E00800000000E0A0307...
2024-05-07 19:22:52,612 DEBUG  13 OutlookGoogleCalendarSync.Console [348] -  Reminder Default: True => False
2024-05-07 19:22:52,613 DEBUG  13 OutlookGoogleCalendarSync.Console [348] -  3 attributes updated.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something's not working right
Projects
None yet
Development

No branches or pull requests

2 participants