Zimbra offers Open Source email server software and shared calendar for Linux and the Mac
Go Back   Zimbra :: Forums > Zimbra Collaboration Suite > Migration
Reload this Page import Sun Calendar into ics error

Welcome to the Zimbra :: Forums!
Welcome, if you would like to post a comment please register. We also encourage you to explore all things Zimbra with our team and members of the community.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-30-2008, 11:21 AM
Member
  
Posts: 14
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


Quote:
$ 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
Quote:
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'
Quote:
<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>
Reply With Quote
  #2 (permalink)  
Old 01-30-2008, 02:36 PM
Former Zimbran
  
Posts: 5,606
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.
Reply With Quote
  #3 (permalink)  
Old 01-30-2008, 04:28 PM
Member
  
Posts: 14
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.
Reply With Quote
  #4 (permalink)  
Old 03-18-2009, 11:54 AM
Member
  
Posts: 14
Default link to bug
I just had to hunt this down, thought it might be helpful:
Bug 24223 &ndash; Import from a Sun Calendar ics fails with cannot start a logged transaction from within another
Reply With Quote
  #5 (permalink)  
Old 04-02-2009, 10:05 AM
Advanced Member
  
Posts: 194
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.
Reply With Quote
  #6 (permalink)  
Old 04-08-2009, 02:27 PM
Loyal Member
  
Posts: 86
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.
Reply With Quote
  #7 (permalink)  
Old 04-10-2009, 06:10 PM
Active Member
  
Posts: 46
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.
Reply With Quote
Reply

« Previous Thread | Today's Posts or Week's Posts | Next Thread »

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode


Similar Threads

Product Information

Why Join?

Registering let's you ask questions, makes it easier to search, displays any files attached to posts, and notifies you about replies.

blog.zimbra.com


Home - Blog - Contact Us - Archive - Top


 

SEO by vBSEO ©2011, Crawlability, Inc.