'Error while loading the detail 'in campaign

[priyankah586599]

Hi there,

Why does such error occur often in the campaign? We are creating new workfow everytime it occurs.

Regards,

Priyanka

[Vipul_Raghav]

HI Priyanka,

You need to study the entire SQL and understand which JOIN is breaking the query for you.

If you can paste the query we can try to assist but it has to be checked against your underlying data.

Regards,
Vipul

[priyankah586599]

Hi Vipul,

Sorry I didnt understand which query you meant. I'm pasting the query which came up in the error window.

WDB-200001 SQL statement 'SELECT   O0.iOperationId, O0.sLabel, O0.sInternalName, O0.iUseBudget, O0.iUseTask, O0.iUseBudgetValidation, O0.iUseTargetValidation, O0.iUseContentValidation, O0.iUseExtractionValidation, O0.iUseFCPValidation, case when IsBitSet(O0.iUseFCPValidation , 1) <> 0 then 1 else 0 end, case when IsBitSet(O0.iUseFCPValidation , 2) <> 0 then 1 else 0 end, case when IsBitSet(O0.iUseFCPValidation , 4) <> 0 then 1 else 0 end, case when IsBitSet(O0.iUseFCPValidation , 8) <> 0 then 1 else 0 end, O0.iUseTaskCreation, O0.iUseLinkedDeliveryValidation, O0.iDisableNotification, O0.iValidationMode, O0.iSandboxMode, O0.iAssignEdition, O0.iExternalValidation, O0.iLinkedOperationId, O0.iIsModel, case when O0.iCancelState <> 0 then O0.iCancelState else case when O0.iSandboxMode = 2 and O0.iLinkedOperationId <> 0 then 5 else case when O0.iIsModel = 0 and DateOnly(GetDate(), 'Asia/Calcutta') > O0.tsEnd then 2 else case when O0.iIsModel = 0 and GetDate() > O0.tsStart then 1 else 0 end end end end, COALESCE(O0.sLabel, '') || E' (' || COALESCE(O0.sInternalName, '') || E')', O0.sCampaignCode, O0.sNature, O0.iType, O0.iOwnerId, O0.iProgramProcessId, O0.iMessageType, O0.iProductLineId, O0.sProductContent, O0.iProductSender, O0.iProductPlatformId, O0.iSenderId, O0.iSectorId, O0.iSectorSender, O0.iSalesDivisionId, O0.iSalesRegionId, O0.iSalesChannelId, O0.sMarketingGroupId, O0.iMarketingSubgroupId, O0.iDivision, O0.sCommTypeId, O0.iCommSubTypeId, O0.iUmbrellaBrandId, O0.iTargetPlatformId, O0.iCampaignAudienceId, O0.iSubjectAreaId, O0.sSalesSupportMaterial, O0.sMarketingRefNumber, O0.sCampaignKeywordId, COALESCE(O0.sMarketingGroupId, '') || E'_' || COALESCE(text(L12.iLut_MarketingSubGroupId), '') || E'_' || COALESCE(O0.sCommTypeId, '') || E'_' || COALESCE(O0.sProductContent, '') || E'_' || COALESCE(O0.sCampaignKeywordId, '') || E'_' || COALESCE(text(Extract(MONTH FROM O0.tsStart)), '') || E'_' || COALESCE(text(Extract(YEAR FROM O0.tsStart)), '') || E'_' || COALESCE(text(O0.iOperationId), ''), O0.tsStart, O0.tsEnd, O0.dDuration, O0.dPeriodCovered, O0.iBudgetId, O0.iCommitmentLevel, O0.iBudgetStatus, O0.dEstimatedCost, O0.dRealCost, O0.dComputedCost, O0.tsLastComputed, O0.iComputationState, O0.dFixedCost, O0.iPriority, O0.iForecasted, O0.iFcpGroupId, O0.iWebAnalyticsAccountId, O0.iProgramId, X1.sFullName, X1.iFolderId, COALESCE(O2.sLabel, '') || E' (' || COALESCE(O2.sName, '') || E')', O2.iOperatorId, O2.iType, X3.sLabel, X3.iFolderId, X3.sFullName, COALESCE(L4.sDesc, '') || E' (' || COALESCE(text(L4.iLut_ProductLineId), '') || E')', L4.iLut_ProductLineId, COALESCE(L5.sDesc, '') || E' (' || COALESCE(text(L5.iLut_ProductPlatformId), '') || E')', L5.iLut_ProductPlatformId, COALESCE(L6.sDesc, '') || E' (' || COALESCE(text(L6.iLut_SenderId), '') || E')', L6.iLut_SenderId, COALESCE(L7.sDesc, '') || E' (' || COALESCE(text(L7.iLut_SectorId), '') || E')', L7.iLut_SectorId, COALESCE(L8.sDesc, '') || E' (' || COALESCE(text(L8.iLut_SalesDivisionId), '') || E')', L8.iLut_SalesDivisionId, COALESCE(L9.sDesc, '') || E' (' || COALESCE(text(L9.iLut_SalesRegionId), '') || E')', L9.iLut_SalesRegionId, COALESCE(L10.sDesc, '') || E' (' || COALESCE(text(L10.iLut_SalesChannelId), '') || E')', L10.iLut_SalesChannelId, COALESCE(L11.sDesc, '') || E' (' || COALESCE(L11.sSId, '') || E')', L11.sSId, COALESCE(L12.sMarketinSubGroupDesc, '') || E' (' || COALESCE(L12.sMarketinGroupId, '') || E')', L12.iLut_MarketingSubGroupId, COALESCE(L13.sDesc, '') || E' (' || COALESCE(L13.sSId, '') || E')', L13.sSId, COALESCE(L14.sTypeLevel2, '') || COALESCE(case when L14.sTypeLevel3 IS NOT NULL  then E' - ' || COALESCE(L14.sTypeLevel3, '') else NULL end, '') || COALESCE(case when L14.sCommunicationTypeId IS NOT NULL  then E'(' || COALESCE(L14.sCommunicationTypeId, '') || E')' else NULL end, ''), L14.iLut_CommunicationSubTypeId, COALESCE(L15.sDesc, '') || E' (' || COALESCE(text(L15.iLut_UmbrellaBrandId), '') || E')', L15.iLut_UmbrellaBrandId, COALESCE(L16.sPlatform, '') || E' (' || COALESCE(text(L16.iLut_TargetPlatformId), '') || E')', L16.iLut_TargetPlatformId, COALESCE(L17.sDescription, '') || E' (' || COALESCE(L17.sCode, '') || E')', L17.iLut_CampaignAudienceId, COALESCE(L18.sLevel1Desc, '') || COALESCE(case when L18.sLevel2Desc IS NOT NULL  then E' - ' || COALESCE(L18.sLevel2Desc, '') else NULL end, '') || COALESCE(case when L18.sLevel3Desc IS NOT NULL  then E' - ' || COALESCE(L18.sLevel3Desc, '') else NULL end, '') || E' (' || COALESCE(text(L18.iLut_SubjectAreaId), '') || E')', L18.iLut_SubjectAreaId, COALESCE(L19.sDesc, '') || E' (' || COALESCE(L19.sSId, '') || E')', L19.sSId, B20.sLabel, B20.iBudgetId, COALESCE(O21.sLabel, '') || E' (' || COALESCE(O21.sInternalName, '') || E')', O21.iOperationId, case when O21.iCancelState <> 0 then O21.iCancelState else case when O21.iSandboxMode = 2 and O21.iLinkedOperationId <> 0 then 5 else case when O21.iIsModel = 0 and DateOnly(GetDate(), 'Asia/Calcutta') > O21.tsEnd then 2 else case when O21.iIsModel = 0 and GetDate() > O21.tsStart then 1 else 0 end end end end, COALESCE(G22.sLabel, '') || E' (' || COALESCE(G22.sName, '') || E')', G22.iGroupId, G22.iCreatedFrom, E23.sLabel, E23.iExtAccountId, E23.iType, O0.mData FROM NmsOperation O0 JOIN XtkFolder X1 ON (X1.iFolderId = O0.iProgramId) JOIN XtkOperator O2 ON (O2.iOperatorId = O0.iOwnerId) JOIN XtkFolder X3 ON (X3.iFolderId = O0.iProgramProcessId) JOIN ElsLut_ProductLine L4 ON (L4.iLut_ProductLineId = O0.iProductLineId) JOIN ElsLut_ProductPlatform L5 ON (L5.iLut_ProductPlatformId = O0.iProductPlatformId) JOIN ElsLut_Sender L6 ON (L6.iLut_SenderId = O0.iSenderId) JOIN ElsLut_Sector L7 ON (L7.iLut_SectorId = O0.iSectorId) JOIN ElsLut_SalesDivision L8 ON (L8.iLut_SalesDivisionId = O0.iSalesDivisionId) JOIN ElsLut_SalesRegion L9 ON (L9.iLut_SalesRegionId = O0.iSalesRegionId) JOIN ElsLut_SalesChannel L10 ON (L10.iLut_SalesChannelId = O0.iSalesChannelId) JOIN ElsLut_MarketingGroup L11 ON (L11.sSId = O0.sMarketingGroupId) JOIN ElsLut_MarketingSubGroup L12 ON (L12.iLut_MarketingSubGroupId = O0.iMarketingSubgroupId) JOIN ElsLut_CommunicationType L13 ON (L13.sSId = O0.sCommTypeId) JOIN ElsLut_CommunicationSubType L14 ON (L14.iLut_CommunicationSubTypeId = O0.iCommSubTypeId) JOIN ElsLut_UmbrellaBrand L15 ON (L15.iLut_UmbrellaBrandId = O0.iUmbrellaBrandId) JOIN ElsLut_TargetPlatform L16 ON (L16.iLut_TargetPlatformId = O0.iTargetPlatformId) JOIN ElsLut_CampaignAudience L17 ON (L17.iLut_CampaignAudienceId = O0.iCampaignAudienceId) JOIN ElsLut_SubjectArea L18 ON (L18.iLut_SubjectAreaId = O0.iSubjectAreaId) JOIN ElsLut_campaignKeyword L19 ON (L19.sSId = O0.sCampaignKeywordId) JOIN NmsBudget B20 ON (B20.iBudgetId = O0.iBudgetId) JOIN NmsOperation O21 ON (O21.iOperationId = O0.iLinkedOperationId) JOIN NmsGroup G22 ON (G22.iGroupId = O0.iFcpGroupId) JOIN NmsExtAccount E23 ON (E23.iExtAccountId = O0.iWebAnalyticsAccountId) WHERE (O0.iOperationId = :#(1)#)' could not be executed.

  Param(0)=465031768

