Expand my Community achievements bar.

Error on Custom report setup

Avatar

Level 1

Team,

 Getting error when i increase additional rows in custom report (>88). 

Please let me know if you face any similar type of issues.

 

Date
Message
06/12/2023 23:42:36
WDB-200001 SQL statement 'CREATE TABLE IF NOT EXISTS wkDlv_425351887_Data (biId BIGINT NOT NULL DEFAULT 0, LIKE wkf425351890_1_1); ALTER TABLE wkDlv_425351887_Data ADD COLUMN IF NOT EXISTS mSeedMemberData TEXT; ALTER TABLE wkDlv_425351887_Data ADD COLUMN IF NOT EXISTS mSeedDSData TEXT; CREATE INDEX IF NOT EXISTS wkDlv_425351887_Data_Id ON wkDlv_425351887_Data(biMessageId); INSERT INTO wkDlv_425351887_Data(biId, biMessageId, sAddress, iFormat, sVariant, sTargetCode, iStatus, iBlackList, sCusSegmentCode, iProfileId, tsTargetDataReporting, mTargetDataEnrichment611Desc, sEnrichment611DeliveryLabel, iEnrichment611MessageType, tsEnrichment611Main, iEnrichment611Sent, iEnrichment611Delivered, iTotalVouchersInt, iUsedVouchersInt, iEnrichment611VoucherLeft, mTargetDataEnrichment612Desc, sEnrichment612DeliveryLabel, iEnrichment612MessageType, tsEnrichment612Main, iEnrichment612Sent, iEnrichment612Delivered, iTotalVouchersInt1, iUsedVouchersInt1, iEnrichment612VoucherLeft, mTargetDataEnrichment613Desc, sEnrichment613DeliveryLabel, iEnrichment613MessageType, tsEnrichment613Main, iEnrichment613Sent, iEnrichment613Delivered, iTotalVouchersInt2, iUsedVouchersInt2, iEnrichment613VoucherLeft, mTargetDataEnrichment614Desc, sEnrichment614DeliveryLabel, iEnrichment614MessageType, tsEnrichment614Main, iEnrichment614Sent, iEnrichment614Delivered, iTotalVouchersInt3, iUsedVouchersInt3, iEnrichment614VoucherLeft, mTargetDataEnrichment615Desc, sEnrichment615DeliveryLabel, iEnrichment615MessageType, iEnrichment615Sent, iEnrichment615Delivered, iTotalVouchersInt4, iUsedVouchersInt4, iEnrichment615VoucherLeft, mTargetDataEnrichment616Desc, sEnrichment616DeliveryLabel, iEnrichment616MessageType, tsEnrichment616Main, iEnrichment616Sent, iEnrichment616Delivered, iTotalVouchersInt5, iUsedVouchersInt5, iEnrichment616VoucherLeft, mTargetDataEnrichment617Desc, sEnrichment617DeliveryLabel, iEnrichment617MessageType, tsEnrichment617Main, iEnrichment617Sent, iEnrichment617Delivered, iTotalVouchersInt6, iUsedVouchersInt6, iEnrichment617VoucherLeft, mTargetDataEnrichment618Desc, sEnrichment618DeliveryLabel, iEnrichment618MessageType, tsEnrichment618Main, iEnrichment618Sent, iEnrichment618Delivered, iTotalVouchersInt7, iUsedVouchersInt7, iEnrichment618VoucherLeft, mTargetDataEnrichment619Desc, sEnrichment619DeliveryLabel, iEnrichment619MessageType, tsEnrichment619Main, iEnrichment619Sent, iEnrichment619Delivered, iTotalVouchersInt8, iUsedVouchersInt8, iEnrichment619VoucherLeft, mEnrichment6110Desc, sEnrichment6110DeliveryLabel, iEnrichment6110MessageType, tsEnrichment6110Main, iEnrichment6110Sent, iEnrichment6110Delivered, iTotalVouchersInt9, iUsedVouchersInt9, iEnrichment6110VoucherLeft, mEnrichment6111Desc, sEnrichment6111DeliveryLabel, iEnrichment6111MessageType, tsEnrichment6111Main, iEnrichment6111Sent, iEnrichment6111Delivered, iTotalVouchersInt10, iUsedVouchersInt10, iEnrichment6111VoucherLeft, mEnrichment6112Desc, sEnrichment6112DeliveryLabel, iEnrichment6112MessageType, tsEnrichment6112Main, iEnrichment6112Sent, iEnrichment6112Delivered, iTotalVouchersInt11, iUsedVouchersInt11, iEnrichment6112VoucherLeft, mEnrichment6113Desc, sEnrichment6113DeliveryLabel, iEnrichment6113MessageType, tsEnrichment6113Main, iEnrichment6113Sent, iEnrichment6113Delivered, iTotalVouchersInt12, iUsedVouchersInt12, iEnrichment6113VoucherLeft, mEnrichment6114Desc, sEnrichment6114DeliveryLabel, iEnrichment6114MessageType, tsEnrichment6114Main, iEnrichment6114Sent, iEnrichment6114Delivered, iTotalVouchersInt13, iUsedVouchersInt13, iEnrichment6114VoucherLeft, mEnrichment6115Desc, sEnrichment6115DeliveryLabel, iEnrichment6115MessageType, tsEnrichment6115Main, iEnrichment6115Sent, iEnrichment6115Delivered, iTotalVouchersInt14, iUsedVouchersInt14, iEnrichment6115VoucherLeft, mEnrichment6116Desc, sEnrichment6116DeliveryLabel, iEnrichment6116MessageType, tsEnrichment6116Main, iEnrichment6116Sent, iEnrichment6116Delivered, iTotalVouchersInt15, iUsedVouchersInt15, iEnrichment6116VoucherLeft, mEnrichment6117Desc, sEnrichment6117DeliveryLabel, iEnrichment6117MessageType, tsEnrichment6117Main, iEnrichment6117Sent, iEnrichment6117Delivered, iTotalVouchersInt16, iUsedVouchersInt16, iEnrichment6117VoucherLeft, mEnrichment6118Desc, sEnrichment6118DeliveryLabel, iEnrichment6118MessageType, tsEnrichment6118Main, iEnrichment6118Sent, iEnrichment6118Delivered, iTotalVouchersInt17, iUsedVouchersInt17, iEnrichment6118VoucherLeft, mEnrichment6119Desc, sEnrichment6119DeliveryLabel, iEnrichment6119MessageType, tsEnrichment6119Main, iEnrichment6119Sent, iEnrichment6119Delivered, iTotalVouchersInt18, iUsedVouchersInt18, iEnrichment6119VoucherLeft, mEnrichment6120Desc, sEnrichment6120DeliveryLabel, iEnrichment6120MessageType, tsEnrichment6120Main, iEnrichment6120Sent, iEnrichment6120Delivered, iTotalVouchersInt19, iUsedVouchersInt19, iEnrichment6120VoucherLeft, mEnrichment6121Desc, sEnrichment6121DeliveryLabel, iEnrichment6121MessageType, tsEnrichment6121Main, iEnrichment6121Sent, iEnrichment6121Delivered, iTotalVouchersInt20, iUsedVouchersInt20, iEnrichment6121VoucherLeft, mEnrichment6122Desc, sEnrichment6122DeliveryLabel, iEnrichment6122MessageType, tsEnrichment6122Main, iEnrichment6122Sent, iEnrichment6122Delivered, iTotalVouchersInt21, iUsedVouchersInt21, iEnrichment6122VoucherLeft, mEnrichment6123Desc, sEnrichment6123DeliveryLabel, iEnrichment6123MessageType, tsEnrichment6123Main, iEnrichment6123Sent, iEnrichment6123Delivered, iTotalVouchersInt22, iUsedVouchersInt22, iEnrichment6123VoucherLeft, mEnrichment6124Desc, sEnrichment6124DeliveryLabel, iEnrichment6124MessageType, tsEnrichment6124Main, iEnrichment6124Sent, iEnrichment6124Delivered, iTotalVouchersInt23, iUsedVouchersInt23, iEnrichment6124VoucherLeft, mTargetDataEnrichment811Desc, sEnrichment811DeliveryLabel, iEnrichment811MessageType, tsEnrichment811Main, iEnrichment811Sent, iEnrichment811Delivered, iTotalVouchersInt24, iUsedVouchersInt24, iEnrichment811VoucherLeft, mTargetDataEnrichment812Desc, sEnrichment812DeliveryLabel, iEnrichment812MessageType, tsEnrichment812Main, iEnrichment812Sent, iEnrichment812Delivered, iTotalVouchersInt25, iUsedVouchersInt25, iEnrichment812VoucherLeft, mTargetDataEnrichment813Desc, sEnrichment813DeliveryLabel, iEnrichment813MessageType, tsEnrichment813Main, iEnrichment813Sent, iEnrichment813Delivered, iTotalVouchersInt26, iUsedVouchersInt26, iEnrichment813VoucherLeft, mTargetDataEnrichment814Desc, sEnrichment814DeliveryLabel, iEnrichment814MessageType, tsEnrichment814Main, iEnrichment814Sent, iEnrichment814Delivered, iTotalVouchersInt27, iUsedVouchersInt27, iEnrichment814VoucherLeft, mTargetDataEnrichment815Desc, sEnrichment815DeliveryLabel, iEnrichment815MessageType, tsEnrichment815Main, iEnrichment815Sent, iEnrichment815Delivered, iTotalVouchersInt28, iUsedVouchersInt28, iEnrichment815VoucherLeft, mTargetDataEnrichment816Desc, sEnrichment816DeliveryLabel, iEnrichment816MessageType, tsEnrichment816Main, iEnrichment816Sent, iEnrichment816Delivered, iTotalVouchersInt29, iUsedVouchersInt29, iEnrichment816VoucherLeft, mTargetDataEnrichment817Desc, sEnrichment817DeliveryLabel, iEnrichment817MessageType, tsEnrichment817Main, iEnrichment817Sent, iEnrichment817Delivered, iTotalVouchersInt30, iUsedVouchersInt30, iEnrichment817VoucherLeft, mTargetDataEnrichment818Desc, sEnrichment818DeliveryLabel, iEnrichment818MessageType, tsEnrichment818Main, iEnrichment818Sent, iEnrichment818Delivered, iTotalVouchersInt31, iUsedVouchersInt31, iEnrichment818VoucherLeft, mTargetDataEnrichment819Desc, sEnrichment819DeliveryLabel, iEnrichment819MessageType, tsEnrichment819Main, iEnrichment819Sent, iEnrichment819Delivered, iTotalVouchersInt32, iUsedVouchersInt32, iEnrichment819VoucherLeft, mEnrichment8110Desc, sEnrichment8110DeliveryLabel, iEnrichment8110MessageType, tsEnrichment8110Main, iEnrichment8110Sent, iEnrichment8110Delivered, iTotalVouchersInt33, iUsedVouchersInt33, iEnrichment8110VoucherLeft, mEnrichment8111Desc, sEnrichment8111DeliveryLabel, iEnrichment8111MessageType, tsEnrichment8111Main, iEnrichment8111Sent, iEnrichment8111Delivered, iTotalVouchersInt34, iUsedVouchersInt34, iEnrichment8111VoucherLeft, mEnrichment8112Desc, sEnrichment8112DeliveryLabel, iEnrichment8112MessageType, tsEnrichment8112Main, iEnrichment8112Sent, iEnrichment8112Delivered, iTotalVouchersInt35, iUsedVouchersInt35, iEnrichment8112VoucherLeft, mEnrichment8113Desc, sEnrichment8113DeliveryLabel, iEnrichment8113MessageType, tsEnrichment8113Main, iEnrichment8113Sent, iEnrichment8113Delivered, iTotalVouchersInt36, iUsedVouchersInt36, iEnrichment8113VoucherLeft, mEnrichment8114Desc, sEnrichment8114DeliveryLabel, iEnrichment8114MessageType, tsEnrichment8114Main, iEnrichment8114Sent, iEnrichment8114Delivered, iTotalVouchersInt37, iUsedVouchersInt37, iEnrichment8114VoucherLeft, mEnrichment8115Desc, sEnrichment8115DeliveryLabel, iEnrichment8115MessageType, tsEnrichment8115Main, iEnrichment8115Sent, iEnrichment8115Delivered, iTotalVouchersInt38, iUsedVouchersInt38, iEnrichment8115VoucherLeft, mEnrichment8116Desc, sEnrichment8116DeliveryLabel, iEnrichment8116MessageType, tsEnrichment8116Main, iEnrichment8116Sent, iEnrichment8116Delivered, iTotalVouchersInt39, iUsedVouchersInt39, iEnrichment8116VoucherLeft, mRestOfDelivery1Desc, sDeliveryLabel, iRestOfDelivery1MessageType, tsRestOfDelivery1Main, iRestOfDelivery1Sent, iRestOfDelivery1Delivered, mRestOfDelivery2Desc, sDeliveryLabel1, iRestOfDelivery2MessageType, tsRestOfDelivery2Main, iRestOfDelivery2Sent, iRestOfDelivery2Delivered, mRestOfDelivery3Desc, sDeliveryLabel2, iRestOfDelivery3MessageType, tsRestOfDelivery3Main, iRestOfDelivery3Sent, iRestOfDelivery3Delivered, mRestOfDelivery4Desc, sDeliveryLabel3, iRestOfDelivery4MessageType, tsRestOfDelivery4Main, iRestOfDelivery4Sent, iRestOfDelivery4Delivered, mRestOfDelivery5Desc, sDeliveryLabel4, iRestOfDelivery5MessageType, tsRestOfDelivery5Main, iRestOfDelivery5Sent, iRestOfDelivery5Delivered, mRestOfDelivery6Desc, sDeliveryLabel5, iRestOfDelivery6MessageType, tsRestOfDelivery6Main, iRestOfDelivery6Sent, iRestOfDelivery6Delivered, mRestOfDelivery7Desc, sDeliveryLabel6, iRestOfDelivery7MessageType, tsRestOfDelivery7Main, iRestOfDelivery7Sent, iRestOfDelivery7Delivered, mRestOfDelivery8Desc, sDeliveryLabel7, iRestOfDelivery8MessageType, tsRestOfDelivery8Main, iRestOfDelivery8Sent, iRestOfDelivery8Delivered, mRestOfDelivery9Desc, sDeliveryLabel8, iRestOfDelivery9MessageType, tsRestOfDelivery9Main, iRestOfDelivery9Sent, iRestOfDelivery9Delivered, mRestOfDelivery10Desc, sDeliveryLabel9, iRestOfDelivery10MessageType, tsRestOfDelivery10Main, iRestOfDelivery10Sent, iRestOfDelivery10Delivered, mRestOfDelivery11Desc, sDeliveryLabel10, iRestOfDelivery11MessageType, tsRestOfDelivery11Main, iRestOfDelivery11Sent, iRestOfDelivery11Delivered, mRestOfDelivery12Desc, sDeliveryLabel11, iRestOfDelivery12MessageType, tsRestOfDelivery12Main, iRestOfDelivery12Sent, iRestOfDelivery12Delivered, mRestOfDelivery13Desc, sDeliveryLabel12, iRestOfDelivery13MessageType, tsRestOfDelivery13Main, iRestOfDelivery13Sent, iRestOfDelivery13Delivered, mRestOfDelivery14Desc, sDeliveryLabel13, iRestOfDelivery14MessageType, tsRestOfDelivery14Main, iRestOfDelivery14Sent, iRestOfDelivery14Delivered, mRestOfDelivery15Desc, sDeliveryLabel14, iRestOfDelivery15MessageType, tsRestOfDelivery15Main, iRestOfDelivery15Sent, iRestOfDelivery15Delivered, mRestOfDelivery16Desc, sDeliveryLabel15, iRestOfDelivery16MessageType, tsRestOfDelivery16Main, iRestOfDelivery16Sent, iRestOfDelivery16Delivered, mRestOfDelivery17Desc, sDeliveryLabel16, iRestOfDelivery17MessageType, tsRestOfDelivery17Main, iRestOfDelivery17Sent, iRestOfDelivery17Delivered, mRestOfDelivery18Desc, sDeliveryLabel17, iRestOfDelivery18MessageType, tsRestOfDelivery18Main, iRestOfDelivery18Sent, iRestOfDelivery18Delivered, mRestOfDelivery19Desc, sDeliveryLabel18, iRestOfDelivery19MessageType, tsRestOfDelivery19Main, iRestOfDelivery19Sent, iRestOfDelivery19Delivered, mRestOfDelivery20Desc, sDeliveryLabel19, iRestOfDelivery20MessageType, tsRestOfDelivery20Main, iRestOfDelivery20Sent, iRestOfDelivery20Delivered, mRestOfDelivery21Desc, sDeliveryLabel20, iRestOfDelivery21MessageType, tsRestOfDelivery21Main, iRestOfDelivery21Sent, iRestOfDelivery21Delivered, mRestOfDelivery22Desc, sDeliveryLabel21, iRestOfDelivery22MessageType, tsRestOfDelivery22Main, iRestOfDelivery22Sent, iRestOfDelivery22Delivered, mRestOfDelivery23Desc, sDeliveryLabel22, iRestOfDelivery23MessageType, tsRestOfDelivery23Main, iRestOfDelivery23Sent, iRestOfDelivery23Delivered, mRestOfDelivery24Desc, sDeliveryLabel23, iRestOfDelivery24MessageType, tsRestOfDelivery24Main, iRestOfDelivery24Sent, iRestOfDelivery24Delivered, mRestOfDelivery25Desc, sDeliveryLabel24, iRestOfDelivery25MessageType, tsRestOfDelivery25Main, iRestOfDelivery25Sent, iRestOfDelivery25Delivered, mRestOfDelivery26Desc, sDeliveryLabel25, iRestOfDelivery26MessageType, tsRestOfDelivery26Main, iRestOfDelivery26Sent, iRestOfDelivery26Delivered, mRestOfDelivery27Desc, sDeliveryLabel26, iRestOfDelivery27MessageType, tsRestOfDelivery27Main, iRestOfDelivery27Sent, iRestOfDelivery27Delivered, mRestOfDelivery28Desc, sDeliveryLabel27, iRestOfDelivery28MessageType, tsRestOfDelivery28Main, iRestOfDelivery28Sent, iRestOfDelivery28Delivered, mRestOfDelivery29Desc, sDeliveryLabel28, iRestOfDelivery29MessageType, tsRestOfDelivery29Main, iRestOfDelivery29Sent, iRestOfDelivery29Delivered, mRestOfDelivery30Desc, sDeliveryLabel29, iRestOfDelivery30MessageType, tsRestOfDelivery30Main, iRestOfDelivery30Sent, iRestOfDelivery30Delivered, mRestOfDelivery31Desc, sDeliveryLabel30, iRestOfDelivery31MessageType, tsRestOfDelivery31Main, iRestOfDelivery31Sent, iRestOfDelivery31Delivered, mRestOfDelivery32Desc, sDeliveryLabel31, iRestOfDelivery32MessageType, tsRestOfDelivery32Main, iRestOfDelivery32Sent, iRestOfDelivery32Delivered, mRestOfDelivery33Desc, sDeliveryLabel32, iRestOfDelivery33MessageType, tsRestOfDelivery33Main, iRestOfDelivery33Sent, iRestOfDelivery33Delivered, mRestOfDelivery34Desc, sDeliveryLabel33, iRestOfDelivery34MessageType, tsRestOfDelivery34Main, iRestOfDelivery34Sent, iRestOfDelivery34Delivered, mAdditionalDelivery1Desc, sDeliveryLabel34, iMessageType, tsAdditionalDelivery1Main, iAdditionalDelivery1Sent, iDelivered, mAdditionalDelivery2Desc, sDeliveryLabel35, iMessageType1, tsAdditionalDelivery2Main, iAdditionalDelivery2Sent, iDelivered1, mTargetDataPush1Desc, sPush1DeliveryLabel, iTargetDataPush1MessageType, tsTargetDataPush1Main, iTargetDataPush1Sent, iTargetDataPush1Delivered, mTargetDataPush2Desc, sPush2DeliveryLabel, iTargetDataPush2MessageType, tsTargetDataPush2Main, iTargetDataPush2Sent, iTargetDataPush2Delivered, mTargetDataPush3Desc, sPush3DeliveryLabel, iTargetDataPush3MessageType, tsTargetDataPush3Main, iTargetDataPush3Sent, iTargetDataPush3Delivered, mTargetDataPush4Desc, sPush4DeliveryLabel, iTargetDataPush4MessageType, tsTargetDataPush4Main, iTargetDataPush4Sent, iTargetDataPush4Delivered, mTargetDataPush5Desc, sPush5DeliveryLabel, iTargetDataPush5MessageType, tsTargetDataPush5Main, iTargetDataPush5Sent, iTargetDataPush5Delivered, mTargetDataPush6Desc, sPush6DeliveryLabel, iTargetDataPush6MessageType, tsTargetDataPush6Main, iTargetDataPush6Sent, iTargetDataPush6Delivered, mTargetDataPush7Desc, sPush7DeliveryLabel, iTargetDataPush7MessageType, tsTargetDataPush7Main, iTargetDataPush7Sent, iTargetDataPush7Delivered, mTargetDataPush8Desc, sPush8DeliveryLabel, iTargetDataPush8MessageType, tsTargetDataPush8Main, iTargetDataPush8Sent, iTargetDataPush8Delivered, mTargetDataPush9Desc, sPush9DeliveryLabel, iTargetDataPush9MessageType, tsTargetDataPush9Main, iTargetDataPush9Sent, iTargetDataPush9Delivered, mTargetDataPush10Desc, sPush10DeliveryLabel, iPush10MessageType, tsTargetDataPush10Main, iTargetDataPush10Sent, iTargetDataPush10Delivered, mTargetDataPush11Desc, sPush11DeliveryLabel, iPush11MessageType, tsTargetDataPush11Main, iTargetDataPush11Sent, iTargetDataPush11Delivered, mTargetDataPush12Desc, sPush12DeliveryLabel, iPush12MessageType, tsTargetDataPush12Main, iTargetDataPush12Sent, iTargetDataPush12Delivered, mTargetDataPush13Desc, sPush13DeliveryLabel, iPush13MessageType, tsTargetDataPush13Main, iTargetDataPush13Sent, iTargetDataPush13Delivered, mTargetDataPush14Desc, sPush14DeliveryLabel, iPush14MessageType, tsTargetDataPush14Main, iTargetDataPush14Sent, iTargetDataPush14Delivered, mTargetDataPush15Desc, s' could not be executed.
06/12/2023 23:42:36
PGS-220000 PostgreSQL error: ERROR: column "bimessageid" does not exist LINE 5: ...piration, mSeedMemberData, mSeedDSData) SELECT 0, biMessageI... ^ HINT: There is a column named "bimessageid" in table "wkdlv_425351887_data", but it cannot be referenced from this part of the query.
0 Replies