Schedule Search Index (AP_SDN_ADDRESS and AP_SDN_AKA_NAME) Erroring Out (Doc ID 2268272.1)

Last updated on MAY 19, 2017

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

SES Feed Generation process is abending with the following error.

ERROR

PeopleTools 8.54.28 - Application Engine Server
Copyright (c) 1988-2017 Oracle and/or its affiliates.
All Rights Reserved


PSAESRV started service request at 01.01.22 2017-05-18
Starting program PTSF_GENFEED (35,36)
Generating feed for Search Definition PTSEARCHREPORTS , for language code ENG scheduled with re-crawl mode N (262,155)
Connected query PTRS_CONQRY processed 0 rows generating 0 documents (262,80)
Successfully generated 1 delete feed segments (262,95)
Integration Gateway - External System Contact Error (158,10721)
Successfully generated total 2 segments for language ENG (262,93)

SES crawler launch failed with error Integration Broker encountered an error (262,1020) PT_SEARCH.SESIMPL.MESSAGE.SESRequest.OnExecute Name:Send PCPC:696 Statement:16
Called from:PT_SEARCH.SESIMPL.AdminService.OnExecute Name:doService Statement:992
Called from:PT_SEARCH.SESIMPL.AdminService.OnExecute Name:getState Statement:950
Called from:PT_SEARCH.SESIMPL.AdminService.OnExecute Name:GetCrawlStatus Statement:305
Called from:PTSF_FEED.SESFeedDataSource.OnExecute Name:startCrawl Statement:7

Successfully generated feed for Search definition PTSEARCHREPORTS (262,151)
Step 'DelRows' of section 'POSTINDX' in program 'PTRS_RPTSRCH' completed normally (65,310)
Step 'AddRows' of section 'POSTINDX' in program 'PTRS_RPTSRCH' completed normally (65,310)

Integration Gateway - External System Contact Error (158,10721)

Integration Broker encountered an error (262,1020) PT_SEARCH.SESIMPL.MESSAGE.SESRequest.OnExecute Name:Send PCPC:696 Statement:16
Called from:PT_SEARCH.SESIMPL.AdminService.OnExecute Name:doService Statement:992
Called from:PT_SEARCH.SESIMPL.AdminService.OnExecute Name:getState Statement:950
Called from:PT_SEARCH.SESIMPL.AdminService.OnExecute Name:GetCrawlStatus Statement:305
Called from:PTSF_GENFEED.SES_STAT.GBL.default.1900-01-01.Step01.OnExecute Statement:43

Process 1402234 ABENDED at Step PTSF_GENFEED.SES_STAT.Step01 (PeopleCode) -- RC = 24 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
PSAESRV completed service request at 01.02.14 2017-05-18


The issue can be reproduced at will with the following steps:
1. PeopleTools - Search Frame Work - Admin - Schedule Search Index (AP_SDN_ADDRESS and AP_SDN_AKA_NAME)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms