Received "A persistence error occurred. Contact your administrator for assistance" error while trying to add value in "Reference Designator" in "Manage Replacements" in Windchill PDMLink

• Received below error while trying to add value in Reference Designator in Management Replacements > Substitutes

ATTENTION: A persistence error occurred. Contact your administrator for assistance.

• Error in MethodServer logs

  wt.pds.exception <username> - Unable to perform modify for 1 records (wt.pom.pomResource/0) wt.pom.PersistenceException: A persistence error occurred. System message follows:
  Nested exception is: wt.pom.DatastoreException: A SQL error has occurred for the statement "UPDATE WTPartSubstituteLink SET administrativeLockIsNull=?,typeadministrativeLock=?,classnamekeydomainRef=?,idA3domainRef=?,inheritedDomain=?,quantityIsNull=?,amountA6=?,unitA6=?,referenceDesignator=?,replacementType=?,classnamekeyroleAObjectRef=?,idA3A5=?,classnamekeyroleBObjectRef=?,idA3B5=?,securityLabels=?,markForDeleteA2=?,updateStampA2=?,modifyStampA2=?,updateCountA2=updateCountA2+1 WHERE ((idA2A2 = ?) AND (updateCountA2 = ?))". Database system message follows:
  Nested exception is: com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated in table 'zfwt12frdr18720vdidb.zfwt12frdr18720vdidb.WTPartSubstituteLink', column 'referenceDesignator'. Truncated value: 'R1055$,R1057$,R1062$,R1064$-R1067$,R1073$-R1074$,R1105$-R1106$,R2282$,R2315$,R2318$-R2319$,R2322$,R2'.
      at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)
      at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1624)
      at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:594)
      at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:524)
      at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7194)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2979)
      at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:248)
      at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:223)
      at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:473)
      at wt.pds.SQLDatabasePds.updateList(SQLDatabasePds.java:3391)
      at wt.pds.SQLDatabasePds.update(SQLDatabasePds.java:411)
      at wt.pom.PersistentObjectManager.update(PersistentObjectManager.java:2443)
  
  
  wt.pom.sql <username> - Update Statement=UPDATE WTPartSubstituteLink SET administrativeLockIsNull=?,typeadministrativeLock=?,classnamekeydomainRef=?,idA3domainRef=?,inheritedDomain=?,quantityIsNull=?,amountA6=?,unitA6=?,referenceDesignator=?,replacementType=?,classnamekeyroleAObjectRef=?,idA3A5=?,classnamekeyroleBObjectRef=?,idA3B5=?,securityLabels=?,markForDeleteA2=?,updateStampA2=?,modifyStampA2=?,updateCountA2=updateCountA2+1 WHERE ((idA2A2 = ?) AND (updateCountA2 = ?));Bind Parameters=[null, null, wt.admin.AdministrativeDomain, 445127, false, false, 400.0, ea, R1055$,R1057$,R1062$,R1064$-R1067$,R1073$-R1074$,R1105$-R1106$,R2282$,R2315$,R2318$-R2319$,R2322$,R2324$-R2327$,R2363$,R2405$-R2408$,R6164$,R6448$,R6457$,R6803$-R6804$,R6815$-R6817$,R6825$-R6827$,R7104$,R7211$-R7212$,R7214$-R7215$,R7240$,R7243$,R7247$-R7248$,R7260$,R7263$,R7267$-R7268$,R7307$,R7317$,R7338$,R7733$,R7803$-R7804$,R7811$-R7812$,R7819$-R7820$,R7823$-R7824$,R9001$-R9002$,R9009$,R9017$,R9019$,R9022$,R9056$,R10026$-R10027$,R78082, s, wt.part.WTPartUsageLink, 1075814, wt.part.WTPartMaster, 598468, null, 0, 2024-06-06 05:54:54.0, 2024-06-06 05:54:54.0, 1075815, 4]
  ERROR [ajp-nio-127.0.0.1-8010-exec-5] wt.pds.exception wcadmin - Unable to perform update for 1 records (wt.pom.pomResource/0) wt.pom.PersistenceException: A persistence error occurred. System message follows:
  Nested exception is: wt.pom.DatastoreException: A SQL error has occurred for the statement "UPDATE WTPartSubstituteLink SET administrativeLockIsNull=?,typeadministrativeLock=?,classnamekeydomainRef=?,idA3domainRef=?,inheritedDomain=?,quantityIsNull=?,amountA6=?,unitA6=?,referenceDesignator=?,replacementType=?,classnamekeyroleAObjectRef=?,idA3A5=?,classnamekeyroleBObjectRef=?,idA3B5=?,securityLabels=?,markForDeleteA2=?,updateStampA2=?,modifyStampA2=?,updateCountA2=updateCountA2+1 WHERE ((idA2A2 = ?) AND (updateCountA2 = ?))". Database system message follows:
  Nested exception is: java.sql.SQLException: ORA-12899: value too large for column "DBUSER"."WTPARTSUBSTITUTELINK"."REFERENCEDESIGNATOR" (actual: 442, maximum: 400)
   
  at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
  at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)