Failed While Creating Index for Search Definition (EP_PV_MASTERITEMVENDOR_CD) in MS SQL Server Environment (Doc ID 3048922.1)

Last updated on SEPTEMBER 20, 2024

Applies to:

Symptoms

Failed while Creating index for Search Definition (EP_PV_MASTERITEMVENDOR_CD) in MS SQL Server Environment.

The issue can be reproduced at will with the following steps:

1. Navigate : PeopleTools > Search Framework > Administration > Schedule Search Indexes
2. Add a Run Control
3. Enter Search Definition : EP_PV_MASTERITEMVENDOR_CD
4. Run
5. Check AppEngine Log

Error : 

File: C:\PT860P13B_2403250500-retail\peopletools\src\pssys\qpm.cppSQL error. Stmt #: 8526 Error Position: 0 Return: 8614 - [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information. (SQLSTATE 42000) 8623

 Failed SQL stmt: SELECT A.SETID, A.INV_ITEM_ID, A.VENDOR_SETID, A.VENDOR_ID, A.CONTRACT_SETID, A.PV_CONTRACT_FLAG, A.KEYVALUE, A.BUSINESS_UNIT_REQ FROM PS_PV_SRCH_IVCNTVW A WHERE ( A.SETID = :1 AND A.INV_ITEM_ID = :2 AND A.VENDOR_SETID = :3 AND A.VENDOR_ID = :4)

Changes

Cause

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