Hi,
I just started to use arches and arches-hip. I have installed arches 3.0
and arches-hip package. I successfully load a few authority files. However,
when I loaded my .arches file, it passed validation and started loading
resources. At the end, it showed an error message:
"django.db.utils.DataError: invalid input syntax for uuid: ""
LINE 1: ..."."languageid" FROM "values" WHERE "values"."valueid" = E''"
I didn't set any languageid. I don't know what's going on. I try to remove
the database and recreate a new clean database and reload the authority
files and .arches files. But the same error comes. Does anybody know why is
it? I copy the whole error message as below
***********************************************************************************************ERROR
MESSAGE*********************************************************************************************************************************
(ENV)judy@judy-ThinkPad-S1-Yoga:~/Documents/arches-projects-new/martin_hip_app$
python manage.py packages -o load_resources -s
'./martin_hip_app/source_data/business_data/martin.arches'
operation: load_resources
package: martin_hip_app
loading: ./martin_hip_app/source_data/business_data/martin.arches
VALIDATING ARCHES FILE
(./martin_hip_app/source_data/business_data/martin.arches)
Validation of your Arches file took: 0.000748157501221 seconds.
Validation of your business data took: 0.0002760887146 seconds.
LOADING RESOURCES (./martin_hip_app/source_data/business_data/martin.arches)
time to parse ./martin_hip_app/source_data/business_data/martin resources =
0.000653982162476
Traceback (most recent call last):
File "manage.py", line 28, in <module>
execute_from_command_line(sys.argv)
File
"/home/judy/Documents/arches-projects-new/ENV/local/lib/python2.7/site-packages/django/core/management/__init__.py",
line 399, in execute_from_command_line
utility.execute()
File
"/home/judy/Documents/arches-projects-new/ENV/local/lib/python2.7/site-packages/django/core/management/__init__.py",
line 392, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File
"/home/judy/Documents/arches-projects-new/ENV/local/lib/python2.7/site-packages/django/core/management/base.py",
line 242, in run_from_argv
self.execute(*args, **options.__dict__)
File
"/home/judy/Documents/arches-projects-new/ENV/local/lib/python2.7/site-packages/django/core/management/base.py",
line 285, in execute
output = self.handle(*args, **options)
File
"/home/judy/Documents/arches-projects-new/ENV/local/lib/python2.7/site-packages/arches/management/commands/packages.py",
line 91, in handle
self.load_resources(package_name, options['source'])
File
"/home/judy/Documents/arches-projects-new/ENV/local/lib/python2.7/site-packages/arches/management/commands/packages.py",
line 307, in load_resources
load(data_source)
File
"/home/judy/Documents/arches-projects-new/martin_hip_app/martin_hip_app/setup.py",
line 15, in load_resources
setup.load_resources(external_file)
File
"/home/judy/Documents/arches-projects-new/ENV/local/lib/python2.7/site-packages/arches_hip/setup.py",
line 82, in load_resources
rl.load(external_file)
File
"/home/judy/Documents/arches-projects-new/ENV/local/lib/python2.7/site-packages/arches/app/utils/data_management/resources/importer.py",
line 67, in load
results = self.resource_list_to_entities(resources, archesjson)
File
"/home/judy/Documents/arches-projects-new/ENV/local/lib/python2.7/site-packages/arches/app/utils/data_management/resources/importer.py",
line 112, in resource_list_to_entities
master_graph.index()
File
"/home/judy/Documents/arches-projects-new/ENV/local/lib/python2.7/site-packages/arches/app/models/resource.py",
line 305, in index
search_documents = self.prepare_documents_for_search_index()
File
"/home/judy/Documents/arches-projects-new/ENV/local/lib/python2.7/site-packages/arches_hip/models/resource.py",
line 156, in prepare_documents_for_search_index
documents = super(Resource, self).prepare_documents_for_search_index()
File
"/home/judy/Documents/arches-projects-new/ENV/local/lib/python2.7/site-packages/arches/app/models/resource.py",
line 343, in prepare_documents_for_search_index
value = archesmodels.Values.objects.get(pk=entity.value)
File
"/home/judy/Documents/arches-projects-new/ENV/local/lib/python2.7/site-packages/django/db/models/manager.py",
line 151, in get
return self.get_queryset().get(*args, **kwargs)
File
"/home/judy/Documents/arches-projects-new/ENV/local/lib/python2.7/site-packages/django/db/models/query.py",
line 301, in get
num = len(clone)
File
"/home/judy/Documents/arches-projects-new/ENV/local/lib/python2.7/site-packages/django/db/models/query.py",
line 77, in __len__
self._fetch_all()
File
"/home/judy/Documents/arches-projects-new/ENV/local/lib/python2.7/site-packages/django/db/models/query.py",
line 854, in _fetch_all
self._result_cache = list(self.iterator())
File
"/home/judy/Documents/arches-projects-new/ENV/local/lib/python2.7/site-packages/django/db/models/query.py",
line 220, in iterator
for row in compiler.results_iter():
File
"/home/judy/Documents/arches-projects-new/ENV/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py",
line 709, in results_iter
for rows in self.execute_sql(MULTI):
File
"/home/judy/Documents/arches-projects-new/ENV/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py",
line 782, in execute_sql
cursor.execute(sql, params)
File
"/home/judy/Documents/arches-projects-new/ENV/local/lib/python2.7/site-packages/django/db/backends/util.py",
line 69, in execute
return super(CursorDebugWrapper, self).execute(sql, params)
File
"/home/judy/Documents/arches-projects-new/ENV/local/lib/python2.7/site-packages/django/db/backends/util.py",
line 53, in execute
return self.cursor.execute(sql, params)
File
"/home/judy/Documents/arches-projects-new/ENV/local/lib/python2.7/site-packages/django/db/utils.py",
line 99, in __exit__
six.reraise(dj_exc_type, dj_exc_value, traceback)
File
"/home/judy/Documents/arches-projects-new/ENV/local/lib/python2.7/site-packages/django/db/backends/util.py",
line 53, in execute
return self.cursor.execute(sql, params)
django.db.utils.DataError: invalid input syntax for uuid: ""
LINE 1: ..."."languageid" FROM "values" WHERE "values"."valueid" = E''
^
--
-- To post, send email to archesproject@googlegroups.com. To unsubscribe, send
email to archesproject+unsubscr...@googlegroups.com. For more information,
visit https://groups.google.com/d/forum/archesproject?hl=en
---
You received this message because you are subscribed to the Google Groups
"Arches Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to archesproject+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
