E-SES: Unable To Deploy Search Definitions On PT 8.54- Error: 'Service Exception: ns2:AdminAPIRuntimeFault : EQA-15000' (Doc ID 1999680.1)

Last updated on DECEMBER 28, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.54 and later
Microsoft Windows x64 (64-bit)

Symptoms

On : 8.54 version, Search Framework

Unable to deploy search definitions

Search Definitions                               Deploy Status             Audit Status
=============                                ===========          ==========

AP_SDN_ADDRESS                                  Success                      Success
EP_AM_ASSET                                        Failed with Error          Success 
EP_AP_PAYMENTS                                   Failed with Error          Success
PTPORTALREGISTRY                              Failed with Error          Failed with error - queries not public
PTSEARCHREPORTS                               Failed with Error          Failed with Error - queries not public

Getting same error messages for all 4 failed deployment. Showing error-

Service Exception: ns2:AdminAPIRuntimeFault : EQA-15000: An unexpected error occurred during operation "createAll".
Internal Exception: java.sql.SQLException: ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SEARCHSYS.EQ_FACET", line 594
ORA-06502: PL/SQL: numeric or value error: invalid LOB locator specified: ORA-22275
ORA-06512: at "SYS.DBMS_LOB", line 818
ORA-06512: at "SEARCHSYS.EQ_FACET", line 1521
ORA-06510: PL/SQL: unhandled user-defined exception

-SES was installed using install mode 1 (database and the middle tier on the same server).
-On EP9.2.010

-PT8.54.07, Windows OS
-Cleared all the audit errors listed in the report. But still have deployment error in this document.



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