Error message "ORA-01489: string concatenation result too long" appears when we search for samples or use filters in LMS - WKB285171

SYMPTOMS

• Error message appears when we search for samples or use filters in NuGenesis:
  com.creon.erm.common.SystemException: java.sql.SQLException: ORA-01489: concatenation result string too long
  Problems in SampleManagementServiceImpl.findTestRequests

ENVIRONMENT

• NuGenesis 9.0.2

CAUSE

Unknown. CRI-7161 raised to investigate.

FIX or WORKAROUND

1. In the case where this error was found, the customer had 319 samples associated with this one request. This causes a problem with an Oracle function used by the query.

2. Ungroup the samples and cancel the query. After dissociating the samples, the problem is resolved and the ability to cancel the request is available.

ADDITIONAL INFORMATION

SELECT * FROM (SELECT r.requestid, Count(s.requestguid) as samplecount FROM testrequest r, requestsample s WHERE r.requestguid=s.requestguid GROUP BY r.requestid,s.requestguid ORDER BY samplecount DESC) WHERE ROWNUM<=10;