We got many records in delivery table of DEV which creating performance issue. so we deleted all the finished Deliveries data. Where by itself deleted the used templates of deliveries and technical deliveries. we did imported the package of template from Stage to DEV those CORE delivery templates but in DEV it was through an error while creating a new Delivery template.
Below is the error. Can you please help us what was missing to update in DEV to do successful creation of templates.
SQL statement 'SELECT D0.iDeliveryId, D0.sLabel, D0.sInternalName, D0.iMappingId, D0.sDesc, D0.iFolderId, D0.iFolderProcessId, D0.iState, D0.iIsModel, D0.iWeightType, D0.iWeight, D0.sValidationMode, D0.iDelayed, D0.tsContact, D0.tsValidity, D0.tsWebValidity, D0.iWebResPurged, D0.tsExtraction, D0.dDelayExtraction, D0.tsExtracted, D0.sIPAffinity, D0.iForecasted, D0.sLogin, D0.iMsgPriority, D0.tsExpectedTarget, D0.tsExpectedContent, D0.tsExpectedBudget, D0.tsExpectedExtraction, D0.tsExpectedFCP, D0.tsExpectedForecast, D0.tsExpectedEdition, D0.tsExpectedExternal, D0.tsReminderTarget, D0.tsReminderContent, D0.tsReminderBudget, D0.tsReminderExtraction, D0.tsReminderFCP, D0.tsReminderForecast, D0.tsReminderEdition, D0.tsReminderExternal, D0.iRetry, D0.iMaxRetry, D0.dRetryPeriod, D0.tsNextPass, D0.tsBroadStart, D0.tsBroadEnd, D0.tsPassStart, D0.iInsertMode, D0.iToDeliver, D0.iMidRemoteId, D0.iDeliveryProviderId, D0.iTypologyId, D0.iNeedMirrorPage, D0.sDeliveryCode, D0.iPriority, D0.tsContentModTime, D0.iUseDce, D0.iSandboxMode, D0.iUseBudgetValidation, D0.iUseTargetValidation, D0.iUseContentValidation, D0.iUseExtractionValidation, D0.iUseFCPValidation, case when IsBitSet(D0.iUseFCPValidation , 1) <> 0 then 1 else 0 end, case when IsBitSet(D0.iUseFCPValidation , 2) <> 0 then 1 else 0 end, case when IsBitSet(D0.iUseFCPValidation , 4) <> 0 then 1 else 0 end, case when IsBitSet(D0.iUseFCPValidation , 8) <> 0 then 1 else 0 end, D0.iUseTaskCreation, D0.iUseLinkedDeliveryValidation, D0.iDisableNotification, D0.iValidationMode, D0.iAssignEdition, D0.iExternalValidation, D0.iOfferCategoryId, D0.iOfferAnonymousCategoryId, D0.iOfferSpaceId, D0.iOperationId, D0.iCommitmentLevel, D0.dEstimatedCost, D0.dRealCost, D0.dComputedCost, D0.tsLastComputed, D0.iComputationState, D0.dTotalRealized, D0.dTotalMargin, D0.dTotalEstimatedRealized, D0.dTotalEstimatedMargin, D0.dRate, D0.dDuration, D0.iTargetStatus, D0.iContentStatus, D0.iBudgetStatus, D0.iExtractionStatus, D0.iSandboxStatus, D0.iWorkflowId, D0.iLinkedDeliveryId, D0.iWebAnalyticsAccountId, D0.iCmsAccountId, COALESCE(D0.sLabel, '') || E' (' || COALESCE(D0.sInternalName, '') || E')', D0.iMidSourcing, D0.iBuiltIn, D0.iMessageType, D0.iDeliveryMode, D0.iDeliveryOutlineId, D0.iSupplierModelId, D0.iHasAttachments, D0.sPublishingName, D0.sPublishingNamespace, D0.sNature, D0.iAnalysisStep, D0.iFCP, D0.iDeleteStatus, D0.iBudgetId, D1.sSchema, COALESCE(D1.sLabel, '') || E' (' || COALESCE(D1.sSchema, '') || E')', D1.iDeliveryMappingId, D1.sName, D1.sLabel, D1.sRecipientLink, D1.iBuiltIn, D1.iCreatedById, D1.iModifiedById, D1.tsCreated, D1.tsLastModified, D1.sFacebook, D1.sTwitter, D1.iDefaultOriginId, D1.sBroadLogSchema, D1.sBroadLogExclSchema, D1.sTrackingLogSchema, D1.iFolderId, COALESCE(O2.sLabel, '') || E' (' || COALESCE(O2.sName, '') || E')', O2.iOperatorId, COALESCE(O3.sLabel, '') || E' (' || COALESCE(O3.sName, '') || E')', O3.iOperatorId, COALESCE(D4.sLabel, '') || E' (' || COALESCE(D4.sInternalName, '') || E')', D4.iDeliveryId, F5.sLabel, F5.iFolderId, T6.sLabel, T6.iTypologyId, T6.sIPAffinity, F7.sLabel, F7.iFolderId, F8.sLabel, F8.iFolderId, E9.sLabel, E9.iExtAccountId, E9.iMessageType, E9.iDeliveryMode, E9.sAccount, E9.iActive, E9.sMirrorURL, X10.sLabel, X10.iFolderId, X11.sLabel, X11.iFolderId, COALESCE(O12.sLabel, '') || E' (' || COALESCE(X13.sLabel, '') || E')', O12.iOfferSpaceId, O12.iDisablePropositionStorage, O12.iUseHtmlFunction, O12.iUseTextFunction, O12.iEnvId, X13.iFolderId, D14.sLabel, D14.iDeliveryOutlineId, O15.iOperationId, O15.iLinkedOperationId, O15.iUseLinkedDeliveryValidation, O15.iOwnerId, O15.iUseBudget, COALESCE(D16.sLabel, '') || E' (' || COALESCE(D16.sInternalName, '') || E')', D16.iDeliveryId, D16.sLabel, D16.sDesc, D16.sInternalName, D16.tsStart, D16.tsEnd, D16.iStatus, D16.sJobType, D16.sXtkschema, D16.iBuiltIn, D16.iIsModel, SecondsDiff(Coalesce(D16.tsEnd , GetDate()) , D16.tsStart), D16.iFolderId, D16.iFolderProcessId, D16.iCreatedById, D16.iModifiedById, D16.tsCreated, D16.tsLastModified, D16.iFCPOrSeedCount, D16.iMidRemoteId, D16.tsScenarioModTime, D16.iToDeliver, D16.iImportReject, D16.iSeedProcessed, D16.iReject, D16.iPropositionCount, D16.iToDeliver + D16.iImportReject + D16.iReject, Percent(D16.iReject , (D16.iToDeliver + D16.iImportReject + D16.iReject)), D16.iHtml, D16.iText, D16.iMultipart, Percent(D16.iHtml , D16.iToDeliver), Percent(D16.iText , D16.iToDeliver), Percent(D16.iMultipart , D16.iToDeliver), D16.iUrl, D16.iToValidate, D16.iCtrlGrpReject, D16.iDeliveryProviderId, D16.iWeightType, D16.iWeight, D16.dRate, D16.dDuration, D16.sValidationMode, D16.iDelayed, D16.tsContact, D16.tsValidity, D16.tsWebValidity, D16.iWebResPurged, D16.tsExtraction, D16.dDelayExtraction, D16.tsExtracted, D16.sIPAffinity, D16.iForecasted, D16.sLogin, D16.iMsgPriority, D16.tsExpectedTarget, D16.tsExpectedContent, D16.tsExpectedBudget, D16.tsExpectedExtraction, D16.tsExpectedFCP, D16.tsExpectedForecast, D16.tsExpectedEdition, D16.tsExpectedExternal, D16.tsReminderTarget, D16.tsReminderContent, D16.tsReminderBudget, D16.tsReminderExtraction, D16.tsReminderFCP, D16.tsReminderForecast, D16.tsReminderEdition, D16.tsReminderExternal, D16.iSandboxMode, D16.iUseBudgetValidation, D16.iUseTargetValidation, D16.iUseContentValidation, D16.iUseExtractionValidation, D16.iUseFCPValidation, case when IsBitSet(D16.iUseFCPValidation , 1) <> 0 then 1 else 0 end, case when IsBitSet(D16.iUseFCPValidation , 2) <> 0 then 1 else 0 end, case when IsBitSet(D16.iUseFCPValidation , 4) <> 0 then 1 else 0 end, case when IsBitSet(D16.iUseFCPValidation , 8) <> 0 then 1 else 0 end, D16.iUseTaskCreation, D16.iUseLinkedDeliveryValidation, D16.iDisableNotification, D16.iValidationMode, D16.iAssignEdition, D16.iExternalValidation, D16.iRetry, D16.iMaxRetry, D16.dRetryPeriod, D16.tsNextPass, D16.tsBroadStart, D16.tsBroadEnd, D16.tsPassStart, D16.iTypologyId, D16.iMappingId, D16.iProofedDeliveryId, D16.iNeedMirrorPage, D16.iOfferSpaceId, D16.iOfferCategoryId, D16.iOfferAnonymousCategoryId, D16.iCmsAccountId, D16.sPublishingNamespace, D16.sPublishingName, D16.iInsertMode, D16.iDirty, D16.tsLastErrorComputation, D16.iErrorPending, D16.tsLastTrackingComputation, D16.iTrackingPending, D16.iProcessed, D16.iSent, D16.iSuccess, D16.iSuccessWithoutSeeds, D16.iError, D16.iNewQuarantine, D16.iUnknownUser, D16.iInvalidDomain, D16.iUnreachable, D16.iDisabled, D16.iMailboxFull, D16.iNotConnected, D16.iRefused, D16.iRecipientOpen, D16.iTotalRecipientOpen, D16.iPersonClick, D16.iRecipientClick, D16.iTotalRecipientClick, D16.iForward, D16.iMirrorPage, D16.iOptOut, D16.iTransaction, D16.dAmount, D16.iArticle, D16.iWebPage, D16.iTotalWebPage, Percent(D16.iProcessed , D16.iToDeliver), Percent(D16.iSuccess , D16.iProcessed), Percent(D16.iError , D16.iProcessed), Percent(D16.iNewQuarantine , D16.iProcessed), D16.iUnknownUser + D16.iInvalidDomain + D16.iUnreachable + D16.iDisabled + D16.iMailboxFull + D16.iNotConnected + D16.iRefused, Percent(D16.iUnknownUser , (D16.iUnknownUser + D16.iInvalidDomain + D16.iUnreachable + D16.iDisabled + D16.iMailboxFull + D16.iNotConnected + D16.iRefused)), Percent(D16.iInvalidDomain , (D16.iUnknownUser + D16.iInvalidDomain + D16.iUnreachable + D16.iDisabled + D16.iMailboxFull + D16.iNotConnected + D16.iRefused)), Percent(D16.iUnreachable , (D16.iUnknownUser + D16.iInvalidDomain + D16.iUnreachable + D16.iDisabled + D16.iMailboxFull + D16.iNotConnected + D16.iRefused)), Percent(D16.iDisabled , (D16.iUnknownUser + D16.iInvalidDomain + D16.iUnreachable + D16.iDisabled + D16.iMailboxFull + D16.iNotConnected + D16.iRefused)), Percent(D16.iMailboxFull , (D16.iUnknownUser + D16.iInvalidDomain + D16.iUnreachable + D16.iDisabled + D16.iMailboxFull + D16.iNotConnected + D16.iRefused)), Percent(D16.iNotConnected , (D16.iUnknownUser + D16.iInvalidDomain + D16.iUnreachable + D16.iDisabled + D16.iMailboxFull + D16.iNotConnected + D16.iRefused)), Percent(D16.iRefused , (D16.iUnknownUser + D16.iInvalidDomain + D16.iUnreachable + D16.iDisabled + D16.iMailboxFull + D16.iNotConnected + D16.iRefused)), Percent(D16.iErrorPending , D16.iError), case when (D16.iToDeliver - D16.iText) = 0 then 0 else round(CAST(D16.iRecipientOpen AS NUMERIC) * D16.iToDeliver / (D16.iToDeliver - D16.iText) , 0) end, Percent((case when (D16.iToDeliver - D16.iText) = 0 then 0 else round(CAST(D16.iRecipientOpen AS NUMERIC) * D16.iToDeliver / (D16.iToDeliver - D16.iText) , 0) end) , D16.iSuccessWithoutSeeds), case when (D16.iToDeliver - D16.iText) = 0 then 0 else round(CAST(D16.iTotalRecipientOpen AS NUMERIC) * D16.iToDeliver / (D16.iToDeliver - D16.iText) , 0) end, Percent((case when (D16.iToDeliver - D16.iText) = 0 then 0 else round(CAST(D16.iTotalRecipientOpen AS NUMERIC) * D16.iToDeliver / (D16.iToDeliver - D16.iText) , 0) end) , D16.iSuccessWithoutSeeds), Percent(D16.iRecipientClick , D16.iSuccessWithoutSeeds), Percent(D16.iForward , D16.iSuccessWithoutSeeds), Percent(D16.iOptOut , D16.iSuccessWithoutSeeds), Percent(D16.iTotalRecipientClick , D16.iSuccessWithoutSeeds), Percent(D16.iMirrorPage , D16.iSuccessWithoutSeeds), Percent(D16.iRecipientClick , (case when (D16.iToDeliver - D16.iText) = 0 then 0 else round(CAST(D16.iRecipientOpen AS NUMERIC) * D16.iToDeliver / (D16.iToDeliver - D16.iText) , 0) end)), Percent(D16.iTransaction , D16.iSuccessWithoutSeeds), case when D16.iTransaction = 0 then 0 else D16.dAmount / D16.iTransaction end, case when D16.iTransaction = 0 then 0 else D16.iArticle / D16.iTransaction end, D16.iWebAnalyticsAccountId, D16.tsContentModTime, D16.sNature, D16.iUseDce, D16.iAnalysisStep, D16.iMessageType, D16.iDeliveryMode, D16.iState, D16.iFCP, D16.iMidSourcing, case when D16.iMidSourcing <> 0 then D16.iMidRemoteId else D16.iDeliveryId end, D16.iPriority, D16.sDeliveryCode, D16.iHasAttachments, D16.iDeleteStatus, D16.tsDelete, D16.iCommitmentLevel, D16.dEstimatedCost, D16.dRealCost, D16.dComputedCost, D16.tsLastComputed, D16.iComputationState, D16.dTotalRealized, D16.dTotalMargin, D16.dTotalEstimatedRealized, D16.dTotalEstimatedMargin, D16.iOperationId, D16.iOwnerOperationId, D16.iRoutingDeliveryId, D16.iWorkflowId, D16.iBudgetId, D16.iSupplierModelId, D16.iLinkedDeliveryId, D16.iRecurringDeliveryId, D16.iDeliveryOutlineId, D16.iContentStatus, D16.iTargetStatus, D16.iBudgetStatus, D16.iExtractionStatus, D16.iSandboxStatus, D16.Html1, D16.Html2, D16.Html3, D16.Html4, F17.sLabel, F17.iFolderId, F18.sLabel, F18.iFolderId, COALESCE(O19.sLabel, '') || E' (' || COALESCE(O19.sName, '') || E')', O19.iOperatorId, COALESCE(O20.sLabel, '') || E' (' || COALESCE(O20.sName, '') || E')', O20.iOperatorId, E21.sLabel, E21.sMirrorURL, E21.iExtAccountId, T22.sLabel, T22.iTypologyId, COALESCE(D23.sLabel, '') || E' (' || COALESCE(D23.sSchema, '') || E')', D23.sSchema, D23.iDeliveryMappingId, D23.sName, D23.sLabel, D23.sRecipientLink, D23.iBuiltIn, D23.iCreatedById, D23.iModifiedById, D23.tsCreated, D23.tsLastModified, D23.sFacebook, D23.sTwitter, D23.iDefaultOriginId, D23.sBroadLogSchema, D23.sBroadLogExclSchema, D23.sTrackingLogSchema, D23.iFolderId, COALESCE(O24.sLabel, '') || E' (' || COALESCE(O24.sName, '') || E')', O24.iOperatorId, COALESCE(O25.sLabel, '') || E' (' || COALESCE(O25.sName, '') || E')', O25.iOperatorId, COALESCE(D26.sLabel, '') || E' (' || COALESCE(D26.sInternalName, '') || E')', D26.iDeliveryId, F27.sLabel, F27.iFolderId, COALESCE(D28.sLabel, '') || E' (' || COALESCE(D28.sInternalName, '') || E')', D28.iDeliveryId, COALESCE(O29.sLabel, '') || E' (' || COALESCE(X30.sLabel, '') || E')', O29.iOfferSpaceId, O29.iEnvId, X30.iFolderId, X31.sLabel, X31.iFolderId, X32.sLabel, X32.iFolderId, E33.sLabel, E33.iExtAccountId, E34.sLabel, E34.iExtAccountId, COALESCE(O35.sLabel, '') || E' (' || COALESCE(O35.sInternalName, '') || E')', O35.iOperationId, COALESCE(O36.sLabel, '') || E' (' || COALESCE(O36.sInternalName, '') || E')', O36.iOperationId, COALESCE(D37.sLabel, '') || E' (' || COALESCE(D37.sInternalName, '') || E')', D37.iDeliveryId, COALESCE(W38.sLabel, '') || E' (' || COALESCE(W38.sInternalName, '') || E')', W38.iWorkflowId, B39.sLabel, B39.iBudgetId, S40.sLabel, S40.iSupplierModelId, COALESCE(D41.sLabel, '') || E' (' || COALESCE(D41.sInternalName, '') || E')', D41.iDeliveryId, COALESCE(D42.sLabel, '') || E' (' || COALESCE(D42.sInternalName, '') || E')', D42.iDeliveryId, D43.sLabel, D43.iDeliveryOutlineId, L44.iDeliveryId, E45.sLabel, E45.iExtAccountId, E45.sName, E45.iType, E45.iActive, E45.iPackageAutoExport, E45.sServer, E45.sPort, E45.sAccount, E45.sPassword, E45.sTenant, E45.sImsServer, E45.sUserScope, E45.sClientId, E45.sClientSecret, E45.sCallbackServer, E45.sProvider, E45.sDbName, E45.iUnicodeData, E45.iNChar, E45.sTimezone, E45.iEncryptionType, E45.iEMailFunction, E45.iMessageType, E45.iDeliveryMode, E45.sMirrorURL, E45.iMultiMidProvider, E45.sLastMultiUsed, E45.iCreatedById, E45.iModifiedById, E45.tsCreated, E45.tsLastModified, E45.iFolderId, E45.iFolderSetOfServicesId, E45.iFdaExtAccountId, E45.iDeployed, COALESCE(O46.sLabel, '') || E' (' || COALESCE(O46.sName, '') || E')', O46.iOperatorId, COALESCE(O47.sLabel, '') || E' (' || COALESCE(O47.sName, '') || E')', O47.iOperatorId, F48.sLabel, F48.iFolderId, F49.sLabel, F49.iFolderId, E50.sLabel, E50.iExtAccountId, E51.sLabel, E51.iExtAccountId, E51.sName, E51.iType, E51.iActive, E51.iPackageAutoExport, E51.sServer, E51.sPort, E51.sAccount, E51.sPassword, E51.sTenant, E51.sImsServer, E51.sUserScope, E51.sClientId, E51.sClientSecret, E51.sCallbackServer, E51.sProvider, E51.sDbName, E51.iUnicodeData, E51.iNChar, E51.sTimezone, E51.iEncryptionType, E51.iEMailFunction, E51.iMessageType, E51.iDeliveryMode, E51.sMirrorURL, E51.iMultiMidProvider, E51.sLastMultiUsed, E51.iCreatedById, E51.iModifiedById, E51.tsCreated, E51.tsLastModified, E51.iFolderId, E51.iFolderSetOfServicesId, E51.iFdaExtAccountId, E51.iDeployed, COALESCE(O52.sLabel, '') || E' (' || COALESCE(O52.sName, '') || E')', O52.iOperatorId, COALESCE(O53.sLabel, '') || E' (' || COALESCE(O53.sName, '') || E')', O53.iOperatorId, F54.sLabel, F54.iFolderId, F55.sLabel, F55.iFolderId, E56.sLabel, E56.iExtAccountId, S57.sLabel, S57.iSupplierModelId, S57.iDeliveryModelId, B58.sLabel, B58.iBudgetId, D0.mData, D1.mData, E9.mData, O12.mData, X13.mData, O15.mData, D16.mData, D23.mData, E45.mData, E51.mData, S57.mData FROM NmsDelivery D0 INNER JOIN XtkFolder xf ON (D0.iFolderId=xf.iFolderId AND xf.iFolderId=704951) JOIN NmsDeliveryMapping D1 ON (D1.iDeliveryMappingId = D0.iMappingId) JOIN XtkOperator O2 ON (O2.iOperatorId = D1.iCreatedById) JOIN XtkOperator O3 ON (O3.iOperatorId = D1.iModifiedById) JOIN NmsDelivery D4 ON (D4.iDeliveryId = D1.iDefaultOriginId) JOIN XtkFolder F5 ON (F5.iFolderId = D1.iFolderId) JOIN NmsTypology T6 ON (T6.iTypologyId = D0.iTypologyId) JOIN XtkFolder F7 ON (F7.iFolderId = D0.iFolderId) JOIN XtkFolder F8 ON (F8.iFolderId = D0.iFolderProcessId) JOIN NmsExtAccount E9 ON (E9.iExtAccountId = D0.iDeliveryProviderId) JOIN XtkFolder X10 ON (X10.iFolderId = D0.iOfferCategoryId) JOIN XtkFolder X11 ON (X11.iFolderId = D0.iOfferAnonymousCategoryId) JOIN NmsOfferSpace O12 ON (O12.iOfferSpaceId = D0.iOfferSpaceId) JOIN XtkFolder X13 ON (X13.iFolderId = O12.iEnvId) JOIN NmsDeliveryOutline D14 ON (D14.iDeliveryOutlineId = D0.iDeliveryOutlineId) JOIN NmsOperation O15 ON (O15.iOperationId = D0.iOperationId) JOIN NmsDelivery D16 ON (D16.iDeliveryId = D0.iLinkedDeliveryId) JOIN XtkFolder F17 ON (F17.iFolderId = D16.iFolderId) JOIN XtkFolder F18 ON (F18.iFolderId = D16.iFolderProcessId) JOIN XtkOperator O19 ON (O19.iOperatorId = D16.iCreatedById) JOIN XtkOperator O20 ON (O20.iOperatorId = D16.iModifiedById) JOIN NmsExtAccount E21 ON (E21.iExtAccountId = D16.iDeliveryProviderId) JOIN NmsTypology T22 ON (T22.iTypologyId = D16.iTypologyId) JOIN NmsDeliveryMapping D23 ON (D23.iDeliveryMappingId = D16.iMappingId) JOIN XtkOperator O24 ON (O24.iOperatorId = D23.iCreatedById) JOIN XtkOperator O25 ON (O25.iOperatorId = D23.iModifiedById) JOIN NmsDelivery D26 ON (D26.iDeliveryId = D23.iDefaultOriginId) JOIN XtkFolder F27 ON (F27.iFolderId = D23.iFolderId) JOIN NmsDelivery D28 ON (D28.iDeliveryId = D16.iProofedDeliveryId) JOIN NmsOfferSpace O29 ON (O29.iOfferSpaceId = D16.iOfferSpaceId) JOIN XtkFolder X30 ON (X30.iFolderId = O29.iEnvId) JOIN XtkFolder X31 ON (X31.iFolderId = D16.iOfferCategoryId) JOIN XtkFolder X32 ON (X32.iFolderId = D16.iOfferAnonymousCategoryId) JOIN NmsExtAccount E33 ON (E3' could not be executed.
Param(0)=3283813
Param(1)=0
The requested database record does not exist.
Cannot load document of type 'Deliveries (nms:delivery)' satisfying condition '(@id = 3283813) AND ((@deleteStatus = 0))'.
------
