PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

1652 - ORA-01652: unable to extend temp segment by 128 in tablespace PSTEMP

edited Oct 25, 2012 3:46AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 2 commentsAnswered
Hi,  Experts
We present the next issue:

Environment:
=============
TEST
IBM AIX 7.1 on POWER Systems (64-bit)
PeopleTools 8.51.16
Application Version: FSCM 9.1
Oracle Database: Release 11.2.0.3.0
Webserver: Oracle WebLogic Server 11gR1 (10.3.6)
Oracle Tuxedo 10.3.0.0, Patch Rp057 

ERROR:

File: e:\pt85116b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1617  Error Position: 12  Return: 1652 - ORA-01652: unable to extend temp segment by 128 in tablespace PSTEMP Failed SQL stmt:INSERT INTO PS_COMBO_DATA_TBL (SETID, PROCESS_GROUP, COMBINATION, ACCOUNT, ALTACCT, DEPTID, OPERATING_UNIT, PRODUCT, FUND_CODE, CLASS_FLD, PROGRAM_CODE, BUDGET_REF, AFFILIATE, AFFILIAT E_INTRA1, AFFILIATE_INTRA2, CHARTFIELD1, CHARTFIELD2, CHARTFIELD3, PROJECT_ID, BOOK_CODE, CURRENCY_C D, STATISTICS_CODE, VALID_CODE, EFFDT_FROM, EFFDT_OPEN, EFFDT_TO) SELECT  DISTINCT A.SETID, A.PROCES S_GROUP, A.COMBINATION, A.RANGE_FROM_30, ' ', B.RANGE_FROM_30, D.RANGE_FROM_30, C.RANGE_FROM_30, ' ' , ' ', ' ', E.RANGE_FROM_30, ' ', ' ', ' ', F.RANGE_FROM_30, ' ', ' ', ' ', ' ', ' ', ' ', 'V', CR.E FFDT_FROM, CR.EFFDT_OPEN, CR.EFFDT_TO

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center