Is there any other way to cancel this job? (I do not get any screen listing the active jobs, but there is very clearly one still running.) We are unable to delete the collection becuase we get a message saying another user is in the collection, but we have confirmed that no one else is in it during the attempt to delete. I do have someone comfortable with following Holger's instructions for deleting all the workflows, but really that does not do us any good if a new one is created every five minutes. Thanks!
On Tuesday, September 13, 2022 at 10:45:39 AM UTC-8 GaBriella Branson wrote: > Yes, it is the collection running the job, but I didn’t get an > intermediary screen and the job is definitely still running. > > > > GaBriella > > > > *From:* [email protected] <[email protected]> *On > Behalf Of *Taryn Madey > *Sent:* Tuesday, September 13, 2022 10:35 AM > *To:* [email protected] > *Subject:* Re: [EXTERNAL] [topbraid-users] Re: Cancel Scheduled Import > > > > Hi. Is this the same collection running the scheduled job? You should > expect to see an intermediary page when navigating to import JDBC on the > same collection. It will list the existing jobs if they are still active. > > > > Taryn > > > > On Tue, Sep 13, 2022 at 2:13 PM 'GaBriella Branson' via TopBraid Suite > Users <[email protected]> wrote: > > Thank you. We tried to go in to the Import tab --- Import from JDBC > Connection (and based on the help above I expected to see the details of > the existing connection and the Schedule Import containing information, but > they are blank.) Is this not where I am suppsoed to remove the Expression > to remove the schedule? > > On Tuesday, September 13, 2022 at 8:31:21 AM UTC-8 TopQuadrant wrote: > > Note, clearing history will keep uncommitted workflows. So this may not > work for you. > > > > Taryn > > > > On Tue, Sep 13, 2022 at 12:24 PM David Price <[email protected]> > wrote: > > > > > > On 13 Sep 2022, at 17:14, 'GaBriella Branson' via TopBraid Suite Users < > [email protected]> wrote: > > > > Your warning is duly noted, David. I will refrain for the moment. Because > we are in our "staging" instance and simply testing/exploring, what happens > if we simply delete the collection? Does this remove all the workflows and > the schedule? Or does it leave the workflows and schedule out in limbo land? > > > > Workflows are related to the collection and each collection “graph” has a > related change history “graph", so the related workflows and all related > change history will be deleted entirely if you delete the collection. > > > > Note that before going this far, you could simple Clear Change History > (under Manage tab) for the collection and then you do not have to delete > its content. > > > > Cheers, > > David > > > > > > > > On Tuesday, September 13, 2022 at 5:04:41 AM UTC-8 David Price wrote: > > Although, there is not really a better solution at the moment, SPARQL > queries modifying a TCH graph are a bit dangerous … mistakes are always > possible. > > > > So … I would take great care in doing this. Take a backup just before > doing any editing so that worst-case you can restore from the backup and > try again. Test carefully by viewing the Change History for the collection > and for specific assets in the collection before declaring success. > > > > Cheers, > > David > > > > On 13 Sep 2022, at 08:07, Holger Knublauch <[email protected]> wrote: > > > > > > > > On 12 Sep 2022, at 7:14 pm, 'Branson, GaBriella C' via TopBraid Suite > Users <[email protected]> wrote: > > > > Thanks, John. I have yet to test it out as our EDG is hanging up on us…but > I can see from the logs that our cancel was behaving as expected - now to > get into the collection and edit the import per your instructions. > > > > Do you have any advice on cancelling a massive load of workflows? There > are over 800 that have been created because of this scheduled import. > > > > One way to batch-delete hundreds of workflows is by going to the SPARQL > endpoint page > > > > .../tbl/sparql > > > > as administrator, assuming SPARQL Updates are enabled in the advanced > server configuration parameters. In the drop down below the query editor > field, select the Default Graph to be like urn:x-evn-master:XY.tch where XY > is the ID of your asset collection - this is the part before the .editor in > the URL of the main editor. For example for the geography taxonomy this > would be urn:x-evn-master:geo.tch - note the .tch is the graph containing > the metadata about the workflows. > > > > Then, to delete all workflows, run these queries in sequence. > > > > # Delete all added and deleted triples from all workflows > > PREFIX teamwork: <http://topbraid.org/teamwork# > <https://gcc02.safelinks.protection.outlook.com/?url=http%3A%2F%2Ftopbraid.org%2Fteamwork%23&data=05%7C01%7Cgabriella_branson%40ios.doi.gov%7C412d9c769e4f45fc689608da95b6fd56%7C0693b5ba4b184d7b9341f32f400a5494%7C0%7C0%7C637986910442375973%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=cGBuW9HmK7a4wFLnI9RRLArWXUXWfGklTUx67tyAeJU%3D&reserved=0> > > > > DELETE { > > ?triple ?p ?o . > > } > > WHERE { > > ?tag a teamwork:Tag . > > ?change teamwork:tag ?tag . > > ?change teamwork:added|teamwork:deleted ?triple . > > ?triple ?p ?o . > > } > > > > > > # Delete other change metadata > > PREFIX teamwork: <http://topbraid.org/teamwork# > <https://gcc02.safelinks.protection.outlook.com/?url=http%3A%2F%2Ftopbraid.org%2Fteamwork%23&data=05%7C01%7Cgabriella_branson%40ios.doi.gov%7C412d9c769e4f45fc689608da95b6fd56%7C0693b5ba4b184d7b9341f32f400a5494%7C0%7C0%7C637986910442375973%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=cGBuW9HmK7a4wFLnI9RRLArWXUXWfGklTUx67tyAeJU%3D&reserved=0> > > > > DELETE { > > ?change ?p ?o . > > } > > WHERE { > > ?tag a teamwork:Tag . > > ?change teamwork:tag ?tag . > > ?change ?p ?o . > > } > > > > > > # Delete status transitions > > PREFIX teamwork: <http://topbraid.org/teamwork# > <https://gcc02.safelinks.protection.outlook.com/?url=http%3A%2F%2Ftopbraid.org%2Fteamwork%23&data=05%7C01%7Cgabriella_branson%40ios.doi.gov%7C412d9c769e4f45fc689608da95b6fd56%7C0693b5ba4b184d7b9341f32f400a5494%7C0%7C0%7C637986910442375973%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=cGBuW9HmK7a4wFLnI9RRLArWXUXWfGklTUx67tyAeJU%3D&reserved=0> > > > > DELETE { > > ?sc ?p ?o . > > } > > WHERE { > > ?tag a teamwork:Tag . > > ?tag teamwork:statusChange ?sc . > > ?sc ?p ?o . > > } > > > > > > # Delete workflow itself > > PREFIX teamwork: <http://topbraid.org/teamwork# > <https://gcc02.safelinks.protection.outlook.com/?url=http%3A%2F%2Ftopbraid.org%2Fteamwork%23&data=05%7C01%7Cgabriella_branson%40ios.doi.gov%7C412d9c769e4f45fc689608da95b6fd56%7C0693b5ba4b184d7b9341f32f400a5494%7C0%7C0%7C637986910442375973%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=cGBuW9HmK7a4wFLnI9RRLArWXUXWfGklTUx67tyAeJU%3D&reserved=0> > > > > DELETE { > > ?tag ?p ?o . > > } > > WHERE { > > ?tag a teamwork:Tag . > > ?tag ?p ?o . > > } > > > > > > There are ways to automate this using scripts, but in your version this > would require uploading SWP files which I didn't want to require. > > > > Note that the above will delete *all* workflows including past ones. To > only delete certain workflows, you'd need to filter the ?tag by some > criteria such as by creation date. Let me know if you need that step as > well. > > > > NB: From versions 7.3 onwards, the above could be automated much more > easily using the (ADS) Script Editor panel: > > > > tbs.workflows().forEach(tbs.deleteWorkflow) > > > > HTH > > Holger > > > > > > > > GaBriella Branson > > Wildland Fire Data Management Program - Knowledge Manager > > > > Stay Connected! Sign up to receive email updates from the Wildland Fire > Data Management Program > <https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fpublic.govdelivery.com%2Faccounts%2FUSDOI%2Fsubscriber%2Fnew%3Fqsp%3DUSDOI_6&data=05%7C01%7Cgabriella_branson%40ios.doi.gov%7C412d9c769e4f45fc689608da95b6fd56%7C0693b5ba4b184d7b9341f32f400a5494%7C0%7C0%7C637986910442375973%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=hWIjNAKbUzM3uVTVRi4WfouJgdxTYDPGNfkE05QJofQ%3D&reserved=0> > > > > *From:* [email protected] <[email protected]>*On > Behalf Of *John Beard > *Sent:* Monday, September 12, 2022 9:06 AM > *To:* TopBraid Suite Users <[email protected]> > *Subject:* [EXTERNAL] [topbraid-users] Re: Cancel Scheduled Import > > > > > > * This email has been received from outside of DOI - Use caution before > clicking on links, opening attachments, or responding. * > > > > Hi GaBriella, > > The cancel button only cancels the currently executing job. To cancel > future executions you need to edit the job configuration in the data asset > collection and clear the cron expression field. > > On Monday, September 12, 2022 at 12:33:22 PM UTC-4 > [email protected]: > > We had a user schedule a JDBC import to occur every five minutes and it is > causing a few issues. I have gone into Scheduled Jobs under Server > Administration and attempted to hit the cancel button: > > > But the screen merely flashes and the import continues to run. Am I > supposed to be cancelling from within the collection? > > > > Thanks in advance. > > -- > You received this message because you are subscribed to a topic in the > Google Groups "TopBraid Suite Users" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/topbraid-users/aGy6uYlFKUE/unsubscribe > <https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Ftopic%2Ftopbraid-users%2FaGy6uYlFKUE%2Funsubscribe&data=05%7C01%7Cgabriella_branson%40ios.doi.gov%7C412d9c769e4f45fc689608da95b6fd56%7C0693b5ba4b184d7b9341f32f400a5494%7C0%7C0%7C637986910442375973%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=8lkIEOuQKiSAbTm2etXOYpMOPffCcVdGPEKwPSoVc6g%3D&reserved=0> > . > To unsubscribe from this group and all its topics, send an email to > [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/topbraid-users/b64f332d-0d43-48e8-8b1e-9d46569dcfeen%40googlegroups.com > > <https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Fmsgid%2Ftopbraid-users%2Fb64f332d-0d43-48e8-8b1e-9d46569dcfeen%2540googlegroups.com%3Futm_medium%3Demail%26utm_source%3Dfooter&data=05%7C01%7Cgabriella_branson%40ios.doi.gov%7C412d9c769e4f45fc689608da95b6fd56%7C0693b5ba4b184d7b9341f32f400a5494%7C0%7C0%7C637986910442532738%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=5ZxBC9nk47aK8YnJzkaCkn1ffLfJD1isUFVNs3Vnu2k%3D&reserved=0> > . > > > > -- > You received this message because you are subscribed to the Google Groups > "TopBraid Suite Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/topbraid-users/CO6PR09MB7319B24850E0941F919A95FDDA449%40CO6PR09MB7319.namprd09.prod.outlook.com > > <https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Fmsgid%2Ftopbraid-users%2FCO6PR09MB7319B24850E0941F919A95FDDA449%2540CO6PR09MB7319.namprd09.prod.outlook.com%3Futm_medium%3Demail%26utm_source%3Dfooter&data=05%7C01%7Cgabriella_branson%40ios.doi.gov%7C412d9c769e4f45fc689608da95b6fd56%7C0693b5ba4b184d7b9341f32f400a5494%7C0%7C0%7C637986910442532738%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=twCXTPGM1xgZ8ce%2FVw4qFYBnrvj%2FS5zM0IDgTTXiawE%3D&reserved=0> > . > > > > > > -- > You received this message because you are subscribed to the Google Groups > "TopBraid Suite Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > > To view this discussion on the web visit > https://groups.google.com/d/msgid/topbraid-users/099F5162-1BFC-449D-8390-9DC1B1718098%40topquadrant.com > > <https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Fmsgid%2Ftopbraid-users%2F099F5162-1BFC-449D-8390-9DC1B1718098%2540topquadrant.com%3Futm_medium%3Demail%26utm_source%3Dfooter&data=05%7C01%7Cgabriella_branson%40ios.doi.gov%7C412d9c769e4f45fc689608da95b6fd56%7C0693b5ba4b184d7b9341f32f400a5494%7C0%7C0%7C637986910442532738%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=PiNoTgFWRDjp%2B0j6HB79hPZ5u3AZI4G3dnICSWYiaMI%3D&reserved=0> > . > > > > UK +44 (0) 7788 561308 <+44%207788%20561308> > > US +1 (336) 283-0808 <(336)%20283-0808> > > > > > > -- > You received this message because you are subscribed to the Google Groups > "TopBraid Suite Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/topbraid-users/ccbc1b96-9057-4b33-9ce8-47861e01f0fen%40googlegroups.com > > <https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Fmsgid%2Ftopbraid-users%2Fccbc1b96-9057-4b33-9ce8-47861e01f0fen%2540googlegroups.com%3Futm_medium%3Demail%26utm_source%3Dfooter&data=05%7C01%7Cgabriella_branson%40ios.doi.gov%7C412d9c769e4f45fc689608da95b6fd56%7C0693b5ba4b184d7b9341f32f400a5494%7C0%7C0%7C637986910442532738%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=BfrWvz7QghLwBJS2pitwTFIAcM%2F4dNc9AV0smv%2BnhGU%3D&reserved=0> > . > > > > UK +44 (0) 7788 561308 <+44%207788%20561308> > > US +1 (336) 283-0808 <(336)%20283-0808> > > > > -- > You received this message because you are subscribed to the Google Groups > "TopBraid Suite Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > > To view this discussion on the web visit > https://groups.google.com/d/msgid/topbraid-users/3F92D8DE-F929-4213-BBAF-163A658C9F06%40topquadrant.com > > <https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Fmsgid%2Ftopbraid-users%2F3F92D8DE-F929-4213-BBAF-163A658C9F06%2540topquadrant.com%3Futm_medium%3Demail%26utm_source%3Dfooter&data=05%7C01%7Cgabriella_branson%40ios.doi.gov%7C412d9c769e4f45fc689608da95b6fd56%7C0693b5ba4b184d7b9341f32f400a5494%7C0%7C0%7C637986910442532738%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=jGRerGM5YNTBVrwt5l1YorD09uOBzVXjAghyJ%2FNAFoc%3D&reserved=0> > . > > > > > -- > > Taryn Madey > > Development Manager > > TopQuadrant Inc. > > Raleigh, NC > > > > -- > You received this message because you are subscribed to the Google Groups > "TopBraid Suite Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/topbraid-users/90e35d6c-1f70-4b5d-9e39-e11c46d194e1n%40googlegroups.com > > <https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Fmsgid%2Ftopbraid-users%2F90e35d6c-1f70-4b5d-9e39-e11c46d194e1n%2540googlegroups.com%3Futm_medium%3Demail%26utm_source%3Dfooter&data=05%7C01%7Cgabriella_branson%40ios.doi.gov%7C412d9c769e4f45fc689608da95b6fd56%7C0693b5ba4b184d7b9341f32f400a5494%7C0%7C0%7C637986910442532738%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=AOvylPFOno%2Bd7g2UEB9R%2BqBWe98I4Bqga1dEerDdSgE%3D&reserved=0> > . > > > > > -- > > Taryn Madey > > Development Manager > > TopQuadrant Inc. > > Raleigh, NC > > > > -- > You received this message because you are subscribed to a topic in the > Google Groups "TopBraid Suite Users" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/topbraid-users/aGy6uYlFKUE/unsubscribe > <https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Ftopic%2Ftopbraid-users%2FaGy6uYlFKUE%2Funsubscribe&data=05%7C01%7Cgabriella_branson%40ios.doi.gov%7C412d9c769e4f45fc689608da95b6fd56%7C0693b5ba4b184d7b9341f32f400a5494%7C0%7C0%7C637986910442532738%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=94Rh2yize41DkCM9DPviTnkmtijVKegveoTCRArY2Y4%3D&reserved=0> > . > To unsubscribe from this group and all its topics, send an email to > [email protected]. > > To view this discussion on the web visit > https://groups.google.com/d/msgid/topbraid-users/CAF6qMpo9neaN%3D9sEZddw575nLOXy8gKxjqm%3DW_Pmfu1tGzwYhQ%40mail.gmail.com > > <https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgroups.google.com%2Fd%2Fmsgid%2Ftopbraid-users%2FCAF6qMpo9neaN%253D9sEZddw575nLOXy8gKxjqm%253DW_Pmfu1tGzwYhQ%2540mail.gmail.com%3Futm_medium%3Demail%26utm_source%3Dfooter&data=05%7C01%7Cgabriella_branson%40ios.doi.gov%7C412d9c769e4f45fc689608da95b6fd56%7C0693b5ba4b184d7b9341f32f400a5494%7C0%7C0%7C637986910442532738%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000%7C%7C%7C&sdata=tbYTEpi2IcC%2BZC4fydjtTzOAvsGy32XtPIrPxRkYtrA%3D&reserved=0> > . > -- You received this message because you are subscribed to the Google Groups "TopBraid Suite Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/3fcdbe15-47d8-42b5-8445-f5b71ccd5f7an%40googlegroups.com.
