Kill SIS-import process

[Tyler Clair]

I had a csv file of test students I tried imported into a development system. It appears to be hung so I killed the webBrick server and restarted it but when I went back to the SIS-import tool and it started the previous import process again. How can I stop this process so I can try it again?

Thanks,

Tyler Clair

USU-Eastern FACT

[JT Olds]

No long-running jobs or processes are going to run in the development
environment unless you have also run 'script/delayed_job run' in
addition to 'script/server'. Try that.

I highly recommend setting up a production environment if you are
attempting to do CSV import or similar.

[Christopher Bennell]

So, is possible to stop the import process? During testing (on a production-style setup) I submitted the job without any actual data. Now the import has been basically frozen for hours.

[JT Olds]

Sounds like you don't have your canvas_init daemon running.

[Christopher Bennell]

Hmm. /etc/init.d/canvas_init start runs OK, there no jobs showing up in the list at /jobs, and my emails are all delivered. I think this means that the daemon is running..?

[JT Olds]

Huh, well, if there are no jobs running, but your SIS import page is
still saying an import is running, then it got stuck and killed
somehow. You'll need to clear it out. Try running

SisBatch.last.tap{|x| x.workflow_state = "failed"; x.save}

or equivalent.

[Christopher Bennell]

That did the trick. Thanks!

[JT Olds]

Just for correctness on this list, the following command is more
robust than the one I provided:

Account.default.current_sis_batch.tap{|x| x.workflow_state = "failed"; x.save}

[robert...@gmail.com]

Sorry, I'm new with Canvas, and... where i have to put this sentence?
Thanks in advance!

[Cody Cutrer]

You'll run script/console, and then put it there.

Cody Cutrer

Software Engineer

Instructure

--
 
---
You received this message because you are subscribed to the Google Groups "Canvas LMS Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to canvas-lms-use...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Roberto Diaz]

It worked!!! Now I've stopped the SIS import process.
Thanks a lot!!!

Regards
Roberto

[Amit Lathigara]

Kindly highlight, how to open console?
I am getting an error that no such file/directory exists.
Thanks.

[soni...@gmail.com]

I am getting an error that command is not found.
Kindly help.

[Amit Lathigara]

I found an alternative way to resolve it.
Login in PostgreSQL, and locate table sis_batches.
Retrieve all rows and delete row which is showing progress not as 100.

[Amit Lathigara]

I found an alternative way to resolve it.
Login in PostgreSQL, and locate table sis_batches.
Retrieve all rows and delete row which is showing progress not as 100.

[ismael...@gmail.com]

I'm using Canvas version 2018.09 and I could not delete the specific row as there are associated ids in other tables. However, by changing the workflow_state of the row that is hanging (either less than 100 progress or workflow_state as "importing") to "imported", the SIS import page is now working again