Question

5
Replies
149
Views
Close popover
Bhargav Shastrula (BhargavS)
Evoke Technologies
Technical Associate
Evoke Technologies
IN
BhargavS Member since 2015 23 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,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.