Hi Aadam, Which table should I look into? My arches file only contains one resource as below:
****************************************** .arches file****************************************************************************** RESOURCEID|RESOURCETYPE|ATTRIBUTENAME|ATTRIBUTEVALUE|GROUPID RESOURCEID_1|HERITAGE_RESOURCE.E18|RESOURCE_TYPE_CLASSIFICATION.E55|RESOURCE_TYPE_CLASSIFICATION.E55_2| RESOURCEID_1|HERITAGE_RESOURCE.E18|RESOURCE_CLASSIFICATION_AUTHORITY_DOCUMENT.E32|RESOURCE_TYPE_CLASSIFICATION.E55.csv| RESOURCEID_1|HERITAGE_RESOURCE.E18|NAME.E41|A Mine resource |NAME.E41_01 RESOURCEID_1|HERITAGE_RESOURCE.E18|NAME_TYPE.E55|NAME_TYPE.E55_5|NAME.E41_01 RESOURCEID_1|HERITAGE_RESOURCE.E18|NAME.E41|A Mine resource No. 2 Shaft|NAME.E41_02 RESOURCEID_1|HERITAGE_RESOURCE.E18|NAME_TYPE.E55|NAME_TYPE.E55_1|NAME.E41_02 RESOURCEID_1|HERITAGE_RESOURCE.E18|NAME_TYPE_AUTHORITY_DOCUMENT.E32|NAME_TYPE.E55.csv| RESOURCEID_1|HERITAGE_RESOURCE.E18|DESCRIPTION.E62|city|DESCRIPTION.E62_00 RESOURCEID_1|HERITAGE_RESOURCE.E18|DESCRIPTION_TYPE.E55|DESCRIPTION_TYPE_AUTHORITY_DOCUMENT.E32_08|DESCRIPTION.E62_00 RESOURCEID_1|HERITAGE_RESOURCE.E18|ADMINISTRATIVE_SUBDIVISION.E48|MI|ADMINISTRATIVE_SUBDIVISION.E48_01 RESOURCEID_1|HERITAGE_RESOURCE.E18|ADMINISTRATIVE_SUBDIVISION_TYPE.E55|ADMINISTRATIVE_SUBDIVISION_TYPE_AUTHORITY_DOCUMENT.E32_1|ADMINISTRATIVE_SUBDIVISION.E48_01 RESOURCEID_1|HERITAGE_RESOURCE.E18|ADMINISTRATIVE_SUBDIVISION.E48|Keweenaw|ADMINISTRATIVE_SUBDIVISION.E48_02 RESOURCEID_1|HERITAGE_RESOURCE.E18|ADMINISTRATIVE_SUBDIVISION_TYPE.E55|ADMINISTRATIVE_SUBDIVISION_TYPE_AUTHORITY_DOCUMENT.E32_2|ADMINISTRATIVE_SUBDIVISION.E48_02 RESOURCEID_1|HERITAGE_RESOURCE.E18|PLACE_ADDRESS.E45|First Street,Ahmeek| RESOURCEID_1|HERITAGE_RESOURCE.E18|DESCRIPTION.E62|some text description here.|DESCRIPTION.E62_01 RESOURCEID_1|HERITAGE_RESOURCE.E18|DESCRIPTION_TYPE.E55|DESCRIPTION_TYPE_AUTHORITY_DOCUMENT.E32_02|DESCRIPTION.E62_01 RESOURCEID_1|HERITAGE_RESOURCE.E18|DESCRIPTION.E62|Machine shop, Warehouse, Dryhouse|DESCRIPTION.E62_02 RESOURCEID_1|HERITAGE_RESOURCE.E18|DESCRIPTION_TYPE.E55|DESCRIPTION_TYPE_AUTHORITY_DOCUMENT.E32_04|DESCRIPTION.E62_02 RESOURCEID_1|HERITAGE_RESOURCE.E18|DESCRIPTION.E62|Brick|DESCRIPTION.E62_03 RESOURCEID_1|HERITAGE_RESOURCE.E18|DESCRIPTION_TYPE.E55|DESCRIPTION_TYPE_AUTHORITY_DOCUMENT.E32_05|DESCRIPTION.E62_03 RESOURCEID_1|HERITAGE_RESOURCE.E18|DESCRIPTION.E62|Masonry, Steel-framed|DESCRIPTION.E62_04 RESOURCEID_1|HERITAGE_RESOURCE.E18|DESCRIPTION_TYPE.E55|DESCRIPTION_TYPE_AUTHORITY_DOCUMENT.E32_06|DESCRIPTION.E62_04 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.
