Deleting Record in a subflow in Flow Designer

Ziad Qadora
Kilo Sage

Hello,

I'm trying to delete group member record in a subflow, but so far I'm not able to.  I have tried using the group and user sysID as well as names.  But neither one has worked.  

I'm able to read the record and do check after reading it and comes back true, but I get an error when I attempt to delete the record.

Any idea what I may be doing wrong?

find_real_file.png

1 ACCEPTED SOLUTION

Hi,

In order to resolve the issue, we needed to set the Record field of the step 2.2 "Delete Record" action to the following data pill instead: 2.1➛Group Member Record

This was the solution suggested by HI support.  

 

find_real_file.png

View solution in original post

8 REPLIES 8

Hi Ankur,

Below is the error I found,  and the screenshot showing test results.

The record was found, but the error message is misleading when it says Nonexistent table.  It should state "Nonexistent Record".  But the record does exist and I'm able to open in the step before the error is thrown.

I was able to add these records using a subflow, but I'm not able to delete them using this subflow.

Flow Designer: Operation(Remove User from Group.If$1.b55718e11b5f10907484eb9cbc4bcb18.c25718e11b5f10907484eb9cbc4bcb39.0be0d916c31332002841b63b12d3ae13) failed with error: com.snc.process_flow.exception.OpException: Nonexistent table: 59b70ce11bdb10907484eb9cbc4bcbaf
at com.snc.process_flow.operation.GlideUtilities.createValidGlideRecordObject(GlideUtilities.java:56)
at com.snc.process_flow.operation.FieldValue.getGlideRecord(FieldValue.java:161)
at com.snc.process_flow.operation.CRUDOperation.getInputValidGlideRecord(CRUDOperation.java:42)
at com.snc.process_flow.operation.RecordDeleteOperation.run(RecordDeleteOperation.java:26)
at com.snc.process_flow.engine.Operation.execute(Operation.java:106)
at com.snc.process_flow.engine.ProcessEngine.executeOps(ProcessEngine.java:407)
at com.snc.process_flow.engine.ProcessEngine.run(ProcessEngine.java:355)
at com.snc.process_flow.engine.ProcessAutomation.run(ProcessAutomation.java:57)
at com.snc.process_flow.engine.GlideProcessAutomation.runSync(GlideProcessAutomation.java:126)
at com.snc.process_flow.engine.GlideProcessAutomation.lambda$runAsUserSync$1(GlideProcessAutomation.java:213)
at com.snc.process_flow.engine.GlidePFSession.runPlanAsUserSession(GlidePFSession.java:40)
at com.snc.process_flow.engine.GlideProcessAutomation.runAsUserSync(GlideProcessAutomation.java:205)
at com.snc.process_flow.engine.GlideProcessAutomation.messageFlow(GlideProcessAutomation.java:242)
at com.snc.process_flow.engine.GlideProcessAutomation._start(GlideProcessAutomation.java:364)
at com.snc.process_flow.engine.GlideProcessAutomation.access$400(GlideProcessAutomation.java:82)
at com.snc.process_flow.engine.GlideProcessAutomation$StartBuilder.start(GlideProcessAutomation.java:898)
at com.glide.flow.providers.FlowGlideProvider.testSubFlow(FlowGlideProvider.java:1007)
at com.glide.flow.providers.FlowGlideProvider.testFlow(FlowGlideProvider.java:987)
at com.glide.flow_design.rest.FlowService.testRunFlow(FlowService.java:573)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.glide.rest.handler.impl.ServiceHandlerImpl.invokeService(ServiceHandlerImpl.java:44)
at com.glide.rest.processors.RESTAPIProcessor.process(RESTAPIProcessor.java:290)
at com.glide.processors.AProcessor.runProcessor(AProcessor.java:553)
at com.glide.processors.AProcessor.processTransaction(AProcessor.java:240)
at com.glide.processors.ProcessorRegistry.process0(ProcessorRegistry.java:177)
at com.glide.processors.ProcessorRegistry.process(ProcessorRegistry.java:166)
at com.glide.ui.GlideServletTransaction.process(GlideServletTransaction.java:31)
at com.glide.sys.Transaction.run(Transaction.java:2192)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
: no thrown error

 

find_real_file.png

Ziad Qadora
Kilo Sage

Hi Ankur,

In addition to my earlier reply.  I do not see any business rules that would block the deletion of the record.

 

Ziad Qadora
Kilo Sage

Hello,

 

I have tried the same subflow in Paris instance and I'm still getting the same error.   Again the record is found in the previous step.

Still trying to find what is causing the error

 

find_real_file.png

Hi,

In order to resolve the issue, we needed to set the Record field of the step 2.2 "Delete Record" action to the following data pill instead: 2.1➛Group Member Record

This was the solution suggested by HI support.  

 

find_real_file.png