topic Has Batches To Verify ? result for which batch? in Product Forum

Has Batches To Verify ? result for which batch?

KrishnaElapavul — Thu, 29 Jul 2021 05:56:00 GMT

HI
I would like to know the verify batch ( If it result as "True") belongs to which BatchType while running by BP process.

Let me explain scenario,
a BP process pushed docs for two different Batch Types and one got struck where it need manual intervention.
In this case P2- "02- Batches to Verify " will give Boolean value as "True" , but it can;'t tell for which Batch Type it is?
How to get the Batch Type also ;any idea?
Is there any wat to Query the Decipher table to get such values?
Please help me .

------------------------------
Krishna Elapavuluri RPA Solution Lead
TEchnology Consultant
DXC.technology
Asia/Kolkata
------------------------------

RE: Has Batches To Verify ? result for which batch?

Ben.Lyons1 — Thu, 29 Jul 2021 07:20:00 GMT

Hi Krishna,

To achieve the desired result you will need to use separate RabbitMQ queues for each batch type. It's really easy to configure, you can just change the name of the queue when you upload and it will automatically create the new queue (or use the existing one if it already exists).

Then when you come to check for available batches, they will be separated into their respective queues. Just update the login stages to reflect the new queue names.

Thanks

------------------------------
Ben Lyons
Product Consultant
Blue Prism
UK
------------------------------

RE: Has Batches To Verify ? result for which batch?

KrishnaElapavul — Tue, 10 Aug 2021 14:13:00 GMT

Thanks Ben,
I will try the method and check

------------------------------
Krishna Elapavuluri RPA Solution Lead
TEchnology Consultant
DXC.technology
Asia/Kolkata
------------------------------

RE: Has Batches To Verify ? result for which batch?

lookman — Wed, 11 Aug 2021 13:36:00 GMT

Hi Krishna.

If I understand correctly, then you could also use "Decipher Get Batch Status" process which can be found on the DX. It returns the information about the batches including the batch type name.

Just a thought.

jack

------------------------------
Jack Look
Sr Product Consultant
Blue Prism
------------------------------

RE: Has Batches To Verify ? result for which batch?

bbobo — Fri, 08 Oct 2021 03:03:00 GMT

Hi Jack - does the query you are using provide visibility on whether a batch needs manual data verification?

I am querying the 'DecipherServerDb' to figure out if a batch is finished. I can query the dbo.Batch table status column and know that if the status is '6' then it is ready to be exported. The problem I'm running into is that if the batch needs data verification I can't rely on the status column. Previously I was checking if the status was '5' then I assumed verification was needed but that seems to be invalid because the status can show as '5' and then eventually move to '6'. Is there another table or column in the database that I can query to see if data verification is needed on a batch?

------------------------------
Ben Bobo
RPA Developer
Constellation Brands
America/New_York
------------------------------

RE: Has Batches To Verify ? result for which batch?

KrishnaElapavul — Fri, 08 Oct 2021 07:21:00 GMT

Hi
The simple solution I followed is as below
1. Map your batch_type to some specific user
2. Run the "02-Batches verify " process , use mapped user/pwd while connecting to Decipher in this process
3. If any batches are in Data verification, it will write "true" else false will return . based on this you can take further action.
Let me know if you need any more information.

Thanks
Krishna

------------------------------
Krishna Elapavuluri RPA Solution Lead
TEchnology Consultant
DXC.technology
Asia/Kolkata
------------------------------

RE: Has Batches To Verify ? result for which batch?

lookman — Fri, 08 Oct 2021 12:42:00 GMT

Hi Ben.

The reason I put the process together in the first place was that the sample process provided, the one mentioned by Krishna, did not provide the detail I wanted. It tells you if you have one or more batches to verify. Not how many, the batch id, or any other statuses.

The status codes I provided in the process/documentation came directly from product development and I don't have any other details. Regarding using a different table, I have not seen that information available.

jack

------------------------------
Jack Look
Sr Product Consultant
Blue Prism
------------------------------

RE: Has Batches To Verify ? result for which batch?

Tejaskumar_Darji — Fri, 08 Oct 2021 14:21:00 GMT

Thanks, Jack for informing us about this new process "Decipher Get Batch Status". I'll try to configure and make use if it.

------------------------------
Thanks & Regards,
Tejaskumar Darji
Sr. RPA Consultant-Automation Developer
------------------------------