My Oracle Support Banner

E-UP: Application Upgrade to HCM 9.2 ABENDED ON DB2 at Step PTIADATACONV - Numeric value out of range (Doc ID 2257822.1)

Last updated on JULY 21, 2020

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.54 to 8.54 [Release 8.4]
IBM z/OS on System z

Symptoms

While upgrading an application to 9.2, the following error occurred.

The environment is on  DB2 z/OS v10 with PeopleTools is being upgraded to 8.54.xx during the upgrade.

 

LOG FILE
-----------------------
Filename = AE_PTIADATACONV_2038889_0318175852.AET
See the following error: -- PeopleTools 8.54.25 -- Application Engine
-- Copyright (c) 1988, 2017, Oracle.
-- All rights reserved.
-- Database: HR92PRD (DB2/OS390)

-- 17:58:53.001 Process 2038889 resumed after step PTIADATACONV.GetSectn.Step03

-- 17:58:53.008 .(PTIADATACONV.MAIN.Process) (Do While)
%Select (AE_SQLROWS) SELECT 1 FROM PS_PTIA_DATACONV DC WHERE 1=1 AND
PTIA_UPG_PATH = 'HC90' AND ACTIVE_FLAG = 'A' AND PTIA_RUNSTATUSFLAG IN ('N')
AND NOT EXISTS ( SELECT 1 FROM ( SELECT DISTINCT Z.PTIA_C_UPG_GROUP ,
Z.PTIA_C_TOPSEQNUM , Z.PTIA_C_TOPAEAPPLID , Z.PTIA_C_TOPAESECTN FROM
PS_PTIA_RUNDEPEND Z WHERE EXISTS ( SELECT 1 FROM PS_PTIA_DATACONV A WHERE 1=1
AND A.PTIA_RUNSTATUSFLAG = 'F' AND A.PTIA_UPG_GROUP = Z.PTIA_P_UPG_GROUP AND
A.SEQ_NUM = Z.PTIA_P_TOPSEQNUM AND A.AE_APPLID = Z.PTIA_P_TOPAEAPPLID AND
A.AE_SECTION = Z.PTIA_P_TOPAESECTN ) ) IL1 WHERE 1=1 AND
IL1.PTIA_C_UPG_GROUP = DC.PTIA_UPG_GROUP AND IL1.PTIA_C_TOPSEQNUM =
DC.SEQ_NUM AND IL1.PTIA_C_TOPAEAPPLID = DC.AE_APPLID AND
IL1.PTIA_C_TOPAESECTN = DC.AE_SECTION ) HAVING COUNT(*) > 0
/
-- 17:58:53.041 Process 2038889 ABENDED at Step PTIADATACONV.MAIN.Process (Action Do While) -- RC = 8601
ROLLBACK
/
-- 17:58:53.049 SQL Error: [IBM][CLI Driver] CLI0165E Error in row. SQLSTATE=01S01
[IBM][CLI Driver] CLI0111E Numeric value out of range. SQLSTATE=22003 (SQLSTATE 22003) -99999

PeopleSoft Application Engine Timings
(All timings in seconds)
2017-03-18 17.58.53

 

 

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.