Question

5
Replies
118
Views
Close popover
Bhargav Shastrula (BhargavS)
Evoke Technologies
Technical Associate
Evoke Technologies
IN
BhargavS Member since 2015 22 posts
Evoke Technologies
Posted: May 15, 2019
Last activity: May 16, 2019
Closed
Solved

Error while adding BLOB column

Hi,

I am trying to add BLOB (pzPVStream)column in the table but, we are facing the below error.

There was a problem getting a list: code: 0 SQLState: 42704 Message: ERROR: type "blob" does not exist
  Position: 60 

Please find the below steps we are following:

1. Created a Connect-SQL rule and added the script on Delete tab.

ALTER TABLE pr_table_name
ADD pzPVStream BLOB NULL;
commit;

2.Then using RDB-Delete method in activity, we are executing the scritpt.

we have refered to the following link .

https://community.pega.com/support/support-articles/create-new-record-failed-after-upgrade-conversion-data-tables

We were able to add other columns but facing issue only while trying to add this column.

Thanks,

Bhargav

Data Integration
Moderation Team has archived post