PGS-220000 PostgreSQL error: ERROR: duplicate key value violates unique constraint "nmscountry_labelja" 7.0.9359 | Community
Skip to main content
david--garcia
david--garcia
Level 10
July 4, 2023
Question

PGS-220000 PostgreSQL error: ERROR: duplicate key value violates unique constraint "nmscountry_labelja" 7.0.9359

  • July 4, 2023
  • 0 replies
  • 1078 views

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.

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Terms & ConditionsAccessibility statement

Loading footer...