I have a requirement to create case from a file and the files will be huge with lots of records.
So file listener will parse the file and insert the records in a staging table. Job scheduler will pick the cases from the table and queue it to Queue processor for case creation. We want the QP to create the case and not continue with the case processing.
We are looking for alternatives instead of using the wait shape because it will be processed by SLA and all cases will have to wait till the other cases are processed. Is there any solution to improve the performance? We tried to queue the case to another queue processor after case creation from the flow but that doesn't work. The first queue processor still continues with the case processing and it doesn't stop the processing after queueing the case.
***Edited by Moderator Marije to add Capability tags***
@JAYASHREE-1 I used 2 queue processors for the above scenario. For this to work after queueing to QP2, you need to have a wait or assignment shape. Your QP2 will pick up from this wait or assignment shape for further processing. QP2 activity could use something like resume flow in its activity
Without having a wait or assignment shape, queue processor will continue to processor till processing halts (any of the wait/assignment/end shapes )