We are trying to automate the pega deployment process and tried Pega deployment manager also. But it doesn’t work for Robotic Automations. So we build a custom script to do this. But we ran into issues when solution has configurations? How do we automate this via script? It looks like if we deploy manually via Pega studio, it is inserting data into two tables pr_data_rbtc_autmpkgver and pr_data_rbtc_autmpkgvercfg. There are some encrypted fields in pr_data_rbtc_autmpkgvercfg. How do we create these using scripts?
We are able to insert the remaining fields into the table except pzpvstream value. we wanted to know how to generate the pzpvstream value manually either through script or java function. Please let us if you have any other alternatives also, it would be the great help for us.
Can you please explain how to write the rest service for this.
We are trying this for the automation of RPA deployment process. Once we created the deployable files through OSD command, moving those files to package server then we are trying to insert the values into deployment database tables (pr_data_rbtc_autmpkgver and pr_data_rbtc_autmpkgvercfg tables).But while inserting the data, we are not sure about the pzpvstream coloumn value.
Let me give you the brief detail of what we are trying to do as part of our requirement.
Once the RPA solution is developed then we are opening the visual studio. From there we are cleaning the package, building and deploying into package server. After that assigning the particular version number in the robotics manager.
But we want to eliminate that manual part of opening visual studio and the tasks (clean, build and deployment).
The same tasks we did it through OSD commands and place it in the package server through custom script but after that while inserting the values into the table, getting the issue because of pzpvstream field.
There is a udf pr_read_from_stream() which is used to read blob from pzpvstream.Just execute below command using sql developer management studio and fetch the value of pzpvstream column.Once you get the values then you can insert it using update command.
Example of query.
Select pr_read_from_stream("PROPERTY",pzInsKey,pzpvstream) from TABLE
replace property with the property name and table with table name.
If we are doing the solution deployment using Visual studio and Runtimeconfig.xml file, the pzpvstream column is updating some blob value in the database table. But we manually execute OSD command and place the deployable in the package server. And inserting the version details in the database table.So to insert the values into the table, we know all the column values except the pzpvstream value.
So we wanted to know how to generate the pzpvstream value and insert that value into database table.
Unfortunately, no one but Pega can generate pzpvstream. Well, literally - espesially in IT - you can do anything of course :) but it will mean to rewrite almost the whole Pega from the scratch, which it not your goal I suppose.
What I can propose though, is to create a small REST service (it must be veeery small and veeery secure) in Pega which will update (insert) any value in any workobject you specify.