Has Batches To Verify ? result for which batch?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
29-07-21 06:56 AM
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
------------------------------
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
------------------------------
7 REPLIES 7
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
29-07-21 08:20 AM
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
------------------------------
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
------------------------------
Ben Lyons
Principal Product Specialist - Decipher
SS&C Blue Prism
UK based
Principal Product Specialist - Decipher
SS&C Blue Prism
UK based
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
10-08-21 03:13 PM
Thanks Ben,
I will try the method and check
------------------------------
Krishna Elapavuluri RPA Solution Lead
TEchnology Consultant
DXC.technology
Asia/Kolkata
------------------------------
I will try the method and check
------------------------------
Krishna Elapavuluri RPA Solution Lead
TEchnology Consultant
DXC.technology
Asia/Kolkata
------------------------------
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
11-08-21 02:36 PM
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
------------------------------
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
------------------------------
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-10-21 04:03 AM
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
------------------------------
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
------------------------------
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-10-21 08:21 AM
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
------------------------------
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
------------------------------
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-10-21 01:42 PM
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
------------------------------
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
------------------------------
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-10-21 03:21 PM
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
------------------------------
------------------------------
Thanks & Regards,
Tejaskumar Darji
Sr. RPA Consultant-Automation Developer
------------------------------