Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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

Tejaskumar_Darji
MVP

‎09-06-22 10:14 AM

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
------------------------------
0 Likes
14 REPLIES 14

Soumya21
Level 6
In response to Tejaskumar_Darji

‎09-10-23 07:58 AM

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
------------------------------
0 Likes

Tejaskumar_Darji
MVP
In response to Soumya21

‎09-10-23 09:44 AM

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



------------------------------
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
------------------------------
0 Likes

lookman
Staff
Staff
In response to Soumya21

‎09-10-23 02:20 PM

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
------------------------------
0 Likes

lookman
Staff
Staff
In response to lookman

‎09-10-23 02:58 PM

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
------------------------------
0 Likes

Soumya21
Level 6
In response to lookman

‎10-10-23 07:50 AM

Hi @Jack Look

Thanks for the information



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