WDB-200011 The requested database record does not exist.

Unable to load document of type 'Campaigns (nms:operation)' because link 'FK_Campaign_SubjectArea' with condition '@id = 803' not found in the database.

------

Regards,

Priyanka

[priyankah586599]

Hi Vipul,

Any hints?

Regards,

Priyanka

[Vipul_Raghav · Accepted solution]

HI Priyanka,

The error message states that there is a missing record in the related table of nms:operation on the other side of relation 'FK_Campaign_SubjectArea'. It seems you have a table SubjectArea inside your database and for this campaign, the foreign key field holds the value 803.

Unable to load document of type 'Campaigns (nms:operation)' because link 'FK_Campaign_SubjectArea' with condition '@id = 803' not found in the database.

Can you check if Subject Area table has a record with PK as 803. If not, try to identify what value this record held and try to add a new record with the same PK.

Regards,
Vipul

[AdobeDeveloper1]

Hi Vipul,

I have the similer error message which I get on daily basis :

can you please make me understand this as well?

WDB-200001 SQL statement
'SELECT   R0.iRecipientId, R0.sLastName, R0.sFirstName, R0.sEmail, R0.sSalutation, R0.sMiddleName, R0.sAccount, R0.iStatus, R0.sCompany, R0.iGender, R0.sLanguage, R0.tsBirth, R0.iBlackList, R0.iFolderId, R0.iEmailFormat, R0.sMobilePhone, R0.sFax, R0.sPhone, R0.sOrigin, R0.sAddress1, R0.sAddress2, R0.sAddress3, R0.sAddress4, R0.sZipCode, R0.sCity, R0.sCountryCode, R0.sStateCode, AllNonNull3(R0.sZipCode , R0.sCity , R0.sLastName), R0.iAddrErrorCount, R0.iAddrQuality, R0.tsAddrLastCheck, R0.sText1, R0.sText2, R0.sText3, R0.sText4, R0.sText5, R0.iBoolean1, R0.iBoolean2, R0.iBoolean3, F1.sLabel, F1.iFolderId, F1.sFullName, case when 'eng' = 'fra' then C2.sLabelFR else case when 'eng' = 'deu' then C2.sLabelDE else case when 'eng' = 'jpn' then C2.sLabelJA else C2.sLabelEN end end end, C2.sIsoA2, case when 'eng' = 'jpn' then NULL else S3.sCode || ' - ' end || case when 'eng' = 'fra' then S3.sLabelFR else case when 'eng' = 'deu' then S3.sLabelDE else case when 'eng' = 'jpn' then S3.sLabelJA else S3.sLabelEN end end end, S3.sCode, S3.sCountryCode, case when 'eng' = 'fra' then C4.sLabelFR else case when 'eng' = 'deu' then C4.sLabelDE else case when 'eng' = 'jpn' then C4.sLabelJA else C4.sLabelEN end end end, case when 'eng' = 'fra' then C4.sLabelFR else case when 'eng' = 'deu' then C4.sLabelDE else case when 'eng' = 'jpn' then C4.sLabelJA else C4.sLabelEN end end end, C4.sIsoA2, R0.mData FROM NmsRecipient R0 JOIN XtkFolder F1 ON (F1.iFolderId = R0.iFolderId) LEFT JOIN NmsCountry C2 ON (C2.sIsoA2 = R0.sCountryCode) LEFT JOIN NmsState S3 ON (S3.sCode = R0.sStateCode AND S3.sCountryCode = R0.sCountryCode) LEFT JOIN NmsCountry C4 ON (C4.sIsoA2 = S3.sCountryCode) WHERE ((R0.iFolderId IN (SELECT xr.iFolderId FROM XtkRights xr WHERE xr.iOperatorId IN (6762030, 65221)) OR R0.iFolderId=0)) AND (((R0.iFolderId IN (SELECT xr.iFolderId FROM XtkRights xr WHERE xr.iOperatorId IN (6762030, 65221)) OR R0.iFolderId=0)) AND ((R0.iRecipientId = :1)))'

could not be executed.
 
  
 
  09/16/2017 10:41:36 AM Failed Invalid domain  No mx records have been found! Domain: ''; Type: 28; Time used: 0 ms
WDB-200011 The requested database record does not exist

Cannot load document of type 'Recipients (nms:recipient)' satisfying condition '([/@id] = 8545834)'