Results 1 to 7 of 7

Thread: import Sun Calendar into ics error

  1. #1
    Join Date
    Feb 2007
    Location
    Philadelphia, PA
    Posts
    14
    Rep Power
    8

    Default import Sun Calendar into ics error

    curl posts of calendar ics files have started throwing a curious error. We have been able to post to user calendars but not yet to resource calendars.

    Does anyone have any insight?

    thanks.

    Our version: zcs-5.0.1_GA_1902.RHEL4_64.20080109184405


    $ more three_martini_lunch.ics
    BEGIN:VCALENDAR
    PRODID:-//Sun/Calendar Server//EN
    METHOD:PUBLISH
    VERSION:2.0
    X-S1CS-EXPORTVERSION:6.0
    BEGIN:VEVENT
    UID:0000000000000000000000000000000047a0ca28000063 7600000a7e00003eae
    DTSTAMP:20080130T190628Z
    SUMMARY:three martini lunch
    DTSTART:20080201T170000Z
    DTEND:20080201T180000Z
    CREATED:20080130T190408Z
    LAST-MODIFIED:20080130T190408Z
    PRIORITY:5
    SEQUENCE:0
    CLASS:PUBLIC
    ORGANIZER;CN="Morgan Jones"
    ;X-NSCP-ORGANIZER-UID=morgan
    ;X-S1CS-EMAIL=morgan@domain.pass
    :morgan
    STATUS:CONFIRMED
    TRANSP:OPAQUE
    X-NSCP-ORIGINAL-DTSTART:20080201T170000Z
    X-NSCP-LANGUAGE:en
    X-NSCP-DTSTART-TZID:America/New_York
    X-NSCP-TOMBSTONE:0
    X-NSCP-ONGOING:0
    X-NSCP-ORGANIZER-EMAIL:morgan@domain.pass
    X-NSCP-GSE-COMPONENT-STATE;X-NSCP-GSE-COMMENT="PUBLISH-COMPLETED":65538
    END:VEVENT
    X-NSCP-WCAP-ERRNO:0
    END:VCALENDAR
    curl -k -u 'admin@host.domain:\pass' --data-binary '@/home/mjones/three_martini_lunch.ics' --url 'https://host.domain:7071/service/home/confrm1080@host.domain/calendar?fmt=ics'
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"/>
    <title>Error 500 </title>
    </head>
    <body><h2>HTTP ERROR: 500</h2><pre>system failure: cannot start a logged transaction from within another transaction</pre>
    <p>RequestURI=/service/home/confrm1080@host.domain/calendar</p><h3>Caused by:</h3><pre>com.zimbra.common.service.ServiceException : system failure: cannot start a logged transaction from within another transaction
    Code:service.FAILURE
    at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:183)
    at com.zimbra.cs.mailbox.Mailbox.beginTransaction(Mai lbox.java:1079)
    at com.zimbra.cs.mailbox.Mailbox.beginTransaction(Mai lbox.java:1035)
    at com.zimbra.cs.mailbox.Mailbox.addMessageInternal(M ailbox.java:3818)
    at com.zimbra.cs.mailbox.Mailbox.addMessage(Mailbox.j ava:3750)
    at com.zimbra.cs.mailbox.Mailbox.addMessage(Mailbox.j ava:3698)
    at com.zimbra.cs.mailbox.MailSender.sendMimeMessage(M ailSender.java:249)
    at com.zimbra.cs.mailbox.calendar.CalendarMailSender. sendReply(CalendarMailSender.java:565)
    at com.zimbra.cs.mailbox.Appointment.processPartStat( Appointment.java:316)
    at com.zimbra.cs.mailbox.CalendarItem.create(Calendar Item.java:358)
    at com.zimbra.cs.mailbox.Mailbox.createCalendarItem(M ailbox.java:4818)
    at com.zimbra.cs.mailbox.Mailbox.addInvite(Mailbox.ja va:3524)
    at com.zimbra.cs.mailbox.Mailbox.addInvite(Mailbox.ja va:3474)
    at com.zimbra.cs.service.formatter.IcsFormatter$Impor tInviteVisitor.visit(IcsFormatter.java:133)
    at com.zimbra.cs.mailbox.calendar.Invite.createFromCa lendar(Invite.java:1722)
    at com.zimbra.cs.mailbox.calendar.Invite.createFromCa lendar(Invite.java:1436)
    at com.zimbra.cs.service.formatter.IcsFormatter.saveC allback(IcsFormatter.java:144)
    at com.zimbra.cs.service.formatter.Formatter.save(For matter.java:111)
    at com.zimbra.cs.service.UserServlet.doPost(UserServl et.java:540)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:727)
    at com.zimbra.cs.servlet.ZimbraServlet.service(Zimbra Servlet.java:174)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:820)
    at org.mortbay.jetty.servlet.ServletHolder.handle(Ser vletHolder.java:487)
    at org.mortbay.jetty.servlet.ServletHandler$CachedCha in.doFilter(ServletHandler.java:1093)
    at org.mortbay.servlet.UserAgentFilter.doFilter(UserA gentFilter.java:81)
    at org.mortbay.servlet.GzipFilter.doFilter(GzipFilter .java:148)
    at org.mortbay.jetty.servlet.ServletHandler$CachedCha in.doFilter(ServletHandler.java:1084)
    at org.mortbay.jetty.servlet.ServletHandler.handle(Se rvletHandler.java:360)
    at org.mortbay.jetty.security.SecurityHandler.handle( SecurityHandler.java:216)
    at org.mortbay.jetty.servlet.SessionHandler.handle(Se ssionHandler.java:181)
    at org.mortbay.jetty.handler.ContextHandler.handle(Co ntextHandler.java:712)
    at org.mortbay.jetty.webapp.WebAppContext.handle(WebA ppContext.java:405)
    at org.mortbay.jetty.handler.ContextHandlerCollection .handle(ContextHandlerCollection.java:211)
    at org.mortbay.jetty.handler.HandlerCollection.handle (HandlerCollection.java:114)
    at org.mortbay.jetty.handler.HandlerWrapper.handle(Ha ndlerWrapper.java:139)
    at org.mortbay.jetty.handler.RewriteHandler.handle(Re writeHandler.java:176)
    at org.mortbay.jetty.handler.HandlerWrapper.handle(Ha ndlerWrapper.java:139)
    at org.mortbay.jetty.Server.handle(Server.java:313)
    at org.mortbay.jetty.HttpConnection.handleRequest(Htt pConnection.java:506)
    at org.mortbay.jetty.HttpConnection$RequestHandler.co ntent(HttpConnection.java:844)
    at org.mortbay.jetty.HttpParser.parseNext(HttpParser. java:644)
    at org.mortbay.jetty.HttpParser.parseAvailable(HttpPa rser.java:211)
    at org.mortbay.jetty.HttpConnection.handle(HttpConnec tion.java:381)
    at org.mortbay.io.nio.SelectChannelEndPoint.run(Selec tChannelEndPoint.java:396)
    at org.mortbay.thread.BoundedThreadPool$PoolThread.ru n(BoundedThreadPool.java:442)
    </pre>
    <p><i><small><a href="http://jetty.mortbay.org/">Powered by Jetty://</a></small></i></p><br/>
    <br/>
    <br/>
    <br/>
    <br/>
    <br/>
    <br/>
    <br/>
    <br/>
    <br/>
    <br/>
    <br/>
    <br/>
    <br/>
    <br/>
    <br/>
    <br/>
    <br/>
    <br/>
    <br/>

    </body>
    </html>

  2. #2
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    21

    Default

    Does this only happen on this particular ICS File? Do all ics files fail?

    If it's only this one, can you try to generate another ICS file from Sun Calendar, and see if it fails again? If it does, please file a bug, and include as much information as possible.

  3. #3
    Join Date
    Feb 2007
    Location
    Philadelphia, PA
    Posts
    14
    Rep Power
    8

    Default

    Quote Originally Posted by jholder View Post
    Does this only happen on this particular ICS File? Do all ics files fail?

    If it's only this one, can you try to generate another ICS file from Sun Calendar, and see if it fails again? If it does, please file a bug, and include as much information as possible.

    It's all ics files from Sun Calendar that we've tried. I'll file a bug tomorrow. thanks.

  4. #4
    Join Date
    Feb 2007
    Location
    Philadelphia, PA
    Posts
    14
    Rep Power
    8

  5. #5
    Join Date
    Aug 2007
    Posts
    220
    Rep Power
    8

    Default

    Dealing with IPlanet calendars is a mess. I found that to make it work correctly we had to write a custom export script and manipulate the output. I put the blame on IPlanet.

    The short version is that we use IPLanets fetchcomponents_by_range call, using attrset=2, recurring=1, a tzidout timezone, then we remove all lines starting with X-NSCP, X-S1CS, insert a timezone component, and do some search/replace to replace old address with with new address.

    And for some reason SOME calendars contain garbage that needs to be removed as well, for example random numbers between VEVENTS.

    Its a bit of a mess, but it seems to generate usable data to feed into zimbra. This may also be specific to our install if IPlanet which is now a bit out of date, has been upgraded countless times, and has been running for close to 8 years and no one knows for sure what hacks have been done to it anymore.

  6. #6
    Join Date
    Jan 2007
    Posts
    86
    Rep Power
    8

    Default Import Sun Calendar Date into Zimbra Resource Calendar

    In the resource calendar's Edit page, change Auto-Accept Appointments to Manually Accept/Decline appointments.

    The Sun calendar events will import to the Zimbra resource calendar but cannot be edited.

  7. #7
    Join Date
    Apr 2009
    Posts
    46
    Rep Power
    6

    Default

    I have just done a Meeting Maker Migration entirely by using .ics import. I like to give you a different perspective on this issue.

    This is an invalid .ics file but to be specific, All on the Field for ORGANIZER. There is two major problem:
    1. syntax error on the ORGANIZER:
    in vCalendar, there should be a leading space in front of the sequence lines when a field is written into multiple lines.
    2. The ORGANIZER for Zimbra need a valid "mailto" address so you should fix the ORGANIZER as

    ORGANIZER;CN="Morgan Jones";mailto:morgan@vaild.email.address

    That should fix you import problem. Also with the email fixed, meeting can then be edit (accept and decline only since resource is not the organizer). as normal.

    The reason your user import worked correctly is probably because the ORGANIZER is not exported at all if the meeting was created by the user himself.

Similar Threads

  1. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 01:42 AM
  2. [SOLVED] Debian Etch 32 / 64: MTA not working
    By xflip in forum Installation
    Replies: 2
    Last Post: 01-18-2008, 04:58 AM
  3. 3.0 to 4.5.3 Upgrade failed (mysql error)
    By dealt in forum Installation
    Replies: 35
    Last Post: 03-19-2007, 11:30 PM
  4. M3 problem with shares
    By titangears in forum Users
    Replies: 4
    Last Post: 01-12-2006, 01:01 PM
  5. Building native libraries on MacOS X
    By ajmas in forum Developers
    Replies: 3
    Last Post: 10-15-2005, 12:00 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •