E-CRM: CR_CO_SOLUTION Index Build PTSF_GENFEED Fails on Microsoft SQL Server Database After Applying PRP's to Image 20 With Error "[SQL Server]An expression of non-boolean type specified in a context where a condition is expected, near ','" (Doc ID 2956474.1)

Last updated on JANUARY 26, 2024

Applies to:

Symptoms

While trying to run the Index Build process PTSF_GENFEED for CR_CO_SOLUTION search definition, the following error is noticed in the PTSF_GENFEED's stdout log file in the Process Monitor:

SQL error. Function: SQL.Execute

  Error Position: 0

  Return: 8603 - [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]An expression of non-boolean type specified in a context where a condition is expected, near ','.
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Statement(s) could not be prepared.
[Microsoft][

  Statement: SELECT SETID,SOLUTION_ID,LANGUAGE_CD,RC_SUMMARY,SYMPTOM_DESCR,KEYWORDS,SOLUTION_DESCR FROM PS_RC_SOLUTION_LNG WHERE (SETID,SOLUTION_ID) IN (SELECT SETID,SOLUTION_ID FROM PS_RC_SOLUTION WHERE ROW_LASTMANT_DTTM > '1900-01-01 00:00:01.000' AND SOLN_STATUS = 'ACTV' AND RC_SOLUTION_TYPE IN ('S','W'))

  Original Statement: %SelectAll(:1) WHERE (SETID,SOLUTION_ID) IN (SELECT SETID,SOLUTION_ID FROM PS_RC_SOLUTION WHERE ROW_LASTMANT_DTTM > ÚTETIMEIN('1900-01-01-00.00.01.000000') AND SOLN_STATUS = 'ACTV' AND RC_SOLUTION_TYPE IN ('S','W'))

Fatal SQL error occurred. (2,125) CO_SOLN_AE.SOLNDECR.GBL.default.1900-01-01.Step20.OnExecute PCPC:2883 Statement:35

The issue can be replicated with the following Steps:

1. On CRM 9.2 Image 20 using Microsoft SQL Server Database, Apply PRP's:35146215, 34973546, 34869211, 34826584, 34555616, 33070978, 33773221

2. Deploy CR_CO_SOLUTION from PeopleTools -> Search Framework -> Administration -> Deploy Search Object page.

3. Run the PTSF_GENFEED Index build process for the same search definition from PeopleTools -> Search Framework -> Administration -> Schedule Search Index page replicate the issue.

Changes

Issue happened after Applying the PRP's: 

35146215, 34973546, 34869211, 34826584, 34555616, 33070978, 33773221

Cause

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