We are getting this error today when syncing the web_logs table and the sync fails. I have never seen this one.
'invalid input value for enum canvas_logs.web_logs__web_application_context_type: "SisBatch"'
Has anyone else seen this?
@GergelySchmidt
The enum data type here is called web_application_context_type. The values contained in this type are listed below. According to the web_logs files I downloaded, beginning on 3/26 we started receiving an entry call SisBatch. This is causing the syncdb failure we're now getting because it is not one of the defined values.
"Account" "AssessmentQuestion" "Assignment" "ContentMigration" "Course" "CourseSection" "Group" "Quizzes::QuizSubmission" "StudentEnrollment" "User" "UserProfile"
@Gergely Schmidt
Hi Steven, I got the exactly same error message as yours since March 26. Have tried the solutions below, neither works. (1) manually added this value 'SisBatch' to the type - 'web_application_context_type' by using ALTER TYPE command (2) upgraded the instructure_dap_client to the latest version - v.2.2.0. @Gergely Can you take a look at this issue and show us some guidelines? Thanks -Stephen S.
I have a support ticket open on this issue, I was told they were able to "locate an example" of this issue and it was passed on to the Product and Engineering team.
Steven, Many thanks for the update. Hopefully, Instructure team can solve this issue quickly. -Stephen S.
Hello team!
Sorry for breaking the schema. We have got Steven's support ticket and the team has identified the issue and we are prepping for a fix to be deployed.
We are going to extend the web_application_context_type with the "Sisbatch" value. The plan is that we are going to push the new schema to production on April 27. Please note this date is not a promise, things can slip here and there.
Ok, thanks. Are you going to give a heads up when it is deployed? The catch up on this is going to take a long time..
Hi Gergely, Many thanks for confirming this issue and putting the fix on your release schedule.
However, both Mr. Walls and I noticed this issue on March 26. If the fix is released on April 27 or later, it will be more than 30 days. Are we still able to use 'dap syncdb' command to download the canvas_logs.web_logs data earlier than 30 days? If not, any suggestions? Thanks!
Thank you both for raising this issue. I have the same question regarding the 30-day retention window. Following for updates - thanks.
Hello, the post is out, it is going to be released on April 27.
Gergely, can you please answer the question concerning the 30 day retention window? Will we be able to catch up the web_logs db since it will not have been updated in over 30 days?
On the new_quizzes.quizzes table, all of my institution's records have either "unpublished" or "uninitialized" values in the workflow_state column. The documentation for this type lists "published" as a possible value. It seems like all of my institution's published New Quizzes have the "uninitialized" value. What does…
EDUCAUSE is full of inspiration, whether you’re onsite or following from afar. Join the evolution by sharing what sparks your curiosity, the questions you have, and the insights you discover. We'll learn from each other, expand our networks, and strengthen our Community. Your perspective matters, and the more we share,…
Prompted by the most recent Canvas release notes, we looked into the Page Views feature, and we were happy with the new documented changes. However, we notice that more user actions are done by GraphQL API, which does not provide details in the page view report, either in the GUI or in the CSV file download. We and most…
I am currently teaching five courses this semester with more than 70 students. To track their progress, I currently have to review each course and section individually, which is very time-consuming. Ideally, I would like to consolidate key information for all students into a single Excel file—showing class attendance…
Hello, We are currently using the Analytics API provided in the Instructure Developer Documentation Portal to retrieve certain metrics-related data. We would like to know if it’s possible to replicate these datasets using the Canvas Data Platform (CDP), instead of relying on API calls. For example, could you please advise…
