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:
PeopleSoft Enterprise CRM HelpDesk for HR - Version 9.2 and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |