Deleted delivery templates

Avatar

Avatar
Validate 10
Level 2
Jaspreet_Kaur1
Level 2

Likes

9 likes

Total Posts

26 posts

Correct reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 10
Level 2
Jaspreet_Kaur1
Level 2

Likes

9 likes

Total Posts

26 posts

Correct reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 1
View profile
Jaspreet_Kaur1
Level 2

06-03-2018

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.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 10
Level 2
Jaspreet_Kaur1
Level 2

Likes

9 likes

Total Posts

26 posts

Correct reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 10
Level 2
Jaspreet_Kaur1
Level 2

Likes

9 likes

Total Posts

26 posts

Correct reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 1
View profile
Jaspreet_Kaur1
Level 2

07-03-2018

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.

Answers (2)

Answers (2)

Avatar

Avatar
Establish
Employee
Adhiyan
Employee

Likes

241 likes

Total Posts

343 posts

Correct reply

124 solutions
Top badges earned
Establish
Give Back 50
Give Back 25
Give Back 10
Give Back 5
View profile

Avatar
Establish
Employee
Adhiyan
Employee

Likes

241 likes

Total Posts

343 posts

Correct reply

124 solutions
Top badges earned
Establish
Give Back 50
Give Back 25
Give Back 10
Give Back 5
View profile
Adhiyan
Employee

06-03-2018

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

Avatar

Avatar
Springboard
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct reply

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

Avatar
Springboard
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct reply

231 solutions
Top badges earned
Springboard
Ignite 5
Ignite 3
Ignite 1
Validate 10
View profile
Amit_Kumar
MVP

06-03-2018

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