PGS-220000 PostgreSQL error: ERROR: column "biid" does not exist | Community
Skip to main content
A
abount
Level 2
July 25, 2023
Solved

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

  • July 25, 2023
  • 1 reply
  • 1466 views

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Craig_Thonis

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.

1 reply

Craig_Thonis
Adobe Employee
Craig_ThonisAdobe EmployeeAccepted solution
Adobe Employee
July 25, 2023

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.

    A
    abountAuthor
    Level 2
    July 26, 2023

    Hi Craig_Thonis

     

    Thank you so much for your reply.

    I will raise a ticket with Campaign Support.

     

    Kind regards

      Terms & ConditionsAccessibility statement

      Loading footer...