can be reproduced on demo.sogo.nu, too.

An appointment without start and end date.
How did you create that?

create new event:
title: test
and then delete all values from "from" and "to"

-> save

the error still can be reproduced when importing the .ics file.

AFAIK there are still several ways to add/create such an invalid entry:

• import .ics
• invitation
• via an external caldav client like thunderbird

the bad thing IMHO is, that such an entry can't be edited or changed or deleted in SOGo.

same problem here. any way to fix this ?

11:48:53.507 sogod[5671:5671] EXCEPTION: <NSException: 0x55fce4cdddb0> NAME:NSInvalidArgumentException REASON:Tried to add nil value for key 'localizedStartTime' to dictionary INFO:{calendar = "Personal Calendar"; id = "34f9ff5b-51a7-4af0-abb1-fe5afa1e50f9.ics"; isAllDay = 0; isReadOnly = 0; pid = personal; userHasRSVP = 0; }

I'm on sogo 4.1.1 and this event cannot be edit or deleted.
Also because is my Personal Calendar I cannot even delete the calendar all togheter.

the bad thing IMHO is, that such an entry can't be edited or changed or deleted in SOGo.

strongly agree!

I don't know if the problem is related, but I get the same error -- and I've just updated SOGo to version 4.2.0 (@shiva2.inverse 202001100157).

I have imported an .ics file to preexisting calendar and noticed, that:

• import raised no errors, notification of many (7000+) events imported appeared
• many events in calendar are shown as "(public event)"
• on click, UI shows "(!) Request failed" and event does not open
• sogo logs "2020-01-10 18:37:50.380 sogod[32342] EXCEPTION: <NSException: 0x7fd7e8bd2fa0> NAME:NSInvalidArgumentException REASON:Tried to add nil value for key 'localizedStartTime' to dictionary INFO:{calendar = astro; id = "B3BA5703-33AC-4676-B151-DEF4922B1F10.ics"; isAllDay = 0; isReadOnly = 0; pid = "4F64-5C7AFF80-513-37F72240"; userHasRSVP = 0; }"

I have updated sogo to current nightly (by apt, so with all dependencies), after update I have removed the calendar, added new one and imported .ics file again, with the same result.

The .ics is attached; can be also downloaded from https://cantonbecker.com/astronomy-calendar/astrocal.ics (page https://cantonbecker.com/astronomy-calendar/). I have used the calendar in previous years (and previous SOGo versions, since from 2.x times) and this is first time I get the problem. Maybe for 2020 it was generated in slightly different way? Sadly, I have no .ics files from past years.

One of our customers suffers from the same problem as "briest" now. SOGo is 4.3.0.
The customer mostly uses ActiveSync and frequently creates events with more than 10 local attendees. Once in a while Outlook starts to crash when syncing. In the SOGo UI the calender then contains the events with title "(public event)" which report "Request failed" when clicking and with the Exception "briest" describes in the previous posting.

So we have the same event which is distributed to other local SOGo users. For most attendees the event appears in their personal calendars and looks absolutely sane. They can sync it with Outlook and they can access it via SOGo UI. But one or two users have the "(public event)" entry displayed in their calendars. Looking into the database, they don't have that event in their personal calendars at all - neither in sogo_store nor in sogo_quick_appointment! I also restarted memcached - the "(public event)" still appears. Where else does SOGo store these entries? Any idea how to track that down on a life system without bothering the users too much?

I have the same problem with SOGo 5.1.0. I created an event via the Thunderbird "Convert E-Mail to Event" function and now, I have an appointment without a start time leading to errors in DAVx5 (see attachment) and an event in the sogo web UI that is not accessible.
Sogo.log entroies:

05/11/2021, 2:34:59 PM notice [75]: 172.22.1.1 "GET /SOGo/so/fc[...]/Calendar/personal/fd4b975b-12f1-4efc-aa1a-d12b77d4537b.ics/view HTTP/1.0" 501 0/0 0.007 - - 0 - 13
05/11/2021, 2:34:59 PM notice 14:34:59.380 sogod[75:75] EXCEPTION: <NSException: 0x563a211389c0> NAME:NSInvalidArgumentException REASON:Tried to add nil value for key 'localizedStartTime' to dictionary INFO:{calendar = "Personal Calendar"; id = "fd4b975b-12f1-4efc-aa1a-d12b77d4537b.ics"; isAllDay = 0; isReadOnly = 0; pid = personal; userHasRSVP = 0; }

