ASUTIME Limit Error Is Thrown While Running Search Indexes For Oracle SES

(Doc ID 2215576.1)

Last updated on DECEMBER 19, 2016

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Other

In the process of upgrading from HCM 8.9 to HCM 9.2 when running the PTSF_GENFEED application engine, ASUTIME limit error is thrown while running Search indexes for Oracle SES

 

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


PSAESRV started service request at 12.24.54 2015-04-29


Starting program PTSF_GENFEED (35,36)

Resuming perviously failed schedule from: Generating index data ,recrawl mode :Full index,language: Base Language and prompt: 1900-01-01-00.00.00.000000. (262,92)

File: E:\pt85317c-retail\peopletools\src\pssys\qpm.cppSQL error. Stmt #: 7072 Error Position: 0 Return: 8605 - [IBM][CLI Driver][DB2] SQL0905N Unsuccessful execution due to resource limit being exceeded. Resource name = "ASUTIME", limit = "000000000870" CPU seconds ("000012600000" service units) derived from "SYSIBM.DSNRLST99". SQLSTATE=57014

Error in running query because of SQL Error, Code=8605, Message=[IBM][CLI Driver][DB2] SQL0905N Unsuccessful execution due to resource limit being exceeded. Resource name = "ASUTIME", limit = "000000000870" CPU seconds ("000012600000" service units) derived from "SYSIBM.DSNRLST99". SQLSTATE=57014

 (SQLSTATE 57014 (50,380)

Database Driver Error. (30,11)

Database Driver Error. (30,11)

Error committing work. The host environment could not complete the CommitWork() function. (2,712) PTSF_GENFEED.FEEDGEN.GBL.default.1900-01-01.Step01.OnExecute PCPC:11087 Statement:127

Process 579931 ABENDED at Step PTSF_GENFEED.FEEDGEN.Step01 (PeopleCode) -- RC = 24 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

PSAESRV completed service request at 12.38.09 2015-04-29



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete the project is in a critical phase where SES integration with HCM needs to be completed to advance with the next steps. .

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