DAP initdb error: expected UUID

[AndreDhondt]

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)

[reynlds]

I'm getting the same thing. Failing on any action on the collaborations table. I don't need to post any errors as it's been done above. Just started for me during my mid-day syncdb

[stimme]

Thanks for reporting this. I saw a similar error when I tried to run initdb for canvas.collaborations. The DAP set the wrong data type for canvas.collaborations.uuid in Postgres. The values in for the field use the entire alphabet, but the PostGres UUID data type expects hexadecimal (as the error states). This could be resolved if Instructure updates the schema so that the column's data type is text or varchar.

[sgergely]

This is more than embarrassing. We are on it, thanks for reporting.

[sgergely · Accepted solution]

The fix has been released and it should work now. Sorry for the inconvenience!

[stimme]

The fix worked for me. Thanks for your rapid resolution, @sgergely !

[reynlds]

Same here...thanks!