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

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.

Hi

yes, I did refresh the database table within Pega - to make sure the new table columns definition are stored  correctly.

However import failed

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.

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.

@Cho - Can you please share the current table structure if possible? I am looking for more around what standard columns you have in the table.

2nd option is better.

Please create a new table with the required columns and map them