E- INST: HCM DEMO 9.2 Update Image 16 DB2 Error 8601 when running hcengs dms script (Doc ID 2130853.1)

Last updated on MAY 16, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.

Symptoms

Apps 9.2 Update Image 16 environment setup error on a DB2 Database

We are setting up a new HCM DEMO 9.2 Image 16 vanilla environment.
When we run hcengs dms, we get error message on few tables

"SQL Error. Error Position: 0 Return: 8601 - [IBM][CLI Driver][DB2/AIX64] SQL0302N The value of a host variable in the EXECUTE or OPEN statement is out of range for its corresponding use. SQLSTAT
E=22001 (SQLSTATE 22001) -302"
(SQLSTATE 22001) -302
INSERT INTO PS_GP_FORMULA_DTL (PIN_NUM, EFFDT, SEQ_NUM5, FRML_FUNC_OPTN, FRML_LEFT_PAREN, ENTRY_TYPE_FRML1, PIN_FRML_FLD1_NUM, FRML_FLD1_DAT_TYP, FRML_FLD1_DEC_VAL, FRML_FLD1_DATE_VAL, FRML_FLD1_C
HAR_VAL, FRML_FLD1_ATRB_IND, PIN_RND1_NUM, FRML_FLD1_USE_OPTN, FRML_OPER1, FRML_FLD1_OLDV_IND, ENTRY_TYPE_FRML2, PIN_FRML_FLD2_NUM, FRML_FLD2_DAT_TYP, FRML_FLD2_DEC_VAL, FRML_FLD2_DATE_VAL, FRML_FL
D2_CHAR_VAL, FRML_FLD2_ATRB_IND, PIN_RND2_NUM, FRML_FLD2_USE_OPTN, FRML_FLD2_OLDV_IND, FRML_RIGHT_PAREN, ENTRY_TYPE_FRML3, PIN_FRML_FLD3_NUM, FRML_FLD3_DAT_TYP, FRML_FLD3_ATRB_IND, PIN_RND3_NUM, FR
ML_FLD3_USE_OPTN, FM_COMMENT) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34
)
Error: Unable to insert row 28
Error: SQL execute error for GP_FORMULA_DTL
 SQL Spaces: 0 Tables: 2358 Triggers: 0 Indexes: 2601 Views: 0
Ended: Sun Apr 24 18:44:45 2016
Unsuccessful completion


ERROR
-----------------------
(SQLSTATE 22001) -302"



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. HCM DEMO 9.2 Image 16
2. hcengs dms

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