[Fiware-support] S.O.S. - tracker..

Roberto Andradas Izquierdo randradas at libresoft.es
Mon Nov 7 21:31:47 CET 2011


hi,

alex, please, let me know if it is enough for you in order to restore the
issues manually. do you need more information from the backup?

kind regards!

On 7 November 2011 19:14, Roberto Andradas Izquierdo <randradas at libresoft.es
> wrote:

> try again alex, we had a problem with the database just after solve your
> issue. it should work now.
>
>
> On 7 November 2011 17:44, Alex Glikson <GLIKSON at il.ibm.com> wrote:
>
>> I am trying to re-create the tracker, and am having some issues with
>> customizing fields.. Please, see the attached screenshot. Would appreciate
>> your assistance.
>>
>> Thanks,
>> Alex
>>
>>
>>
>>
>>
>>
>> From:        Roberto Andradas Izquierdo <randradas at libresoft.es>
>> To:        Alex Glikson/Haifa/IBM at IBMIL
>> Cc:        "fiware-support at lists.fi-ware.eu" <
>> fiware-support at lists.fi-ware.eu>, Miguel Carrillo <mcp at tid.es>
>> Date:        07/11/2011 05:52 PM
>> Subject:        Re: [Fiware-support] S.O.S. - tracker..
>> Sent by:        randradas at gmail.com
>> ------------------------------
>>
>>
>>
>> Hi,
>>
>> I found the following tracker:
>>
>> Cloud Chapter Backlog
>>
>> it does not appear in the current database today so I supposed it is
>> the one you want to restore.
>>
>> Find attached the CSV file with the data, the csv file use ";;;" as
>> character separator between fields. The fields are the following:
>>
>> artifact_id,
>> summary,
>> details,
>> unix_group_name,
>> name,
>> priority,
>> email,
>> open_date,
>> assigned_to,
>> status_name,
>> groups.group_id,
>> artifact.group_artifact_id
>>
>> Maybe some fields are not necessary so ignore them.
>>
>> if it is not the data you want let me know.
>>
>> Kind regards!
>>
>>
>>
>> On 7 November 2011 13:36, Alex Glikson <GLIKSON at il.ibm.com> wrote:
>> > 2/11, around 8:30pm CET.
>> >
>> > Regards,
>> > Alex
>> >
>> >
>> >
>> > From:        Roberto Andradas Izquierdo <randradas at libresoft.es>
>> > To:        Miguel Carrillo <mcp at tid.es>
>> > Cc:        Alex Glikson/Haifa/IBM at IBMIL, "
>> fiware-support at lists.fi-ware.eu"
>> > <fiware-support at lists.fi-ware.eu>
>> > Date:        07/11/2011 02:02 PM
>> > Subject:        Re: [Fiware-support] S.O.S. - tracker..
>> > Sent by:        randradas at gmail.com
>> > ________________________________
>> >
>> >
>> > Alex, could you let me know what day do you delete the tracker exactly
>> > in order to search in the backups?
>> >
>> > On 7 November 2011 13:01, Roberto Andradas Izquierdo
>> > <randradas at libresoft.es> wrote:
>> >> On 7 November 2011 12:44, Miguel Carrillo <mcp at tid.es> wrote:
>> >>> Roberto,
>> >>>
>> >>> Thanks for the info and the effort. Assuming that recovering all the
>> >>> data is a no-no, let us evaluate something alternative  and possibly
>> not
>> >>> as painful.
>> >>>
>> >>> Can we recover the list of titles + the list of descriptions (i.e.
>> body
>> >>> of each entry)? If we can have a plain text document with this it
>> would
>> >>> be of great help to save hundreds of hours of typing...
>> >>
>> >> ok, let me take a look to the backups we should be able to provide a
>> >> file with all the issues of the deleted tracker.
>> >>
>> >>>
>> >>> Best
>> >>>
>> >>> Miguel
>> >>>
>> >>> El 07/11/2011 11:04, Roberto Andradas Izquierdo escribió:
>> >>>>
>> >>>> Dear Alex,
>> >>>>
>> >>>> good morning and bad news.
>> >>>>
>> >>>> I have been taking a look at the database and the fusionforge code
>> and
>> >>>> it is deleted completely. It is not a simple DELETE, there are
>> several
>> >>>> queries, several tables and a complex logic involved in the deletion
>> >>>> of a tracker and the only way to restore just one tracker is create
>> it
>> >>>> manually.
>> >>>>
>> >>>> Creating it manually ensure that it will be created correctly,
>> >>>> otherwise by writing our own scripts or inserting queries into the
>> >>>> database manually could damage the database of the forge and break
>> >>>> another data into the forge and it is a risk we can not assume.
>> >>>>
>> >>>> I'm so sorry Alex, if we can help you with another thing don't
>> hesitate
>> >>>> to
>> >>>> ask.
>> >>>>
>> >>>> Kind regards!
>> >>>>
>> >>>>
>> >>>>
>> >>>> On 4 November 2011 15:37, Alex Glikson<GLIKSON at il.ibm.com>  wrote:
>> >>>>>
>> >>>>> Any progress with this?
>> >>>>> It would be really frustrating if we need to re-enter everything in
>> our
>> >>>>> backlog tracker from scratch.. :-(
>> >>>>>
>> >>>>> Thanks,
>> >>>>> Alex
>> >>>>>
>> >>>>>
>> >>>>>
>> >>>>> From:        Roberto Andradas Izquierdo<randradas at libresoft.es>
>> >>>>> To:        Alex Glikson/Haifa/IBM at IBMIL
>> >>>>> Cc:        fiware-support at lists.fi-ware.eu, Juanjo
>> >>>>> Hierro<jhierro at tid.es>
>> >>>>> Date:        03/11/2011 10:57 AM
>> >>>>> Subject:        Re: [Fiware-support] S.O.S. - tracker..
>> >>>>> Sent by:        randradas at gmail.com
>> >>>>> ________________________________
>> >>>>>
>> >>>>>
>> >>>>> Dear Alex,
>> >>>>>
>> >>>>> backups are done based on the restore the system in case of hardware
>> >>>>> failures or something similar, are not designed to restore only
>> parts
>> >>>>> of the forge. So it will take too much effort to restore your
>> tracker,
>> >>>>> to do that we have to introduce the data again in the database
>> >>>>> manually and it could produce database inconsistencies and so on.
>> >>>>>
>> >>>>> In any case, I will try to figure out how to restore it, several
>> >>>>> tables are involved in trackers it depends on how the forge deletes
>> >>>>> the tracker, for example, if it is just a flag, then I can change it
>> >>>>> and you tracker will appear again, but if the data has been deleted
>> >>>>> completely from the database I'm afraid I won't be able to restore
>> it.
>> >>>>>
>> >>>>> Stay tuned, I will tel you something tomorrow.
>> >>>>>
>> >>>>> Kind regards!
>> >>>>>
>> >>>>> On 2 November 2011 20:41, Alex Glikson<GLIKSON at il.ibm.com>  wrote:
>> >>>>>>
>> >>>>>> Hi,
>> >>>>>>
>> >>>>>> Seems that I've mistakenly removed the Backlog Tracker under the
>> Cloud
>> >>>>>> project in Forge (instead of removing an item in it).
>> >>>>>> I hope we have backups.. would appreciate your help!!
>> >>>>>>
>> >>>>>> Thanks,
>> >>>>>> Alex
>> >>>>>> _______________________________________________
>> >>>>>> Fiware-support mailing list
>> >>>>>> Fiware-support at lists.fi-ware.eu
>> >>>>>> http://lists.fi-ware.eu/listinfo/fiware-support
>> >>>>>>
>> >>>>>>
>> >>>>>
>> >>>>>
>> >>>> _______________________________________________
>> >>>> Fiware-support mailing list
>> >>>> Fiware-support at lists.fi-ware.eu
>> >>>> http://lists.fi-ware.eu/listinfo/fiware-support
>> >>>> .
>> >>>>
>> >>>
>> >>> --
>> >>> ----------------------------------------------------------------------
>> >>>     _/          _/_/                     Miguel Carrillo Pacheco
>> >>>    _/   _/     _/  _/   Telefónica       Distrito C
>> >>>   _/ _/_/_/   _/   _/   Investigación y  Edifico Oeste 1, Planta 5
>> >>>  _/   _/     _/  _/     Desarrollo       Ronda de la Comunicación S/N
>> >>>  _/          _/_/                         Madrid 28050 (Spain)
>> >>>                                          Tel:  (+34) 91 483 26 77
>> >>>
>> >>>                                          e-mail: mcp at tid.es
>> >>> ----------------------------------------------------------------------
>> >>>
>> >>>
>> >>> Este mensaje se dirige exclusivamente a su destinatario. Puede
>> consultar
>> >>> nuestra política de envío y recepción de correo electrónico en el
>> enlace
>> >>> situado más abajo.
>> >>> This message is intended exclusively for its addressee. We only send
>> and
>> >>> receive email on the basis of the terms set out at.
>> >>> http://www.tid.es/ES/PAGINAS/disclaimer.aspx
>>
>> >>>
>> >>
>> >
>> >
>> >
>>
>> [attachment "cloud_issues.csv" deleted by Alex Glikson/Haifa/IBM]
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.fiware.org/private/fiware-support/attachments/20111107/ca825565/attachment.html>


More information about the Fiware-support mailing list

You can get more information about our cookies and privacy policies clicking on the following links: Privacy policy   Cookies policy