[Go-essp-tech] Incorrect dataset names

[Estanislao Gonzalez]

Thanks Eric,

it worked perfectly. Do we need to do anything regarding the 3*store or 
it will update automatically becase of the data_update time stamp?

Thanks,
Estani
Am 06.10.2011 18:41, schrieb Eric Nienhouse:
> Hi Stephen, All,
>
> Republishing these "CMIP5 / IPCC Fifth Assessment Report" datasets 
> with the proper name will update the related Gateway dataset name.  As 
> noted, there may be an enormous number of datasets to update and this 
> may not be practical to do.
>
> To update all of these CMIP5 dataset names at your Gateway without 
> republishing, you can run the following SQL.  Please be sure to backup 
> your database prior to doing so.
>
> -- 
> -- SQL to update all CMIP5 related dataset names in the Gateway database.
> -- 
> update metadata.resource
> set name = replace (name,'project=CMIP5 / IPCC Fifth Assessment 
> Report,','project=CMIP5,'),
> date_updated = now()
> where name like '%project=CMIP5 / IPCC Fifth Assessment Report,%';
> -- 
> -- END
> -- 
>
> Additional information can be found below:
>
> https://wiki.ucar.edu/display/esgcet/FAQ#FAQ-updatedataset
>
> I can echo what Stephen notes below regarding the publisher 
> configuration.  In order to make this default CMIP5 name change by 
> had, you need to:
>
> 1) update the esg.ini project options for cmip5.
> 2) update the related publisher database project table record.
>
> These configuration updates will be handled in the next publisher 
> release.
>
> Thanks,
>
> -Eric
>
>
>
> stephen.pascoe at stfc.ac.uk wrote:
>> Sorry Estani, I was wrong -- I thought our clean test datanode had 
>> built with the new configuration but I must have copied it from my 
>> production system and forgotten.  The published distributions still 
>> have the old version.
>>
>> Stephen.
>>
>> ---
>> Stephen Pascoe  +44 (0)1235 445980
>> Centre of Environmental Data Archival
>> STFC Rutherford Appleton Laboratory, Harwell Oxford, Didcot OX11 0QX, UK
>>
>>
>> -----Original Message-----
>> From: Estanislao Gonzalez [mailto:gonzalez at dkrz.de] Sent: 05 October 
>> 2011 16:56
>> To: Pascoe, Stephen (STFC,RAL,RALSP)
>> Cc: Serguei.Nikonov at noaa.gov; go-essp-tech at ucar.edu
>> Subject: Re: [Go-essp-tech] Incorrect dataset names
>>
>> Hi Stephen,
>>
>> Which version is the latest one? Does it the latest version of esgcet 
>> get published somewhere?
>>
>> just wanted to check, because I still have the old configuration...
>>
>> Thanks,
>> Estani
>> Am 05.10.2011 17:36, schrieb stephen.pascoe at stfc.ac.uk:
>>>> it's surprise for me. I changed project_options in esg.ini as it 
>>>> was recommended
>>>> by Bob D. before any publishing. What else does control this, any 
>>>> hidden
>>>> parameter I wasn't aware of?
>>> No, that's where you configure it.  We have a mixture of correct and 
>>> incorrect titles because we changed the parameter but haven't 
>>> republished everything with the wrong title.  The default is correct 
>>> now but many are probably still running old datanode installs.  
>>> Those centres that haven't changed the default or upgraded will have 
>>> the problem.
>>>
>>> Stephen.
>>>
>>> ---
>>> Stephen Pascoe  +44 (0)1235 445980
>>> Centre of Environmental Data Archival
>>> STFC Rutherford Appleton Laboratory, Harwell Oxford, Didcot OX11 
>>> 0QX, UK
>>>
>>> -----Original Message-----
>>> From: go-essp-tech-bounces at ucar.edu 
>>> [mailto:go-essp-tech-bounces at ucar.edu] On Behalf Of Estanislao Gonzalez
>>> Sent: 05 October 2011 16:30
>>> To: Serguei Nikonov
>>> Cc: go-essp-tech at ucar.edu
>>> Subject: Re: [Go-essp-tech] Incorrect dataset names
>>>
>>> Hi Sergey,
>>>
>>> AFAICT the default parameters are wrong, and that's what caused the
>>> problem. The template.ini which generates the esg.ini is:
>>> project_options =
>>>     cmip5 | CMIP5 / IPCC Fifth Assessment Report | 1
>>>
>>> It should have been:
>>> project_options =
>>>     cmip5 | CMIP5 | 1
>>>
>>> or something the like. (so is in my 2.8.5 version at least)
>>> (Bob, could you update the template please?)
>>>
>>> I'm not sure why there are institutions without showing this problem.
>>> They might have manually configured it...
>>>
>>> Thanks,
>>> Estani
>>>
>>> Am 05.10.2011 17:20, schrieb Serguei Nikonov:
>>>> Hi all,
>>>>
>>>> it's surprise for me. I changed project_options in esg.ini as it 
>>>> was recommended
>>>> by Bob D. before any publishing. What else does control this, any 
>>>> hidden
>>>> parameter I wasn't aware of?
>>>>
>>>> Sergey Nikonov,
>>>> GFDL
>>>>
>>>> martin.juckes at stfc.ac.uk wrote:
>>>>> Hello,
>>>>>
>>>>> A number of datasets, including some at BADC, have been published 
>>>>> with "project=CMIP5 / IPCC Fifth Assessment Report, .... " in the 
>>>>> dataset name. A search for "IPCC Fifth" suggests we have 4021 
>>>>> datasets with this error, from CCCMA, CNRM-CERFACS, CSIRO-QCCCE, 
>>>>> IPSL, MOHC, and NOAA-GFDL. We should develop a plan to correct 
>>>>> this -- I guess this means republishing the affected datasets,
>>>>>
>>>>> cheers,
>>>>> Martin--
>>>>> Scanned by iCritical.
>>>>> _______________________________________________
>>>>> GO-ESSP-TECH mailing list
>>>>> GO-ESSP-TECH at ucar.edu
>>>>> http://mailman.ucar.edu/mailman/listinfo/go-essp-tech
>>>>>
>>>> _______________________________________________
>>>> GO-ESSP-TECH mailing list
>>>> GO-ESSP-TECH at ucar.edu
>>>> http://mailman.ucar.edu/mailman/listinfo/go-essp-tech
>>
>>
>


-- 
Estanislao Gonzalez

Max-Planck-Institut für Meteorologie (MPI-M)
Deutsches Klimarechenzentrum (DKRZ) - German Climate Computing Centre
Room 108 - Bundesstrasse 45a, D-20146 Hamburg, Germany

Phone:   +49 (40) 46 00 94-126
E-Mail:  gonzalez at dkrz.de