ODF-0231 Creating Attribute (log: column xxxxx already exists)

Products

• Clarity PPM SaaS

Issue/Introduction

Unable to create attributes on object.

ODF-0231: Serious error on inserting or updating object attribute, contact system administrator

Error in APP log:

ERROR 2021-11-18 11:18:58,237 [http-nio-8080-exec-279] niku.xql2 (clarity:xxxxx:session:odf.addObjectDefinitionAttributeAndExit) Database Error thrown 
com.niku.union.persistence.PersistenceException: 
SQL error code: 0
Error message: ERROR: column "attributexxx" of relation "odf_ca_project" already exists
Executed:
 alter table odf_ca_project add attributexxx character varying(2000) null 
Derived from statement:
<?xml version="1.0" encoding="UTF-8"?>
<statement location="unionPMD.xml" id="union.dynamicSQL" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" inputSource="none" xmlns="http://schemas.niku.com/2002/pmd">
  <sql dbVendor="all" tsvTemplateAttrCode="">
    <text>@dynamic@</text>
    <param direction="IN" dynamicReplacement="@dynamic@" expressionListDelimiter=","/>
  </sql>
</statement>

Environment

Release : 16.0.0

Resolution

Check the attribute page to verify if the ID has already been taken. If so, use another unique ID.

Additional Information

Please also see:

ODF-0231 while creating an attribute

ODF-0231 Error When Updating Attribute Properties