Method server logs are being flooded with database related errors e.g. "Closed Connection" in Windchill PDMLink

• MethodServer logs are flooded with database connection errors:

2024-01-18 15:09:11,265 ERROR [com.ptc.core.components.dataUtilities.worker-16] com.ptc.core.components.beans.DataUtilityBean Org1User10 - Exception happened calling setModelData for DataUtility : com.ptc.windchill.enterprise.wip.datautilities.ShareStatusDataUtility@4e18191b (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 "SELECT ...". Database system message follows:
Nested exception is: java.sql.SQLRecoverableException: Closed Connection

• This appears to only affect com.ptc.core.components.dataUtilities.worker-* threads
• The thread was interrupted prior to the database connection errors:

2024-01-18 15:09:09,669 WARN  [com.ptc.core.components.dataUtilities.worker-12] wt.method.server Org1User9 - Interrupting thread com.ptc.core.components.dataUtilities.worker-16
2024-01-18 15:09:09,669 WARN  [com.ptc.core.components.dataUtilities.worker-12] wt.pds.queryCancel Org1User9 - QueryContext.cancel(): cancelling

• Below is an example use case:
  • While performing move to the next page, an intermittent issue occurs with error "??? signs are shown on statusfamilyshare column"
  • Users are getting ??? and Red eye error when they are loading scrolling on product folder page
  • Error stack trace:

2023-12-14 14:58:26,712 ERROR [com.ptc.core.components.dataUtilities.worker-60] com.ptc.core.components.beans.DataUtilityBean Z10736 - Exception happened calling setModelData for DataUtility : com.ptc.windchill.enterprise.wip.datautilities.ShareStatusDataUtility@62d326b1 (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 "SELECT A0.classnamekeyroleBObjectRef,A0.idA3B5,A0.classnamekeyroleAObjectRef,A0.idA3A5 FROM CheckoutLink A0 WHERE ((A0.idA3A5 IN (?,?,?,?,?,?,?,?,?,?,?,?,?,...,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)))". Database system message follows:
Nested exception is: java.sql.SQLRecoverableException: Closed Connection

or

Nested exception is: wt.pom.DatastoreException: A SQL error has occurred. Database system message follows: 
Nested exception is: java.sql.SQLRecoverableException: IO Error: Socket read interrupted 

• The column values of Task table are blank or garbled with question mark "???"

ava.lang.NullPointerException
at com.ptc.windchill.enterprise.work.assignmentslist.dataUtilities.AssignmentsSubjectNameDataUtility.getWorkItemSubjectDisplayName(AssignmentsSubjectNameDataUtility.java:186)
at com.ptc.windchill.enterprise.work.assignmentslist.dataUtilities.AssignmentsSubjectNameDataUtility.handleAssignmentSubject(AssignmentsSubjectNameDataUtility.java:144)
at com.ptc.windchill.enterprise.work.assignmentslist.dataUtilities.AssignmentsSubjectNameDataUtility.getDataValue(AssignmentsSubjectNameDataUtility.java:122)

•  On opening the folder browser, page get ??? on the status column with warning Exception occurred trying to get glyph: null