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.
Solved! Go to 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.
Views
Replies
Total Likes
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
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
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
Views
Likes
Replies