Expand my Community achievements bar.

We are excited to introduce our latest innovation to enhance the Adobe Campaign user experience — the Adobe Campaign v8 Web User Interface!
SOLVED

PGS-220000 PostgreSQL error: ERROR: column "biid" does not exist

Avatar

Level 1

Hi Team,

 

Please can you provide any help with the below issue with the SMS delivery. 

 

I have tried to find out similar questions with the same error and everybody suggests to have a look at a previous successful SMS delivery. What if you do not have a successful delivery?

 

Any suggestions are welcomed. Please let me know if you require any further information.

 

Kind regards

 

 

 

WDB-200001 SQL statement
'
INSERT INTO wkf79816182_187_1_ALL
(
iId,sChannelType,sCampaignName,sProgramName,sCampaignSelectedDate,sStatus,sCampaignID,iDrawPeriodNumber,
biAccountHolderNumber,biCusExactMatchRef,tsCollection_date,sEventType,sProfile_type,sDraw_period_label_month,
biCusAccountHolderNumber,sEmail,sFirstName,sLastName,sDDCollectionDate,sMobilePhone,iCusFlagBlocked,iCusFlagQasVerified,
sDrawmonth,sThismonth,sDrawMonthLabel,sNextMonth,sLocationAddress1,sLocationAddress2,sLocationAddress3,sLocationCity,
sLocationZipCode
)
SELECT iId,sChannelType,sCampaignName,sProgramName,sCampaignSelectedDate,sStatus,sCampaignID,
iDrawPeriodNumber,biAccountHolderNumber,biCusExactMatchRef,tsCollection_date,sEventType,sProfile_type,sDraw_period_label_month,
biCusAccountHolderNumber,sEmail,sFirstName,sLastName,sDDCollectionDate,sMobilePhone,iCusFlagBlocked,iCusFlagQasVerified,
sDrawmonth,sThismonth,sDrawMonthLabel,sNextMonth,sLocationAddress1,sLocationAddress2,sLocationAddress3,sLocationCity,
sLocationZipCode
FROM wkf79816182_186_1
'
could not be executed.

25/07/2023 13:18:19

deliverySms3

PGS-220000 PostgreSQL error: ERROR: column "iid" does not exist
LINE 1: ...nAddress3,sLocationCity,sLocationZipCode ) SELECT iId,sChann...
^
HINT: There is a column named "iid" in table "wkf79816182_187_1_all", but it cannot be referenced from this part of the query.

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

SMS
1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

Hello Abount,

The error states that there is a column (iid) in the temporary workflow table, but it cannot be referenced. Unfortunately, further context would be required around how the workflow is being configured, associated schemas, etc.

 

Internally, I have seen some old bugs with a similar signature, which have since been addressed. As such, I would recommend opening a ticket with Campaign Support.

View solution in original post

2 Replies

Avatar

Correct answer by
Employee Advisor

Hello Abount,

The error states that there is a column (iid) in the temporary workflow table, but it cannot be referenced. Unfortunately, further context would be required around how the workflow is being configured, associated schemas, etc.

 

Internally, I have seen some old bugs with a similar signature, which have since been addressed. As such, I would recommend opening a ticket with Campaign Support.

Avatar

Level 1

Hi Craig_Thonis

 

Thank you so much for your reply.

I will raise a ticket with Campaign Support.

 

Kind regards