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.

Reply via email to