No problem, glad that helped. On Thu, Nov 19, 2015 at 10:37 AM, Ruimin Zhang <[email protected]> wrote:
> It's awesome, Adam, once I delete the lines your mentioned to be wrong. It > is successfully loaded into the database and I can search the resource from > arches website search box. Thanks so much!! > > Ruimin > > On Wednesday, November 18, 2015 at 9:54:54 PM UTC-5, 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. > -- -- 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.
