Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

'Error while loading the detail 'in campaign

Avatar

Avatar
Validate 10
Level 3
priyankah586599
Level 3

Likes

23 likes

Total Posts

89 posts

Correct Reply

4 solutions
Top badges earned
Validate 10
Validate 1
Ignite 5
Ignite 3
Ignite 1
View profile

Avatar
Validate 10
Level 3
priyankah586599
Level 3

Likes

23 likes

Total Posts

89 posts

Correct Reply

4 solutions
Top badges earned
Validate 10
Validate 1
Ignite 5
Ignite 3
Ignite 1
View profile
priyankah586599
Level 3

07-09-2017

Hi there,

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

image-2017-09-07-17-23-12-262.pngimage-2017-09-07-17-24-40-691.pngimage-2017-09-07-17-25-26-907.png

Regards,

Priyanka

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

370 likes

Total Posts

726 posts

Correct Reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

370 likes

Total Posts

726 posts

Correct Reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
Vapsy
Employee

10-09-2017

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

Answers (4)

Answers (4)

Avatar

Avatar
Validate 1
Level 1
AdobeDeveloper1
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 1
AdobeDeveloper1
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
Applaud 5
View profile
AdobeDeveloper1
Level 1

20-09-2017

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)'

Avatar

Avatar
Validate 10
Level 3
priyankah586599
Level 3

Likes

23 likes

Total Posts

89 posts

Correct Reply

4 solutions
Top badges earned
Validate 10
Validate 1
Ignite 5
Ignite 3
Ignite 1
View profile

Avatar
Validate 10
Level 3
priyankah586599
Level 3

Likes

23 likes

Total Posts

89 posts

Correct Reply

4 solutions
Top badges earned
Validate 10
Validate 1
Ignite 5
Ignite 3
Ignite 1
View profile
priyankah586599
Level 3

08-09-2017

Hi Vipul,

Any hints?

Regards,

Priyanka

Avatar

Avatar
Validate 10
Level 3
priyankah586599
Level 3

Likes

23 likes

Total Posts

89 posts

Correct Reply

4 solutions
Top badges earned
Validate 10
Validate 1
Ignite 5
Ignite 3
Ignite 1
View profile

Avatar
Validate 10
Level 3
priyankah586599
Level 3

Likes

23 likes

Total Posts

89 posts

Correct Reply

4 solutions
Top badges earned
Validate 10
Validate 1
Ignite 5
Ignite 3
Ignite 1
View profile
priyankah586599
Level 3

07-09-2017

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 , 😎 <> 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

Avatar

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

370 likes

Total Posts

726 posts

Correct Reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

370 likes

Total Posts

726 posts

Correct Reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
Vapsy
Employee

07-09-2017

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