Case Search - Conversion Failed When Converting from a Character String to UniqueIdentifier Message (Doc ID 3044597.1)

Last updated on SEPTEMBER 05, 2024

Applies to:

Symptoms

On : 11.3.1.19 version, Plan

When attempting to perform a Case Search
the following error occurs.

ERROR
-----------------------
java.lang.RuntimeException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.6.v20200131-b7c997804f): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Conversion failed when converting from a character string to uniqueidentifier.
Error Code: 8169
Call: SELECT COUNT( *) FROM ( SELECT DISTINCT AsCase.CaseGuid
, AsCase.CaseNumber
, Client_03.FirstName
, Client_03.LastName
, Policy_3.PolicyNumber
, Case_StatusCode.ShortDescription
, AsCase.CreationDate
FROM AsCase LEFT OUTER JOIN AsCasePolicy AsCasePolicy ON AsCasePolicy.CaseGuid = AsCase.CaseGuid
AND AsCasePolicy.RoleCode = '01'
LEFT OUTER JOIN AsPolicy AsPolicy ON AsPolicy.PolicyGuid = AsCasePolicy.PolicyGuid
LEFT OUTER JOIN AsRole Role_03 ON Role_03.PolicyGuid = AsCasePolicy.PolicyGuid
AND Role_03.RoleCode in (?)
AND Role_03.StatusCode = '01'
LEFT OUTER JOIN AsClient Client_03 ON Client_03.ClientGuid = Role_03.ClientGuid
LEFT OUTER JOIN AsPolicy Policy_3 ON Policy_3.PolicyGuid = AsCasePolicy.PolicyGuid
LEFT OUTER JOIN AsCode Case_StatusCode ON Case_StatusCode.CodeName = 'AsCodeCaseStatus'
AND Case_StatusCode.CodeValue = AsCase.StatusCode
WHERE AsCase.CompanyGuid = '########'
AND AsPolicy.CompanyGUID = ?

STEPS
-----------------------

The issue can be reproduced at will with the following steps:
1. Login to OIPA.
2. Navigate to the Advanced Case Search Screen.
3. Select Company - Product.
4. Fill out one or many search criteria.
5. Click Search.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.