multi_term_batch_mode - "workflow_state": "aborted" and Terms not found.

Jump to solution
ember_ludwig
Community Explorer

Hi,

We're trying to switch a sis_import to use multi_term_batch_mode instead of batch_mode. It appears to work. However, we get two errors that I'm trying to figure out in case I'm missing something.

1) It is 100% complete, but has a "workflow_state": "aborted". All three files we upload, courses.csv, enrollments.csv, and users.csv are marked as "upload_status": "success".

2) There is an errors_attachment with a file. The final error is: "Terms not found. Terms must be included with multi_term_batch_mode". But, I can't find any explanation of this error. The terms are defined in Canvas.  Everything seems to work--the courses, enrollments, and users are all added.

Thanks for any insight,

Ember

{
"id": 9090909,
"created_at": "2023-09-12T20:48:57Z",
"started_at": "2023-09-12T20:49:01Z",
"ended_at": "2023-09-12T20:52:35Z",
"updated_at": "2023-09-12T20:52:35Z",
"progress": 100,
"workflow_state": "aborted",
"data": {
"import_type": "instructure_csv",
"downloadable_attachment_ids": [
442364123,
442364124,
442364125
],
"supplied_batches": [
"course",
"user",
"enrollment"
],
"counts": {
"change_sis_ids": 0,
"accounts": 0,
"terms": 0,
"abstract_courses": 0,
"courses": 1897,
"sections": 0,
"xlists": 0,
"users": 3191,
"logins": 0,
"enrollments": 13807,
"admins": 0,
"group_categories": 0,
"groups": 0,
"group_memberships": 0,
"grade_publishing_results": 0,
"user_observers": 0,
"error_count": 0,
"warning_count": 5
},
"running_immediately": false,
"completed_importers": [
"course",
"user",
"enrollment"
],
"statistics": {
"total_state_changes": 0,
"Account": {
"created": 0,
"restored": 0,
"deleted": 0
},
"EnrollmentTerm": {
"created": 0,
"restored": 0,
"deleted": 0
},
"AbstractCourse": {
"created": 0,
"restored": 0,
"deleted": 0
},
"Course": {
"created": 0,
"restored": 0,
"concluded": 0,
"deleted": 0
},
"CourseSection": {
"created": 0,
"restored": 0,
"deleted": 0
},
"GroupCategory": {
"created": 0,
"restored": 0,
"deleted": 0
},
"Group": {
"created": 0,
"restored": 0,
"deleted": 0
},
"Pseudonym": {
"created": 0,
"restored": 0,
"deleted": 0
},
"CommunicationChannel": {
"created": 0,
"restored": 0,
"deleted": 0
},
"Enrollment": {
"created": 0,
"restored": 0,
"concluded": 0,
"deactivated": 0,
"deleted": 0
},
"GroupMembership": {
"created": 0,
"restored": 0,
"deleted": 0
},
"UserObserver": {
"created": 0,
"restored": 0,
"deleted": 0
},
"AccountUser": {
"created": 0,
"restored": 0,
"deleted": 0
}
}
},
"batch_mode": true,
"batch_mode_term_id": null,
"multi_term_batch_mode": true,
"override_sis_stickiness": null,
"add_sis_stickiness": null,
"update_sis_id_if_login_claimed": false,
"clear_sis_stickiness": null,
"diffing_data_set_identifier": null,
"diffing_remaster": null,
"diffed_against_import_id": null,
"diffing_drop_status": null,
"diffing_user_remove_status": null,
"skip_deletes": false,
"change_threshold": 25,
"diff_row_count_threshold": null,
"processing_warnings": [
[
"courses.csv",
"Account not found \"SUBJ\" for course 123456"
],
[
"users.csv",
"An existing Canvas user with the SIS ID 9999999 has already claimed 9999999's user_id requested login information, skipping"
],
[
"enrollments.csv",
"User not found for enrollment (User ID: 9999999, Course ID: 123434, Section ID: )"
],
[
"enrollments.csv",
"User not found for enrollment (User ID: 9999999, Course ID: 123432, Section ID: )"
],
[
null,
"Terms not found. Terms must be included with multi_term_batch_mode"
]
],
"errors_attachment": {
"id": 999999999,
"uuid": "xxxx",
"folder_id": null,
"display_name": "sis_errors_attachment_9090909.csv",
"filename": "00000009090909_processing_warnings_and_errors2023-09-12205235UTC20230912.csv",
"upload_status": "success",
"content-type": "csv",
"url": "xxx",
"size": 602,
"created_at": "2023-09-12T20:52:35Z",
"updated_at": "2023-09-12T20:52:35Z",
"unlock_at": null,
"locked": false,
"hidden": false,
"lock_at": null,
"hidden_for_user": false,
"thumbnail_url": null,
"modified_at": "2023-09-12T20:52:35Z",
"mime_class": "file",
"media_entry_id": null,
"category": "uncategorized",
"locked_for_user": false
},
"user": {
"id": 4769734,
"name": "Keene Canvas Provisioning",
"created_at": "2021-08-04T10:13:12-04:00",
"sortable_name": "Keene Canvas Provisioning",
"short_name": "Keene Canvas Provisioning",
"sis_user_id": "keene-canvas-provisioning",
"integration_id": null,
"sis_import_id": null,
"root_account": "mycourses.keene.edu",
"login_id": "keene-canvas-provisioning"
},
"csv_attachments": [
{
"id": 442364123,
"uuid": "xxxx",
"folder_id": null,
"display_name": "courses.csv",
"filename": "courses.csv",
"upload_status": "success",
"content-type": "text/csv",
"url": "xxx",
"size": 146168,
"created_at": "2023-09-12T20:49:01Z",
"updated_at": "2023-09-12T20:49:01Z",
"unlock_at": null,
"locked": false,
"hidden": false,
"lock_at": null,
"hidden_for_user": false,
"thumbnail_url": null,
"modified_at": "2023-09-12T20:49:01Z",
"mime_class": "file",
"media_entry_id": null,
"category": "uncategorized",
"locked_for_user": false
},
{
"id": 442364124,
"uuid": "xxxx",
"folder_id": null,
"display_name": "enrollments.csv",
"filename": "enrollments.csv",
"upload_status": "success",
"content-type": "text/csv",
"url": "xxx",
"size": 704322,
"created_at": "2023-09-12T20:49:02Z",
"updated_at": "2023-09-12T20:49:02Z",
"unlock_at": null,
"locked": false,
"hidden": false,
"lock_at": null,
"hidden_for_user": false,
"thumbnail_url": null,
"modified_at": "2023-09-12T20:49:02Z",
"mime_class": "file",
"media_entry_id": null,
"category": "uncategorized",
"locked_for_user": false
},
{
"id": 442364125,
"uuid": "xxxx",
"folder_id": null,
"display_name": "users.csv",
"filename": "users.csv",
"upload_status": "success",
"content-type": "text/csv",
"url": "xxx",
"size": 218839,
"created_at": "2023-09-12T20:49:02Z",
"updated_at": "2023-09-12T20:49:02Z",
"unlock_at": null,
"locked": false,
"hidden": false,
"lock_at": null,
"hidden_for_user": false,
"thumbnail_url": null,
"modified_at": "2023-09-12T20:49:02Z",
"mime_class": "file",
"media_entry_id": null,
"category": "uncategorized",
"locked_for_user": false
}
]
}
Labels (1)
0 Likes
1 Solution

Hi @ember_ludwig,

I'm interpreting this sentence under the "Multi Term Batch Mode" heading: "Multi term batch mode is run against all terms included in the same import for the batch" (this is a very generic statement and should probably be improved in the future).  Then also the final error message you're receiving: "Terms not found. Terms must be included with multi_term_batch_mode".  The SIS Import API documentation also states the following: "multi_term_batch_mode boolean Runs batch mode against all terms in terms file. Requires change_threshold." All of those together lead me to believe you need the terms file to be included in your batch for the multi term batch mode to correctly operate.  I could be wrong, but I strongly suspect this is the case.

-Chris

View solution in original post

0 Likes