--- BEGIN DEBUG INFO ---

SYNCHRONIZATION INFO
Account: Account {name=fc@ntr.li, type=bitfire.at.davdroid}
Authority: com.android.calendar

EXCEPTION
at.bitfire.dav4jvm.exception.DavException: Received multi-get response without address data
	at at.bitfire.davdroid.syncadapter.CalendarSyncManager$downloadRemote$1$1$1.invoke(CalendarSyncManager.kt:9)
	at at.bitfire.davdroid.syncadapter.CalendarSyncManager$downloadRemote$1$1$1.invoke(CalendarSyncManager.kt:1)
	at at.bitfire.davdroid.syncadapter.SyncManager.responseExceptionContext(SyncManager.kt:1)
	at at.bitfire.davdroid.syncadapter.CalendarSyncManager$downloadRemote$1$1.invoke(CalendarSyncManager.kt:2)
	at at.bitfire.davdroid.syncadapter.CalendarSyncManager$downloadRemote$1$1.invoke(CalendarSyncManager.kt:1)
	at at.bitfire.dav4jvm.Response$Companion.parse(Response.kt:46)
	at at.bitfire.dav4jvm.DavResource$processMultiStatus$2.invoke(DavResource.kt:9)
	at at.bitfire.dav4jvm.DavResource.processMultiStatus(DavResource.kt:14)
	at at.bitfire.dav4jvm.DavResource.processMultiStatus(DavResource.kt:5)
	at at.bitfire.dav4jvm.DavCalendar.multiget(DavCalendar.kt:10)
	at at.bitfire.davdroid.syncadapter.CalendarSyncManager$downloadRemote$1.invoke(CalendarSyncManager.kt:2)
	at at.bitfire.davdroid.syncadapter.CalendarSyncManager$downloadRemote$1.invoke(CalendarSyncManager.kt:1)
	at at.bitfire.davdroid.syncadapter.SyncManager.remoteExceptionContext(SyncManager.kt:1)
	at at.bitfire.davdroid.syncadapter.SyncManager.remoteExceptionContext(SyncManager.kt:8)
	at at.bitfire.davdroid.syncadapter.CalendarSyncManager.downloadRemote(CalendarSyncManager.kt:2)
	at at.bitfire.davdroid.syncadapter.SyncManager$syncRemote$1$1$1.invokeSuspend(SyncManager.kt:2)
	at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:3)
	at kotlinx.coroutines.DispatchedTask.run(DispatchedTask.kt:15)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641)
	at java.lang.Thread.run(Thread.java:919)

REMOTE RESOURCE
https://[...]]/Calendar/personal/60720cd1-566f-412b-bea0-e5bfaa27ce6d.ics

I could delete the causing event by using a webdav-client (cadaver) on the calendar url, displayed at "Links to this Calendar".

Please provide a vCalendar/vEvent that raises the exception.

Hello Francis and thanks for looking into this.
Do you have an idea how I can download the failing vCalendar item from SOGo (database table, ...) ? Via webdav, I can only delete the .ics file. The downloaded file is empty.
Or would it be better to hook the thunderbird connection and intercept the creation of the failing vCard?

You can perform a cat in cadaver.

A cat in cadaveron the failing .ics returns an empty response . Other .ics generate correct outputs.

Unfortunately I didn't keep one of the broken events we discovered, but here is the SQL statement that worked for me to find them:

select c_folder_id,c_content from sogo_store where c_content like '%BEGIN:VEVENT%' and c_content not like '%DTSTART%';

In our case the events had multiple attendees and only one or two of them were broken. Grab the UID value from one of the events returned above to see if there's also a clean version of the same event in your database:
select c_folder_id,c_content from sogo_store where c_name like '%FILL_IN_UID_VALUE%';