search

EMU-CFE / CanvasDataViewer

CanvasDataViewer is used to automatically download Canvas Data files into a SQL Server database where you can query and analyze the information.
29 stars 8 forks source link

No data loading #1

Open brianmullinsbsd opened 8 years ago

brianmullinsbsd commented 8 years ago

Hello,

I'm trying to get this working here and it looks to be doing everything except actually loading the file data into the tables. I don't see any code that looks like it should do that piece, and I'm wondering if it just isn't finished? I am getting the records in the [dbo].[RAWSchemaKey] and [dbo].[RAWSchemaVal] tables, but the actual dim and fact tables are not loading.

Thanks for any help.

Brian

wjones20 commented 8 years ago

Brian,

I'm so glad you asked your question--the README document is incomplete. So, if you look inside the CanvasData database in CanvasData/Programmability/Stored Procedures there are two procedures to run:

  1. dbo.CanvasData_DownloadLatestSchemaAndTables
  2. dbo.CanvasData_TableBuild

Run the first one and let it finish (it downloads all the files, pops fresh schema info into tables, and unzips the files into the unzipped folder). This could take a while since you're doing a fresh download. Then run the second procedure--TableBuild. It uses the sub-procedures labelled 01 thru 06 and completes the entire process. For us it usually takes two hours to complete.

If these run ok then you can set up a Job Agent in SQL Server to run them. I think we run the first one at 1AM and the second one at 3AM so each has time to complete.

I'll keep an eye out if you have other questions. And we'll update the README doc.

Thanks! Bill

brianmullinsbsd commented 8 years ago

Hi Bill,

Thanks for the speedy reply! I found the procedures, and ran the first one sucessfully. However, when I run the second one i'm getting the following error:

Msg 512, Level 16, State 1, Procedure CanvasData_TableBuild_00_CreateCanvasDataTableFields, Line 60 [Batch Start Line 2] Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. The statement has been terminated.

I pulled the first 100 or so lines of the procedure out and found that the following query that populates ##kvtable had sub-queries returning multiple rows. I got it to run by adding top 1 to sub-queries building the following fields: ImportType ImportLength ProductionType ProductionLength SegmentA SegmentB FieldDescription

Will I be OK leaving the Top's in there, or is there something else happening that is putting the underlying data in an unexpected state?

Thanks again for your help!

Brian

brianmullinsbsd commented 8 years ago

Another update: I truncated all the tables and re-ran the two procs. First one finished fine, second one spit out a bunch of errors:

Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 208, Level 16, State 82, Line 3 Invalid object name 'CanvasData.dbo.import_pseudonym_fact'. Msg 208, Level 16, State 82, Line 3 Invalid object name 'CanvasData.dbo.importuser'. Msg 105, Level 15, State 1, Line 3 Unclosed quotation mark after the character string 'import[object Object]; '. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'import_[object Object]; '. Msg 103, Level 15, State 4, Line 3 The identifier that starts with 'import_Attributes for groups in canvas. Groups contain two or more students enrolled in a particular course working on an assign' is too long. Maximum length is 128. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'unpublished'. Msg 103, Level 15, State 4, Line 3 The identifier that starts with 'import_Denotes where the quiz question is in the workflow. Possible values are 'unpublished', 'published' and 'deleted'. Default' is too long. Maximum length is 128. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'hide_results'. Msg 103, Level 15, State 4, Line 3 The identifier that starts with 'import_Dictates whether the browser has to be locked-down to display the results. Is valid only if 'hide_results' is set to 'nev' is too long. Maximum length is 128. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 's'. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 's'. Msg 4145, Level 15, State 1, Line 3 An expression of non-boolean type specified in a context where a condition is expected, near 'account'. Msg 4145, Level 15, State 1, Line 3 An expression of non-boolean type specified in a context where a condition is expected, near 'account'. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 's'. Msg 1088, Level 16, State 12, Line 3 Cannot find the object "dbo.256" because it does not exist or you do not have permissions.

I suspect I'm still doing something wrong.

Thanks,

Brian

wjones20 commented 8 years ago

Brian,

Hmm...try this:

