Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0026080ModulesGoogle Calendar integration for Resources and Reservationspublic2014-03-25 11:552014-04-25 08:31
Reportercaristu 
Assigned Toalostale 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version1.0.1 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Tocaristu
Support ticket
OBNetwork customer
Regression introduced in release
Summary0026080: Synchronization fails after updating a reservation the second time
DescriptionSynchronization fails after updating the reservation start date the second time. The following error is raised in the log:

ERROR org.openbravo.integration.google.calendar.GoogleCalendarUtils - Error updating event in Google Calendar
com.google.api.client.googleapis.json.GoogleJsonResponseException: 400 Bad Request
{
  "code" : 400,
  "errors" : [ {
    "domain" : "global",
    "message" : "Invalid sequence value.",
    "reason" : "invalid"
  } ],
  "message" : "Invalid sequence value."
}

Steps To Reproduce1) Create a new reservation, for example start date: 5:00 and end Date 8:00
2) Check in the [Google Integration] log that the synchronization is correct
3) Update the reservation, changing the start date to 6:00
4) Check in the [Google Integration] log that the synchronization is correct
5) Update the reservation, changing the start date to 7:00. The synchronization fails
Proposed SolutionSeems that a possible solution could be to increment the sequence number when updating events
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-03-25 11:55caristuNew Issue
2014-03-25 11:55caristuAssigned To => alostale
2014-03-25 11:55caristuResolution time => 1397944800
2014-03-25 11:55caristuIssue Monitored: networkb
2014-03-25 11:58caristuSummarySynchronization fails after updating the reservation the second time => Synchronization fails after updating a reservation the second time
2014-03-25 11:58caristuDescription Updatedbug_revision_view_page.php?rev_id=5610#r5610
2014-03-31 16:56caristuDescription Updatedbug_revision_view_page.php?rev_id=5644#r5644
2014-04-15 12:29alostaleReview Assigned To => caristu
2014-04-15 12:40hgbotCheckin
2014-04-15 12:40hgbotNote Added: 0066432
2014-04-15 12:40hgbotStatusnew => resolved
2014-04-15 12:40hgbotResolutionopen => fixed
2014-04-15 12:40hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.module.resources.google.calendar/rev/126a906eb032dc99f281f29dddb37058772a08ca [^]
2014-04-15 12:43alostaleNote Added: 0066433
2014-04-25 08:31caristuNote Added: 0066591
2014-04-25 08:31caristuStatusresolved => closed
2014-04-25 08:31caristuFixed in Version => 1.0.1

Notes
(0066432)
hgbot   
2014-04-15 12:40   
Repository: erp/pmods/org.openbravo.module.resources.google.calendar
Changeset: 126a906eb032dc99f281f29dddb37058772a08ca
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue Apr 15 12:37:34 2014 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.resources.google.calendar/rev/126a906eb032dc99f281f29dddb37058772a08ca [^]

fixed bug 26080: Synchronization fails for 2nd reservation update

---
M src-db/database/model/modifiedTables/OBRE_RESERVATION.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src/org/openbravo/module/resources/google/calendar/ReservationGoogleEventObserver.java
---
(0066433)
alostale   
2014-04-15 12:43   
Published new version 1.0.1 fixing this issue: http://centralrepository.openbravo.com/heartbeat-server/org.openbravo.forge.ui/sso/ForgeModuleDetail/Google-Calendar-Integration-For-Resources-And-Reservations [^]
(0066591)
caristu   
2014-04-25 08:31   
Verified