Deleted delivery templates

[#1]

Accidentally, few out of the box delivery templates have been deleted from the system and while trying to import the package of same template from the other environment, its giving error. Can anyone suggest the way to restore ?

3:19:42 - PGS-220000 PostgreSQL error: ERROR:  duplicate key value violates unique constraint "nmsdelivery_internalname" DETAIL:  Key (sinternalname)=(notifySupervisor) already exists.

13:19:42 - WDB-200001 SQL statement 'INSERT INTO NmsDelivery (iDeliveryId, sLabel, sInternalName, sXtkschema, iBuiltIn, iIsModel, iFolderId, iFolderProcessId, iModifiedById, tsLastModified, iDeliveryProviderId, sValidationMode, iMaxRetry, dRetryPeriod, iTypologyId, iMappingId, iMessageType, iDeliveryMode, iContactElement, iStatus, sJobType, iCreatedById, tsCreated, iWeightType, iWeight, dRate, dDuration, iWebResPurged, dDelayExtraction, iMsgPriority, iSandboxMode, iUseBudgetValidation, iUseTargetValidation

13:19:42 - , iUseContentValidation, iUseExtractionValidation, iUseFCPValidation, iValidationMode, iNeedMirrorPage, iInsertMode, iPublicationStatus, iAnalysisStep, iState, iPriority, iDeleteStatus, iDepartment, iCommitmentLevel, iComputationState, iContentStatus, iTargetStatus, iBudgetStatus, iExtractionStatus, iSandboxStatus, mData) VALUES (:#(1)#, :#(2)#, :#(3)#, :#(4)#, :#(5)#, :#(6)#, :#(7)#, :#(8)#, :#(9)#, :#(10)#, :#(11)#, :#(12)#, :#(13)#, :#(14)#, :#(15)#, :#(16)#, :#(17)#, :#(18)#, :#(19)#, :#(20)

13:19:42 - #, :#(21)#, :#(22)#, :#(23)#, :#(24)#, :#(25)#, :#(26)#, :#(27)#, :#(28)#, :#(29)#, :#(30)#, :#(31)#, :#(32)#, :#(33)#, :#(34)#, :#(35)#, :#(36)#, :#(37)#, :#(38)#, :#(39)#, :#(40)#, :#(41)#, :#(42)#, :#(43)#, :#(44)#, :#(45)#, :#(46)#, :#(47)#, :#(48)#, :#(49)#, :#(50)#, :#(51)#, :#(52)#, :#(53)#)' could not be executed.   Param(0)=106720120   Param(1)=Notification of the workflow supervisor   Param(2)=notifySupervisor   Param(3)=nms:delivery   Param(4)=1   Param(5)=1   Param(6)=1163   Param(7)

13:19:42 - =1172   Param(8)=24702251   Param(9)=06/03/2018 13:19:42   Param(10)=3621   Param(11)=auto   Param(12)=5   Param(13)=1h   Param(14)=3619   Param(15)=3626   Param(16)=0   Param(17)=1   Param(18)=0   Param(19)=0   Param(20)=delivery   Param(21)=24702251   Param(22)=06/03/2018 13:19:42   Param(23)=0   Param(24)=5   Param(25)=100   Param(26)=1   Param(27)=0   Param(28)=0s   Param(29)=0   Param(30)=0   Param(31)=1   Param(32)=1   Param(33)=1   Param(34)=1   Param(35)=1   Param(36)=0   Param(37)=0   P

13:19:42 - aram(38)=0   Param(39)=0   Param(40)=0   Param(41)=0   Param(42)=10   Param(43)=0   Param(44)=0   Param(45)=0   Param(46)=0   Param(47)=0   Param(48)=0   Param(49)=0   Param(50)=0   Param(51)=0   Param(52)=<?xml version='1.0'?> <delivery launchFCP="0" maxPropositionCount="1" outOfProcess="false" useTargetOffers="false"><properties deliveryState="0" warning="false"/><forecast simuResponseType="0"><weightFormula>$(deliveryWeight)</weightFormula></forecast><sc

13:19:42 - Package 'Del-notifySupervisor': Saving entities of type 'xtk:specFile'...

13:19:42 - Installation of packages successful.

[#2 · Accepted solution]

Thanks Adhiyan and Amit for the inputs.

The template was deleted accidentally deleted from the system and was not even present in the deleted deliveries folder.. seems it was deleted 7 days before I checked. Also, importing the same template from higher env was causing issues even by renaming the internal name.

So, the issue got sorted by changing the template status to 0 (i.e ideleteStatus='0' ) by running a SQL query.

[#3]

Hi Jaspreet,

The error suggest that you still have the template called notifySupervisor in the database.

Can you query the nms: delivery schema and filter on this internal name to see if it exists. I doubt it's just moved from one folder to another.

Regards,

Adhiyan

[#4]

Hi Jaspreet,

Create a new view of the delivery templates in your instance and identify the missing models and only import the missing one. To fix this import problem Search  "notifySupervisor" in your Del-notifySupervisor package content that you are importing in your instance and either rename this internal name to something else or remove this entity from the content. You are trying to import a delivery template which already exists in your instance.

Regards,

Amit