How to update pzpvstream column value from outside pega
We are trying to update the values into the pr_data_rbtc_autmpkgver and pr_data_rbtc_autmpkgvercfg tables for deployment. But there is some encrypted field in these tables.
The encrypted field is pzpvstream column. How to generate that field manually?
Do we have any option with java class or user defined functions?
***Moderator Edit-Vidyaranjan: Updated SR details***
Pegasystems Inc.
IN
If you want extract the data you can use the BIX. but if you want update the data you have to do within the pega application it self..
Can you please explain your use case in details to suggest any alternatives
Flex
IN
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?
Flex
IN
Hi Teegu,
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.
Pegasystems Inc.
IN
We can't insert the data into the pzpvstream from outside pega.. we can write rest service to receive the data and insert it through the activity.. This is one way we can insert the data
Flex
IN
Hi Teegu,
Can you please explain how to write the rest service for this.
Hi Teegu,
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.
Pegasystems Inc.
IN
Hi
If you are interesting in doing automatic deployment without deployment manager, you can do it via jenkins with prpcserviceutil. You might want to explore that option.
Thanks
Saikat
Flex
IN
Actually deployment manager is not supported for RPA solution deployment. we have tried that too.
Deployment manager is usefull for platform deployment automation not for the solution deployment.
can u able to provide any document or links releated to prpcserviceutill? Did u tried with prpcserviceutill and is it working for you?
Flex
IN
Anybody have a better solution for this?
Let me give you the brief detail of what we are trying to do as part of our requirement.
Anybody have a better solution for this?
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.
Pegasystems Inc.
IN
Hi,
The below link might help you.
https://collaborate.pega.com/question/how-update-blob-column
Thank You,
Pegasystems Inc.
IN
Hi Meena,
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.
Thanks,
Abhinav
Flex
IN
Hi Abhinav,
Thanks for your reply.
Actually we are trying to insert the new value for the pzpvstream column in the table.
So we wanted to know how to generate the pzpvstream field at the time of deployment.
Pegasystems Inc.
IN
Hi Meena,
Don't you have any data in pzpvstream blob?If not then is there any usecase to insert it manually.
Thanks,
Abhinav
Flex
IN
Hi Abhinav,
We have some existing data available in the pzpvsteam column. But we want to insert the new value for the pzpvstream field for the automated deployment.
When we are doing the through automated script, this pzpvstream field is getting filled with null value.
Pegasystems Inc.
IN
Hi Meena,
Are you converting values in blob?I don't think we can add it manually.Still let's try by converting the values to blob and then insert it.
Thanks,
Abhinav
Flex
IN
Hi Abhinav,
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.
Pegasystems Inc.
IN
Hi Meena,
You can not generate pzpvstream manually.It is not feasible.Please follow the first approach.
Thanks,
Abhinav
Updated: 27 Sep 2019 9:58 EDT
BPM Company
NL
Hi Meena,
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.
Hope at least it will help
BPM Company
NL
Well, I can only show you a direction, but you must choose a pill by yourself, Neo.
There're a lot of information about how to create a REST service.
What I would suggest you is to create a REST service which accepts 3 parameters - caseID, propertyName and propertyValue
In the service activity you should open the work object (using Obj-Open method with caseID provided), then set a value to propertyName using java step.
Newfold Digital
IN
Hi Meena,
As Abhinav already stated – “You cannot generate pzpvstream manually”,
since you were trying to build/deploy solution packages from outside Robotics studio platform with your custom script, this may be considered as a feature request in product.
You may please also reach out to your Account Executive and discuss adding this ability as a feature request.
Regards,
Ranjith