Since the DAP updates posted on June 30 (here), our Canvas Data 2 integration with Microsoft SQL Server has not been completing properly. I followed the post's indication that only a dap snapshot —namespace canvas —table [tablenames] command would be needed, but that hasn't resolve the issue. Specifically, when performing a syncdb command on specific tables (e.g. "users") the operation failed, indicating that there was an error executing the query. I attempted to dap dropdb on the table and then dap initidb to recreate the table but the same error is occurring. Specifically, when the following initdb command is executed:
To diagnose further, I ran a MSSQL profiler session on the transaction, and it seems to indicate that there is incorrect syntax near ')'— though the query appeared to be valid to me:
I consulted LLMs for a possible solution, and it indicated that this is a possible issue with the pysqlsync library- and indicated that I should upgrade to pysqlsync 1.0 even though the instructure dap client wants version 0.8.4 (I decided not to follow this advice)
Anyone else seeing this issue with dap mssql? Any proposed fixes? Btw, running dap version 2.2.0. Many tables (e.g. account_users, assignments, courses, etc) are syncing without issues. Only a limited number of tables (e.g. users, roles, pseudonyms, grading_periods, etc) are having the issue.
