Unable to load a SugarCRM iCal Calendar

[simone.girlanda]

I'm using ICal Patch in SugarCRM to get calendar in ics format, I'm able to use it from Windows Calendar on my vista notebook, but in ZimbraDesktop I got this error "No such folder exists." when I try to load calendar.

The only difference is that WindowsCalendar ask me for user/password, while ZimbraDesktop does not.

A Google Calendar works in ZImbraDesktop.

Is the authentication the problem ?

[celsowebber]

Hello,

I believe I'm having the same problem as you are.

We use SugarCRM internally and some appointments are made on Sugar's calendar. This worked great together with Mozilla's Sunbird extension (calendar extension for Thunderbird), and with Apple's iCal application also.

The problem is that now that we moved to Zimbra, we cannot subscribe to SugarCRM calendars anymore.

Whenever we subscribe to a SugarCRM (using Sugar's iCal patch) such as:

http://SUGARHOST/sugar/ical_server.p...=USER&key=PASS

Zimbra returns this error to the user:

"Appointments could not be retrieved. Make sure the following URL is a valid ICAL feed: http://SUGARHOST/sugar/ical_server.php?type=ics&user_name=USER&key=PASS"

Looking at the logs in /opt/zimbra/log/mailbox.log, we can see:

2009-07-27 17:27:31,198 INFO [btpool0-24] [name=celso.webber@webbertek.com.br;mid=8;ip=172.31 .2.68;ua=ZimbraWebClient - FF3.0 (Win)/5.0.14_GA
_2850.RHEL5_64;] soap - CreateFolderRequest
2009-07-27 17:27:31,198 INFO [btpool0-24] [name=celso.webber@webbertek.com.br;mid=8;ip=172.31 .2.68;ua=ZimbraWebClient - FF3.0 (Win)/5.0.14_GA
_2850.RHEL5_64;] mailop - adding folder SugarCRM (celso): id=23515, parentId=1.
2009-07-27 17:27:31,212 INFO [btpool0-25] [name=celso.webber@webbertek.com.br;mid=8;ip=172.31 .2.68;ua=ZimbraWebClient - FF3.0 (Win)/5.0.14_GA
_2850.RHEL5_64;] soap - NoOpRequest
2009-07-27 17:27:31,234 INFO [btpool0-25] [name=celso.webber@webbertek.com.br;mid=8;ip=172.31 .2.68;ua=ZimbraWebClient - FF3.0 (Win)/5.0.14_GA
_2850.RHEL5_64;] soap - BatchRequest
2009-07-27 17:27:31,234 INFO [btpool0-25] [name=celso.webber@webbertek.com.br;mid=8;ip=172.31 .2.68;ua=ZimbraWebClient - FF3.0 (Win)/5.0.14_GA
_2850.RHEL5_64;] soap - (batch) GetMiniCalRequest
2009-07-27 17:27:31,646 INFO [btpool0-24] [name=celso.webber@webbertek.com.br;mid=8;ip=172.31 .2.68;ua=ZimbraWebClient - FF3.0 (Win)/5.0.14_GA
_2850.RHEL5_64;] mailbox - deleting folder /SugarCRM (celso), id=23515
2009-07-27 17:27:31,648 INFO [btpool0-24] [name=celso.webber@webbertek.com.br;mid=8;ip=172.31 .2.68;ua=ZimbraWebClient - FF3.0 (Win)/5.0.14_GA
_2850.RHEL5_64;] mailop - Deleting Folder SugarCRM (celso) (id=23515).
2009-07-27 17:27:31,651 INFO [btpool0-24] [name=celso.webber@webbertek.com.br;mid=8;ip=172.31 .2.68;ua=ZimbraWebClient - FF3.0 (Win)/5.0.14_GA
_2850.RHEL5_64;] SoapEngine - handler exception
com.zimbra.common.service.ServiceException: parse error: Unable to parse iCalendar data: Invalid date/time specified: 20090319 18:00:00
ExceptionId:btpool0-24:1248726451646:f98884061596f449
Code:service.PARSE_ERROR
at com.zimbra.common.service.ServiceException.PARSE_E RROR(ServiceException.java:271)
at com.zimbra.cs.mailbox.calendar.Invite.createFromCa lendar(Invite.java:1909)
at com.zimbra.cs.mailbox.calendar.Invite.createFromCa lendar(Invite.java:1615)
... <other similar messages HERE>
Caused by: java.text.ParseException: Invalid date/time specified: 20090319 18:00:00
at com.zimbra.cs.mailbox.calendar.ParsedDateTime.pars e(ParsedDateTime.java:171)
at com.zimbra.cs.mailbox.calendar.ParsedDateTime.pars e(ParsedDateTime.java:78)
at com.zimbra.cs.mailbox.calendar.ParsedDateTime.pars e(ParsedDateTime.java:187)
at com.zimbra.cs.mailbox.calendar.Invite.createFromCa lendar(Invite.java:1711)
... 37 more
2009-07-27 17:27:31,653 INFO [btpool0-25] [name=celso.webber@webbertek.com.br;mid=8;ip=172.31 .2.68;ua=ZimbraWebClient - FF3.0 (Win)/5.0.14_GA
_2850.RHEL5_64;] SoapEngine - handler exception
com.zimbra.cs.mailbox.MailServiceException$NoSuchI temException: no such folder id: 23515
ExceptionId:btpool0-25:1248726451653:f98884061596f449
Code:mail.NO_SUCH_FOLDER ArgitemId, IID, "23515")
at com.zimbra.cs.mailbox.MailServiceException.NO_SUCH _FOLDER(MailServiceException.java:180)
at com.zimbra.cs.mailbox.MailItem.noSuchItem(MailItem .java:1167)
at com.zimbra.cs.mailbox.Mailbox.getItemById(Mailbox. java:2004)
at com.zimbra.cs.mailbox.Mailbox.getItemById(Mailbox. java:1988)
... <other similar messages HERE>


Could anyone point out where is the problem?


Thank you all.

Celso.