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

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.

View Entire Topic

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.