[ECODP-dev] Problem with updating the nal list
Dimitrios Mexis
dimitrios.mexis at tenforce.com
Thu Sep 26 10:56:45 UTC 2013
Hi John,
the database back up is under the /home/PO.ftp/odp folder
and currently it is running there
Regards
Dimitrios
On 26/09/2013 12:54, John Glover wrote:
> 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
> <mailto: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
> <mailto: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
> <mailto: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 resultwhich 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 <http://www.tenforce.be>
>
> Bert.Van.Nuffelen at tenforce.com
> <mailto:Bert.Van.Nuffelen at tenforce.com>
> Office: +32 (0)16 31 48 60 <tel:%2B32%20%280%2916%2031%2048%2060>
> Mobile:+32 479 06 24 26 <tel:%2B32%20479%2006%2024%2026>
> skype: bert.van.nuffelen
>
>
>
>
> --
> Bert Van Nuffelen
>
> Semantic Technologies Software Architect at TenForce
> www.tenforce.be <http://www.tenforce.be>
>
> Bert.Van.Nuffelen at tenforce.com <mailto:Bert.Van.Nuffelen at tenforce.com>
> Office: +32 (0)16 31 48 60 <tel:%2B32%20%280%2916%2031%2048%2060>
> Mobile:+32 479 06 24 26 <tel:%2B32%20479%2006%2024%2026>
> skype: bert.van.nuffelen
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.okfn.org/mailman/private/ecodp-dev/attachments/20130926/0204091f/attachment.html>
More information about the ecodp-dev
mailing list