[ECODP-dev] Problem with updating the nal list

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>