My Oracle Support Banner

EPY: PY_SSP_BUILD Job Is Failing With Error "Error attaching file to database (235,105) PY_SSP_BUILD.INSATTCH.GBL.default.1900-01-01.Step01.OnExecute PCPC:312 Statement:4" (Doc ID 2819309.1)

Last updated on NOVEMBER 05, 2021

Applies to:

PeopleSoft Enterprise HCM Payroll for North America - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

PYCHKUSA job is failing on process PY_SSP_BUILD due to file attaching error.

File: /vob/peopletools/src/pspcm/pcmeweb.cppSQL error. Stmt #: 13774 Error Position: 12 Return: 4031 - ORA-04031: unable to allocate 13224 bytes of shared memory ("shared pool","unknown object","KTSL subheap","ktsl_load_disp-2")
Failed SQL stmt: INSERT INTO PS_PY_SSP_XML_DATA (ATTACHSYSFILENAME, FILE_SEQ, VERSION, FILE_SIZE, LASTUPDDTTM, LASTUPDOPRID, FILE_DATA) VALUES (:1,:2,:3,:4,TO_TIMESTAMP(:5,'YYYY-MM-DD-HH24.MI.SS.FF'),:6,:7)

Error attaching file to database (235,105) PY_SSP_BUILD.INSATTCH.GBL.default.1900-01-01.Step01.OnExecute PCPC:312 Statement:4
Process 7178313 ABENDED at Step PY_SSP_BUILD.INSATTCH.Step01 (PeopleCode) -- RC = 8 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
PSAESRV completed service request at 15.36.10 2021-10-29

 

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
References


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