DAP initdb error: expected UUID

AndreDhondt
Community Member

When running the following from the command-line, I get an error that prevents me from synchronizing the collaborations table:

>dap initdb --namespace canvas --table collaborations

2025-02-12 14:16:09,376 - INFO - Query started with job ID: 5bb1d1c0-595b-4bfb-8bdb-feb74c21f521
2025-02-12 14:16:09,516 - INFO - Data has been successfully retrieved...

...

"ERROR - expected: a UUID string of 32 hexadecimal digits, or a UUID in the 8-4-4-4-12 format; got" ... "(len = 40)"

 

This fails both for syncdb and initdb. Any suggestions? 

 

When running it from an automated process I get the following stack trace:

 

Traceback (most recent call last):
  File "/var/task/app.py", line 51, in lambda_handler
    asyncio.get_event_loop().run_until_complete(
  File "/var/lang/lib/python3.11/asyncio/base_events.py", line 654, in run_until_complete
    return future.result()
           ^^^^^^^^^^^^^^^
  File "/var/task/app.py", line 67, in init_table
    await SQLReplicator(session, db_connection).initialize(namespace, table_name)
  File "/var/task/dap/replicator/sql.py", line 54, in initialize
    await init_op.run()
  File "/var/task/dap/replicator/sql_op_init.py", line 70, in run
    await self.init_insert_data_from_files_to_db(
  File "/var/task/dap/replicator/sql_op_init.py", line 109, in init_insert_data_from_files_to_db
    rows = await reader.read_records()
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/var/task/pysqlsync/data/exchange.py", line 197, in read_records
    rows.append(self.parser.parse_line(record))
                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/var/task/tsv/helper.py", line 204, in parse_line
    return parser.parse_line(self._format, line)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
ValueError: expected: a UUID string of 32 hexadecimal digits, or a UUID in the 8-4-4-4-12 format; got: ... (len = 40)
Labels (2)
0 Likes