Join us for the Adobe Campaign Community Q&A Coffee Break on 30th September at 8 am PT with Campaign experts Arthur Lacroix and Sandra Hausmann.
PGS-220000 PostgreSQL error: ERROR: duplicate key value violates unique constraint "nmscountry_labelja" 7.0.9359
I am getting the error on a brand new deployment, unicode database option checked on deployment, underlying OS RHEL8 and PostgreSQL14
Submitting job to the server
13:57:46 - Dropping database 'campaign'
13:57:46 - Creating new database 'campaign'
13:57:46 - Granting rights on database 'campaign' to user 'neolane'
13:57:47 - Enumerating the file entities...
13:57:48 - Generating schemas...
13:57:49 - Executing SQL script 'xtk:postgresql-functions.sql'...
13:57:49 - Starting 1 connection(s) on pool 'default garcia' (PostgreSQL, server='192.168.0.30', login='neolane:campaign')
13:57:49 - Creating DDL procedures
13:57:49 - Creating standard date and time functions
13:57:49 - Creating standard string functions
13:57:49 - Creating standard bitwise functions
13:57:49 - Executing SQL script 'xtk:postgresql-nldb.sql'...
13:57:49 - Creating Id generator
13:57:49 - Creating specific Id generator for xtkworkflowlogs
13:57:49 - Creating specific Id generator for xtkworkflowtask
13:57:49 - Creating specific Id generator for xtkworkflowevent
13:57:49 - Creating specific Id generator for NmsGroup
13:57:49 - Creating specific Id generator for XtkWorkflowJob
13:57:49 - Creating specific Id generator for NmsCostLine
13:57:49 - Creating specific Id generator for NmsExpenseLine
13:57:49 - Creating table 'XtkAudit'
13:57:49 - Creating table 'XtkConflict'
13:57:49 - Creating table 'XtkCounter'
13:57:49 - Creating table 'XtkDashboard'
13:57:49 - Creating table 'XtkJob'
13:57:49 - Creating table 'XtkEntity'
13:57:49 - Creating table 'XtkReject'
13:57:49 - Creating table 'XtkDictionaryString'
13:57:49 - Creating table 'XtkEnum'
13:57:49 - Creating table 'XtkEnumAlias'
13:57:49 - Creating table 'XtkEnumValue'
13:57:49 - Creating table 'XtkFileRes'
13:57:49 - Creating table 'XtkFileResData'
13:57:49 - Creating table 'XtkFileResHistory'
13:57:49 - Creating table 'XtkFolder'
13:57:49 - Creating table 'XtkFormRendering'
13:57:49 - Creating table 'XtkOperator'
13:57:49 - Creating table 'XtkJobLog'
13:57:49 - Creating table 'XtkOlapAggregate'
13:57:49 - Creating table 'XtkOlapCube'
13:57:49 - Creating table 'XtkOlapDimension'
13:57:49 - Creating table 'XtkOlapMeasure'
13:57:49 - Creating table 'XtkOperatorGroup'
13:57:49 - Creating table 'XtkOption'
13:57:49 - Creating table 'XtkPackageInstall'
13:57:49 - Creating table 'XtkPkgInstRel'
13:57:49 - Creating table 'XtkQueryFilter'
13:57:49 - Creating table 'XtkReport'
13:57:49 - Creating table 'XtkReportHistory'
13:57:49 - Creating table 'XtkReportRights'
13:57:49 - Creating table 'XtkRights'
13:57:49 - Creating table 'XtkSessionInfo'
13:57:49 - Creating table 'XtkWorkflow'
13:57:49 - Creating table 'XtkWorkflowEvent'
13:57:49 - Creating table 'XtkWorkflowJob'
13:57:49 - Creating table 'XtkWorkflowLog'
13:57:49 - Creating table 'XtkWorkflowLogin'
13:57:49 - Creating table 'XtkWorkflowTask'
13:57:50 - Creating table 'NmsCountry'
13:57:50 - Creating table 'NmsState'
13:57:50 - Creating table 'NmsActiveContact'
13:57:50 - Creating table 'NmsActiveContactReport'
13:57:50 - Creating table 'NmsActiveContactReportDetail'
13:57:50 - Creating table 'NmsAddress'
13:57:50 - Creating table 'NmsBilling'
13:57:50 - Creating table 'NmsBroadLogRcp'
13:57:50 - Creating table 'NmsBroadLogVisitor'
13:57:50 - Creating table 'NmsExcludeLogRcp'
13:57:50 - Creating table 'NmsBroadLogOp'
13:57:50 - Creating table 'NmsBroadLogMsg'
13:57:50 - Creating table 'NmsProviderMsgId'
13:57:50 - Creating table 'NmsTypology'
13:57:50 - Creating table 'NmsTypologyRule'
13:57:50 - Creating table 'NmsTypologyRuleRel'
13:57:50 - Creating table 'NmsDelivery'
13:57:50 - Creating table 'NmsAttachments'
13:57:50 - Creating table 'NmsSeedMember'
13:57:50 - Creating table 'NmsDeliveryMapping'
13:57:50 - Creating table 'NmsDeliveryPart'
13:57:50 - Creating table 'NmsDeliveryStat'
13:57:50 - Creating table 'NmsDeliveryLogStats'
13:57:50 - Creating table 'NmsDlvExclusion'
13:57:50 - Creating table 'NmsDomain'
13:57:50 - Creating table 'NmsExtAccount'
13:57:50 - Creating table 'NmsGroup'
13:57:50 - Creating table 'NmsIncludeView'
13:57:50 - Creating table 'NmsMirrorPageInfo'
13:57:50 - Creating table 'NmsMirrorPageSearch'
13:57:50 - Creating table 'NmsRcpGrpRel'
13:57:50 - Creating table 'NmsRecipient'
13:57:50 - Creating table 'NmsVisitor'
13:57:50 - Creating table 'NmsRuleSet'
13:57:50 - Creating table 'NmsService'
13:57:50 - Creating table 'NmsSubHisto'
13:57:50 - Creating table 'NmsSubscription'
13:57:50 - Creating table 'NmsTrackingLogRcp'
13:57:50 - Creating table 'NmsTrackingLogVisitor'
13:57:50 - Creating table 'NmsTrackingStats'
13:57:50 - Creating table 'NmsTrackingUrl'
13:57:50 - Creating table 'NmsTrackingUrlInfo'
13:57:50 - Creating table 'NmsUserAgent'
13:57:50 - Creating table 'NmsUserAgentReject'
13:57:50 - Creating table 'NmsUserAgentStats'
13:57:50 - Creating table 'NmsWebApp'
13:57:50 - Creating table 'NmsWebForm'
13:57:50 - Creating table 'NmsWebTrackingLog'
13:57:50 - Creating table 'NmsWebAppLogRcp'
13:57:50 - Creating table 'NmsEmailError'
13:57:50 - Creating table 'NmsEmailErrorStat'
13:57:50 - Creating table 'NmsMxDomain'
13:57:50 - Creating table 'NmsMxOwner'
13:57:50 - Creating table 'NmsLocalOrgUnit'
13:57:50 - Creating table 'NmsPipelineOffset'
13:57:50 - Creating table 'NmsPipelineDiscard'
13:57:50 - Creating table 'NmsSuppressionAddress'
13:57:50 - Creating table 'NmsSuppressionDomain'
13:57:50 - Creating table 'NmsReplicationStrategy'
13:57:50 - Creating table 'NmsOfferSpace'
13:57:50 - Creating table 'NmsOffer'
13:57:50 - Creating table 'NmsPropositionRcp'
13:57:50 - Creating table 'NmsPropositionVisitor'
13:57:51 - Creating table 'NmsOfferView'
13:57:51 - Generating identifier for database ''...
13:57:51 - Executing SQL script 'nms:postgresql-nms.sql'...
13:57:51 - Creating specific Id generator for broadLogs
13:57:51 - Creating specific Id generator for trackingLogs
13:57:51 - Creating specific Id generator for Propositions
13:57:51 - Creating specific Id generator for nmsaddress
13:57:51 - Creating specific Id generator for nmstrackingstats
13:57:51 - Creating specific Id generator for NmsBroadLogMsg
13:57:51 - Creating specific Id generator for NmsTrackingUrl
13:57:51 - Creating specific Id generator for NmsRecipient
13:57:51 - Creating specific Id generator for NmsReplicationStrategy
13:57:51 - Creating specific Id generator for NmsSubHisto
13:57:51 - Executing SQL script 'nms:postgresql-functions.sql'...
13:57:51 - Executing SQL script 'nms:postgresql-geomktg.sql'...
13:57:51 - Executing SQL script 'nms:postgresql-interaction.sql'...
13:57:51 - Writing schemas in the database...
13:57:52 - Writing entities in the database...
13:57:52 - Updating documents of type 'xtk:srcSchema'
13:57:52 - Updating documents of type 'xtk:form'
13:57:53 - Updating documents of type 'xtk:image'
13:57:54 - Updating documents of type 'xtk:xslt'
13:57:54 - Updating documents of type 'xtk:sql'
13:57:54 - Updating documents of type 'xtk:javascript'
13:57:54 - Updating documents of type 'xtk:jssp'
13:57:54 - Updating documents of type 'xtk:navtree'
13:57:54 - Updating documents of type 'xtk:funcList'
13:57:54 - Updating documents of type 'xtk:resourceMenu'
13:57:54 - Updating documents of type 'xtk:strings'
13:57:55 - Saving data related to packages...
13:57:55 - Generating the navigation tree...
13:57:55 - Package 'Initialization package': Saving entities of type 'xtk:folder'...
13:57:55 - Package 'Initialization package': Saving entities of type 'xtk:fileResData'...
13:57:55 - Package 'Initialization package': Saving entities of type 'xtk:group'...
13:57:55 - Package 'Initialization package': Saving entities of type 'xtk:operator'...
13:57:55 - Package 'Initialization package': Saving entities of type 'xtk:queryFilter'...
13:57:55 - Package 'Initialization package': Saving entities of type 'xtk:formRendering'...
13:57:55 - Package 'Initialization package': Saving entities of type 'xtk:report'...
13:57:55 - Package 'Initialization package': Saving entities of type 'xtk:enum'...
13:57:55 - Package 'Initialization package': Saving entities of type 'xtk:option'...
13:57:55 - Package 'Default folders': Saving entities of type 'xtk:folder'...
13:57:55 - Package 'systemStrings': Saving entities of type 'xtk:dictionaryString'...
13:57:56 - Package 'Delivery error-qualification rules': Saving entities of type 'nms:ruleSet'...
13:57:56 - Package 'Delivery error-qualification rules': Saving entities of type 'xtk:option'...
13:57:56 - Package 'Delivery error-qualification rules': Saving entities of type 'nms:broadLogMsg'...
13:57:57 - Package 'Delivery error-qualification rules': Saving entities of type 'xtk:option'...
13:57:57 - Package 'List of countries and states': Saving entities of type 'nms:country'...
13:57:57 - PGS-220000 PostgreSQL error: ERROR: duplicate key value violates unique constraint "nmscountry_labelja" DETAIL: Key (slabelja)=(¿¿¿¿¿) already exists. .
13:57:57 - WDB-200001 SQL statement 'INSERT INTO NmsCountry (sIsoA2, sIsoA3, iIsoNum, sLabelISO, sLabelFR, sLabelEN, sLabelDE, sIana, sItu, sLabelJA, sPhoneFormat, sPhoneExit) VALUES (:#(1)#, :#(2)#, :#(3)#, :#(4)#, :#(5)#, :#(6)#, :#(7)#, :#(8)#, :#(9)#, :#(10)#, :#(11)#, :#(12)#)' could not be executed. Param(0)=AL Param(1)=ALB Param(2)=8 Param(3)=ALBANIA Param(4)=Albanie Param(5)=Albania Param(6)=Albanien Param(7)=al Param(8)=355 Param(9)=アルバニア Param(10)= Param(11)=
13:57:57 - Failed to install the packages.
13:57:57 - The database creation process has failed.
13:57:58 - XSV-350122 An error occurred and the process has been stopped.
I narrowed the problem down to encoding as I manually removed the contraint from the code execution to understand what was being stored and realised japanese values were no being encoded correctly, however, the database is in unicode mode (utf8) which should be compatible.
