[ECODP-dev] Problem with updating the nal list

Thu Sep 26 10:54:45 UTC 2013

Hi Bert,

Thanks for the update, so this has been resolved?

Could you please keep the database on that machine for now so that we can
check the table sizes.

Thanks,
John

On 26 September 2013 12:22, Bert Van Nuffelen <
bert.van.nuffelen at tenforce.com> wrote:

> Hi John,
>
> some more background info.
>
> I found out that this publisher was in the past set deprecated in the
> source RDF, which normally means it was not uploaded then.
> Now it has been activated.
>
> Maybe it was active in the past, made then deprecated (so there the delete
> came from) and now it is resurrected.
>
> Bert
>
>
>
> 2013/9/26 Bert Van Nuffelen <bert.van.nuffelen at tenforce.com>
>
>> Hi John,
>>
>> we did a quick investigation:
>>
>> this is the problematic publisher: egsa
>>
>> The publisher was denoted deleted.
>>
>> After this update:
>>
>> update public.group set state='active', description='European GNSS
>> Supervisory Authority', name='egsa1' where name='egsa'
>>
>> the process worked.
>>
>> Bert
>>
>>
>>
>> 2013/9/26 Dimitrios Mexis <dimitrios.mexis at tenforce.com>
>>
>>>  John good morning,
>>>
>>> I have the db from PO installed for you on the machine 192.168.35.139,
>>> where we try to update this database with the corporatebodies-nal.rdf
>>>
>>> Running the :
>>> ./nal2CKAN.sh /tmp/corporatebodies-skos.rdf
>>> followed by:
>>> ./ckan_update_publishers.sh
>>>
>>> produces this result which is what PO has said :
>>> 2013-09-26 11:18:02,554 INFO
>>> [/applications/ecodp/users/ecodp/ckan/ecportal/src/ckanext-ecportal-release-v1.8.1/ckanext/ecportal/plugin.pyc]
>>> Reading homepage content from
>>> /applications/ecodp/users/ecodp/ckan/ecportal/src/ckanext-ecportal/data/home.json
>>> 2013-09-26 11:18:02,555 INFO
>>> [/applications/ecodp/users/ecodp/ckan/ecportal/src/ckanext-ecportal-release-v1.8.1/ckanext/ecportal/plugin.pyc]
>>> Reading maintenance message from
>>> /applications/ecodp/users/ecodp/ckan/ecportal/src/ckanext-ecportal/data/maintenance.json
>>> 2013-09-26 11:18:06,505 INFO  [root] Creating CKAN publisher (group)
>>> objects
>>> 2013-09-26 11:18:06,518 DEBUG [ckan.logic.action.create] group_create
>>> validate_errs={'name': ['Group name already exists in database']}
>>> user=ecportal group=egsa data_dict={'type': u'organization', 'name':
>>> u'egsa', 'title': u'European GNSS Agency'}
>>> Traceback (most recent call last):
>>>   File "/applications/ecodp/users/ecodp/ckan/ecportal/bin/paster", line
>>> 9, in <module>
>>>     load_entry_point('PasteScript==1.7.5', 'console_scripts', 'paster')()
>>>   File
>>> "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/paste/script/command.py",
>>> line 104, in run
>>>     invoke(command, command_name, options, args[1:])
>>>   File
>>> "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/paste/script/command.py",
>>> line 143, in invoke
>>>     exit_code = runner.run(args)
>>>   File
>>> "/applications/ecodp/users/ecodp/ckan/ecportal/lib/python2.6/site-packages/paste/script/command.py",
>>> line 238, in run
>>>     result = self.command()
>>>   File
>>> "/applications/ecodp/users/ecodp/ckan/ecportal/src/ckanext-ecportal-release-v1.8.1/ckanext/ecportal/commands.py",
>>> line 109, in command
>>>     self.update_publishers(file_path)
>>>   File
>>> "/applications/ecodp/users/ecodp/ckan/ecportal/src/ckanext-ecportal-release-v1.8.1/ckanext/ecportal/commands.py",
>>> line 456, in update_publishers
>>>     self._add_publishers(new_publishers)
>>>   File
>>> "/applications/ecodp/users/ecodp/ckan/ecportal/src/ckanext-ecportal-release-v1.8.1/ckanext/ecportal/commands.py",
>>> line 213, in _add_publishers
>>>     plugins.toolkit.get_action('group_create')(context, group)
>>>   File
>>> "/applications/ecodp/users/ecodp/ckan/ecportal/src/ckan/ckan/logic/action/create.py",
>>> line 538, in group_create
>>>     raise ValidationError(errors)
>>> ckan.logic.ValidationError: {'Name': 'Group name already exists in
>>> database'}
>>>
>>>
>>> It would very kind to ssh that machine with password I can give you in skype
>>> and give us your perspective.
>>> Database of this mashine is on 192.168.35.137
>>>
>>> Best
>>> Dimitrios
>>>
>>
>>
>>
>> --
>> Bert Van Nuffelen
>>
>> Semantic Technologies Software Architect at TenForce
>> www.tenforce.be
>>
>> Bert.Van.Nuffelen at tenforce.com
>> Office: +32 (0)16 31 48 60
>> Mobile:+32 479 06 24 26
>> skype: bert.van.nuffelen
>>
>
>
>
> --
> Bert Van Nuffelen
>
> Semantic Technologies Software Architect at TenForce
> www.tenforce.be
>
> Bert.Van.Nuffelen at tenforce.com
> Office: +32 (0)16 31 48 60
> Mobile:+32 479 06 24 26
> skype: bert.van.nuffelen
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.okfn.org/mailman/private/ecodp-dev/attachments/20130926/5036cbbb/attachment.html>