1) Delete the CanvasData database in SQL Server (right-click on it and delete) 2) Re-run Step 8 in the README instructions. (Do Not re-run Step 9) 3) In the CanvasData database run the two stored procedures again (DownloadLatestSchemaAndTables, and TableBuild)

Let me know how that runs.

Thanks, Bill

brianmullinsbsd commented 8 years ago

Hey Bill,

Still errors on the second script, but some different info:

Msg 512, Level 16, State 1, Procedure CanvasData_TableBuild_02LoadImportTables, Line 38 [Batch Start Line 2] Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. The statement has been terminated. Msg 105, Level 15, State 1, Line 3 Unclosed quotation mark after the character string 'import[object Object]; '. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'import_[object Object]; '. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 's'. Msg 156, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'set'. Msg 4145, Level 15, State 1, Line 3 An expression of non-boolean type specified in a context where a condition is expected, near ')'. Msg 156, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'set'. Msg 4145, Level 15, State 1, Line 3 An expression of non-boolean type specified in a context where a condition is expected, near ')'. Msg 103, Level 15, State 4, Line 3 The identifier that starts with 'import_Foreign key in user_dim for the user that made the request. If the request was made by one user masquerading as another, ' is too long. Maximum length is 128. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 's'. Msg 4145, Level 15, State 1, Line 3 An expression of non-boolean type specified in a context where a condition is expected, near 'account'. Msg 4145, Level 15, State 1, Line 3 An expression of non-boolean type specified in a context where a condition is expected, near 'account'. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'discussion_topic'. Msg 103, Level 15, State 4, Line 3 The identifier that starts with 'import_Type of submission. Possible values are 'discussion_topic', 'external_tool', 'media_recording', 'online_file_upload', 'on' is too long. Maximum length is 128. Msg 156, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'or'. Msg 105, Level 15, State 1, Line 3 Unclosed quotation mark after the character string 'active]; '. Msg 1088, Level 16, State 12, Line 3 Cannot find the object "dbo.(Not implemented) Foreign key to group category dimension table." because it does not exist or you do not have permissions.

Thanks,

Brian

wjones20 commented 8 years ago

Brian,

Bizarre. Ok, so during the 01CreateImportTable process it uses the dbo.CanvasDataTableFields table to create each import table. At some point during that process the FieldDescription text is getting sucked into either the table name. Can you refresh the table names and see if some of the import_ tables have bloated names like that? Also, can you Select Top 1000 Rows from the dbo.CanvasDataTableFields and see if those records look in good order?

If that's what's happening then I'm kind of surprised that the 01_CreateImportTable process can even finish so it can advance to the 02_LoadImportTable process.

Thanks, Bill

brianmullinsbsd commented 8 years ago

Actual database table names look correct. In dbo.CanvasDataTableFields I have table names that don't make sense. It looks like maybe the schema data isn't getting parsed into that table correctly. Here's a distinct on TableName from there:

(

  1. Not implemented) Foreign key to group category dimension table.
  2. [object Object]
  3. 256
  4. account
  5. account_dim
  6. assignment_group_rule_dim
  7. assignment_id
  8. assignment_override_fact
  9. bigint
  10. can_manually_enroll
  11. canvas_id
  12. conversation_message_id
  13. course_id
  14. course_ui_canvas_navigation_id
  15. Dictates whether correct answers are shown when are results are viewed. It's valid only if 'show_results' is set to 'always'. Possible values are 'always', 'never', 'only_once_after_last_attempt' and 'always_after_last_attempt' (Last two are only valid if 'dw_quiz_fact.allowed_attempts > 1') which have a behavior similar to 'show_results'. Defaults to 'always'. Equivalent Canvas API field -> 'show_correct_answers' combined with 'show_correct_answers_last_attempt'.
  16. Enrollment ID if this a valid role for the user in the course, else NULL.
  17. enrollment_rollup
  18. extra_time
  19. fact
  20. false
  21. Foreign key in user_dim for the user that made the request. If the request was made by one user masquerading as another, then this column contains the ID of the user being masqueraded as.
  22. Foreign key to the account of the course this submission belongs to.
  23. Foreign key to the assignment group dimension table.
  24. Foreign key to the course associated with this assignment.
  25. grader_id
  26. group_membership_id
  27. id
  28. last_login_ip
  29. Name of this account's parent at subaccount level 8. If this account is a level 8 account, subaccount8 will be the name of this account.
  30. Original ID for canvas table.
  31. subject
  32. text
  33. The new due_at date-time for this group of users.
  34. The parent account for this course.
  35. timestamp
  36. Type of submission. Possible values are 'discussion_topic', 'external_tool', 'media_recording', 'online_file_upload', 'online_quiz', 'online_text_entry', 'online_upload' and 'online_url'.
  37. Unique surrogate id for the user and the course.
  38. unlock_at
  39. user
  40. user_id
  41. varchar
  42. wiki_dim
  43. wiki_fact
  44. wiki_id
  45. wiki_page_dim
  46. wiki_page_fact
  47. Workflow status indicating that account is [deleted] or [active]
  48. workflow_state

