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

[abount]

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.

[Craig_Thonis · Accepted solution]

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.

[abount]

Hi Craig_Thonis

Thank you so much for your reply.

I will raise a ticket with Campaign Support.

Kind regards