topic RE: Which DB table of BP stores the version history of Process and Object? in Product Forum

Which DB table of BP stores the version history of Process and Object?

Tejaskumar_Darji — Thu, 09 Jun 2022 09:14:00 GMT

Hi,

Which DB table of BP stores the version history of Process and Object?

I checked BPAProcess but seems it stores only the latest XML so unable to find older versions.

------------------------------
If I was of assistance, please vote for it to be the "Best Answer".

Thanks & Regards,
Tejaskumar Darji
Sr. Consultant-Technical Lead
------------------------------

RE: Which DB table of BP stores the version history of Process and Object?

PabloSarabia — Thu, 09 Jun 2022 11:17:00 GMT

Hi @Tejaskumar_Darji

Check this table: BPAAuditEvents.

Here you have all the changes in the platform.

You can join this table with BPAProcess by using the field gTgtProcID

In the Audit Table you have two fields at the end, oldXML and newXML

Hope this helps you!!

See you in the Community, bye 🙂

------------------------------
Pablo Sarabia
Solution Manager & Architect
Altamira Assets Management
Madrid
------------------------------

RE: Which DB table of BP stores the version history of Process and Object?

devneetmohanty07 — Thu, 09 Jun 2022 12:01:00 GMT

Hi Tejas,

The BPAAuditEvents along with BPAProcess table would give you the desired information as BPAAudit events stores all the activity trail done on an user account. You can join the two tables using 'processid' and 'gTgProcID' columns:

SELECT [eventdatetime]
      ,[sNarrative]
      ,[gTgtProcID]
      ,[comments]
      ,[EditSummary]
      ,[oldXML]
      ,[newXML]
  FROM [blueprism].[dbo].[BPAAuditEvents] INNER JOIN [blueprism].[dbo].[BPAProcess] 
  ON [blueprism].[dbo].[BPAAuditEvents].gTgtProcID = [blueprism].[dbo].[BPAProcess].processid
  WHERE [newXML] IS NOT NULL

------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------

------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------

RE: Which DB table of BP stores the version history of Process and Object?

lookman — Thu, 09 Jun 2022 13:44:00 GMT

Hi Devneet.

Thanks for sharing the query. I added BPAProcess.name and BPAProcess.description to the SELECT list to make it easier to recognize which process/object each line represents.

In my environment, I also noticed the column oldXML was always NULL.

Was that your experience as well?

jack

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

RE: Which DB table of BP stores the version history of Process and Object?

devneetmohanty07 — Thu, 09 Jun 2022 14:00:00 GMT

Hi Jack,

Definitely those extra columns would help a lot to identify the processes. I might have removed those due to chunk of data I was seeing on the screen. But that totally is useful to have I agree.

On that [oldXML] column , I exactly have experienced that. At first, I felt was weird but thought maybe it would be something to do specifically with my environment for some reason.

Is there any specific reason for that though, even I am curious to know on that.

------------------------------
----------------------------------

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------

RE: Which DB table of BP stores the version history of Process and Object?

lookman — Thu, 09 Jun 2022 14:11:00 GMT

Hi Devneet.

I'll ask around and see if I can find out why that column is NULL.

jack

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

RE: Which DB table of BP stores the version history of Process and Object?

lookman — Thu, 09 Jun 2022 16:08:00 GMT

Hi Devneet.

Apparently, the thought was that "oldXML" was used in Studio for comparing versions but that was not the case. It was "turned off" awhile back to reduce the size of the BPAAuditEvents table.

I don't have an explanation why the column has not been removed from the table but it is not used and so can be ignored.

jack

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

RE: Which DB table of BP stores the version history of Process and Object?

devneetmohanty07 — Thu, 09 Jun 2022 16:26:00 GMT

Thanks a lot Jack for sharing the details with us. It makes sense as XML's would clog up spaces if he processes or objects are large in nature and they gather up quite often down the line.

------------------------------
----------------------------------

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------

RE: Which DB table of BP stores the version history of Process and Object?

Soumya21 — Mon, 09 Oct 2023 06:28:00 GMT

Hi @Jack Look

Is there any way to enable the turned off "oldxml" in the database

Thanks,

Soumya

------------------------------
Soumya k RPA Developer
RPA Developer
Qualesce India Private Limited
Bangalore
------------------------------

RE: Which DB table of BP stores the version history of Process and Object?

Tejaskumar_Darji — Mon, 09 Oct 2023 06:45:00 GMT

Hi Soumya k

Did not get your question. Can you add bit more details please

------------------------------
If I was of assistance, please vote for it to be the "Best Answer".

Thanks & Regards,
Tejaskumar Darji - https://www.linkedin.com/in/tejaskumardarji/
Technical Lead
------------------------------

RE: Which DB table of BP stores the version history of Process and Object?

Soumya21 — Mon, 09 Oct 2023 06:58:00 GMT

Hi @Tejaskumar_Darji

If we query the 'auditevents' table, then we are getting 'oldxml' column empty

So, what has to be done to get 'oldxml' column as not empty (I want to get old xml file file)

Thanks,

Soumya

------------------------------
Soumya k RPA Developer
RPA Developer
Qualesce India Private Limited
Bangalore
------------------------------

RE: Which DB table of BP stores the version history of Process and Object?

Tejaskumar_Darji — Mon, 09 Oct 2023 08:44:00 GMT

Ok yeah, now I get your question and oldxml is NULL for me too. I think this needs to be checked with the dev team itself.

So now the question is if oldxml column is not used then from where BP is reading the version history?

Anybody else has idea on this please

RE: Which DB table of BP stores the version history of Process and Object?

lookman — Mon, 09 Oct 2023 13:20:00 GMT

Hi Soumya.

As mentioned in my post above (see #7), OLDXML is no longer supported. I have posted a question to the developers so if I get a response, I will share it.

jack

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

RE: Which DB table of BP stores the version history of Process and Object?

lookman — Mon, 09 Oct 2023 13:58:00 GMT

Hi Soumya.

I have received a response from the development team. Whenever a process is changed, there is a row placed in the BPAAuditEvents table in which the column newXML contains the "code".

If you want to compare the old "code", you can use the newXML column from the previous row and newXML column from the current one.

jack

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

RE: Which DB table of BP stores the version history of Process and Object?

Soumya21 — Tue, 10 Oct 2023 06:50:00 GMT

Hi @Jack Look

Thanks for the information

------------------------------
Soumya k RPA Developer
RPA Developer
Qualesce India Private Limited
Bangalore
------------------------------