Thanks again,

Brian

brianmullinsbsd commented 8 years ago

OK, i've been doing some more digging in the [CanvasData_TableBuild_00_CreateCanvasDataTableFields] procedure. The code that builds the ##kvindexes temp table looks to be broken. when I run this code

SELECT distinct KeyValue FROM ##kvindexes where keyName = 'tableName' ORDER BY KeyString

I get the same list as in my previous comment.

It's looking to me like the RawSchemaKey and/or RawSchemaVal tables are not getting built right.

Brian

brianmullinsbsd commented 8 years ago

Sorry to spam the thread!

OK, so I've done some more digging. In the RawSchemaKey and RawSchemaVal tables there is an ID field, and in the [CanvasData_DownloadLatestSchemaAndTables] sproc you are correlating the two tables on this ID field. However, the insert done in CanvasData_Schema_Latest.js into those two tables doesn't seem to keep the data in sync by that ID. Keep in mind that I'm a JS novice, but since there's ordering in the select you can't guarantee that the rows go into the table in the same order they appear in the array. This would break the correlation.

Am I on the right track?

Thanks,

Brian

wjones20 commented 8 years ago

Brian,

You're on the right track. I'm attaching an Excel file that includes the tables as we have them downloaded. Can you make up a similar Excel file of your tables and post them up here so I can see at what stage the data gets messed up? These are just schema so there isn't any PII from Canvas in this.

Thanks, Bill CanvasData_schema_output_111716.xlsx

brianmullinsbsd commented 8 years ago

Hey Bill,

Here's what my tables look like.

Brian BSD CanvasData Schema.xlsx

wjones20 commented 8 years ago

Excellent--thanks. We're working on troubleshooting it. It may be tomorrow before we find something. --B

brianmullinsbsd commented 8 years ago

Thanks Bill. No rush.

wjones20 commented 8 years ago

Brian,

We re-ran it on our side and it's coming out ok. Would you be open to a phone call to have you poke around on your side? If so please send an email address or email Andrew Anders (aanders at emich edu).

Thanks, Bill

brianmullinsbsd commented 8 years ago

Wierd. I'd be more than happy to do a phone call. I'm only here part of today and out all next week, so I'll contact Andrew the following week.

Thanks again,

Brian

irshaada commented 8 years ago

Hello Brian, Bill,

We have just begun to review CanvasDataViewer and are very interested setting up this tool at our institution. I'd love to join you all on your call. My contact info irshaad(dot)alha(at)utt(dot)edu(dot)tt

Thanks,

Irshaad

wjones20 commented 8 years ago

Irshaada -- We'd be happy to set up a call. I'm out of the office tomorrow but let's connect next week (wjones20 at emich dot edu) Happy Thanksgiving to all, Bill

irshaada commented 8 years ago

Sounds good. Thanks Bill. Happy Thanksgiving!

Irshaad

omshiv2415 commented 7 years ago

