Hi Ruimin, would you be able to show a small piece of your .arches file? The validation tool could be missing something. Also, do the resources actually get loaded into the database, or does the error happen before that?
Cheers, Adam On Wednesday, November 18, 2015 at 8:54:54 PM UTC-6, Ruimin Zhang wrote: > > 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 [email protected]. To unsubscribe, send email to [email protected]. 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
