syncdb interval exceeded

Hi,

We recently had a space issue with the PC where we routinely run a syncdb on the web_logs table in the canvas_logs namespace. The space issue has now been resolved but when I attempt a dap syncdb it is erroring with "The maximum interval for this request should be '30' days. The requested interval was '35' days"

Is the only solution to truncate and do a full initdb on the table?

Thanks for any suggestions

Find more posts tagged with

Accepted answers

sgergely

Hi @MarkAgar,

The reason you are getting this error message is because you are trying to download (sync) data from web_logs table that is not available. Web_logs table only provides the last 30 days of data. I guess you have last synced 35 days ago and the DAP CLI tries to use that start time. The start time is stored in the `dap_meta` table, you might want to change it to cover only 30 days and then it would be fine. Or do a snapshot and start from there.

Beware, if you are doing `dropdb` before doing a new snapshot you might loose data and would end up with the last 30 days of data only.

All comments

sgergely

Hi @MarkAgar,

Beware, if you are doing `dropdb` before doing a new snapshot you might loose data and would end up with the last 30 days of data only.

MarkAgar

I see now the table with the metadata in it is called instructure_dap_table_sync 👍

Unanswered Questions

EDUCAUSE Insights: Data and Decision-Making
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,…
Problems with GraphQL in User Pageviews reports
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…
Metrics Easy Button
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…
Analytics API / Metrics calculation logic
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…
CD2: Enhanced Rubrics
Is there a way to tell via CD2 if a course is using Enhanced Rubrics? I didn't see it in the entity diagram for Rubrics table, but I might have missed something... Thanks Ian