Hello Everyone I am having the same issue. I have followed all the process correctly. but some reason it is not loading data correctly. It downloads the data and schema but not inserting the data. it throws the following errors.

Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'object Object'. Msg 319, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. BEFORE TRY Loading file: Msg 208, Level 16, State 82, Line 3 Invalid object name 'CanvasDataStore.dbo.import_account'. BEFORE TRY Loading file: Msg 208, Level 16, State 82, Line 3 Invalid object name 'CanvasDataStore.dbo.import_account'. BEFORE TRY Loading file: Msg 208, Level 16, State 82, Line 3 Invalid object name 'CanvasDataStore.dbo.import_account'. BEFORE TRY Loading file: Msg 208, Level 16, State 82, Line 3 Invalid object name 'CanvasDataStore.dbo.import_course_section'. BEFORE TRY Loading file: Msg 208, Level 16, State 82, Line 3 Invalid object name 'CanvasDataStore.dbo.import_course_section'. BEFORE TRY Loading file: Msg 208, Level 16, State 82, Line 3 Invalid object name 'CanvasDataStore.dbo.import_course_section'. BEFORE TRY Loading file: Msg 208, Level 16, State 82, Line 3 Invalid object name 'CanvasDataStore.dbo.import_course_section'. BEFORE TRY Loading file: Msg 208, Level 16, State 82, Line 3 Invalid object name 'CanvasDataStore.dbo.import_enrollment_term'. BEFORE TRY Loading file: Msg 208, Level 16, State 82, Line 3 Invalid object name 'CanvasDataStore.dbo.import_enrollment_term'. BEFORE TRY Loading file: Msg 208, Level 16, State 82, Line 3 Invalid object name 'CanvasDataStore.dbo.import_enrollment_term'. BEFORE TRY Loading file: Msg 208, Level 16, State 82, Line 3 Invalid object name 'CanvasDataStore.dbo.import_wiki_fact'. BEFORE TRY Loading file: Msg 208, Level 16, State 82, Line 3 Invalid object name 'CanvasDataStore.dbo.import_wiki_fact'. BEFORE TRY Loading file: Msg 208, Level 16, State 82, Line 3 Invalid object name 'CanvasDataStore.dbo.import_wiki_fact'. BEFORE TRY Loading file: Msg 208, Level 16, State 82, Line 3 Invalid object name 'CanvasDataStore.dbo.import_wiki_fact'. BEFORE TRY Loading file: Msg 208, Level 16, State 82, Line 3 Invalid object name 'CanvasDataStore.dbo.import_wikifact'. Msg 103, Level 15, State 4, Line 3 The identifier that starts with 'import(Not implemented) Foreign key to the group categories table of the group this wiki page is associated with. Otherwise thi' is too long. Maximum length is 128. Msg 105, Level 15, State 1, Line 3 Unclosed quotation mark after the character string 'import[object Object]; '. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'import[object Object]; '. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'Page'. Msg 103, Level 15, State 4, Line 3 The identifier that starts with 'import_Table contains measures related to students for whom an assignment override exists. This table contains the user ids of ' is too long. Maximum length is 128. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'NoPermissions'. Msg 1088, Level 16, State 12, Line 3 Cannot find the object "dbo.assignment_id" because it does not exist or you do not have permissions.

I need help. if you have fixed the problem.

Thanks Viralkumar

SmruthiMadhugiri commented 6 years ago

Hi all, We have just started implementing this at our college. Anyone find the solution?

ghost commented 6 years ago

Having same issue, looking for a solution as well

SmruthiMadhugiri commented 6 years ago

Hi all - I think I might have a work around.

The issue looks like its from the java script code which gets called when we run the CanvasData_General_DownloadSchemaAndTables. It rewrites the rawschemKey table and rawschemaval table and somewhere the parsing is incorrect and the names of tables are incorrect. Which is why we are getting the error. The work around I have is to run the CanvasDataStore sql file again to rewrite the rawschema tables after the CanvasData_General_DownloadSchemaAndTables. and then run the CanvasData_General_tableBuild.

This way I am able to run the tableBuild without any errors. I am not sure by rerunning the canvasdatastore file again if I am editing any other config. But looks to be working without any errors for now. I still have to test the data. but thought I would just post my solution here if anyone else has any other input.

Thanks, Smruthi