Task sync: PRIORITY without value

[m3adow]

I have the same or at least a very similar issue. I get the same error when syncinc tasks.

This is the respective debug log entry doesn’t help me a lot:

2018-04-24 13:14:00 4699 [HttpClient] BEGIN:VCALENDAR
VERSION:2.0
X-WR-CALNAME:Wieseclan
PRODID:-//The Horde Project//Horde iCalendar Library//EN
BEGIN:VTODO
UID:1d58e8e0-4fac-4632-8d43-ec79757490d2.1519164997000
SUMMARY:Alex Geschenkeliste
DESCRIPTION:[ ] Tip Toi Rund um die Uhr\n[ ] Ravensburger Wort für Wort\n[
  ] Hula Hoop Reifen\n[ ] Pfeil und Bogen mit Zielscheibe\n[ ] Tip Toi
  Spielwelt Autorennen
PRIORITY:
STATUS:NEEDS-ACTION
END:VTODO
END:VCALENDAR

2018-04-24 13:14:00 4699 [HttpClient] <-- END HTTP (441-byte body)
2018-04-24 13:14:00 4699 Error loading custom timezone aliases: Attempt to invoke virtual method 'int java.io.Reader.read(char[])' on a null object reference
2018-04-24 13:14:00 4699 Unfolding...
2018-04-24 13:14:00 4699 Unfolding...
2018-04-24 13:14:00 4699 [syncadapter.SyncManager] Unclassified sync error
EXCEPTION java.lang.NumberFormatException: For input string: ""
	at java.lang.Integer.parseInt(Integer.java:620)
	at java.lang.Integer.parseInt(Integer.java:643)
	at net.fortuna.ical4j.model.property.Priority.setValue(Priority.java:218)
	at net.fortuna.ical4j.data.CalendarBuilder$ContentHandlerImpl.propertyValue(CalendarBuilder.java:299)
	at net.fortuna.ical4j.data.CalendarParserImpl$PropertyParser.parse(CalendarParserImpl.java:282)
	at net.fortuna.ical4j.data.CalendarParserImpl$PropertyParser.access$1100(CalendarParserImpl.java:229)
	at net.fortuna.ical4j.data.CalendarParserImpl$PropertyListParser.parse(CalendarParserImpl.java:210)
	at net.fortuna.ical4j.data.CalendarParserImpl$ComponentParser.parse(CalendarParserImpl.java:422)
	at net.fortuna.ical4j.data.CalendarParserImpl$ComponentParser.access$900(CalendarParserImpl.java:406)
	at net.fortuna.ical4j.data.CalendarParserImpl$PropertyListParser.parse(CalendarParserImpl.java:208)
	at net.fortuna.ical4j.data.CalendarParserImpl.parseCalendar(CalendarParserImpl.java:115)
	at net.fortuna.ical4j.data.CalendarParserImpl.parseCalendarList(CalendarParserImpl.java:180)
	at net.fortuna.ical4j.data.CalendarParserImpl.parse(CalendarParserImpl.java:149)
	at net.fortuna.ical4j.data.CalendarBuilder.build(CalendarBuilder.java:198)
	at net.fortuna.ical4j.data.CalendarBuilder.build(CalendarBuilder.java:178)
	at at.bitfire.ical4android.Task$Companion.fromReader(Task.kt:66)
	at at.bitfire.davdroid.syncadapter.TasksSyncManager.processVTodo(TasksSyncManager.kt:149)
	at at.bitfire.davdroid.syncadapter.TasksSyncManager.access$processVTodo(TasksSyncManager.kt:41)
	at at.bitfire.davdroid.syncadapter.TasksSyncManager$processRemoteChanges$2.invoke(TasksSyncManager.kt:122)
	at at.bitfire.davdroid.syncadapter.TasksSyncManager$processRemoteChanges$2.invoke(TasksSyncManager.kt:41)
	at at.bitfire.davdroid.syncadapter.BaseDavSyncManager.useRemote(BaseDavSyncManager.kt:276)
	at at.bitfire.davdroid.syncadapter.TasksSyncManager.processRemoteChanges(TasksSyncManager.kt:114)
	at at.bitfire.davdroid.syncadapter.SyncManager.performSync(SyncManager.kt:127)
	at at.bitfire.davdroid.syncadapter.TasksSyncAdapterService$TasksSyncAdapter.sync(TasksSyncAdapterService.kt:63)
	at at.bitfire.davdroid.syncadapter.SyncAdapterService$SyncAdapter.onPerformSync(SyncAdapterService.kt:77)
	at android.content.AbstractThreadedSyncAdapter$SyncThread.run(AbstractThreadedSyncAdapter.java:272)

Custom Timezone aliases? What is this supposed to mean?

I encountered this on a plethora of tasks, so I assume there’s some error/mistake made during the creation (timezone set incorrectly?). To my knowledge the task has been created via OpenTasks.

[rfc2822]

Hello,

The custom timezone alias message is probably not an error message (merely informative). Please always provide the full logs/exception details.

PRIORITY:

This is an invalid property. PRIORITY must have an Integer value between 0 and 9.

Please fix your task files. Maybe it helps to edit the tasks with an up-to-date OwnCloud version and/or change the priority. See also https://forums.bitfire.at/topic/1107/tasks-synchronisation-error-with-owncloud-9-priority-must-be-an-integer-between-0-and-9

Does that help?

[m3adow]

You got me on the right direction, thanks a lot. For some reason my Horde installation did not properly report its priorities via DAV.

If people ever come to this post due to similar errors:

The table nag_tasks in the Horde DB uses the Default 0 for task_priority. If I interpreted the issue correctly, Horde only supports five priorities, 1-5. But as the CalDAV standard(?) expects 0-9, this is evaluated when reported via ics (e.g. priority 2 in the DB and the web interface is reported to DavDroid as a 3 while 3 is reported as 5). Not only are not all values used or usable, the Default of 0 is not evaluated at all (similar to values above 5, it seems) which results in an empty string. To resolve this, I manually changed all the tasks in the DB with task_priority 0 or >5 to 2 and also changed the Default value of the table to 3 (which evaluates to 5).
These are the commands I used, continue with caution:

ALTER TABLE nag_tasks CHANGE `task_priority` `task_priority` int(11) NOT NULL DEFAULT '3';
UPDATE nag_tasks SET task_priority = 3 WHERE task_priority = 0 OR task_priority > 5;

While my Horde installation is up to date, I initially installed it four or five years ago, so perhaps the “new install db scheme” has been changed in the meantime.

[m3adow]

I couldn’t find a way to edit my previous post, so here’s an update this way. Please merge if possible.

Edit for completeness sake:
I found out that OpenTasks creates tasks with priority 0 by default. This of course results in the same problem as before. To solve this problem for good, one would probably need to create a BEFORE INSERT Trigger in MySQL to change the task_priorityvalue when a new task is added (and perhaps another BEFORE UPDATE Trigger as well).
Sadly, my host does not support MySQL Triggers. Therefore I simply created a cronjob to run the UPDATE command above every 10 minutes.

In the meantime I also found a feature request in the Horde bugtracker which is probably connected: https://bugs.horde.org/ticket/14032
Horde doesn’t comply to the RFC yet (and handle’s RFC compliant values strangely), while the other applications do.

[rfc2822]

Thanks for the update and the link!