My Oracle Support Banner

Error "Return: 805 - [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert duplicate key row in object 'xxx.PS_PV_CATTREE_FLAT" when Running Index - EP_PV_MASTERITEMVENDOR_SD (Doc ID 2861182.1)

Last updated on APRIL 06, 2022

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 and later
PeopleSoft Enterprise SCM eProcurement - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Error "Return:  805 - [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert duplicate key row in object 'xxx.PS_PV_CATTREE_FLAT" when running index - EP_PV_MASTERITEMVENDOR_SD  


The issue can be reproduced at will with the following steps:
     1. Navigate : PeopleTools > Search Framework > Administration > Schedule Search Indexes
     2. Add new Run Control
     3. Enter Search Definition : EP_PV_MASTERITEMVENDOR_SD
     4. Select Full Index
     5. Run PTSF_GENFEED
          Issue : Process Failed

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
Cause
Solution


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