Question
Infosys
AU
Last activity: 31 Dec 2018 0:49 EST
How to recreate the pzpvStream blob column
Hi
Previously we created a datatable for an application. The datatable created did not have default Pega columns (that is no pzpvStream).
Now we want to create the pzpvStream blob column, is there a way to repopulate existing data columns into the blob stream ?
Thanks in advance
CXForward
US
I am assuming table already have standard columns(like pzInsKey,pyLable,pxObjClass,..etc). Then you could try the below steps
1) Table a DB Backup of the table ( just to restore if something goes wrong)
1) Take a product of the datatable
2) Delete the rows the from the table
3) Add pzPVStream column to the table
4) Import the product
Infosys
AU
Hi
Thanks for suggestion. I did try but without success.
Step tried:
1. took Product of the whole datatable instances
2. within database, drop all records from teh datatable
3. added pzpvstream column to the datatable
4. import Product from step 1. - failed with error:
Hi
Thanks for suggestion. I did try but without success.
Step tried:
1. took Product of the whole datatable instances
2. within database, drop all records from teh datatable
3. added pzpvstream column to the datatable
4. import Product from step 1. - failed with error:
Cannot save instance of class XXXXXXX; it belongs to fully exposed table pegadata.xxxxx in database PegaDATA, but the instance has properties which do not correspond to columns: pxMoveImportOperName , pxMoveImportOperId , pxMoveImportDateTime
FATAL ERROR: Invalid clipboard stream detected in module PegaArchiveException.RuleArchiveLoader. Reason: importContents(PegaArchive)
5. Drop the pzpvstream column from datatable
6. import Product again, no error
Still looking for other solution/suggestion
Thanks
CXForward
US
After adding the columns in the table, did you try to do the Test Connectivity from the class rule or from Database Table instance to refresh the cached in memory columns for that class.
Coforge Technologies (Erstwhile Incessant Technologies)
GB
It's better to import data table instances into excel sheet, recreate the datatable by deleting previous table and exporting the data table instances into the new table.
Verizon
IN
Looks like import in same structure could not help here, what i tried long back was have a utility/data page with all the data from Data Table(we generally have one at page and page list level). Keep this data page populated and now 2 options :
1. Use existing table/db structure just remove all the columns from table which you want to be in blob and remove the mapping from class rule as well. Add new column pzpvstream as Blob type, test the connection from class and commit the changes in db. Now using the utility to an obj-save with commit in save class.
2. Create new table/db structure with needed column + pzpvstream column change ur sysadmin-db-table for class test connection from class and use have utility to do obj-save + commit
Let me know if helps.
Coforge Technologies (Erstwhile Incessant Technologies)
GB
2nd option is better.